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