public List <Exp_Cat> all() { SqlCommand cmd = new SqlCommand("All_Exp_Cat", Connection.Get()); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader sdr = cmd.ExecuteReader(); List <Exp_Cat> expall = new List <Exp_Cat>(); while (sdr.Read()) { Exp_Cat ex = new Exp_Cat(); ex.EC_ID = (int)sdr[0]; ex.Name = (string)sdr[1]; expall.Add(ex); } sdr.Close(); return(expall); }
public List <Expense> expensebyecid() { SqlCommand cmd = new SqlCommand("byecid_Expense", Connection.Get()); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ecid", EC_ID); SqlDataReader sdr = cmd.ExecuteReader(); List <Expense> exall = new List <Expense>(); while (sdr.Read()) { Expense e = new Expense(); e.E_ID = (int)sdr[0]; e.Name = (string)sdr[1]; e.Amount = (decimal)sdr[2]; e.Date = (string)sdr[3]; e.EC_ID = (int)sdr[4]; e.Add_By = (string)sdr[5]; exall.Add(e); } sdr.Close(); Exp_Cat ec = new Exp_Cat(); List <Exp_Cat> allexpcat = ec.all(); for (int i = 0; i < allexpcat.Count; i++) { for (int j = 0; j < exall.Count; j++) { if (allexpcat[i].EC_ID == exall[j].EC_ID) { exall[j].EC_Name = allexpcat[i].Name; break; } } } return(exall); }