//Return Product public void InsertDistributorReturnProduct(DistributorReturnProductDTO DistributorReturnProduct) { try { con.Open(); var para = new DynamicParameters(); para.Add("@DistributorReturnProductId", DistributorReturnProduct.DistributorReturnProductId); // Normal Parameters para.Add("@ReturnOrder", DistributorReturnProduct.ReturnOrder); para.Add("@PaperId", DistributorReturnProduct.PaperId); para.Add("@PaperRate", DistributorReturnProduct.PaperRate); para.Add("@PaperQuantity", DistributorReturnProduct.PaperQuantity); para.Add("@TotalPrice", DistributorReturnProduct.TotalPrice); para.Add("@PamphletQuantity", DistributorReturnProduct.PamphletQuantity); para.Add("@PamphletRate", DistributorReturnProduct.PamphletRate); para.Add("@TotalPamphletAmount", DistributorReturnProduct.TotalPamphletAmount); para.Add("@TotalFinalAmount", DistributorReturnProduct.TotalFinalAmount); para.Add("@DistributorId", DistributorReturnProduct.CreatedBy); para.Add("@CreatedDate", DistributorReturnProduct.CreatedDate); para.Add("@CreatedBy", DistributorReturnProduct.CreatedBy); para.Add("@ModifiedDate", DistributorReturnProduct.ModifiedDate); para.Add("@ModifiedBy", DistributorReturnProduct.ModifiedBy); para.Add("@DeleteStatus", "ACTIVE"); var value = con.Query<int>("SP_Insert_DistributorReturnProduct", para, null, true, 0, CommandType.StoredProcedure); } catch (Exception) { throw; } finally { con.Close(); } }
public ActionResult AddProductT(string CityId, string DistributorId) { DistributorReturnProductDTO objDT = new DistributorReturnProductDTO(); objDT.ListPaperbyDistId = BindListPaperL(CityId, DistributorId); objDT.ReturnOrder = Session["ReturnOrder"].ToString(); string selectDate = Session["TransDate"].ToString(); string D = Convert.ToDateTime(selectDate).ToString("yyyy-MM-dd"); DateTime FD = Convert.ToDateTime(D); objDT.TransDateP = FD; //objDT.re = Convert.ToInt32(Session["VRetailerId"]); ViewData["SelectedPaper"] = string.Empty; return(View(objDT)); }
public HttpResponseMessage CRAddPaperReturn([FromUri] DistributorReturnProductDTO look) { try { objDistributorReturn.InsertDistributorReturnProduct(look); var message = Request.CreateResponse <DistributorReturnProductDTO>(HttpStatusCode.Created, look); message.Headers.Location = new Uri(Request.RequestUri + look.DistributorReturnProductId.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 AddProductT(DistributorReturnProductDTO obj, FormCollection frm, string cityId, string DistributorId) { try { if (string.IsNullOrEmpty(Convert.ToString(obj.PaperId))) { ModelState.AddModelError("Error", "Please Select Paper Name"); } else { obj.DistributorReturnProductId = 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; objdistributorReturn.InsertDistributorReturnProduct(obj); TempData["MessageRegistration"] = "Data Saved Successfully!"; TempData["AddPaperTrn"] = "AddPapaerTrn"; TempData["UpdtDistTrn"] = "UpdtDistTrn"; // DistributorReturnDTO DS = new DistributorReturnDTO(); return(RedirectToAction("AddProductT", obj)); } // obj.ListRetailer = BindListRetailer(tri); obj.ListPaperbyDistId = BindListPaperL(cityId, DistributorId); //obj.ListCity = BindListCity(); // ViewData["SelectedrRetailer"] = obj.RetailerId; ViewData["SelectedPaper"] = obj.PaperId; //ViewData["SelectedCity"] = obj.CityId; return(PartialView("Create", objdistributorReturn)); } catch (Exception) { throw; } }