public void InsertRetailer(RetailerDTO retailer)
{
con.Open();
var para = new DynamicParameters();
para.Add("@RetailerId", retailer.RetailerId); // Normal Parameters
para.Add("@RetailerName", retailer.RetailerName);
para.Add("@RetailerAddress", retailer.RetailerAddress);
para.Add("@Area", retailer.Area);
para.Add("@PinCode", retailer.Pincode);
para.Add("@MobileNo", retailer.MobileNo);
para.Add("@AltMobileNo", retailer.AltMobileNo);
para.Add("@StateId", retailer.StateId);
para.Add("@CityId", retailer.CityId);
para.Add("@Email", retailer.Email);
para.Add("@DateofBirth", retailer.DateofBirth);
para.Add("@RemainingAMT", retailer.RemainingAMT);
para.Add("@DistributorId", retailer.CreatedBy);
para.Add("@CreatedDate", retailer.CreatedDate);
para.Add("@CreatedBy", retailer.CreatedBy);
para.Add("@ModifiedDate", retailer.ModifiedDate);
para.Add("@ModifiedBy", retailer.ModifiedBy);
para.Add("@DeleteStatus", "ACTIVE");
var value = con.Query <int>("SP_Insert_Update_RetailerMaster", para, null, true, 0, CommandType.StoredProcedure);
con.Close();
}
public ActionResult Create()
{
RetailerDTO objRT = new RetailerDTO();
objRT.ListState = BindListState();
objRT.ListCity = BindListCity();
ViewData["SelectedState"] = string.Empty;
ViewData["SelectedCity"] = string.Empty;
return(View(objRT));
}
public HttpResponseMessage Put(int id, [FromBody] RetailerDTO retailer)
{
try
{
objRetailerAll.UpdateRetailer(retailer);
var message = Request.CreateResponse <RetailerDTO>(HttpStatusCode.OK, retailer);
message.Headers.Location = new Uri(Request.RequestUri + retailer.RetailerId.ToString());
return(message);
//string uri = Url.Link("DefaultApi", new { orderID = order.OrderId });
//response.Headers.Location = new Uri(uri);
//return response;
//return Request.CreateResponse(HttpStatusCode.Created);
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
// return 0;
}
}
public ActionResult Create(RetailerDTO obj, FormCollection frm)
{
try
{
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
{
obj.RetailerId = 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!";
objretailer.RetailerExists(obj.RetailerName, obj.StateId, obj.CityId);
objretailer.InsertRetailer(obj);
return(RedirectToAction("Create"));
}
obj.ListState = BindListState();
obj.ListCity = BindListCity();
ViewData["SelectedState"] = obj.StateId;
ViewData["SelectedCity"] = obj.CityId;
return(View(obj));
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit(RetailerDTO 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
{
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;
objretailer.UpdateRetailer(obj);
TempData["MessageUpdate"] = "Retailer Details Updated Successfully.";
return(RedirectToAction("Details"));
// return RedirectToAction("Details");
}
return(RedirectToAction("Details"));
}
else
{
return(RedirectToAction("Details"));
}
}
