public void UpdateDistributorReturnAPI(DistributorReturnDTO DistributorTrans)
{
try
{
con.Open();
var para = new DynamicParameters();
//para.Add("@PaperRate", DistributorTrans.PaperRate);
//para.Add("@PaperQuantity", DistributorTrans.PaperQuantity);
//para.Add("@TotalPrice", DistributorTrans.TotalPrice);
//para.Add("@PamphletQuantity", DistributorTrans.PamphletQuantity);
//para.Add("@PamphletRate", DistributorTrans.PamphletRate);
//para.Add("@TotalPamphletAmount", DistributorTrans.TotalPamphletAmount);
para.Add("@ReturnOrder", DistributorTrans.ReturnOrder);
para.Add("@TotalFinalAmount", DistributorTrans.TotalFinalAmount);
para.Add("@PaidAmount", DistributorTrans.PaidAmount);
para.Add("@BalanceAmount", DistributorTrans.BalanceAmount);
para.Add("@PrvBalanceAmount", DistributorTrans.PrvBalanceAmount);
para.Add("@FinalBalaceAmount", DistributorTrans.FinalBalaceAmount);
para.Add("@DistributorId", DistributorTrans.ModifiedBy);
para.Add("@ModifiedDate", DistributorTrans.ModifiedDate);
para.Add("@ModifiedBy", DistributorTrans.ModifiedBy);
para.Add("@DeleteStatus", "COMPLETE");
var value = con.Query<int>("SP_Update_MainDistributorReturn", para, null, true, 0, CommandType.StoredProcedure);
// con.Close();
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}
public void InsertDistributorReturnProductAPI(DistributorReturnDTO 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);
//con.Close();
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}
public ActionResult AddProduct()
{
DistributorReturnDTO model = new DistributorReturnDTO();
//model.ReturnOrder = Session["VReturnOrder"].ToString();
//model.TransDate = Convert.ToDateTime(Session["VTrnDate"].ToString());
//model.RetailerId =Convert.ToInt32(Session["VRetailerId"]);
return(PartialView("AddProduct", model));
}
public ActionResult Create(string tri)
{
DistributorReturnDTO objDS = new DistributorReturnDTO();
objDS.ListRetailer = BindListRetailer_DReturn(tri);
//BindListRetailer(objDT.DistributorId.ToString());
ViewData["SelectedRetailer"] = string.Empty;
return(View(objDS));
}
public ActionResult UpdateDistTrans(string tri)
{
DistributorReturnDTO objDS = new DistributorReturnDTO();
// objDS.ListRetailer = BindListRetailer_DReturn(tri);
//BindListRetailer(objDT.DistributorId.ToString());
ViewData["SelectedRetailer"] = string.Empty;
var TotalFinalAMT = GetFinalAmount_By_ReturnOrder(tri);
TempData["TFianlAMT"] = TotalFinalAMT;
return(View(objDS));
}
public List <DistributorReturnDTO> BindListRetailer_DReturn(string distId)
{
List <DistributorReturnDTO> listritailer = new List <DistributorReturnDTO>()
{
new DistributorReturnDTO {
RetailerId = 0, RetailerName = "Select"
}
};
foreach (var item in objdistributorReturn.GetRetailerByDistributerId(distId))
{
DistributorReturnDTO RT = new DistributorReturnDTO();
RT.RetailerId = item.RetailerId;
RT.RetailerName = item.RetailerName;
listritailer.Add(RT);
}
return(listritailer);
}
public HttpResponseMessage CRMainReturnOrder([FromBody] DistributorReturnDTO DistributorReturn)
{
try
{
objDistributorReturn.InsertDistributorReturn(DistributorReturn);
var message = Request.CreateResponse <DistributorReturnDTO>(HttpStatusCode.Created, DistributorReturn);
message.Headers.Location = new Uri(Request.RequestUri + DistributorReturn.DistributorReturnId.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(DistributorReturnDTO obj, FormCollection frm, string tri)
{
try
{
if (string.IsNullOrEmpty(Convert.ToString(obj.RetailerId)))
{
ModelState.AddModelError("Error", "Please Select Retailer");
}
else
{
obj.DistributorReturnId = 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.InsertDistributorReturn(obj);
TempData["MessageRegistration"] = "Data Saved Successfully!";
// ViewData["VReturnOrder"]= obj.ReturnOrder;
TempData["AddPaperTrn"] = "AddPapaerTrn";
Session["TransDate"] = obj.TransDate.ToShortDateString();
ViewBag.VRetailerId = obj.RetailerId;
Session["ReturnOrder"] = obj.ReturnOrder;
Session["PrvBalanceRetailer"] = obj.PrvBalanceAmount;
return(RedirectToAction("AddProductT"));
}
obj.ListRetailer = BindListRetailer_DReturn(tri);
// obj.ListPaperbyCityId = BindListPaper(tri);
//obj.ListCity = BindListCity();
ViewData["SelectedrRetailer"] = obj.RetailerId;
//ViewData["SelectedPaper"] = obj.PaperId;
//ViewData["SelectedCity"] = obj.CityId;
return(View(obj));
}
catch (Exception)
{
throw;
}
}
public ActionResult UpdateDistTrans(DistributorReturnDTO 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.UpdateDistributorReturn(obj);
TempData["MessageRegistration"] = "Data Saved Successfully!";
TempData["AddPaperTrn"] = "AddPapaerTrn";
TempData["UpdtDistTrn"] = "UpdtDistTrn";
// DistributorReturnDTO DS = new DistributorReturnDTO();
return(RedirectToAction("Details"));
}
// obj.ListRetailer = BindListRetailer(tri);
// obj.ListPaperbyDistId = BindListPaperL(tri);
//obj.ListCity = BindListCity();
// ViewData["SelectedrRetailer"] = obj.RetailerId;
// ViewData["SelectedPaper"] = obj.PaperId;
//ViewData["SelectedCity"] = obj.CityId;
return(PartialView("Create", objdistributorReturn));
}
catch (Exception)
{
throw;
}
}
