public void Update(PurchaseOrderCancelLine pt)
{
pt.ObjectState = ObjectState.Modified;
_unitOfWork.Repository <PurchaseOrderCancelLine>().Update(pt);
}
public PurchaseOrderCancelLine Create(PurchaseOrderCancelLine pt)
{
pt.ObjectState = ObjectState.Added;
_unitOfWork.Repository <PurchaseOrderCancelLine>().Insert(pt);
return(pt);
}
public void Delete(PurchaseOrderCancelLine pt)
{
_unitOfWork.Repository <PurchaseOrderCancelLine>().Delete(pt);
}
public PurchaseOrderCancelLine Add(PurchaseOrderCancelLine pt)
{
_unitOfWork.Repository <PurchaseOrderCancelLine>().Insert(pt);
return(pt);
}
public ActionResult ConfirmedPurchaseOrders(List <PurchaseOrderCancelWizardViewModel> ConfirmedList, int DocTypeId, string UserRemark, int ReasonId)
{
//System.Web.HttpContext.Current.Session["BalanceQtyAmendmentWizardOrders"] = ConfirmedList;
//return Json(new { Success = "URL", Data = "/PurchaseOrderCancelWizard/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 = PurchaseOrderCancelDocEvents.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;
PurchaseOrderSetting Settings = new PurchaseOrderSettingService(_unitOfWork).GetPurchaseOrderSettingForDocument(DocTypeId, DivisionId, SiteId);
int?MaxLineId = 0;
if (ModelState.IsValid && BeforeSave && !EventException)
{
PurchaseOrderCancelHeader pt = new PurchaseOrderCancelHeader();
//Getting Settings
pt.SiteId = SiteId;
pt.SupplierId = ConfirmedList.FirstOrDefault().SupplierId;
pt.DivisionId = DivisionId;
pt.Remark = UserRemark;
pt.DocTypeId = DocTypeId;
pt.ReasonId = ReasonId;
pt.DocDate = DateTime.Now;
pt.DocNo = new DocumentTypeService(_unitOfWork).FGetNewDocNo("DocNo", ConfigurationManager.AppSettings["DataBaseSchema"] + ".PurchaseOrderCancelHeaders", pt.DocTypeId, pt.DocDate, pt.DivisionId, pt.SiteId);
pt.ModifiedBy = User.Identity.Name;
pt.ModifiedDate = DateTime.Now;
pt.CreatedBy = User.Identity.Name;
pt.CreatedDate = DateTime.Now;
pt.Status = (int)StatusConstants.Drafted;
pt.ObjectState = Model.ObjectState.Added;
db.PurchaseOrderCancelHeader.Add(pt);
var SelectedPurchaseOrders = ConfirmedList;
var PurchaseOrderLineIds = SelectedPurchaseOrders.Select(m => m.PurchaseOrderLineId).ToArray();
var PurchaseOrderBalanceRecords = (from p in db.ViewPurchaseOrderBalance
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.CancelQty <= PurchaseOrderBalanceRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault().BalanceQty)
{
PurchaseOrderCancelLine line = new PurchaseOrderCancelLine();
line.PurchaseOrderCancelHeaderId = pt.PurchaseOrderCancelHeaderId;
line.PurchaseOrderLineId = item.PurchaseOrderLineId;
line.Qty = PurchaseOrderBalanceRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault().BalanceQty;
line.Qty = item.CancelQty;
line.Sr = Serial++;
line.PurchaseOrderCancelLineId = Cnt;
line.CreatedDate = DateTime.Now;
line.ModifiedDate = DateTime.Now;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
LineStatus.Add(line.PurchaseOrderLineId, line.Qty);
line.ObjectState = Model.ObjectState.Added;
db.PurchaseOrderCancelLine.Add(line);
Cnt = Cnt + 1;
}
}
new PurchaseOrderLineStatusService(_unitOfWork).UpdatePurchaseQtyCancelMultiple(LineStatus, pt.DocDate, ref db);
try
{
PurchaseOrderCancelDocEvents.onWizardSaveEvent(this, new PurchaseEventArgs(pt.PurchaseOrderCancelHeaderId, 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
{
PurchaseOrderCancelDocEvents.afterWizardSaveEvent(this, new PurchaseEventArgs(pt.PurchaseOrderCancelHeaderId, 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.PurchaseOrderCancelHeaderId,
ActivityType = (int)ActivityTypeContants.WizardCreate,
DocNo = pt.DocNo,
DocDate = pt.DocDate,
DocStatus = pt.Status,
}));
return(Json(new { Success = "URL", Data = "/PurchaseOrderCancelHeader/Submit/" + pt.PurchaseOrderCancelHeaderId }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Success = false, Data = "ModelState is Invalid" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult _ResultsPost(PurchaseOrderCancelMasterDetailModel vm)
{
int Serial = _PurchaseOrderCancelLineService.GetMaxSr(vm.PurchaseOrderCancelViewModels.FirstOrDefault().PurchaseOrderCancelHeaderId);
Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();
var Header = new PurchaseOrderCancelHeaderService(_unitOfWork).Find(vm.PurchaseOrderCancelViewModels.FirstOrDefault().PurchaseOrderCancelHeaderId);
bool BeforeSave = true;
try
{
BeforeSave = PurchaseOrderCancelDocEvents.beforeLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseOrderCancelViewModels.FirstOrDefault().PurchaseOrderCancelHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
EventException = true;
}
if (!BeforeSave)
{
ModelState.AddModelError("", "Validation failed before save");
}
if (ModelState.IsValid && BeforeSave && !EventException)
{
foreach (var item in vm.PurchaseOrderCancelViewModels)
{
decimal balqty = (from p in db.ViewPurchaseOrderBalance
where p.PurchaseOrderLineId == item.PurchaseOrderLineId
select p.BalanceQty).FirstOrDefault();
if (item.Qty > 0 && item.Qty <= balqty)
{
PurchaseOrderCancelLine line = new PurchaseOrderCancelLine();
line.PurchaseOrderCancelHeaderId = item.PurchaseOrderCancelHeaderId;
line.PurchaseOrderLineId = item.PurchaseOrderLineId;
line.Qty = item.Qty;
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.PurchaseOrderLineId, line.Qty);
line.ObjectState = Model.ObjectState.Added;
db.PurchaseOrderCancelLine.Add(line);
//_PurchaseOrderCancelLineService.Create(line);
}
}
new PurchaseOrderLineStatusService(_unitOfWork).UpdatePurchaseQtyCancelMultiple(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.PurchaseOrderCancelHeader.Add(Header);
}
try
{
PurchaseOrderCancelDocEvents.onLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseOrderCancelViewModels.FirstOrDefault().PurchaseOrderCancelHeaderId), 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
{
PurchaseOrderCancelDocEvents.afterLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseOrderCancelViewModels.FirstOrDefault().PurchaseOrderCancelHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Header.DocTypeId,
DocId = Header.PurchaseOrderCancelHeaderId,
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(PurchaseOrderCancelLineViewModel vm)
{
bool BeforeSave = true;
try
{
BeforeSave = PurchaseOrderCancelDocEvents.beforeLineDeleteEvent(this, new PurchaseEventArgs(vm.PurchaseOrderCancelHeaderId, vm.PurchaseOrderCancelLineId), 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)
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
PurchaseOrderCancelLine PurchaseOrderCancelLine = db.PurchaseOrderCancelLine.Find(vm.PurchaseOrderCancelLineId);
try
{
PurchaseOrderCancelDocEvents.onLineDeleteEvent(this, new PurchaseEventArgs(PurchaseOrderCancelLine.PurchaseOrderCancelHeaderId, PurchaseOrderCancelLine.PurchaseOrderCancelLineId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
EventException = true;
}
LogList.Add(new LogTypeViewModel
{
ExObj = Mapper.Map <PurchaseOrderCancelLine>(PurchaseOrderCancelLine),
});
PurchaseOrderCancelHeader header = new PurchaseOrderCancelHeaderService(_unitOfWork).Find(PurchaseOrderCancelLine.PurchaseOrderCancelHeaderId);
new PurchaseOrderLineStatusService(_unitOfWork).UpdatePurchaseQtyOnCancel(PurchaseOrderCancelLine.PurchaseOrderLineId, PurchaseOrderCancelLine.PurchaseOrderCancelLineId, header.DocDate, 0, ref db, true);
//_PurchaseOrderCancelLineService.Delete(vm.PurchaseOrderCancelLineId);
PurchaseOrderCancelLine.ObjectState = Model.ObjectState.Deleted;
db.PurchaseOrderCancelLine.Remove(PurchaseOrderCancelLine);
if (header.Status != (int)StatusConstants.Drafted)
{
header.Status = (int)StatusConstants.Modified;
header.ModifiedDate = DateTime.Now;
header.ModifiedBy = User.Identity.Name;
header.ObjectState = Model.ObjectState.Modified;
db.PurchaseOrderCancelHeader.Add(header);
//new PurchaseOrderCancelHeaderService(_unitOfWork).Update(header);
}
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
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
{
PurchaseOrderCancelDocEvents.afterLineDeleteEvent(this, new PurchaseEventArgs(PurchaseOrderCancelLine.PurchaseOrderCancelHeaderId, PurchaseOrderCancelLine.PurchaseOrderCancelLineId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = header.DocTypeId,
DocId = header.PurchaseOrderCancelHeaderId,
DocLineId = PurchaseOrderCancelLine.PurchaseOrderCancelLineId,
ActivityType = (int)ActivityTypeContants.Deleted,
DocNo = header.DocNo,
xEModifications = Modifications,
DocDate = header.DocDate,
DocStatus = header.Status,
}));
}
return(Json(new { success = true }));
}
public ActionResult _CreatePost(PurchaseOrderCancelLineViewModel svm)
{
if (svm.PurchaseOrderLineId <= 0)
{
ViewBag.LineMode = "Create";
}
else
{
ViewBag.LineMode = "Edit";
}
bool BeforeSave = true;
try
{
if (svm.PurchaseOrderCancelLineId <= 0)
{
BeforeSave = PurchaseOrderCancelDocEvents.beforeLineSaveEvent(this, new PurchaseEventArgs(svm.PurchaseOrderCancelHeaderId, EventModeConstants.Add), ref db);
}
else
{
BeforeSave = PurchaseOrderCancelDocEvents.beforeLineSaveEvent(this, new PurchaseEventArgs(svm.PurchaseOrderCancelHeaderId, 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.");
}
if (svm.PurchaseOrderCancelLineId <= 0)
{
PurchaseOrderCancelLine s = new PurchaseOrderCancelLine();
decimal balqty = (from p in db.ViewPurchaseOrderBalance
where p.PurchaseOrderLineId == svm.PurchaseOrderLineId
select p.BalanceQty).FirstOrDefault();
if (balqty < svm.Qty)
{
ModelState.AddModelError("Qty", "Qty Exceeding Balance Qty");
}
if (svm.Qty == 0)
{
ModelState.AddModelError("Qty", "Please Check Qty");
}
if (ModelState.IsValid && BeforeSave && !EventException)
{
s.Remark = svm.Remark;
s.PurchaseOrderCancelHeaderId = svm.PurchaseOrderCancelHeaderId;
s.PurchaseOrderLineId = svm.PurchaseOrderLineId;
s.Qty = svm.Qty;
s.Sr = _PurchaseOrderCancelLineService.GetMaxSr(s.PurchaseOrderCancelHeaderId);
s.CreatedDate = DateTime.Now;
s.ModifiedDate = DateTime.Now;
s.CreatedBy = User.Identity.Name;
s.ModifiedBy = User.Identity.Name;
s.ObjectState = Model.ObjectState.Added;
db.PurchaseOrderCancelLine.Add(s);
//_PurchaseOrderCancelLineService.Create(s);
PurchaseOrderCancelHeader temp2 = new PurchaseOrderCancelHeaderService(_unitOfWork).Find(s.PurchaseOrderCancelHeaderId);
new PurchaseOrderLineStatusService(_unitOfWork).UpdatePurchaseQtyOnCancel(s.PurchaseOrderLineId, s.PurchaseOrderCancelLineId, temp2.DocDate, s.Qty, ref db, true);
if (temp2.Status != (int)StatusConstants.Drafted && temp2.Status != (int)StatusConstants.Import)
{
temp2.Status = (int)StatusConstants.Modified;
temp2.ModifiedBy = User.Identity.Name;
temp2.ModifiedDate = DateTime.Now;
temp2.ObjectState = Model.ObjectState.Modified;
db.PurchaseOrderCancelHeader.Add(temp2);
}
//new PurchaseOrderCancelHeaderService(_unitOfWork).Update(temp2);
try
{
PurchaseOrderCancelDocEvents.onLineSaveEvent(this, new PurchaseEventArgs(s.PurchaseOrderCancelHeaderId, s.PurchaseOrderCancelLineId, 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
{
PurchaseOrderCancelDocEvents.afterLineSaveEvent(this, new PurchaseEventArgs(s.PurchaseOrderCancelHeaderId, s.PurchaseOrderCancelLineId, 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 = s.PurchaseOrderCancelHeaderId,
DocLineId = s.PurchaseOrderCancelLineId,
ActivityType = (int)ActivityTypeContants.Added,
DocNo = temp2.DocNo,
DocDate = temp2.DocDate,
DocStatus = temp2.Status,
}));
return(RedirectToAction("_Create", new { id = s.PurchaseOrderCancelHeaderId, sid = svm.SupplierId }));
}
return(PartialView("_Create", svm));
}
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
PurchaseOrderCancelHeader temp = new PurchaseOrderCancelHeaderService(_unitOfWork).Find(svm.PurchaseOrderCancelHeaderId);
int status = temp.Status;
StringBuilder logstring = new StringBuilder();
PurchaseOrderCancelLine s = db.PurchaseOrderCancelLine.Find(svm.PurchaseOrderCancelLineId);
PurchaseOrderCancelLine ExRec = new PurchaseOrderCancelLine();
ExRec = Mapper.Map <PurchaseOrderCancelLine>(s);
decimal balqty = (from p in db.ViewPurchaseOrderBalance
where p.PurchaseOrderLineId == svm.PurchaseOrderLineId
select p.BalanceQty).FirstOrDefault();
if (balqty + s.Qty < svm.Qty)
{
ModelState.AddModelError("Qty", "Qty Exceeding Balance Qty");
}
if (ModelState.IsValid && BeforeSave && !EventException)
{
if (svm.Qty > 0)
{
s.Remark = svm.Remark;
s.Qty = svm.Qty;
s.ModifiedBy = User.Identity.Name;
s.ModifiedDate = DateTime.Now;
new PurchaseOrderLineStatusService(_unitOfWork).UpdatePurchaseQtyOnCancel(s.PurchaseOrderLineId, s.PurchaseOrderCancelLineId, temp.DocDate, s.Qty, ref db, true);
}
//_PurchaseOrderCancelLineService.Update(s);
s.ObjectState = Model.ObjectState.Modified;
db.PurchaseOrderCancelLine.Add(s);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = s,
});
if (temp.Status != (int)StatusConstants.Drafted && temp.Status != (int)StatusConstants.Import)
{
temp.Status = (int)StatusConstants.Modified;
temp.ModifiedBy = User.Identity.Name;
temp.ModifiedDate = DateTime.Now;
temp.ObjectState = Model.ObjectState.Modified;
db.PurchaseOrderCancelHeader.Add(temp);
//new PurchaseOrderCancelHeaderService(_unitOfWork).Update(temp);
}
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
PurchaseOrderCancelDocEvents.onLineSaveEvent(this, new PurchaseEventArgs(s.PurchaseOrderCancelHeaderId, s.PurchaseOrderCancelLineId, 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
{
PurchaseOrderCancelDocEvents.afterLineSaveEvent(this, new PurchaseEventArgs(s.PurchaseOrderCancelHeaderId, s.PurchaseOrderCancelLineId, 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 = s.PurchaseOrderCancelHeaderId,
DocLineId = s.PurchaseOrderCancelLineId,
ActivityType = (int)ActivityTypeContants.Modified,
DocNo = temp.DocNo,
xEModifications = Modifications,
DocDate = temp.DocDate,
DocStatus = temp.Status,
}));
//End Of Saving Activity Log
return(Json(new { success = true }));
}
return(PartialView("_Create", svm));
}
}
