public ActionResult ConfirmedPurchaseOrders(List <PurchaseOrderAmendmentWizardViewModel> ConfirmedList, int DocTypeId, string UserRemark)
{
//System.Web.HttpContext.Current.Session["RateAmendmentWizardOrders"] = ConfirmedList;
//return Json(new { Success = "URL", Data = "/PurchaseOrderRateAmendmentWizard/Create/" + DocTypeId }, JsonRequestBehavior.AllowGet);
if (ConfirmedList.Count() > 0 && ConfirmedList.GroupBy(m => m.SupplierId).Count() > 1)
{
return(Json(new { Success = false, Data = " Multiple Headers are selected. " }, JsonRequestBehavior.AllowGet));
}
else if (ConfirmedList.Count() == 0)
{
return(Json(new { Success = false, Data = " No Records are selected. " }, JsonRequestBehavior.AllowGet));
}
else
{
int DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
int SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
bool BeforeSave = true;
int Serial = 1;
Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();
try
{
BeforeSave = PurchaseOrderAmendmentDocEvents.beforeWizardSaveEvent(this, new PurchaseEventArgs(0), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
return(Json(new { Success = false, Data = message }, JsonRequestBehavior.AllowGet));
}
if (!BeforeSave)
{
TempData["CSEXC"] += "Failed validation before save";
}
int Cnt = 0;
int Sr = 0;
List <HeaderChargeViewModel> HeaderCharges = new List <HeaderChargeViewModel>();
List <LineChargeViewModel> LineCharges = new List <LineChargeViewModel>();
int pk = 0;
bool HeaderChargeEdit = false;
PurchaseOrderSetting Settings = new PurchaseOrderSettingService(_unitOfWork).GetPurchaseOrderSettingForDocument(DocTypeId, DivisionId, SiteId);
int?MaxLineId = 0;
int PersonCount = 0;
if (!Settings.CalculationId.HasValue)
{
throw new Exception("Calculation not configured in Purchase order settings");
}
int CalculationId = Settings.CalculationId ?? 0;
List <LineDetailListViewModel> LineList = new List <LineDetailListViewModel>();
if (ModelState.IsValid && BeforeSave && !EventException)
{
PurchaseOrderAmendmentHeader pt = new PurchaseOrderAmendmentHeader();
//Getting Settings
pt.SiteId = SiteId;
pt.SupplierId = ConfirmedList.FirstOrDefault().SupplierId;
pt.DivisionId = DivisionId;
pt.DocTypeId = DocTypeId;
pt.DocDate = DateTime.Now;
pt.DocNo = new DocumentTypeService(_unitOfWork).FGetNewDocNo("DocNo", ConfigurationManager.AppSettings["DataBaseSchema"] + ".PurchaseOrderAmendmentHeaders", pt.DocTypeId, pt.DocDate, pt.DivisionId, pt.SiteId);
pt.Status = (int)StatusConstants.Drafted;
_PurchaseOrderAmendmentHeaderService.Create(pt, User.Identity.Name);
var SelectedPurchaseOrders = ConfirmedList;
var PurchaseOrderLineIds = SelectedPurchaseOrders.Select(m => m.PurchaseOrderLineId).ToArray();
var PurchaseOrderBalanceRecords = (from p in db.ViewPurchaseOrderBalanceForInvoice
where PurchaseOrderLineIds.Contains(p.PurchaseOrderLineId)
select p).AsNoTracking().ToList();
var PurchaseOrderRecords = (from p in db.PurchaseOrderLine
where PurchaseOrderLineIds.Contains(p.PurchaseOrderLineId)
select p).AsNoTracking().ToList();
foreach (var item in SelectedPurchaseOrders)
{
PurchaseOrderLine orderline = PurchaseOrderRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault();
var balorderline = PurchaseOrderBalanceRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault();
if (item.Rate - PurchaseOrderBalanceRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault().Rate != 0)
{
PurchaseOrderRateAmendmentLine line = new PurchaseOrderRateAmendmentLine();
line.PurchaseOrderAmendmentHeaderId = pt.PurchaseOrderAmendmentHeaderId;
line.PurchaseOrderLineId = item.PurchaseOrderLineId;
line.Qty = PurchaseOrderBalanceRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault().BalanceQty;
line.AmendedRate = item.Rate;
line.Rate = line.AmendedRate - balorderline.Rate;
line.Amount = balorderline.BalanceQty * orderline.UnitConversionMultiplier * line.Rate;
line.PurchaseOrderRate = balorderline.Rate;
line.Sr = Serial++;
line.PurchaseOrderRateAmendmentLineId = pk;
line.CreatedDate = DateTime.Now;
line.ModifiedDate = DateTime.Now;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
LineStatus.Add(line.PurchaseOrderLineId, line.Rate);
line.ObjectState = Model.ObjectState.Added;
db.PurchaseOrderRateAmendmentLine.Add(line);
if (Settings.CalculationId.HasValue)
{
LineList.Add(new LineDetailListViewModel {
Amount = line.Amount, Rate = line.Rate, LineTableId = line.PurchaseOrderRateAmendmentLineId, HeaderTableId = pt.PurchaseOrderAmendmentHeaderId, PersonID = pt.SupplierId, DealQty = orderline.DealQty
});
}
pk++;
Cnt = Cnt + 1;
}
}
new PurchaseOrderLineStatusService(_unitOfWork).UpdatePurchaseRateOnAmendmentMultiple(LineStatus, pt.DocDate, ref db);
new ChargesCalculationService(_unitOfWork).CalculateCharges(LineList, pt.PurchaseOrderAmendmentHeaderId, CalculationId, MaxLineId, out LineCharges, out HeaderChargeEdit, out HeaderCharges, "Web.PurchaseOrderAmendmentHeaderCharges", "Web.PurchaseOrderRateAmendmentLineCharges", out PersonCount, pt.DocTypeId, pt.SiteId, pt.DivisionId);
//Saving Charges
foreach (var item in LineCharges)
{
PurchaseOrderRateAmendmentLineCharge PoLineCharge = Mapper.Map <LineChargeViewModel, PurchaseOrderRateAmendmentLineCharge>(item);
PoLineCharge.ObjectState = Model.ObjectState.Added;
db.PurchaseOrderRateAmendmentLineCharge.Add(PoLineCharge);
}
//Saving Header charges
for (int i = 0; i < HeaderCharges.Count(); i++)
{
if (!HeaderChargeEdit)
{
PurchaseOrderAmendmentHeaderCharge POHeaderCharge = Mapper.Map <HeaderChargeViewModel, PurchaseOrderAmendmentHeaderCharge>(HeaderCharges[i]);
POHeaderCharge.HeaderTableId = pt.PurchaseOrderAmendmentHeaderId;
POHeaderCharge.PersonID = pt.SupplierId;
POHeaderCharge.ObjectState = Model.ObjectState.Added;
db.PurchaseOrderAmendmentHeaderCharges.Add(POHeaderCharge);
}
else
{
var footercharge = new PurchaseOrderAmendmentHeaderChargeService(_unitOfWork).Find(HeaderCharges[i].Id);
footercharge.Rate = HeaderCharges[i].Rate;
footercharge.Amount = HeaderCharges[i].Amount;
footercharge.ObjectState = Model.ObjectState.Modified;
db.PurchaseOrderAmendmentHeaderCharges.Add(footercharge);
}
}
try
{
PurchaseOrderAmendmentDocEvents.onWizardSaveEvent(this, new PurchaseEventArgs(pt.PurchaseOrderAmendmentHeaderId, 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);
return(Json(new { Success = false, Data = message }, JsonRequestBehavior.AllowGet));
}
try
{
PurchaseOrderAmendmentDocEvents.afterWizardSaveEvent(this, new PurchaseEventArgs(pt.PurchaseOrderAmendmentHeaderId, EventModeConstants.Add), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = pt.DocTypeId,
DocId = pt.PurchaseOrderAmendmentHeaderId,
ActivityType = (int)ActivityTypeContants.WizardCreate,
DocNo = pt.DocNo,
DocDate = pt.DocDate,
DocStatus = pt.Status,
}));
return(Json(new { Success = "URL", Data = "/PurchaseOrderAmendmentHeader/Submit/" + pt.PurchaseOrderAmendmentHeaderId }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Success = false, Data = "ModelState is Invalid" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult Post(PurchaseOrderAmendmentHeaderViewModel vm)
{
bool BeforeSave = true;
PurchaseOrderAmendmentHeader pt = AutoMapper.Mapper.Map <PurchaseOrderAmendmentHeaderViewModel, PurchaseOrderAmendmentHeader>(vm);
#region BeforeSave
try
{
if (vm.PurchaseOrderAmendmentHeaderId <= 0)
{
BeforeSave = PurchaseOrderAmendmentDocEvents.beforeHeaderSaveEvent(this, new PurchaseEventArgs(vm.PurchaseOrderAmendmentHeaderId, EventModeConstants.Add), ref db);
}
else
{
BeforeSave = PurchaseOrderAmendmentDocEvents.beforeHeaderSaveEvent(this, new PurchaseEventArgs(vm.PurchaseOrderAmendmentHeaderId, EventModeConstants.Edit), 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
{
if (vm.PurchaseOrderAmendmentHeaderId <= 0)
{
TimePlanValidation = DocumentValidation.ValidateDocument(Mapper.Map <DocumentUniqueId>(vm), DocumentTimePlanTypeConstants.Create, User.Identity.Name, out ExceptionMsg, out Continue);
}
else
{
TimePlanValidation = DocumentValidation.ValidateDocument(Mapper.Map <DocumentUniqueId>(vm), DocumentTimePlanTypeConstants.Modify, 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))
{
#region CreateRecord
if (vm.PurchaseOrderAmendmentHeaderId <= 0)
{
pt.Status = (int)StatusConstants.Drafted;
_PurchaseOrderAmendmentHeaderService.Create(pt, User.Identity.Name);
try
{
PurchaseOrderAmendmentDocEvents.onHeaderSaveEvent(this, new PurchaseEventArgs(pt.PurchaseOrderAmendmentHeaderId, 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
{
PurchaseOrderAmendmentDocEvents.afterHeaderSaveEvent(this, new PurchaseEventArgs(pt.PurchaseOrderAmendmentHeaderId, EventModeConstants.Add), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = pt.DocTypeId,
DocId = pt.PurchaseOrderAmendmentHeaderId,
ActivityType = (int)ActivityTypeContants.Added,
DocNo = pt.DocNo,
DocDate = pt.DocDate,
DocStatus = pt.Status,
}));
return(RedirectToAction("Modify", new { id = pt.PurchaseOrderAmendmentHeaderId }).Success("Data saved Successfully"));
}
#endregion
#region EditRecord
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
PurchaseOrderAmendmentHeader temp = _PurchaseOrderAmendmentHeaderService.Find(pt.PurchaseOrderAmendmentHeaderId);
PurchaseOrderAmendmentHeader ExRec = new PurchaseOrderAmendmentHeader();
ExRec = Mapper.Map <PurchaseOrderAmendmentHeader>(temp);
int status = temp.Status;
if (temp.Status != (int)StatusConstants.Drafted)
{
temp.Status = (int)StatusConstants.Modified;
}
temp.DocDate = pt.DocDate;
temp.DocNo = pt.DocNo;
temp.DocTypeId = pt.DocTypeId;
temp.Remark = pt.Remark;
temp.SupplierId = pt.SupplierId;
_PurchaseOrderAmendmentHeaderService.Update(temp, User.Identity.Name);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = temp,
});
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
PurchaseOrderAmendmentDocEvents.onHeaderSaveEvent(this, new PurchaseEventArgs(temp.PurchaseOrderAmendmentHeaderId, EventModeConstants.Edit), 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 = "Edit";
return(View("Create", pt));
}
try
{
PurchaseOrderAmendmentDocEvents.afterHeaderSaveEvent(this, new PurchaseEventArgs(pt.PurchaseOrderAmendmentHeaderId, EventModeConstants.Edit), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = temp.DocTypeId,
DocId = temp.PurchaseOrderAmendmentHeaderId,
ActivityType = (int)ActivityTypeContants.Modified,
DocNo = temp.DocNo,
xEModifications = Modifications,
DocDate = temp.DocDate,
DocStatus = temp.Status,
}));
return(RedirectToAction("Index", new { id = temp.DocTypeId }).Success("Data saved successfully"));
}
#endregion
}
PrepareViewBag(vm.DocTypeId);
ViewBag.Mode = "Add";
return(View("Create", vm));
}
