public void UpdateSalePaperRate(SalePaperRateDTO salepaperrate) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mystring"].ToString())) { con.Open(); var para = new DynamicParameters(); para.Add("@SalePaperRateId", salepaperrate.SalePaperRateId); // Normal Parameters para.Add("@StateId", salepaperrate.StateId); para.Add("@PaperId", salepaperrate.PaperId); para.Add("@CityId", salepaperrate.CityId); para.Add("@MondayRate", salepaperrate.MondayRate); para.Add("@TuesdayRate", salepaperrate.TuesdayRate); para.Add("@WednesdayRate", salepaperrate.WednesdayRate); para.Add("@ThursdayRate", salepaperrate.ThursdayRate); para.Add("@FridayRate", salepaperrate.FridayRate); para.Add("@SaturdayRate", salepaperrate.SaturdayRate); para.Add("@SundayRate", salepaperrate.SundayRate); para.Add("@CreatedDate", salepaperrate.CreatedDate); para.Add("@CreatedBy", salepaperrate.CreatedBy); para.Add("@ModifiedDate", salepaperrate.ModifiedDate); para.Add("@ModifiedBy", salepaperrate.ModifiedBy); para.Add("@DeleteStatus", "ACTIVE"); var value = con.Query <int>("SP_Insert_Update_SalePaperRateMaster", para, null, true, 0, CommandType.StoredProcedure); con.Close(); } }
public ActionResult Create() { SalePaperRateDTO objPR = new SalePaperRateDTO(); objPR.ListState = BindListState(); objPR.ListPaper = BindListPaper(); objPR.ListCity = BindListCity(); ViewData["SelectedState"] = string.Empty; ViewData["SelectedPaper"] = string.Empty; ViewData["SelectedCity"] = string.Empty; return(View(objPR)); }
public ActionResult Create(SalePaperRateDTO obj, FormCollection frm) { try { if (string.IsNullOrEmpty(Convert.ToString(obj.StateId))) { ModelState.AddModelError("Error", "Please Select State"); } else if (string.IsNullOrEmpty(Convert.ToString(obj.PaperId))) { ModelState.AddModelError("Error", "Please Select Paper Name"); } else if (string.IsNullOrEmpty(Convert.ToString(obj.CityId))) { ModelState.AddModelError("Error", "Please Select City"); } else { obj.SalePaperRateId = 0; obj.CreatedBy = Convert.ToInt32(Session["UserID"]); DateTime timeUtc = System.DateTime.UtcNow; TimeZoneInfo cstZone = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"); DateTime cstTime = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, cstZone); obj.CreatedDate = cstTime; TempData["MessageRegistration"] = "Data Saved Successfully!"; objsalepaperrate.InsertSalePaperRate(obj); return(RedirectToAction("Create")); } obj.ListState = BindListState(); obj.ListPaper = BindListPaper(); obj.ListCity = BindListCity(); ViewData["SelectedState"] = obj.StateId; ViewData["SelectedPaper"] = obj.PaperId; ViewData["SelectedCity"] = obj.CityId; return(View(obj)); } catch (Exception) { throw; } }
public ActionResult Edit(SalePaperRateDTO obj, FormCollection collection, string actionType) { if (actionType == "Update") { if (string.IsNullOrEmpty(Convert.ToString(obj.StateId))) { ModelState.AddModelError("Error", "Please Select State"); } else if (string.IsNullOrEmpty(Convert.ToString(obj.CityId))) { ModelState.AddModelError("Error", "Please Select City"); } else if (string.IsNullOrEmpty(Convert.ToString(obj.PaperId))) { ModelState.AddModelError("Error", "Please Select Paper"); } else { obj.ModifiedBy = Convert.ToInt32(Session["UserID"]); DateTime timeUtc = System.DateTime.UtcNow; TimeZoneInfo cstZone = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"); DateTime cstTime = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, cstZone); obj.ModifiedDate = cstTime; objsalepaperrate.UpdateSalePaperRate(obj); TempData["MessageUpdate"] = "Sale Paper Rate Details Updated Successfully."; return(RedirectToAction("Details")); // return RedirectToAction("Details"); } return(RedirectToAction("Details")); } else { return(RedirectToAction("Details")); } }