public ActionResult Post(JobInvoiceAmendmentHeaderViewModel vm)
{
int Serial = 1;
bool TimePlanValidation = true;
string ExceptionMsg = "";
bool Continue = true;
int pk = 0;
Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();
var SelectedJobInvoices = (List <JobInvoiceAmendmentWizardViewModel>)System.Web.HttpContext.Current.Session["RateAmendmentWizardOrders"];
JobInvoiceAmendmentHeader Header = AutoMapper.Mapper.Map <JobInvoiceAmendmentHeaderViewModel, JobInvoiceAmendmentHeader>(vm);
List <HeaderChargeViewModel> HeaderCharges = new List <HeaderChargeViewModel>();
List <LineChargeViewModel> LineCharges = new List <LineChargeViewModel>();
List <LineReferenceIds> RefIds = new List <LineReferenceIds>();
bool HeaderChargeEdit = false;
int PersonCount = 0;
var settings = new JobInvoiceSettingsService(_unitOfWork).GetJobInvoiceSettingsForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId);
//int? CalculationId = settings.CalculationId;
List <LineDetailListViewModel> LineList = new List <LineDetailListViewModel>();
if (vm.JobInvoiceSettings.isVisibleHeaderJobWorker && !vm.JobWorkerId.HasValue)
{
ModelState.AddModelError("JobWorkerId", "The JobWorker field is required");
}
#region BeforeSave
bool BeforeSave = true;
try
{
BeforeSave = JobInvoiceAmendmentDocEvents.beforeWizardSaveEvent(this, new JobEventArgs(vm.JobInvoiceAmendmentHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
EventException = true;
}
if (!BeforeSave)
{
TempData["CSEXC"] += "Failed validation before save";
}
#endregion
#region DocTypeTimeLineValidation
try
{
TimePlanValidation = DocumentValidation.ValidateDocument(Mapper.Map <DocumentUniqueId>(vm), DocumentTimePlanTypeConstants.Create, User.Identity.Name, out ExceptionMsg, out Continue);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
TimePlanValidation = false;
}
if (!TimePlanValidation)
{
TempData["CSEXC"] += ExceptionMsg;
}
#endregion
if (ModelState.IsValid && BeforeSave && !EventException && (TimePlanValidation || Continue))
{
if (SelectedJobInvoices.Count > 0)
{
Header.Status = (int)StatusConstants.Drafted;
Header.CreatedDate = DateTime.Now;
Header.ModifiedDate = DateTime.Now;
Header.CreatedBy = User.Identity.Name;
Header.ModifiedBy = User.Identity.Name;
Header.ObjectState = Model.ObjectState.Added;
db.JobInvoiceAmendmentHeader.Add(Header);
//_JobInvoiceAmendmentHeaderService.Create(pt);
var JobInvoiceLineIds = SelectedJobInvoices.Select(m => m.JobInvoiceLineId).ToArray();
var JobInvoiceBalanceRecords = (from p in db.ViewJobInvoiceBalanceForRateAmendment
where JobInvoiceLineIds.Contains(p.JobInvoiceLineId)
select p).AsNoTracking().ToList();
var JobInvoiceRecords = (from p in db.JobInvoiceLine
where JobInvoiceLineIds.Contains(p.JobInvoiceLineId)
select p).AsNoTracking().ToList();
int?CalculationId = 0;
int JobInvoiceLineId = JobInvoiceBalanceRecords.FirstOrDefault().JobInvoiceLineId;
var SalesTaxGroupPerson = (from L in db.JobInvoiceLine where L.JobInvoiceLineId == JobInvoiceLineId select new { SalesTaxGroupPersonId = (int?)L.JobInvoiceHeader.SalesTaxGroupPerson.ChargeGroupPersonId ?? 0 }).FirstOrDefault();
if (SalesTaxGroupPerson != null)
{
CalculationId = new ChargeGroupPersonCalculationService(_unitOfWork).GetChargeGroupPersonCalculation(Header.DocTypeId, SalesTaxGroupPerson.SalesTaxGroupPersonId, Header.SiteId, Header.DivisionId) ?? 0;
}
if (CalculationId == 0)
{
CalculationId = settings.CalculationId ?? 0;
}
foreach (var item in SelectedJobInvoices)
{
if (item.Rate - JobInvoiceBalanceRecords.Where(m => m.JobInvoiceLineId == item.JobInvoiceLineId).FirstOrDefault().Rate != 0)
{
JobInvoiceRateAmendmentLine line = new JobInvoiceRateAmendmentLine();
line.JobInvoiceAmendmentHeaderId = Header.JobInvoiceAmendmentHeaderId;
line.JobInvoiceLineId = item.JobInvoiceLineId;
line.Qty = JobInvoiceBalanceRecords.Where(m => m.JobInvoiceLineId == item.JobInvoiceLineId).FirstOrDefault().BalanceQty;
line.AmendedRate = item.Rate;
line.Rate = line.AmendedRate - JobInvoiceBalanceRecords.Where(m => m.JobInvoiceLineId == item.JobInvoiceLineId).FirstOrDefault().Rate;
line.Amount = JobInvoiceBalanceRecords.Where(m => m.JobInvoiceLineId == item.JobInvoiceLineId).FirstOrDefault().BalanceQty *JobInvoiceRecords.Where(m => m.JobInvoiceLineId == item.JobInvoiceLineId).FirstOrDefault().UnitConversionMultiplier *line.Rate;
line.Amount = DecimalRoundOff.amountToFixed(line.Amount, settings.AmountRoundOff);
line.JobInvoiceRate = JobInvoiceBalanceRecords.Where(m => m.JobInvoiceLineId == item.JobInvoiceLineId).FirstOrDefault().Rate;
line.JobWorkerId = JobInvoiceBalanceRecords.Where(m => m.JobInvoiceLineId == item.JobInvoiceLineId).FirstOrDefault().JobWorkerId;
line.Sr = Serial++;
line.JobInvoiceRateAmendmentLineId = pk;
line.CreatedDate = DateTime.Now;
line.ModifiedDate = DateTime.Now;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
LineStatus.Add(line.JobInvoiceLineId, line.Rate);
RefIds.Add(new LineReferenceIds {
LineId = line.JobInvoiceRateAmendmentLineId, RefLineId = line.JobInvoiceLineId
});
line.ObjectState = Model.ObjectState.Added;
db.JobInvoiceRateAmendmentLine.Add(line);
LineList.Add(new LineDetailListViewModel {
Amount = line.Amount, Rate = line.Rate, LineTableId = line.JobInvoiceRateAmendmentLineId, HeaderTableId = Header.JobInvoiceAmendmentHeaderId, PersonID = line.JobWorkerId, DealQty = 0
});
pk++;
}
}
//new JobInvoiceLineStatusService(_unitOfWork).UpdateJobRateOnAmendmentMultiple(LineStatus, pt.DocDate, ref db);
int[] RecLineIds = null;
RecLineIds = RefIds.Select(m => m.RefLineId).ToArray();
var Charges = (from p in db.JobInvoiceLine
where RecLineIds.Contains(p.JobInvoiceLineId)
join LineCharge in db.JobInvoiceLineCharge on p.JobInvoiceLineId equals LineCharge.LineTableId
join HeaderCharge in db.JobInvoiceHeaderCharges on p.JobInvoiceHeaderId equals HeaderCharge.HeaderTableId
group new { p, LineCharge, HeaderCharge } by new { p.JobInvoiceLineId } into g
select new
{
LineId = g.Key.JobInvoiceLineId,
HeaderCharges = g.Select(m => m.HeaderCharge).ToList(),
Linecharges = g.Select(m => m.LineCharge).ToList(),
}).ToList();
var LineListWithReferences = (from p in LineList
join t in RefIds on p.LineTableId equals t.LineId
join t2 in Charges on t.RefLineId equals t2.LineId into table
from LineLis in table.DefaultIfEmpty()
orderby p.LineTableId
select new LineDetailListViewModel
{
Amount = p.Amount,
DealQty = p.DealQty,
HeaderTableId = p.HeaderTableId,
LineTableId = p.LineTableId,
PersonID = p.PersonID,
Rate = p.Rate,
CostCenterId = p.CostCenterId,
RLineCharges = (LineLis == null ? null : Mapper.Map <List <LineChargeViewModel> >(LineLis.Linecharges)),
}).ToList();
if (CalculationId != null)
{
new ChargesCalculationService(_unitOfWork).CalculateCharges(LineListWithReferences, Header.JobInvoiceAmendmentHeaderId, (int)CalculationId, 0, out LineCharges, out HeaderChargeEdit, out HeaderCharges, "Web.JobInvoiceAmendmentHeaderCharges", "Web.JobInvoiceRateAmendmentLineCharges", out PersonCount, Header.DocTypeId, Header.SiteId, Header.DivisionId);
}
//Saving Charges
foreach (var item in LineCharges)
{
JobInvoiceRateAmendmentLineCharge PoLineCharge = Mapper.Map <LineChargeViewModel, JobInvoiceRateAmendmentLineCharge>(item);
PoLineCharge.ObjectState = Model.ObjectState.Added;
db.JobInvoiceRateAmendmentLineCharge.Add(PoLineCharge);
}
//Saving Header charges
for (int i = 0; i < HeaderCharges.Count(); i++)
{
if (!HeaderChargeEdit)
{
JobInvoiceAmendmentHeaderCharge POHeaderCharge = Mapper.Map <HeaderChargeViewModel, JobInvoiceAmendmentHeaderCharge>(HeaderCharges[i]);
POHeaderCharge.HeaderTableId = Header.JobInvoiceAmendmentHeaderId;
POHeaderCharge.PersonID = Header.JobWorkerId;
POHeaderCharge.ObjectState = Model.ObjectState.Added;
db.JobInvoiceAmendmentHeaderCharge.Add(POHeaderCharge);
}
else
{
var footercharge = new JobInvoiceAmendmentHeaderChargeService(db).Find(HeaderCharges[i].Id);
footercharge.Rate = HeaderCharges[i].Rate;
footercharge.Amount = HeaderCharges[i].Amount;
footercharge.ObjectState = Model.ObjectState.Modified;
db.JobInvoiceAmendmentHeaderCharge.Add(footercharge);
}
}
try
{
JobInvoiceAmendmentDocEvents.onWizardSaveEvent(this, new JobEventArgs(Header.JobInvoiceAmendmentHeaderId, EventModeConstants.Add), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
EventException = true;
}
try
{
if (EventException)
{
throw new Exception();
}
db.SaveChanges();
//_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
PrepareViewBag(vm.DocTypeId);
ViewBag.Mode = "Add";
return(View("Create", vm));
}
try
{
JobInvoiceAmendmentDocEvents.afterWizardSaveEvent(this, new JobEventArgs(Header.JobInvoiceAmendmentHeaderId, EventModeConstants.Add), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Header.DocTypeId,
DocId = Header.JobInvoiceAmendmentHeaderId,
ActivityType = (int)ActivityTypeContants.WizardCreate,
DocNo = Header.DocNo,
DocDate = Header.DocDate,
DocStatus = Header.Status,
}));
Session.Remove("RateAmendmentWizardOrders");
}
return(RedirectToAction("Index", "JobInvoiceAmendmentHeader", new { id = Header.DocTypeId }).Success("Data saved Successfully"));
}
PrepareViewBag(vm.DocTypeId);
ViewBag.Mode = "Add";
return(View("Create", vm));
}
public ActionResult _ResultsPost(JobInvoiceAmendmentMasterDetailModel vm)
{
int Serial = _JobInvoiceRateAmendmentLineService.GetMaxSr(vm.JobInvoiceRateAmendmentLineViewModel.FirstOrDefault().JobInvoiceAmendmentHeaderId);
var Header = new JobInvoiceAmendmentHeaderService(_unitOfWork).Find(vm.JobInvoiceRateAmendmentLineViewModel.FirstOrDefault().JobInvoiceAmendmentHeaderId);
JobInvoiceSettings Settings = new JobInvoiceSettingsService(_unitOfWork).GetJobInvoiceSettingsForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId);
Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();
List <HeaderChargeViewModel> HeaderCharges = new List <HeaderChargeViewModel>();
List <LineChargeViewModel> LineCharges = new List <LineChargeViewModel>();
List <LineReferenceIds> RefIds = new List <LineReferenceIds>();
bool HeaderChargeEdit = false;
int?MaxLineId = new JobInvoiceRateAmendmentLineChargeService(db).GetMaxProductCharge(Header.JobInvoiceAmendmentHeaderId, "Web.JobInvoiceRateAmendmentLines", "JobInvoiceAmendmentHeaderId", "JobInvoiceRateAmendmentLineId");
int pk = 0;
int PersonCount = 0;
//int? CalculationId = Settings.CalculationId;
List <LineDetailListViewModel> LineList = new List <LineDetailListViewModel>();
bool BeforeSave = true;
try
{
BeforeSave = JobInvoiceAmendmentDocEvents.beforeLineSaveBulkEvent(this, new JobEventArgs(vm.JobInvoiceRateAmendmentLineViewModel.FirstOrDefault().JobInvoiceAmendmentHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
EventException = true;
}
if (!BeforeSave)
{
ModelState.AddModelError("", "Validation failed before save");
}
int?CalculationId = 0;
int JobInvoiceLineId = vm.JobInvoiceRateAmendmentLineViewModel.FirstOrDefault().JobInvoiceLineId;
var SalesTaxGroupPerson = (from L in db.JobInvoiceLine where L.JobInvoiceLineId == JobInvoiceLineId select new { SalesTaxGroupPersonId = (int?)L.JobInvoiceHeader.SalesTaxGroupPerson.ChargeGroupPersonId ?? 0 }).FirstOrDefault();
if (SalesTaxGroupPerson != null)
{
CalculationId = new ChargeGroupPersonCalculationService(_unitOfWork).GetChargeGroupPersonCalculation(Header.DocTypeId, SalesTaxGroupPerson.SalesTaxGroupPersonId, Header.SiteId, Header.DivisionId) ?? 0;
}
if (CalculationId == 0)
{
CalculationId = Settings.CalculationId ?? 0;
}
if (ModelState.IsValid && BeforeSave && !EventException)
{
foreach (var item in vm.JobInvoiceRateAmendmentLineViewModel.Where(m => (m.AmendedRate - m.JobInvoiceRate) != 0 && m.AAmended == false))
{
JobInvoiceRateAmendmentLine line = new JobInvoiceRateAmendmentLine();
line.JobInvoiceAmendmentHeaderId = item.JobInvoiceAmendmentHeaderId;
line.JobInvoiceLineId = item.JobInvoiceLineId;
line.Qty = item.Qty;
line.AmendedRate = item.AmendedRate;
line.Rate = item.AmendedRate - item.JobInvoiceRate;
line.Amount = DecimalRoundOff.amountToFixed(item.DealQty * line.Rate, Settings.AmountRoundOff);
line.JobInvoiceRate = item.JobInvoiceRate;
line.JobWorkerId = item.JobWorkerId;
line.Sr = Serial++;
line.JobInvoiceRateAmendmentLineId = pk;
line.CreatedDate = DateTime.Now;
line.ModifiedDate = DateTime.Now;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
line.Remark = item.Remark;
LineStatus.Add(line.JobInvoiceLineId, line.Rate);
RefIds.Add(new LineReferenceIds {
LineId = line.JobInvoiceRateAmendmentLineId, RefLineId = line.JobInvoiceLineId
});
line.ObjectState = Model.ObjectState.Added;
db.JobInvoiceRateAmendmentLine.Add(line);
LineList.Add(new LineDetailListViewModel {
Amount = line.Amount, Rate = line.Rate, LineTableId = line.JobInvoiceRateAmendmentLineId, HeaderTableId = item.JobInvoiceAmendmentHeaderId, PersonID = Header.JobWorkerId, DealQty = 0
});
//_JobInvoiceRateAmendmentLineService.Create(line);
pk++;
}
//Commented No InvoiceLineStatus
//new JobInvoiceLineStatusService(_unitOfWork).UpdateJobRateOnAmendmentMultiple(LineStatus, Header.DocDate, ref db);
if (Header.Status != (int)StatusConstants.Drafted && Header.Status != (int)StatusConstants.Import)
{
Header.Status = (int)StatusConstants.Modified;
Header.ModifiedBy = User.Identity.Name;
Header.ModifiedDate = DateTime.Now;
}
Header.ObjectState = Model.ObjectState.Modified;
db.JobInvoiceAmendmentHeader.Add(Header);
int[] RecLineIds = null;
RecLineIds = RefIds.Select(m => m.RefLineId).ToArray();
var Charges = (from p in db.JobInvoiceLine
where RecLineIds.Contains(p.JobInvoiceLineId)
join LineCharge in db.JobInvoiceLineCharge on p.JobInvoiceLineId equals LineCharge.LineTableId
join HeaderCharge in db.JobInvoiceHeaderCharges on p.JobInvoiceHeaderId equals HeaderCharge.HeaderTableId
group new { p, LineCharge, HeaderCharge } by new { p.JobInvoiceLineId } into g
select new
{
LineId = g.Key.JobInvoiceLineId,
HeaderCharges = g.Select(m => m.HeaderCharge).ToList(),
Linecharges = g.Select(m => m.LineCharge).ToList(),
}).ToList();
var LineListWithReferences = (from p in LineList
join t in RefIds on p.LineTableId equals t.LineId
join t2 in Charges on t.RefLineId equals t2.LineId into table
from LineLis in table.DefaultIfEmpty()
orderby p.LineTableId
select new LineDetailListViewModel
{
Amount = p.Amount,
DealQty = p.DealQty,
HeaderTableId = p.HeaderTableId,
LineTableId = p.LineTableId,
PersonID = p.PersonID,
Rate = p.Rate,
CostCenterId = p.CostCenterId,
RLineCharges = (LineLis == null ? null : Mapper.Map <List <LineChargeViewModel> >(LineLis.Linecharges)),
}).ToList();
if (CalculationId != null)
{
new ChargesCalculationService(_unitOfWork).CalculateCharges(LineListWithReferences, vm.JobInvoiceRateAmendmentLineViewModel.FirstOrDefault().JobInvoiceAmendmentHeaderId, (int)CalculationId, MaxLineId, out LineCharges, out HeaderChargeEdit, out HeaderCharges, "Web.JobInvoiceAmendmentHeaderCharges", "Web.JobInvoiceRateAmendmentLineCharges", out PersonCount, Header.DocTypeId, Header.SiteId, Header.DivisionId);
}
//Saving Charges
foreach (var item in LineCharges)
{
JobInvoiceRateAmendmentLineCharge PoLineCharge = Mapper.Map <LineChargeViewModel, JobInvoiceRateAmendmentLineCharge>(item);
PoLineCharge.ObjectState = Model.ObjectState.Added;
db.JobInvoiceRateAmendmentLineCharge.Add(PoLineCharge);
}
//Saving Header charges
for (int i = 0; i < HeaderCharges.Count(); i++)
{
if (!HeaderChargeEdit)
{
JobInvoiceAmendmentHeaderCharge POHeaderCharge = Mapper.Map <HeaderChargeViewModel, JobInvoiceAmendmentHeaderCharge>(HeaderCharges[i]);
POHeaderCharge.HeaderTableId = vm.JobInvoiceRateAmendmentLineViewModel.FirstOrDefault().JobInvoiceAmendmentHeaderId;
POHeaderCharge.PersonID = Header.JobWorkerId;
POHeaderCharge.ObjectState = Model.ObjectState.Added;
db.JobInvoiceAmendmentHeaderCharge.Add(POHeaderCharge);
}
else
{
var footercharge = new JobInvoiceAmendmentHeaderChargeService(db).Find(HeaderCharges[i].Id);
footercharge.Rate = HeaderCharges[i].Rate;
footercharge.Amount = HeaderCharges[i].Amount;
footercharge.ObjectState = Model.ObjectState.Modified;
db.JobInvoiceAmendmentHeaderCharge.Add(footercharge);
}
}
try
{
JobInvoiceAmendmentDocEvents.onLineSaveBulkEvent(this, new JobEventArgs(vm.JobInvoiceRateAmendmentLineViewModel.FirstOrDefault().JobInvoiceAmendmentHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
EventException = true;
}
try
{
if (EventException)
{
throw new Exception();
}
db.SaveChanges();
//_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Results", vm));
}
try
{
JobInvoiceAmendmentDocEvents.afterLineSaveBulkEvent(this, new JobEventArgs(vm.JobInvoiceRateAmendmentLineViewModel.FirstOrDefault().JobInvoiceAmendmentHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Header.DocTypeId,
DocId = Header.JobInvoiceAmendmentHeaderId,
ActivityType = (int)ActivityTypeContants.MultipleCreate,
DocNo = Header.DocNo,
DocDate = Header.DocDate,
DocStatus = Header.Status,
}));
return(Json(new { success = true }));
}
return(PartialView("_Results", vm));
}
public ActionResult Post(JobOrderAmendmentHeaderViewModel vm)
{
bool BeforeSave = true;
int Serial = 1;
Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();
JobOrderAmendmentHeader pt = AutoMapper.Mapper.Map <JobOrderAmendmentHeaderViewModel, JobOrderAmendmentHeader>(vm);
var settings = new JobOrderSettingsService(_unitOfWork).GetJobOrderSettingsForDocument(pt.DocTypeId, pt.DivisionId, pt.SiteId);
if (!vm.JobOrderSettings.isVisibleJobWorkerLine && !vm.JobWorkerId.HasValue)
{
ModelState.AddModelError("JobWorkerId", "The JobWorker field is required");
}
try
{
BeforeSave = JobOrderAmendmentDocEvents.beforeWizardSaveEvent(this, new JobEventArgs(vm.JobOrderAmendmentHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
EventException = true;
}
if (!BeforeSave)
{
TempData["CSEXC"] += "Failed validation before save";
}
if (ModelState.IsValid && BeforeSave && !EventException)
{
pt.Status = (int)StatusConstants.Drafted;
pt.CreatedDate = DateTime.Now;
pt.ModifiedDate = DateTime.Now;
pt.CreatedBy = User.Identity.Name;
pt.ModifiedBy = User.Identity.Name;
pt.ObjectState = Model.ObjectState.Added;
db.JobOrderAmendmentHeader.Add(pt);
//_JobOrderAmendmentHeaderService.Create(pt);
var SelectedJobOrders = (List <JobOrderAmendmentWizardViewModel>)System.Web.HttpContext.Current.Session["RateAmendmentWizardOrders"];
var JobOrderLineIds = SelectedJobOrders.Select(m => m.JobOrderLineId).ToArray();
var JobOrderBalanceRecords = (from p in db.ViewJobOrderBalanceForInvoice
where JobOrderLineIds.Contains(p.JobOrderLineId)
select p).AsNoTracking().ToList();
var JobOrderRecords = (from p in db.JobOrderLine
where JobOrderLineIds.Contains(p.JobOrderLineId)
select p).AsNoTracking().ToList();
foreach (var item in SelectedJobOrders)
{
if (item.Rate - JobOrderBalanceRecords.Where(m => m.JobOrderLineId == item.JobOrderLineId).FirstOrDefault().Rate != 0)
{
JobOrderRateAmendmentLine line = new JobOrderRateAmendmentLine();
line.JobOrderAmendmentHeaderId = pt.JobOrderAmendmentHeaderId;
line.JobOrderLineId = item.JobOrderLineId;
line.Qty = JobOrderBalanceRecords.Where(m => m.JobOrderLineId == item.JobOrderLineId).FirstOrDefault().BalanceQty;
line.AmendedRate = item.Rate;
line.Rate = line.AmendedRate - JobOrderBalanceRecords.Where(m => m.JobOrderLineId == item.JobOrderLineId).FirstOrDefault().Rate;
line.Amount = JobOrderBalanceRecords.Where(m => m.JobOrderLineId == item.JobOrderLineId).FirstOrDefault().BalanceQty *JobOrderRecords.Where(m => m.JobOrderLineId == item.JobOrderLineId).FirstOrDefault().UnitConversionMultiplier *line.Rate;
line.Amount = DecimalRoundOff.amountToFixed(line.Amount, settings.AmountRoundOff);
line.JobOrderRate = JobOrderBalanceRecords.Where(m => m.JobOrderLineId == item.JobOrderLineId).FirstOrDefault().Rate;
line.JobWorkerId = JobOrderBalanceRecords.Where(m => m.JobOrderLineId == item.JobOrderLineId).FirstOrDefault().JobWorkerId;
line.Sr = Serial++;
line.CreatedDate = DateTime.Now;
line.ModifiedDate = DateTime.Now;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
LineStatus.Add(line.JobOrderLineId, line.Rate);
line.ObjectState = Model.ObjectState.Added;
db.JobOrderRateAmendmentLine.Add(line);
}
}
new JobOrderLineStatusService(_unitOfWork).UpdateJobRateOnAmendmentMultiple(LineStatus, pt.DocDate, ref db);
try
{
JobOrderAmendmentDocEvents.onWizardSaveEvent(this, new JobEventArgs(pt.JobOrderAmendmentHeaderId, EventModeConstants.Add), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
EventException = true;
}
try
{
if (EventException)
{
throw new Exception();
}
db.SaveChanges();
//_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
PrepareViewBag(vm.DocTypeId);
ViewBag.Mode = "Add";
return(View("Create", vm));
}
try
{
JobOrderAmendmentDocEvents.afterWizardSaveEvent(this, new JobEventArgs(pt.JobOrderAmendmentHeaderId, EventModeConstants.Add), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(new ActiivtyLogViewModel
{
DocTypeId = pt.DocTypeId,
DocId = pt.JobOrderAmendmentHeaderId,
ActivityType = (int)ActivityTypeContants.WizardCreate,
User = User.Identity.Name,
DocNo = pt.DocNo,
DocDate = pt.DocDate
});
Session.Remove("RateAmendmentWizardOrders");
return(RedirectToAction("Index", "JobOrderAmendmentHeader", new { id = pt.DocTypeId }).Success("Data saved Successfully"));
}
PrepareViewBag(vm.DocTypeId);
ViewBag.Mode = "Add";
return(View("Create", vm));
}
public ActionResult _ResultsPost(JobOrderAmendmentMasterDetailModel vm)
{
int Serial = _JobOrderRateAmendmentLineService.GetMaxSr(vm.JobOrderRateAmendmentLineViewModel.FirstOrDefault().JobOrderAmendmentHeaderId);
var Header = new JobOrderAmendmentHeaderService(_unitOfWork).Find(vm.JobOrderRateAmendmentLineViewModel.FirstOrDefault().JobOrderAmendmentHeaderId);
Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();
JobOrderSettings Settings = new JobOrderSettingsService(_unitOfWork).GetJobOrderSettingsForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId);
#region BeforeSave
bool BeforeSave = true;
try
{
BeforeSave = JobOrderAmendmentDocEvents.beforeLineSaveBulkEvent(this, new JobEventArgs(vm.JobOrderRateAmendmentLineViewModel.FirstOrDefault().JobOrderAmendmentHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
EventException = true;
}
if (!BeforeSave)
{
ModelState.AddModelError("", "Validation failed before save");
}
#endregion
if (ModelState.IsValid && BeforeSave && !EventException)
{
foreach (var item in vm.JobOrderRateAmendmentLineViewModel.Where(m => (m.AmendedRate - m.JobOrderRate) != 0 && m.AAmended == false))
{
JobOrderRateAmendmentLine line = new JobOrderRateAmendmentLine();
line.JobOrderAmendmentHeaderId = item.JobOrderAmendmentHeaderId;
line.JobOrderLineId = item.JobOrderLineId;
line.Qty = item.Qty;
line.AmendedRate = item.AmendedRate;
line.Rate = item.AmendedRate - item.JobOrderRate;
line.Amount = DecimalRoundOff.amountToFixed((item.DealQty * line.Rate), Settings.AmountRoundOff);
line.JobOrderRate = item.JobOrderRate;
line.JobWorkerId = item.JobWorkerId;
line.Sr = Serial++;
line.CreatedDate = DateTime.Now;
line.ModifiedDate = DateTime.Now;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
line.Remark = item.Remark;
LineStatus.Add(line.JobOrderLineId, line.Rate);
line.ObjectState = Model.ObjectState.Added;
db.JobOrderRateAmendmentLine.Add(line);
//_JobOrderRateAmendmentLineService.Create(line);
}
if (Header.Status != (int)StatusConstants.Drafted && Header.Status != (int)StatusConstants.Import)
{
Header.Status = (int)StatusConstants.Modified;
Header.ModifiedBy = User.Identity.Name;
Header.ModifiedDate = DateTime.Now;
}
Header.ObjectState = Model.ObjectState.Modified;
db.JobOrderAmendmentHeader.Add(Header);
new JobOrderLineStatusService(_unitOfWork).UpdateJobRateOnAmendmentMultiple(LineStatus, Header.DocDate, ref db);
try
{
JobOrderAmendmentDocEvents.onLineSaveBulkEvent(this, new JobEventArgs(vm.JobOrderRateAmendmentLineViewModel.FirstOrDefault().JobOrderAmendmentHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
EventException = true;
}
try
{
if (EventException)
{
throw new Exception();
}
db.SaveChanges();
//_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Results", vm));
}
try
{
JobOrderAmendmentDocEvents.afterLineSaveBulkEvent(this, new JobEventArgs(vm.JobOrderRateAmendmentLineViewModel.FirstOrDefault().JobOrderAmendmentHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Header.DocTypeId,
DocId = Header.JobOrderAmendmentHeaderId,
ActivityType = (int)ActivityTypeContants.MultipleCreate,
DocNo = Header.DocNo,
DocDate = Header.DocDate,
DocStatus = Header.Status,
}));
return(Json(new { success = true }));
}
return(PartialView("_Results", vm));
}
