public ActionResult DeleteConfirmed(int id)
{
JobOrderRateAmendmentLine line = db.JobOrderRateAmendmentLine.Find(id);
line.ObjectState = ObjectState.Deleted;
int HeaderId = line.JobOrderAmendmentHeaderId;
_JobOrderRateAmendmentLineService.Delete(id);
_unitOfWork.Save();
return(RedirectToAction("Index", new { Id = HeaderId }).Success("Data deleted successfully"));
}
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 void Update(JobOrderRateAmendmentLine pt)
{
pt.ObjectState = ObjectState.Modified;
_unitOfWork.Repository <JobOrderRateAmendmentLine>().Update(pt);
}
public void Delete(JobOrderRateAmendmentLine pt)
{
_unitOfWork.Repository <JobOrderRateAmendmentLine>().Delete(pt);
}
public JobOrderRateAmendmentLine Create(JobOrderRateAmendmentLine pt)
{
pt.ObjectState = ObjectState.Added;
_unitOfWork.Repository <JobOrderRateAmendmentLine>().Insert(pt);
return(pt);
}
public JobOrderRateAmendmentLine Add(JobOrderRateAmendmentLine pt)
{
_unitOfWork.Repository <JobOrderRateAmendmentLine>().Insert(pt);
return(pt);
}
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));
}
public ActionResult DeletePost(JobOrderRateAmendmentLineViewModel vm)
{
bool BeforeSave = true;
try
{
BeforeSave = JobOrderAmendmentDocEvents.beforeLineDeleteEvent(this, new JobEventArgs(vm.JobOrderAmendmentHeaderId, vm.JobOrderRateAmendmentLineId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
EventException = true;
}
if (!BeforeSave)
{
TempData["CSEXC"] += "Validation failed before delete.";
}
if (BeforeSave && !EventException)
{
JobOrderRateAmendmentLine JobOrderLine = db.JobOrderRateAmendmentLine.Find(vm.JobOrderRateAmendmentLineId);
JobOrderAmendmentHeader header = new JobOrderAmendmentHeaderService(_unitOfWork).Find(JobOrderLine.JobOrderAmendmentHeaderId);
new JobOrderLineStatusService(_unitOfWork).UpdateJobRateOnAmendment(JobOrderLine.JobOrderLineId, JobOrderLine.JobOrderRateAmendmentLineId, header.DocDate, 0, ref db);
//_JobOrderRateAmendmentLineService.Delete(vm.JobOrderRateAmendmentLineId);
JobOrderLine.ObjectState = Model.ObjectState.Deleted;
db.JobOrderRateAmendmentLine.Remove(JobOrderLine);
if (header.Status != (int)StatusConstants.Drafted)
{
header.Status = (int)StatusConstants.Modified;
//new JobOrderAmendmentHeaderService(_unitOfWork).Update(header);
header.ModifiedBy = User.Identity.Name;
header.ModifiedDate = DateTime.Now;
header.ObjectState = Model.ObjectState.Modified;
db.JobOrderAmendmentHeader.Add(header);
}
try
{
JobOrderAmendmentDocEvents.onLineDeleteEvent(this, new JobEventArgs(JobOrderLine.JobOrderAmendmentHeaderId, JobOrderLine.JobOrderRateAmendmentLineId), 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("_Create", vm));
}
try
{
JobOrderAmendmentDocEvents.afterLineDeleteEvent(this, new JobEventArgs(JobOrderLine.JobOrderAmendmentHeaderId, JobOrderLine.JobOrderRateAmendmentLineId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
}
return(Json(new { success = true }));
}
public ActionResult _CreatePost(JobOrderRateAmendmentLineViewModel svm)
{
bool BeforeSave = true;
if (svm.JobOrderRateAmendmentLineId <= 0)
{
ViewBag.LineMode = "Create";
}
else
{
ViewBag.LineMode = "Edit";
}
if (svm.JobWorkerId == 0)
{
ModelState.AddModelError("JobWorkerId", "The JobWorker field is required");
}
#region BeforeSave
try
{
if (svm.JobOrderRateAmendmentLineId <= 0)
{
BeforeSave = JobOrderAmendmentDocEvents.beforeLineSaveEvent(this, new JobEventArgs(svm.JobOrderAmendmentHeaderId, EventModeConstants.Add), ref db);
}
else
{
BeforeSave = JobOrderAmendmentDocEvents.beforeLineSaveEvent(this, new JobEventArgs(svm.JobOrderAmendmentHeaderId, EventModeConstants.Edit), ref db);
}
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
EventException = true;
}
if (!BeforeSave)
{
ModelState.AddModelError("", "Validation failed before save.");
}
#endregion
JobOrderAmendmentHeader temp2 = new JobOrderAmendmentHeaderService(_unitOfWork).Find(svm.JobOrderAmendmentHeaderId);
JobOrderSettings Settings = new JobOrderSettingsService(_unitOfWork).GetJobOrderSettingsForDocument(temp2.DocTypeId, temp2.DivisionId, temp2.SiteId);
if (svm.JobOrderRateAmendmentLineId <= 0)
{
JobOrderRateAmendmentLine s = new JobOrderRateAmendmentLine();
if (ModelState.IsValid && BeforeSave && !EventException)
{
if (svm.Rate != 0)
{
s.Remark = svm.Remark;
s.JobOrderAmendmentHeaderId = svm.JobOrderAmendmentHeaderId;
s.JobOrderLineId = svm.JobOrderLineId;
s.Qty = svm.Qty;
s.AmendedRate = svm.AmendedRate;
s.Amount = svm.Amount;
s.JobOrderRate = svm.JobOrderRate;
s.JobWorkerId = svm.JobWorkerId;
s.Rate = svm.Rate;
s.Remark = svm.Remark;
s.Sr = _JobOrderRateAmendmentLineService.GetMaxSr(s.JobOrderAmendmentHeaderId);
s.CreatedDate = DateTime.Now;
s.ModifiedDate = DateTime.Now;
s.CreatedBy = User.Identity.Name;
s.ModifiedBy = User.Identity.Name;
//_JobOrderRateAmendmentLineService.Create(s);
s.ObjectState = Model.ObjectState.Added;
db.JobOrderRateAmendmentLine.Add(s);
if (temp2.Status != (int)StatusConstants.Drafted)
{
temp2.Status = (int)StatusConstants.Modified;
temp2.ModifiedBy = User.Identity.Name;
temp2.ModifiedDate = DateTime.Now;
}
//new JobOrderAmendmentHeaderService(_unitOfWork).Update(temp2);
temp2.ObjectState = Model.ObjectState.Modified;
db.JobOrderAmendmentHeader.Add(temp2);
new JobOrderLineStatusService(_unitOfWork).UpdateJobRateOnAmendment(svm.JobOrderLineId, s.JobOrderRateAmendmentLineId, temp2.DocDate, s.Rate, ref db);
try
{
JobOrderAmendmentDocEvents.onLineSaveEvent(this, new JobEventArgs(s.JobOrderAmendmentHeaderId, s.JobOrderRateAmendmentLineId, EventModeConstants.Add), 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("_Create", svm));
}
try
{
JobOrderAmendmentDocEvents.afterLineSaveEvent(this, new JobEventArgs(s.JobOrderAmendmentHeaderId, s.JobOrderRateAmendmentLineId, EventModeConstants.Add), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = temp2.DocTypeId,
DocId = temp2.JobOrderAmendmentHeaderId,
DocLineId = s.JobOrderRateAmendmentLineId,
ActivityType = (int)ActivityTypeContants.Added,
DocNo = temp2.DocNo,
DocDate = temp2.DocDate,
DocStatus = temp2.Status,
}));
}
if (svm.JobOrderSettings.isVisibleJobWorkerLine)
{
return(RedirectToAction("_Create", new { id = s.JobOrderAmendmentHeaderId }));
}
else
{
return(RedirectToAction("_Create", new { id = s.JobOrderAmendmentHeaderId, sid = svm.JobWorkerId }));
}
}
return(PartialView("_Create", svm));
}
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
JobOrderAmendmentHeader temp = new JobOrderAmendmentHeaderService(_unitOfWork).Find(svm.JobOrderAmendmentHeaderId);
int status = temp.Status;
StringBuilder logstring = new StringBuilder();
JobOrderRateAmendmentLine s = _JobOrderRateAmendmentLineService.Find(svm.JobOrderRateAmendmentLineId);
JobOrderRateAmendmentLine ExRecLine = new JobOrderRateAmendmentLine();
ExRecLine = Mapper.Map <JobOrderRateAmendmentLine>(s);
if (ModelState.IsValid && BeforeSave && !EventException)
{
if (svm.Rate != 0)
{
s.Remark = svm.Remark;
s.AmendedRate = svm.AmendedRate;
s.Rate = svm.Rate;
s.Amount = svm.Amount;
s.ModifiedBy = User.Identity.Name;
s.ModifiedDate = DateTime.Now;
}
s.ObjectState = Model.ObjectState.Modified;
db.JobOrderRateAmendmentLine.Add(s);
//_JobOrderRateAmendmentLineService.Update(s);
new JobOrderLineStatusService(_unitOfWork).UpdateJobRateOnAmendment(s.JobOrderLineId, s.JobOrderRateAmendmentLineId, temp.DocDate, s.Rate, ref db);
if (temp.Status != (int)StatusConstants.Drafted)
{
temp.Status = (int)StatusConstants.Modified;
temp.ModifiedDate = DateTime.Now;
temp.ModifiedBy = User.Identity.Name;
}
//new JobOrderAmendmentHeaderService(_unitOfWork).Update(temp);
temp.ObjectState = Model.ObjectState.Modified;
db.JobOrderAmendmentHeader.Add(temp);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRecLine,
Obj = s,
});
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
JobOrderAmendmentDocEvents.onLineSaveEvent(this, new JobEventArgs(s.JobOrderAmendmentHeaderId, s.JobOrderRateAmendmentLineId, EventModeConstants.Edit), 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("_Create", svm));
}
try
{
JobOrderAmendmentDocEvents.afterLineSaveEvent(this, new JobEventArgs(s.JobOrderAmendmentHeaderId, s.JobOrderRateAmendmentLineId, EventModeConstants.Edit), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
//SAving the Activity Log::
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = temp.DocTypeId,
DocId = temp.JobOrderAmendmentHeaderId,
DocLineId = s.JobOrderRateAmendmentLineId,
ActivityType = (int)ActivityTypeContants.Modified,
DocNo = temp.DocNo,
DocDate = temp.DocDate,
xEModifications = Modifications,
DocStatus = temp.Status,
}));
//End Of Saving Activity Log
return(Json(new { success = true }));
}
return(PartialView("_Create", svm));
}
}
