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 void Update(JobInvoiceAmendmentHeader pt)
{
pt.ObjectState = ObjectState.Modified;
_unitOfWork.Repository <JobInvoiceAmendmentHeader>().Update(pt);
}
public JobInvoiceAmendmentHeader Create(JobInvoiceAmendmentHeader pt)
{
pt.ObjectState = ObjectState.Added;
_unitOfWork.Repository <JobInvoiceAmendmentHeader>().Insert(pt);
return(pt);
}
public void Delete(JobInvoiceAmendmentHeader pt)
{
_unitOfWork.Repository <JobInvoiceAmendmentHeader>().Delete(pt);
}
public JobInvoiceAmendmentHeader Add(JobInvoiceAmendmentHeader pt)
{
_unitOfWork.Repository <JobInvoiceAmendmentHeader>().Insert(pt);
return(pt);
}
