//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;
}
}
