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);
}
}