public ActionResult URSSE_Child_Form(URSSEModel m) { if (ModelState.IsValid) { using (var con = new SqlConnection(_connectionString)) { var result = con.Query <int>("Insert_into_URSSE_Page_transactions " , new { CC_NO = m.CcNo, SerialNumber = m.Serial_No, m.IMEI1, m.IMEI2, m.RepairStatus, m.TotalCost, m.CollectableAmount, m.PaymentMode, m.CashReceived, m.TransactionAmount, m.TransactionDateTime, m.TransactionNumber, m.ReVisitDateTime }, commandType: CommandType.StoredProcedure).FirstOrDefault(); if (result == 1) { TempData["Message"] = "Updated Successfully"; } } } return(RedirectToAction("URSSEForm", "Logistics")); }
public ActionResult URSSEForm() { if (TempData["Message"] != null) { ViewBag.Message = TempData["Message"].ToString(); } ViewBag.CallStatus = new SelectList(dropdown.BindCall_Status_Master(), "Value", "Text"); ViewBag.CourierName = new SelectList(dropdown.BindCourier(CurrentUser.CompanyId), "Value", "Text"); ViewBag.EngineerName = new SelectList(dropdown.BindEngineer(CurrentUser.CompanyId), "Value", "Text"); using (var con = new SqlConnection(_connectionString)) { var result = new URSSEModel(); var result1 = con.Query <URSSE_Page_Model>("URSSE_Page_Single_Table", null, commandType: CommandType.StoredProcedure).ToList(); result.URSSE_Table = result1; return(View(result)); } }