//public IActionResult CheckPRARev(int PRIDRecords)
//{
// this.PRAIDRecord=PRIDRecords; // Set the PRA Record to the required PRI
// return View("Index",this);
// //Index();// Call
// //if ((_unitOfWork.PRAQuote.GetAll(
// // u => u.PRAId == (PRIDRecords),
// // u => u.OrderBy(x => x.PRARevision)).
// // Count() == 0))
// //{ Index(()); }
// ////return View();
// //int testcount = (_unitOfWork.PRAQuote.GetAll(
// // u => u.PRAId == (PRIDRecords),
// // u => u.OrderBy(x => x.PRARevision)).
// // Count());
//}
// create an method for upsert and can get null Id in case of create
public IActionResult Upsert(int?id)
{
PRAQuoteVM praquoteVM = new PRAQuoteVM()
{
PRAQuote = new PRAQuote(),
PRApprovalList = _unitOfWork.PRApproval.GetAll().Select(i => new SelectListItem
{
Text = i.PRApprovalId.ToString(),
Value = i.Id.ToString()
}),
EmployeeList = _unitOfWork.Employee.GetAll().Select(i => new SelectListItem
{
Text = i.EmployeeName,
Value = i.Id.ToString()
}),
QuoteList = _unitOfWork.Quote.GetAll().Select(i => new SelectListItem
{
Text = i.QuoteDescription,
Value = i.Id.ToString()
}),
QuoteList1 = _unitOfWork.Quote.GetAll().Select(i => new SelectListItem
{
Text = i.QuoteDescription,
Value = i.Id.ToString()
}),
QuoteList2 = _unitOfWork.Quote.GetAll().Select(i => new SelectListItem
{
Text = i.QuoteDescription,
Value = i.Id.ToString()
})
};
if (id == null) // create case
{
return(View(praquoteVM));
}
// this for edit request
praquoteVM.PRAQuote = _unitOfWork.PRAQuote.Get(id.GetValueOrDefault()); // To add stored procedure
// var parameter = new DynamicParameters(); // arrange parameters for sql server
//parameter.Add("@Id", id); // arrange to send the Id
// var objFromDb = _unitOfWork.PRAQuote.Get(id);
//praquote = _unitOfWork.SP_Call.OneRecord<PRAQuote>(SD.Proc_PRAQuote_Get, parameter);
if (praquoteVM.PRAQuote == null)
{
return(NotFound());
}
return(View(praquoteVM));
// return View();
}
[Authorize(Roles = SD.Role_Admin_Modify + "," + SD.Role_Admin_View + "," + SD.Role_Employee_Modify)]// Add authorization Level
public IActionResult Upsert(PRAQuoteVM praquoteVM)
{
if (ModelState.IsValid)
{
// to pass parameters to sql procedrues
var parameter = new DynamicParameters();
parameter.Add("@PRAQuoteDate", praquoteVM.PRAQuote.PRAQuoteDate);
parameter.Add("@PRARevision", praquoteVM.PRAQuote.PRARevision);
parameter.Add("@JustificationRev", praquoteVM.PRAQuote.JustificationRev);
parameter.Add("@EstimatedPrice", praquoteVM.PRAQuote.EstimatedPrice);
parameter.Add("@AddWarCost", praquoteVM.PRAQuote.AddWarCost);
parameter.Add("@FreightCost", praquoteVM.PRAQuote.FreightCost);
parameter.Add("@EnvFees", praquoteVM.PRAQuote.EnvFees);
parameter.Add("@CarbonTax", praquoteVM.PRAQuote.CarbonTax);
parameter.Add("@PSTCost", praquoteVM.PRAQuote.PSTCost);
parameter.Add("@Mobilization", praquoteVM.PRAQuote.Mobilization);
parameter.Add("@SiteOrientation", praquoteVM.PRAQuote.SiteOrientation);
parameter.Add("@RentalInsurance", praquoteVM.PRAQuote.RentalInsurance);
parameter.Add("@EquipmentDisinfection", praquoteVM.PRAQuote.EquipmentDisinfection);
parameter.Add("@ContingencyPercentage", praquoteVM.PRAQuote.ContingencyPercentage);
parameter.Add("@ContingencyAmount", praquoteVM.PRAQuote.ContingencyAmount);
parameter.Add("@Total", praquoteVM.PRAQuote.Total);
parameter.Add("@PRAId", praquoteVM.PRAQuote.PRAId);
parameter.Add("@SubmittedBy ", praquoteVM.PRAQuote.SubmittedBy);
parameter.Add("@QuoteId", praquoteVM.PRAQuote.QuoteId);
parameter.Add("@QuoteAl1Id", praquoteVM.PRAQuote.QuoteAl1Id);
parameter.Add("@QuoteAl2Id", praquoteVM.PRAQuote.QuoteAl2Id);
if (praquoteVM.PRAQuote.Id == 0) // create case whenever no ID posted
{
_unitOfWork.PRAQuote.Add(praquoteVM.PRAQuote); // to allow sql procedrues
//_unitOfWork.SP_Call.Execute(SD.Proc_PRAQuote_Create, parameter);
}
else
{
parameter.Add("@Id", praquoteVM.PRAQuote.Id);
// _unitOfWork.SP_Call.Execute(SD.Proc_PRAQuote_Update, parameter);
_unitOfWork.PRAQuote.Update(praquoteVM.PRAQuote); // to allow sql procedrues
}
_unitOfWork.Save();
EditExcelPRAQuote(_unitOfWork.PRApproval.Get(praquoteVM.PRAQuote.PRAId).ExcelFileUrl, praquoteVM.PRAQuote);
return(RedirectToAction(nameof(Index))); // if any mistake the name is gotted
}
return(View(praquoteVM));
}
