/// <summary> /// A specialist version to reload data WITHOUT changing global version /// </summary> /// <returns></returns> public static BankCollection LoadBankTest(BankCollection temp) { try { for (int i = 0; i < dtBank.Rows.Count; i++) { temp.Add(new BankAccountViewModel { Id = Convert.ToInt32(dtBank.Rows [i] [0]), BankNo = dtBank.Rows [i] [1].ToString( ), CustNo = dtBank.Rows [i] [2].ToString( ), AcType = Convert.ToInt32(dtBank.Rows [i] [3]), Balance = Convert.ToDecimal(dtBank.Rows [i] [4]), IntRate = Convert.ToDecimal(dtBank.Rows [i] [5]), ODate = Convert.ToDateTime(dtBank.Rows [i] [6]), CDate = Convert.ToDateTime(dtBank.Rows [i] [7]), }); } } catch (Exception ex) { Console.WriteLine($"BANK : SQL Error in BankCollection load function : {ex . Message}, {ex . Data}"); MessageBox.Show($"BANK : SQL Error in BankCollection load function : {ex . Message}, {ex . Data}"); } finally { Console.WriteLine($"BANK : Completed load into Bankcollection : {temp . Count} records loaded successfully ...."); } return(temp); }
public async static Task <bool> LoadBankCollection( ) { int count = 0; Console.WriteLine($"Entered LoadBankCollection in Bankcollection ...."); try { for (int i = 0; i < dtBank.Rows.Count; i++) { Bankcollection.Add(new BankAccountViewModel { Id = Convert.ToInt32(dtBank.Rows [i] [0]), BankNo = dtBank.Rows [i] [1].ToString( ), CustNo = dtBank.Rows [i] [2].ToString( ), AcType = Convert.ToInt32(dtBank.Rows [i] [3]), Balance = Convert.ToDecimal(dtBank.Rows [i] [4]), IntRate = Convert.ToDecimal(dtBank.Rows [i] [5]), ODate = Convert.ToDateTime(dtBank.Rows [i] [6]), CDate = Convert.ToDateTime(dtBank.Rows [i] [7]), }); count = i; } } catch (Exception ex) { Console.WriteLine($"SQL Error in BankCollection load function : {ex . Message}, {ex . Data}"); } finally { Console.WriteLine($"Completed load into Bankcollection : {Bankcollection . Count} records in Bankcollection ...."); } return(true); }
public async static Task <bool> LoadBankCollection(bool Notify = false) { int count = 0; try { BankCollection bc = new BankCollection( ); for (int i = 0; i < dtBank.Rows.Count; i++) { Bankinternalcollection.Add(new BankAccountViewModel { Id = Convert.ToInt32(dtBank.Rows [i] [0]), BankNo = dtBank.Rows [i] [1].ToString( ), CustNo = dtBank.Rows [i] [2].ToString( ), AcType = Convert.ToInt32(dtBank.Rows [i] [3]), Balance = Convert.ToDecimal(dtBank.Rows [i] [4]), IntRate = Convert.ToDecimal(dtBank.Rows [i] [5]), ODate = Convert.ToDateTime(dtBank.Rows [i] [6]), CDate = Convert.ToDateTime(dtBank.Rows [i] [7]), }); count = i; } } catch (Exception ex) { Console.WriteLine($"BANK : SQL Error in BankCollection load function : {ex . Message}, {ex . Data}"); MessageBox.Show($"BANK : SQL Error in BankCollection load function : {ex . Message}, {ex . Data}"); } finally { BankCollection bc = new BankCollection( ); if (Notify) { EventControl.TriggerBankDataLoaded(null, new LoadedEventArgs { CallerDb = "BankAccount", DataSource = bc, RowCount = Bankinternalcollection.Count }); } } // Flags . BankCollection = Bankcollection; return(true); }