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