public void InsertDistributorTransaction(DistributorTransactionDTO DistributorTrans)
{
con.Open();
var para = new DynamicParameters();
para.Add("@TransDistributorId", DistributorTrans.TransDistributorId); // Normal Parameters
para.Add("@RetailerId", DistributorTrans.RetailerId);
para.Add("@PaperId", DistributorTrans.PaperId);
para.Add("@TransDate", DistributorTrans.TransDate);
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("@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.CreatedBy);
para.Add("@CreatedDate", DistributorTrans.CreatedDate);
para.Add("@CreatedBy", DistributorTrans.CreatedBy);
para.Add("@ModifiedDate", DistributorTrans.ModifiedDate);
para.Add("@ModifiedBy", DistributorTrans.ModifiedBy);
para.Add("@DeleteStatus", "ACTIVE");
var value = con.Query <int>("SP_Insert_Update_DistributorTransaction", para, null, true, 0, CommandType.StoredProcedure);
con.Close();
}
public ActionResult Create(string tri)
{
DistributorTransactionDTO objDT = new DistributorTransactionDTO();
objDT.ListRetailer = BindListRetailer(tri);
//BindListRetailer(objDT.DistributorId.ToString());
objDT.ListPaperbyCityId = BindListPaper(tri);
ViewData["SelectedRetailer"] = string.Empty;
ViewData["SelectedPaper"] = string.Empty;
return(View(objDT));
}
public List <DistributorTransactionDTO> BindListRetailer(string distId)
{
List <DistributorTransactionDTO> listritailer = new List <DistributorTransactionDTO>()
{
new DistributorTransactionDTO {
RetailerId = 0, RetailerName = "Select"
}
};
foreach (var item in objdistributortransactions.GetRetailerByDistributerId(distId))
{
DistributorTransactionDTO RT = new DistributorTransactionDTO();
RT.RetailerId = item.RetailerId;
RT.RetailerName = item.RetailerName;
listritailer.Add(RT);
}
return(listritailer);
}
public List <DistributorTransactionDTO> BindListPaper(string CityId)
{
List <DistributorTransactionDTO>
ListPaper = new List <DistributorTransactionDTO>()
{
new DistributorTransactionDTO {
PaperId = 0, PaperName = "Select"
}
};
foreach (var item in objdistributortransactions.GetPaperByCityId(CityId))
{
DistributorTransactionDTO P = new DistributorTransactionDTO();
P.PaperId = item.PaperId;
P.PaperName = item.PaperName;
ListPaper.Add(P);
}
return(ListPaper);
}
public ActionResult Create(DistributorTransactionDTO obj, FormCollection frm, string tri)
{
try
{
if (string.IsNullOrEmpty(Convert.ToString(obj.RetailerId)))
{
ModelState.AddModelError("Error", "Please Select State");
}
else if (string.IsNullOrEmpty(Convert.ToString(obj.PaperId)))
{
ModelState.AddModelError("Error", "Please Select Paper Name");
}
else
{
obj.TransDistributorId = 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!";
objdistributortransactions.InsertDistributorTransaction(obj);
return(RedirectToAction("Create"));
}
obj.ListRetailer = BindListRetailer(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;
}
}