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