public ActionResult Create(PaymentRecordModel smodel) { ProviderDBHandle pdbh = new ProviderDBHandle(); ViewBag.providerList = pdbh.Get(); ExpenseCategoryDBHandle exdbh = new ExpenseCategoryDBHandle(); ViewBag.categoryList = exdbh.Get(); RecurenceTypeDBHandle rtdbh = new RecurenceTypeDBHandle(); ViewBag.resourceTypeList = rtdbh.Get(); try { if (ModelState.IsValid) { PaymentRecordDBHandle sdb = new PaymentRecordDBHandle(); if (sdb.Add(smodel)) { ViewBag.Message = "Details Added Successfully"; ModelState.Clear(); } } return(View()); } catch (Exception e) { e.GetBaseException(); return(View()); } }
public bool Add(PaymentRecordModel smodel) { connection(); SqlCommand cmd = new SqlCommand("AddPaymentRecord", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@idUser", 1); cmd.Parameters.AddWithValue("@detail", smodel.detail); cmd.Parameters.AddWithValue("@amount", smodel.amount); cmd.Parameters.AddWithValue("@recurrence", smodel.recurrence); cmd.Parameters.AddWithValue("@recurrenciaTypeId", smodel.recurrenciaTypeId); cmd.Parameters.AddWithValue("@paymentDate", smodel.paymentDate); cmd.Parameters.AddWithValue("@providerId", smodel.providerId); cmd.Parameters.AddWithValue("@expenseCategoryId", smodel.expenseCategoryId); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i >= 1) { return(true); } else { return(false); } }
public ActionResult Edit(int id, PaymentRecordModel smodel) { ProviderDBHandle pdbh = new ProviderDBHandle(); ViewBag.providerList = pdbh.Get(); ExpenseCategoryDBHandle exdbh = new ExpenseCategoryDBHandle(); ViewBag.categoryList = exdbh.Get(); RecurenceTypeDBHandle rtdbh = new RecurenceTypeDBHandle(); ViewBag.resourceTypeList = rtdbh.Get(); try { PaymentRecordDBHandle sdb = new PaymentRecordDBHandle(); sdb.UpdateDetails(smodel); return(RedirectToAction("Index")); } catch { return(View()); } }