public static async Task <DetCollection> LoadDetTest(DetCollection Detinternalcollection) { int count = 0; try { for (int i = 0; i < dtDetails.Rows.Count; i++) { Detinternalcollection.Add(new DetailsViewModel { Id = Convert.ToInt32(dtDetails.Rows [i] [0]), BankNo = dtDetails.Rows [i] [1].ToString( ), CustNo = dtDetails.Rows [i] [2].ToString( ), AcType = Convert.ToInt32(dtDetails.Rows [i] [3]), Balance = Convert.ToDecimal(dtDetails.Rows [i] [4]), IntRate = Convert.ToDecimal(dtDetails.Rows [i] [5]), ODate = Convert.ToDateTime(dtDetails.Rows [i] [6]), CDate = Convert.ToDateTime(dtDetails.Rows [i] [7]) }); count = i; } Console.WriteLine($"DETAILS : Sql data loaded into Details ObservableCollection \"DetCollection\" [{count}] ...."); Flags.DetCollection = Detinternalcollection; return(Detinternalcollection); } catch (Exception ex) { Console.WriteLine($"DETAILS : ERROR in LoadDetCollection() : loading Details into ObservableCollection \"DetCollection\" : [{ex . Message}] : {ex . Data} ...."); MessageBox.Show($"DETAILS : ERROR in LoadDetCollection() : loading Details into ObservableCollection \"DetCollection\" : [{ex . Message}] : {ex . Data} ...."); return(null); } }
//**************************************************************************************************************************************************************// public static async Task <bool> LoadDetCollection( ) { int count = 0; try { for (int i = 0; i < dtDetails.Rows.Count; i++) { Detcollection.Add(new DetailsViewModel { Id = Convert.ToInt32(dtDetails.Rows [i] [0]), BankNo = dtDetails.Rows [i] [1].ToString( ), CustNo = dtDetails.Rows [i] [2].ToString( ), AcType = Convert.ToInt32(dtDetails.Rows [i] [3]), Balance = Convert.ToDecimal(dtDetails.Rows [i] [4]), IntRate = Convert.ToDecimal(dtDetails.Rows [i] [5]), ODate = Convert.ToDateTime(dtDetails.Rows [i] [6]), CDate = Convert.ToDateTime(dtDetails.Rows [i] [7]) }); count = i; } Console.WriteLine($"Sql data loaded into Details ObservableCollection \"DetCollection\" [{count}] ...."); return(true); } catch (Exception ex) { Console.WriteLine($"ERROR in LoadDetCollection() : loading Details into ObservableCollection \"DetCollection\" : [{ex . Message}] : {ex . Data} ...."); return(false); } }
//**************************************************************************************************************************************************************// public static async Task <DetCollection> LoadDetCollection(int row, bool Notify = true) { int count = 0; try { for (int i = 0; i < dtDetails.Rows.Count; i++) { Detinternalcollection.Add(new DetailsViewModel { Id = Convert.ToInt32(dtDetails.Rows [i] [0]), BankNo = dtDetails.Rows [i] [1].ToString( ), CustNo = dtDetails.Rows [i] [2].ToString( ), AcType = Convert.ToInt32(dtDetails.Rows [i] [3]), Balance = Convert.ToDecimal(dtDetails.Rows [i] [4]), IntRate = Convert.ToDecimal(dtDetails.Rows [i] [5]), ODate = Convert.ToDateTime(dtDetails.Rows [i] [6]), CDate = Convert.ToDateTime(dtDetails.Rows [i] [7]) }); count = i; } Console.WriteLine($"DETAILS : Sql data loaded into Details ObservableCollection \"DetCollection\" [{count}] ...."); if (Notify) { // OnDetDataLoaded ( Detcollection , row ); EventControl.TriggerDetDataLoaded(null, new LoadedEventArgs { CallerDb = "DETAILS", DataSource = Detinternalcollection, RowCount = Detinternalcollection.Count }); } Flags.DetCollection = Detinternalcollection; return(Detinternalcollection); } catch (Exception ex) { Console.WriteLine($"DETAILS : ERROR in LoadDetCollection() : loading Details into ObservableCollection \"DetCollection\" : [{ex . Message}] : {ex . Data} ...."); MessageBox.Show($"DETAILS : ERROR in LoadDetCollection() : loading Details into ObservableCollection \"DetCollection\" : [{ex . Message}] : {ex . Data} ...."); return(null); } }