public ActionResult DeletePost(RequisitionCancelLineViewModel vm)
{
bool BeforeSave = true;
try
{
BeforeSave = MaterialRequestCancelDocEvents.beforeLineDeleteEvent(this, new StockEventArgs(vm.RequisitionCancelHeaderId, vm.RequisitionCancelLineId), 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>();
RequisitionCancelLine RequisitionLine = (from p in db.RequisitionCancelLine
where p.RequisitionCancelLineId == vm.RequisitionCancelLineId
select p).FirstOrDefault();
//RequisitionCancelLine RequisitionLine = _RequisitionCancelLineService.Find(vm.RequisitionCancelLineId);
RequisitionCancelHeader header = new RequisitionCancelHeaderService(_unitOfWork).Find(RequisitionLine.RequisitionCancelHeaderId);
RequisitionCancelLine ExRec = new RequisitionCancelLine();
ExRec = Mapper.Map <RequisitionCancelLine>(RequisitionLine);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
});
new RequisitionLineStatusService(_unitOfWork).UpdateRequisitionQtyOnCancel(RequisitionLine.RequisitionLineId, RequisitionLine.RequisitionCancelLineId, header.DocDate, 0, ref db, true);
RequisitionLine.ObjectState = Model.ObjectState.Deleted;
db.RequisitionCancelLine.Remove(RequisitionLine);
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.RequisitionCancelHeader.Add(header);
}
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
MaterialRequestCancelDocEvents.onLineDeleteEvent(this, new StockEventArgs(RequisitionLine.RequisitionCancelHeaderId, RequisitionLine.RequisitionCancelLineId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
EventException = true;
}
try
{
if (EventException)
{
throw new Exception();
}
db.SaveChanges();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Create", vm));
}
try
{
MaterialRequestCancelDocEvents.afterLineDeleteEvent(this, new StockEventArgs(RequisitionLine.RequisitionCancelHeaderId, RequisitionLine.RequisitionCancelLineId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = header.DocTypeId,
DocId = header.RequisitionCancelHeaderId,
DocLineId = RequisitionLine.RequisitionCancelLineId,
ActivityType = (int)ActivityTypeContants.Deleted,
DocNo = header.DocNo,
xEModifications = Modifications,
DocDate = header.DocDate,
DocStatus = header.Status,
}));
}
return(Json(new { success = true }));
}
public ActionResult _ResultsPost(RequisitionCancelListModel vm)
{
Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();
var Header = new RequisitionCancelHeaderService(_unitOfWork).Find(vm.RequisitionCancelViewModels.FirstOrDefault().RequisitionCancelHeaderId);
bool BeforeSave = true;
try
{
BeforeSave = MaterialRequestCancelDocEvents.beforeLineSaveBulkEvent(this, new StockEventArgs(vm.RequisitionCancelViewModels.FirstOrDefault().RequisitionCancelHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
EventException = true;
}
if (!BeforeSave)
{
ModelState.AddModelError("", "Validation failed before save");
}
if (ModelState.IsValid && BeforeSave && !EventException)
{
foreach (var item in vm.RequisitionCancelViewModels)
{
decimal balqty = (from p in db.ViewRequisitionBalance
where p.RequisitionLineId == item.RequisitionLineId
select p.BalanceQty).FirstOrDefault();
if (item.Qty > 0 && item.Qty <= balqty)
{
RequisitionCancelLine line = new RequisitionCancelLine();
line.RequisitionCancelHeaderId = item.RequisitionCancelHeaderId;
line.RequisitionLineId = item.RequisitionLineId;
line.Qty = item.Qty;
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.RequisitionLineId, line.Qty);
//_RequisitionCancelLineService.Create(line);
line.ObjectState = Model.ObjectState.Added;
db.RequisitionCancelLine.Add(line);
}
}
new RequisitionLineStatusService(_unitOfWork).UpdateRequisitionQtyCancelMultiple(LineStatus, Header.DocDate, ref db);
try
{
MaterialRequestCancelDocEvents.onLineSaveBulkEvent(this, new StockEventArgs(vm.RequisitionCancelViewModels.FirstOrDefault().RequisitionCancelHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
EventException = true;
}
try
{
if (EventException)
{
throw new Exception();
}
db.SaveChanges();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Results", vm));
}
try
{
MaterialRequestCancelDocEvents.afterLineSaveBulkEvent(this, new StockEventArgs(vm.RequisitionCancelViewModels.FirstOrDefault().RequisitionCancelHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Header.DocTypeId,
DocId = Header.RequisitionCancelHeaderId,
ActivityType = (int)ActivityTypeContants.MultipleCreate,
DocNo = Header.DocNo,
DocDate = Header.DocDate,
DocStatus = Header.Status,
}));
return(Json(new { success = true }));
}
return(PartialView("_Results", vm));
}
public ActionResult DeleteConfirmed(ReasonViewModel vm)
{
bool BeforeSave = true;
try
{
BeforeSave = MaterialRequestCancelDocEvents.beforeHeaderDeleteEvent(this, new StockEventArgs(vm.id), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
EventException = true;
}
if (!BeforeSave)
{
TempData["CSEXC"] += "Failed validation before delete";
}
if (ModelState.IsValid && BeforeSave && !EventException)
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
//var temp = _RequisitionCancelHeaderService.Find(vm.id);
var temp = (from p in db.RequisitionCancelHeader
where p.RequisitionCancelHeaderId == vm.id
select p).FirstOrDefault();
try
{
MaterialRequestCancelDocEvents.onHeaderDeleteEvent(this, new StockEventArgs(vm.id), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
EventException = true;
}
RequisitionCancelHeader ExRec = new RequisitionCancelHeader();
ExRec = Mapper.Map <RequisitionCancelHeader>(temp);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
});
//var lines = new RequisitionCancelLineService(_unitOfWork).GetRequisitionCancelLineForHeader(vm.id);
var lines = (from p in db.RequisitionCancelLine
where p.RequisitionCancelHeaderId == vm.id
select p).ToList();
new RequisitionLineStatusService(_unitOfWork).DeleteRequisitionQtyOnCancelMultiple(vm.id, ref db);
foreach (var item in lines)
{
RequisitionCancelLine ExRecLine = new RequisitionCancelLine();
ExRecLine = Mapper.Map <RequisitionCancelLine>(item);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRecLine,
});
item.ObjectState = Model.ObjectState.Deleted;
db.RequisitionCancelLine.Remove(item);
//new RequisitionCancelLineService(_unitOfWork).Delete(item.RequisitionCancelLineId);
}
//_RequisitionCancelHeaderService.Delete(vm.id);
temp.ObjectState = Model.ObjectState.Deleted;
db.RequisitionCancelHeader.Remove(temp);
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
if (EventException)
{
throw new Exception();
}
db.SaveChanges();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
return(PartialView("_Reason", vm));
}
try
{
MaterialRequestCancelDocEvents.afterHeaderDeleteEvent(this, new StockEventArgs(vm.id), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = temp.DocTypeId,
DocId = temp.RequisitionCancelHeaderId,
ActivityType = (int)ActivityTypeContants.Deleted,
UserRemark = vm.Reason,
DocNo = temp.DocNo,
xEModifications = Modifications,
DocDate = temp.DocDate,
DocStatus = temp.Status,
}));
return(Json(new { success = true }));
}
return(PartialView("_Reason", vm));
}
public ActionResult _CreatePost(RequisitionCancelLineViewModel svm)
{
bool BeforeSave = true;
try
{
if (svm.RequisitionLineId <= 0)
{
BeforeSave = MaterialRequestCancelDocEvents.beforeLineSaveEvent(this, new StockEventArgs(svm.RequisitionCancelHeaderId, EventModeConstants.Add), ref db);
}
else
{
BeforeSave = MaterialRequestCancelDocEvents.beforeLineSaveEvent(this, new StockEventArgs(svm.RequisitionCancelHeaderId, 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.RequisitionCancelLineId <= 0)
{
ViewBag.LineMode = "Create";
}
else
{
ViewBag.LineMode = "Edit";
}
if (svm.RequisitionCancelLineId <= 0)
{
RequisitionCancelHeader temp = new RequisitionCancelHeaderService(_unitOfWork).Find(svm.RequisitionCancelHeaderId);
RequisitionCancelLine s = new RequisitionCancelLine();
decimal balqty = (from p in db.ViewRequisitionBalance
where p.RequisitionLineId == svm.RequisitionLineId
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.RequisitionCancelHeaderId = svm.RequisitionCancelHeaderId;
s.RequisitionLineId = svm.RequisitionLineId;
s.Qty = svm.Qty;
s.CreatedDate = DateTime.Now;
s.ModifiedDate = DateTime.Now;
s.CreatedBy = User.Identity.Name;
s.ModifiedBy = User.Identity.Name;
s.ObjectState = Model.ObjectState.Added;
db.RequisitionCancelLine.Add(s);
//_RequisitionCancelLineService.Create(s);
new RequisitionLineStatusService(_unitOfWork).UpdateRequisitionQtyOnCancel(s.RequisitionLineId, s.RequisitionCancelLineId, temp.DocDate, s.Qty, ref db, true);
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.RequisitionCancelHeader.Add(temp);
}
try
{
MaterialRequestCancelDocEvents.onLineSaveEvent(this, new StockEventArgs(s.RequisitionCancelHeaderId, s.RequisitionLineId, 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();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Create", svm));
}
try
{
MaterialRequestCancelDocEvents.afterLineSaveEvent(this, new StockEventArgs(s.RequisitionCancelHeaderId, s.RequisitionLineId, EventModeConstants.Add), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = temp.DocTypeId,
DocId = temp.RequisitionCancelHeaderId,
DocLineId = s.RequisitionCancelLineId,
ActivityType = (int)ActivityTypeContants.Added,
DocNo = temp.DocNo,
DocDate = temp.DocDate,
DocStatus = temp.Status,
}));
return(RedirectToAction("_Create", new { id = s.RequisitionCancelHeaderId, sid = svm.PersonId }));
}
return(PartialView("_Create", svm));
}
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
RequisitionCancelHeader temp = new RequisitionCancelHeaderService(_unitOfWork).Find(svm.RequisitionCancelHeaderId);
int status = temp.Status;
StringBuilder logstring = new StringBuilder();
RequisitionCancelLine s = _RequisitionCancelLineService.Find(svm.RequisitionCancelLineId);
RequisitionCancelLine ExRec = new RequisitionCancelLine();
ExRec = Mapper.Map <RequisitionCancelLine>(s);
decimal balqty = (from p in db.ViewRequisitionBalance
where p.RequisitionLineId == svm.RequisitionLineId
select p.BalanceQty).FirstOrDefault();
if (balqty + s.Qty < svm.Qty)
{
ModelState.AddModelError("Qty", "Qty Exceeding Balance Qty");
}
if (ModelState.IsValid && BeforeSave)
{
if (svm.Qty > 0)
{
s.Remark = svm.Remark;
s.Qty = svm.Qty;
s.ModifiedBy = User.Identity.Name;
s.ModifiedDate = DateTime.Now;
new RequisitionLineStatusService(_unitOfWork).UpdateRequisitionQtyOnCancel(s.RequisitionLineId, s.RequisitionCancelLineId, temp.DocDate, s.Qty, ref db, true);
}
//_RequisitionCancelLineService.Update(s);
s.ObjectState = Model.ObjectState.Modified;
db.RequisitionCancelLine.Add(s);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = s,
});
if (temp.Status != (int)StatusConstants.Drafted)
{
temp.Status = (int)StatusConstants.Modified;
temp.ObjectState = Model.ObjectState.Modified;
db.RequisitionCancelHeader.Add(temp);
//new RequisitionCancelHeaderService(_unitOfWork).Update(temp);
}
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
MaterialRequestCancelDocEvents.onLineSaveEvent(this, new StockEventArgs(s.RequisitionCancelHeaderId, s.RequisitionCancelLineId, 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();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Create", svm));
}
try
{
MaterialRequestCancelDocEvents.afterLineSaveEvent(this, new StockEventArgs(s.RequisitionCancelHeaderId, s.RequisitionCancelLineId, 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.RequisitionCancelHeaderId,
DocLineId = s.RequisitionCancelLineId,
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));
}
}
public void Update(RequisitionCancelLine pt)
{
pt.ObjectState = ObjectState.Modified;
_unitOfWork.Repository <RequisitionCancelLine>().Update(pt);
}
public void Delete(RequisitionCancelLine pt)
{
_unitOfWork.Repository <RequisitionCancelLine>().Delete(pt);
}
public RequisitionCancelLine Create(RequisitionCancelLine pt)
{
pt.ObjectState = ObjectState.Added;
_unitOfWork.Repository <RequisitionCancelLine>().Insert(pt);
return(pt);
}
public RequisitionCancelLine Add(RequisitionCancelLine pt)
{
_unitOfWork.Repository <RequisitionCancelLine>().Insert(pt);
return(pt);
}
public bool CancelPendingWeavingRequisitions(int HeaderId, string UserName, int DocType)
{
bool Success = false;
var PendingRequisitionLines = (from p in db.ViewRequisitionBalance
where p.RequisitionHeaderId == HeaderId && p.BalanceQty > 0
select new { p.RequisitionLineId, p.BalanceQty, p.PersonId }).ToList();
int SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
var ReasonId = (from p in db.RequisitionSetting
where p.DocTypeId == DocType && p.DivisionId == DivisionId && p.SiteId == SiteId
select p.DefaultReasonId).FirstOrDefault();
if (!ReasonId.HasValue)
{
ReasonId = new ReasonService(_unitOfWork).GetReasonList(TransactionDocCategoryConstants.RequisitionCancel).FirstOrDefault().ReasonId;
}
if (PendingRequisitionLines.Count() > 0)
{
RequisitionCancelHeader Header = new RequisitionCancelHeader();
Header.CreatedBy = UserName;
Header.CreatedDate = DateTime.Now;
Header.DivisionId = DivisionId;
Header.DocDate = DateTime.Now;
Header.DocTypeId = DocType;
Header.SiteId = SiteId;
Header.DocNo = new DocumentTypeService(_unitOfWork).FGetNewDocNo("DocNo", ConfigurationManager.AppSettings["DataBaseSchema"] + ".RequisitionCancelHeaders", Header.DocTypeId, Header.DocDate, Header.DivisionId, Header.SiteId);
Header.ModifiedBy = UserName;
Header.ModifiedDate = DateTime.Now;
Header.PersonId = PendingRequisitionLines.FirstOrDefault().PersonId;
Header.ReasonId = ReasonId.Value;
Header.ObjectState = Model.ObjectState.Added;
db.RequisitionCancelHeader.Add(Header);
foreach (var item in PendingRequisitionLines)
{
RequisitionCancelLine Line = new RequisitionCancelLine();
Line.CreatedBy = UserName;
Line.CreatedDate = DateTime.Now;
Line.ModifiedBy = UserName;
Line.ModifiedDate = DateTime.Now;
Line.Qty = item.BalanceQty;
Line.RequisitionLineId = item.RequisitionLineId;
Line.RequisitionCancelHeaderId = Header.RequisitionCancelHeaderId;
Line.ObjectState = Model.ObjectState.Added;
db.RequisitionCancelLine.Add(Line);
RequisitionLineStatus LineStatus = db.RequisitionLineStatus.Find(item.RequisitionLineId);
if (LineStatus != null)
{
LineStatus.CancelQty = (LineStatus.CancelQty ?? 0) + Line.Qty;
LineStatus.ObjectState = Model.ObjectState.Modified;
db.RequisitionLineStatus.Add(LineStatus);
}
}
try
{
db.SaveChanges();
}
catch (Exception Ex)
{
Success = false;
}
Success = true;
}
return(Success);
}
