public IEnumerable <T> DashboardCreditPastDueAlertNotification(List <Dictionary <string, object> > keyValueParam)
{
var result = new List <SalesCredit>();
using (DBClass = new MSSQLDatabase())
{
var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_SALES_CREDIT_PAST_DUE_NOTIFICATION") as SqlCommand;
RoutinesParameterSetter.Set(ref cmd, keyValueParam);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
var salesCredit = new SalesCredit();
salesCredit.CreditID = int.Parse(reader[0].ToString());
salesCredit.SalesVoucherCode = reader[1].ToString();
salesCredit.DepartementName = reader[2].ToString();
salesCredit.CustomerName = reader[3].ToString();
salesCredit.CreditDate = DateTime.Parse(reader[4].ToString());
salesCredit.TotalCredit = decimal.Parse(reader[5].ToString());
salesCredit.TotalInstallment = decimal.Parse(reader[6].ToString());
salesCredit.CreditBalance = decimal.Parse(reader[7].ToString());
result.Add(salesCredit);
}
}
return(result as List <T>);
}
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam)
{
var result = new List <SalesCredit>();
using (DBClass = new MSSQLDatabase())
{
var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_SALES_CREDIT") as SqlCommand;
RoutinesParameterSetter.Set(ref cmd, keyValueParam);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
var salesCredit = new SalesCredit
{
CreditID = int.Parse(reader[0].ToString()),
SalesID = int.Parse(reader[1].ToString()),
SalesVoucherCode = reader[2].ToString(),
DepartementName = reader[3].ToString(),
CustomerName = reader[4].ToString(),
CreditDate = DateTime.Parse(reader[5].ToString()),
TotalCredit = decimal.Parse(reader[6].ToString()),
TotalInstallment = decimal.Parse(reader[7].ToString()),
CreditBalance = decimal.Parse(reader[8].ToString())
};
result.Add(salesCredit);
}
}
return(result as List <T>);
}
