public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam)
{
var result = new List <DepositSales>();
using (DBClass = new MSSQLDatabase())
{
var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_DEPOSIT_SALES") as SqlCommand;
RoutinesParameterSetter.Set(ref cmd, keyValueParam);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
var depositSales = new DepositSales();
depositSales.DepositAccountID = int.Parse(reader[0].ToString());
depositSales.VoucherCode = reader[1].ToString();
depositSales.DepartementName = reader[2].ToString();
depositSales.AccountByName = reader[3].ToString();
depositSales.StartingBalance = decimal.Parse(reader[4].ToString());
depositSales.Balance = decimal.Parse(reader[5].ToString());
depositSales.Note = reader[6].ToString();
depositSales.CreatedDate = DateTime.Parse(reader[7].ToString());
result.Add(depositSales);
}
}
return(result as List <T>);
}
public T FindbyId(int id)
{
var depositSales = new DepositSales();
using (DBClass = new MSSQLDatabase())
{
var cmd = DBClass.GetStoredProcedureCommand("APP_GET_DEPOSIT_SALES_BY_ID") as SqlCommand;
DBClass.AddSimpleParameter(cmd, "@DepositSalesId", id);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
depositSales.DepositAccountID = int.Parse(reader[0].ToString());
depositSales.VoucherCode = reader[1].ToString();
depositSales.DepartementID = int.Parse(reader[2].ToString());
depositSales.CashBankId = int.Parse(reader[3].ToString());
depositSales.AccountByName = reader[4].ToString();
depositSales.StartingBalance = decimal.Parse(reader[5].ToString());
depositSales.Balance = decimal.Parse(reader[6].ToString());
depositSales.Note = reader[7].ToString();
depositSales.BankLogObject = new BankLogObject
{
CashBankID = depositSales.CashBankId,
DepositSalesVoucher = depositSales.VoucherCode
};
}
}
return(depositSales as T);
}
public T FindbyVoucherCode(string voucherCode, decimal nominalToPaid)
{
var depositSales = new DepositSales();
using (DBClass = new MSSQLDatabase())
{
var cmd = DBClass.GetStoredProcedureCommand("APP_GET_DEPOSIT_SALES_BY_VOUCHER_CODE") as SqlCommand;
DBClass.AddSimpleParameter(cmd, "@VoucherCode", voucherCode);
DBClass.AddSimpleParameter(cmd, "@NominalToPaid", nominalToPaid);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
depositSales.DepositAccountID = int.Parse(reader[0].ToString());
depositSales.VoucherCode = reader[1].ToString();
depositSales.DepartementID = int.Parse(reader[2].ToString());
depositSales.CashBankId = int.Parse(reader[3].ToString());
depositSales.AccountByName = reader[4].ToString();
depositSales.StartingBalance = decimal.Parse(reader[5].ToString());
depositSales.Balance = decimal.Parse(reader[6].ToString());
depositSales.Note = reader[7].ToString();
}
}
return(depositSales as T);
}
