Click here to Skip to main content
15,887,267 members
Home / Discussions / C#
   

C#

 
Questionmysql bracket Pin
abdujalilc12-Sep-15 16:50
abdujalilc12-Sep-15 16:50 
AnswerRe: mysql bracket Pin
Dave Kreskowiak12-Sep-15 16:56
mveDave Kreskowiak12-Sep-15 16:56 
AnswerRe: mysql bracket Pin
Wendelius12-Sep-15 18:28
mentorWendelius12-Sep-15 18:28 
AnswerRe: mysql bracket Pin
Richard Deeming14-Sep-15 2:44
mveRichard Deeming14-Sep-15 2:44 
QuestionC# Change Directory Function Pin
Erics Johnson12-Sep-15 10:59
Erics Johnson12-Sep-15 10:59 
AnswerRe: C# Change Directory Function Pin
Dave Kreskowiak12-Sep-15 16:52
mveDave Kreskowiak12-Sep-15 16:52 
AnswerRe: C# Change Directory Function Pin
BillWoodruff13-Sep-15 22:07
professionalBillWoodruff13-Sep-15 22:07 
QuestionUnable to work with Multi-Threading Pin
Bastar Media12-Sep-15 4:02
Bastar Media12-Sep-15 4:02 
Hello there,

Please have a look in this code:
ERROR LINE IS JUST BELOW #REGION YEARLYTAX... (COMMENTED)

C#
private void ImportData_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
        {
            #region Delete Previous Data...
            if (MessageBox.Show("Delete all previous records?", "DELETE ALL", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No) == MessageBoxResult.Yes)
            {
                if (MessageBox.Show("ALL RECORDS WILL BE DELETED PERMANENTLY... ARE YOU SURE?", "DELETE ALL", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No) == MessageBoxResult.Yes)
                {
                    lblMessage.Content = "Please wait...";
                    Cursor = Cursors.Wait;
                    Engine E = new Engine();
                    SQLiteCommand CMD = new SQLiteCommand("DELETE FROM YEARS", E.Conn);
                    CMD.ExecuteNonQuery();
                    CMD = new SQLiteCommand("DELETE FROM WARDS", E.Conn);
                    CMD.ExecuteNonQuery();
                    CMD = new SQLiteCommand("DELETE FROM USERS", E.Conn);
                    CMD.ExecuteNonQuery();
                    CMD = new SQLiteCommand("DELETE FROM SETTINGS", E.Conn);
                    CMD.ExecuteNonQuery();

                    E.Dispose();
                    CMD.Dispose();
                    Cursor = null;
                }
                else goto Import;
            }
            #endregion

        Import:
            ButtonsPanel.IsEnabled = false;
            FrmClose.IsEnabled = false;

            BW.WorkerSupportsCancellation = false;
            BW.WorkerReportsProgress = true;
            BW.WorkerSupportsCancellation = false;
            BW.DoWork += BW_DoWork;
            BW.ProgressChanged += BW_ProgressChanged;
            BW.RunWorkerCompleted += BW_RunWorkerCompleted;
            BW.RunWorkerAsync();

            lblMessage.Content = "Done...";
            ButtonsPanel.IsEnabled = true;
            FrmClose.IsEnabled = true;
        }
        void BW_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
        {
            lblMessage.Content = "Done...";
            Progress.Value = 0;
        }
        void BW_ProgressChanged(object sender, ProgressChangedEventArgs e)
        {
            Progress.Value = e.ProgressPercentage;
        }
        void BW_DoWork(object sender, DoWorkEventArgs e)
        {
            Progress.Value = 0;
            #region YearlyTax...
            var INF = new IniFile(Path.Combine(Directories.OLD_DATAFOLDER, @"yt.txn")); // Error in this line (Cross-Thread) IniFile is another static class in another file.
            string[] T = INF.GetSectionNames();
            Progress.Maximum = T.Length;

            foreach (string M in T)
            {
                SQLiteCommand CMD = new SQLiteCommand(E.InsertSQL("YEARS"), E.Conn);

                CMD.Parameters.AddWithValue("ID", Guid.NewGuid().ToString());
                CMD.Parameters.AddWithValue("YEAR", M);
                CMD.Parameters.AddWithValue("B6000", INF.GetDouble(M, "txt6000"));
                CMD.Parameters.AddWithValue("I12000", INF.GetDouble(M, "txt12000"));
                CMD.Parameters.AddWithValue("I100000", INF.GetDouble(M, "txt100000"));
                CMD.Parameters.AddWithValue("I150000", INF.GetDouble(M, "txt150000"));
                CMD.Parameters.AddWithValue("I200000", INF.GetDouble(M, "txt200000"));
                CMD.Parameters.AddWithValue("I250000", INF.GetDouble(M, "txt250000"));
                CMD.Parameters.AddWithValue("A250000", INF.GetDouble(M, "txtabove250000"));
                CMD.Parameters.AddWithValue("SAMEKIT", INF.GetDouble(M, "samekit"));
                CMD.Parameters.AddWithValue("VIVRANI", INF.GetDouble(M, "vivraniprapatrashulk"));
                CMD.Parameters.AddWithValue("LATEFEESPERCENT", INF.GetDouble(M, "latefees"));
                CMD.Parameters.AddWithValue("HOUSINGDISCOUNTPERCENT", INF.GetDouble(M, "housingdiscount"));
                CMD.Parameters.AddWithValue("OWNERDISCOUNTPERCENT", INF.GetDouble(M, "completeownerdiscountpercent"));
                CMD.Parameters.AddWithValue("WIDOWDISCOUNT", INF.GetDouble(M, "concessiontypediscount"));

                CMD.ExecuteNonQuery();

                lblMessage.Content = "Importing: " + M;
                BW.ReportProgress(P++);
                Thread.Sleep(30);
            }
            #endregion
            BW.ReportProgress(0);
            #region Wards...
            T = Directory.GetFiles(Path.Combine(Directories.OLD_DATAFOLDER, "Wards"), "*.wrd", SearchOption.AllDirectories);
            foreach (string M in T)
            {
                INF = new IniFile(M);
                string[] Q = INF.GetSectionNames();

                foreach (string L in Q)
                {
                    SQLiteCommand CMD = new SQLiteCommand(E.InsertSQL("WARDS"), E.Conn);

                    CMD.Parameters.AddWithValue("ID", Guid.NewGuid().ToString());
                    CMD.Parameters.AddWithValue("WARDNUMBER", Convert.ToInt32(L));
                    CMD.Parameters.AddWithValue("ZONE", INF.GetInt32(L, "zone"));
                    CMD.Parameters.AddWithValue("NAME", INF.GetString(L, "name"));
                    CMD.Parameters.AddWithValue("MANAGER", string.Empty);
                    CMD.Parameters.AddWithValue("N1", INF.GetDouble(L, "m1"));
                    CMD.Parameters.AddWithValue("N2", INF.GetDouble(L, "m2"));
                    CMD.Parameters.AddWithValue("N3", INF.GetDouble(L, "m3"));
                    CMD.Parameters.AddWithValue("ON1", INF.GetDouble(L, "mn1"));
                    CMD.Parameters.AddWithValue("ON2", INF.GetDouble(L, "mn2"));
                    CMD.Parameters.AddWithValue("ON3", INF.GetDouble(L, "mn3"));
                    CMD.Parameters.AddWithValue("IN1", INF.GetDouble(L, "vm1"));
                    CMD.Parameters.AddWithValue("IN2", INF.GetDouble(L, "vm2"));
                    CMD.Parameters.AddWithValue("IN3", INF.GetDouble(L, "vm3"));
                    CMD.Parameters.AddWithValue("OIN1", INF.GetDouble(L, "vmn1"));
                    CMD.Parameters.AddWithValue("OIN2", INF.GetDouble(L, "vmn2"));
                    CMD.Parameters.AddWithValue("OIN3", INF.GetDouble(L, "vmn3"));

                    CMD.ExecuteNonQuery();
                    lblMessage.Content = "Importing: " + M;
                    BW.ReportProgress(P++);
                    Thread.Sleep(30);
                }
            }
            #endregion
            BW.ReportProgress(0);
            #region Customers...
            T = Directory.GetFiles(Path.Combine(Directories.OLD_DATAFOLDER, "Customer"), "custdata.cst", SearchOption.AllDirectories);
            P = 0;
            foreach (string M in T)
            {
                INF = new IniFile(M);

                SQLiteCommand CMD = new SQLiteCommand(E.InsertSQL("Customers"), E.Conn);

                CMD.Parameters.AddWithValue("ID", Guid.NewGuid().ToString());
                CMD.Parameters.AddWithValue("DEMAND", CheckDemand(INF.GetString("data", "voterid")));
                CMD.Parameters.AddWithValue("AADHAR", INF.GetString("data", "aadhar").Trim());
                CMD.Parameters.AddWithValue("WARDNUMBER", INF.GetInt32("data", "wno"));
                CMD.Parameters.AddWithValue("NAME", INF.GetString("data", "name").Trim());
                CMD.Parameters.AddWithValue("CASTE", INF.GetString("data", "caste").Trim());
                CMD.Parameters.AddWithValue("ADDRESS1", INF.GetString("data", "address1").Trim());
                CMD.Parameters.AddWithValue("ADDRESS2", INF.GetString("data", "address2").Trim());
                CMD.Parameters.AddWithValue("PLOTNUMBER", INF.GetString("data", "plotno").Trim());
                CMD.Parameters.AddWithValue("MOBILENUMBER", INF.GetString("data", "mobile").Trim());
                CMD.Parameters.AddWithValue("LEDGERBALANCE", 0);

                CMD.ExecuteNonQuery();

                lblMessage.Content = "Importing: " + Path.GetFileName(M);
                BW.ReportProgress(P++);
                Thread.Sleep(30);
            }
            #endregion
        }


Any help is appreciated.

Thanks in advance.
AnswerRe: Unable to work with Multi-Threading Pin
OriginalGriff12-Sep-15 4:55
mveOriginalGriff12-Sep-15 4:55 
GeneralRe: Unable to work with Multi-Threading Pin
Bastar Media12-Sep-15 20:27
Bastar Media12-Sep-15 20:27 
GeneralRe: Unable to work with Multi-Threading Pin
OriginalGriff12-Sep-15 20:59
mveOriginalGriff12-Sep-15 20:59 
SuggestionRe: Unable to work with Multi-Threading Pin
Richard MacCutchan12-Sep-15 5:42
mveRichard MacCutchan12-Sep-15 5:42 
AnswerRe: Unable to work with Multi-Threading Pin
Pete O'Hanlon12-Sep-15 11:42
mvePete O'Hanlon12-Sep-15 11:42 
QuestionSimple and reusable system for user registration and tracking and auto-updates Pin
Bartosz Jarmuż12-Sep-15 1:02
Bartosz Jarmuż12-Sep-15 1:02 
AnswerRe: Simple and reusable system for user registration and tracking and auto-updates Pin
OriginalGriff12-Sep-15 1:43
mveOriginalGriff12-Sep-15 1:43 
GeneralRe: Simple and reusable system for user registration and tracking and auto-updates Pin
Bartosz Jarmuż12-Sep-15 4:19
Bartosz Jarmuż12-Sep-15 4:19 
AnswerRe: Simple and reusable system for user registration and tracking and auto-updates Pin
Dave Kreskowiak12-Sep-15 3:25
mveDave Kreskowiak12-Sep-15 3:25 
GeneralRe: Simple and reusable system for user registration and tracking and auto-updates Pin
Bartosz Jarmuż12-Sep-15 4:22
Bartosz Jarmuż12-Sep-15 4:22 
QuestionC# RUN zero-based index of the longest run in a string Pin
Erics Johnson11-Sep-15 4:40
Erics Johnson11-Sep-15 4:40 
AnswerRe: C# RUN zero-based index of the longest run in a string Pin
Richard Andrew x6411-Sep-15 5:09
professionalRichard Andrew x6411-Sep-15 5:09 
GeneralRe: C# RUN zero-based index of the longest run in a string Pin
Erics Johnson12-Sep-15 10:56
Erics Johnson12-Sep-15 10:56 
QuestionAdvantages of using .dll files over linking .cs files to projects (for my own generic helper classes / extension methods) Pin
Bartosz Jarmuż11-Sep-15 0:52
Bartosz Jarmuż11-Sep-15 0:52 
AnswerRe: Advantages of using .dll files over linking .cs files to projects (for my own generic helper classes / extension methods) Pin
OriginalGriff11-Sep-15 1:16
mveOriginalGriff11-Sep-15 1:16 
GeneralRe: Advantages of using .dll files over linking .cs files to projects (for my own generic helper classes / extension methods) Pin
Bartosz Jarmuż11-Sep-15 1:39
Bartosz Jarmuż11-Sep-15 1:39 
GeneralRe: Advantages of using .dll files over linking .cs files to projects (for my own generic helper classes / extension methods) Pin
OriginalGriff11-Sep-15 2:02
mveOriginalGriff11-Sep-15 2:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.