public void UpdatePaperRate(PaperRateDTO paperrate)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mystring"].ToString()))
{
con.Open();
var para = new DynamicParameters();
para.Add("@PaperRateId", paperrate.PaperRateId); // Normal Parameters
para.Add("@StateId", paperrate.StateId);
para.Add("@PaperId", paperrate.PaperId);
para.Add("@CityId", paperrate.CityId);
para.Add("@MondayRate", paperrate.MondayRate);
para.Add("@TuesdayRate", paperrate.TuesdayRate);
para.Add("@WednesdayRate", paperrate.WednesdayRate);
para.Add("@ThursdayRate", paperrate.ThursdayRate);
para.Add("@FridayRate", paperrate.FridayRate);
para.Add("@SaturdayRate", paperrate.SaturdayRate);
para.Add("@SundayRate", paperrate.SundayRate);
para.Add("@CreatedDate", paperrate.CreatedDate);
para.Add("@CreatedBy", paperrate.CreatedBy);
para.Add("@ModifiedDate", paperrate.ModifiedDate);
para.Add("@ModifiedBy", paperrate.ModifiedBy);
para.Add("@DeleteStatus", "ACTIVE");
var value = con.Query <int>("SP_Insert_Update_PaperRateMaster", para, null, true, 0, CommandType.StoredProcedure);
con.Close();
}
}
public void InsertPaperRate(PaperRateDTO paperrate)
{
con.Open();
var para = new DynamicParameters();
para.Add("@PaperRateId", paperrate.PaperRateId); // Normal Parameters
para.Add("@StateId", paperrate.StateId);
para.Add("@PaperId", paperrate.PaperId);
para.Add("@CityId", paperrate.CityId);
para.Add("@MondayRate", paperrate.MondayRate);
para.Add("@TuesdayRate", paperrate.TuesdayRate);
para.Add("@WednesdayRate", paperrate.WednesdayRate);
para.Add("@ThursdayRate", paperrate.ThursdayRate);
para.Add("@FridayRate", paperrate.FridayRate);
para.Add("@SaturdayRate", paperrate.SaturdayRate);
para.Add("@SundayRate", paperrate.SundayRate);
para.Add("@CreatedDate", paperrate.CreatedDate);
para.Add("@CreatedBy", paperrate.CreatedBy);
para.Add("@ModifiedDate", paperrate.ModifiedDate);
para.Add("@ModifiedBy", paperrate.ModifiedBy);
para.Add("@DeleteStatus", "ACTIVE");
var value = con.Query <int>("SP_Insert_Update_PaperRateMaster", para, null, true, 0, CommandType.StoredProcedure);
con.Close();
}
public ActionResult Create()
{
PaperRateDTO objPR = new PaperRateDTO();
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(PaperRateDTO 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.PaperRateId = 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!";
objpaperrate.InsertPaperRate(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(PaperRateDTO 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;
objpaperrate.UpdatePaperRate(obj);
TempData["MessageUpdate"] = "Paper Rate Details Updated Successfully.";
return(RedirectToAction("Details"));
// return RedirectToAction("Details");
}
return(RedirectToAction("Details"));
}
else
{
return(RedirectToAction("Details"));
}
}
