public T FindbyId(int id)
{
var cashAdjustment = new CashAdjustment();
using (DBClass = new MSSQLDatabase())
{
var cmd = DBClass.GetStoredProcedureCommand("APP_GET_CASH_ADJUSTEMENT_BY_ID") as SqlCommand;
DBClass.AddSimpleParameter(cmd, "@CashAdjustmentId", id);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
cashAdjustment.AdjustmentID = int.Parse(reader[0].ToString());
cashAdjustment.VoucherCode = reader[1].ToString();
cashAdjustment.DepartementId = int.Parse(reader[2].ToString());
cashAdjustment.CashId = int.Parse(reader[3].ToString());
cashAdjustment.AdjustmentType = reader[4].ToString();
cashAdjustment.Nominal = decimal.Parse(reader[5].ToString());
cashAdjustment.Note = reader[6].ToString();
cashAdjustment.AdjustmentDate = DateTime.Parse(reader[7].ToString());
cashAdjustment.LogObject = new CashLogObject
{
DepartementID = cashAdjustment.DepartementId,
CashID = cashAdjustment.CashId,
AdjustmentVoucher = cashAdjustment.VoucherCode
};
}
}
return(cashAdjustment as T);
}
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam)
{
var result = new List <CashAdjustment>();
using (DBClass = new MSSQLDatabase())
{
var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_CASH_ADJUSTMENT") as SqlCommand;
RoutinesParameterSetter.Set(ref cmd, keyValueParam);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
var cashAdjustment = new CashAdjustment();
cashAdjustment.AdjustmentID = int.Parse(reader[0].ToString());
cashAdjustment.VoucherCode = reader[1].ToString();
cashAdjustment.AdjustmentDate = DateTime.Parse(reader[2].ToString());
cashAdjustment.DepartementName = reader[3].ToString();
cashAdjustment.AdjustmentType = reader[4].ToString();
cashAdjustment.Nominal = decimal.Parse(reader[5].ToString());
cashAdjustment.Note = reader[6].ToString();
result.Add(cashAdjustment);
}
}
return(result as List <T>);
}
