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