public int IndexOf(Plan plan) { return List.IndexOf(plan); }
public void Delete(Plan plan) { List.Remove(plan); }
public Plans GetPlans() { Plans plans = new Plans(); try { using (SqlConnection conn = new SqlConnection(connString)) using (SqlCommand comm = new SqlCommand("usp_GetInstalmentSchedules", conn)) { comm.CommandType = CommandType.StoredProcedure; conn.Open(); using (SqlDataReader dr = comm.ExecuteReader()) { while (dr.Read()) { Plan p = new Plan(); p.PlanID = dr["Plan ID"].ToString(); p.Description = dr["Description"].ToString(); p.NoOfPayments = Convert.ToInt32(dr["Number of Payments"].ToString()); p.DaysFromFirstPayment = Convert.ToInt32(dr["Days from first payment"].ToString()); p.Cadence = Convert.ToInt32(dr["Cadence"].ToString()); plans.Add(p); } } } } catch (Exception ex) { log.Error(ex); throw; } return plans; }
public void Add(Plan plan) { List.Add(plan); }
public Plan GetPlan(string planID) { Plan plan = new Plan(); try { using (SqlConnection conn = new SqlConnection(connString)) using (SqlCommand comm = new SqlCommand("usp_GetPlanDetails", conn)) { comm.CommandType = CommandType.StoredProcedure; conn.Open(); comm.Parameters.Clear(); comm.Parameters.Add(new SqlParameter("@Plan_ID", planID)); using (SqlDataReader dr = comm.ExecuteReader()) { while (dr.Read()) { plan.PlanID = dr["Plan ID"].ToString(); plan.Description = dr["Description"].ToString(); plan.NoOfPayments = Convert.ToInt32(dr["Number of Payments"].ToString()); plan.DaysFromFirstPayment = Convert.ToInt32(dr["Days from first payment"].ToString()); plan.Cadence = Convert.ToInt32(dr["Cadence"].ToString()); plan.InstallmentFeePercentage = Convert.ToDecimal(dr["Installment Fee Percentage"]); } } } } catch (Exception ex) { log.Error(ex); throw; } return plan; }