Click here to Skip to main content
15,905,323 members
Home / Discussions / C#
   

C#

 
GeneralRe: Serializing a Dictionary of Items where the Value member is a List of instances of an Interface Pin
BillWoodruff16-Sep-15 7:37
professionalBillWoodruff16-Sep-15 7:37 
GeneralRe: Serializing a Dictionary of Items where the Value member is a List of instances of an Interface Pin
BillWoodruff15-Sep-15 6:58
professionalBillWoodruff15-Sep-15 6:58 
QuestionGridView Export to Excel keeping the date format Pin
Member 1180079714-Sep-15 3:34
Member 1180079714-Sep-15 3:34 
AnswerRe: GridView Export to Excel keeping the date format Pin
Richard MacCutchan14-Sep-15 6:31
mveRichard MacCutchan14-Sep-15 6:31 
QuestionWhat is it like working as a .NET developer? Pin
Jason Smith14-Sep-15 0:54
Jason Smith14-Sep-15 0:54 
AnswerRe: What is it like working as a .NET developer? Pin
Richard MacCutchan14-Sep-15 1:01
mveRichard MacCutchan14-Sep-15 1:01 
GeneralRe: What is it like working as a .NET developer? Pin
Jason Smith14-Sep-15 1:36
Jason Smith14-Sep-15 1:36 
QuestionHow to change a textbox text while the code is running Pin
Member 1191673513-Sep-15 20:29
Member 1191673513-Sep-15 20:29 
AnswerRe: How to change a textbox text while the code is running Pin
OriginalGriff13-Sep-15 21:03
mveOriginalGriff13-Sep-15 21:03 
AnswerRe: How to change a textbox text while the code is running Pin
BillWoodruff13-Sep-15 22:04
professionalBillWoodruff13-Sep-15 22:04 
GeneralRe: How to change a textbox text while the code is running Pin
Member 1191673514-Sep-15 23:54
Member 1191673514-Sep-15 23:54 
QuestionChange speech recognition language Pin
Member 1085025313-Sep-15 16:03
Member 1085025313-Sep-15 16:03 
AnswerRe: Change speech recognition language PinPopular
Dave Kreskowiak13-Sep-15 16:09
mveDave Kreskowiak13-Sep-15 16:09 
GeneralRe: Change speech recognition language Pin
Eddy Vluggen13-Sep-15 21:39
professionalEddy Vluggen13-Sep-15 21:39 
GeneralRe: Change speech recognition language Pin
Richard MacCutchan13-Sep-15 21:54
mveRichard MacCutchan13-Sep-15 21:54 
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 

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.