public ActionResult Detail(int id, string IndexType, string transactionType)
{
ViewBag.transactionType = transactionType;
ViewBag.IndexStatus = IndexType;
RequisitionCancelHeader pt = _RequisitionCancelHeaderService.Find(id);
RequisitionCancelHeaderViewModel temp = AutoMapper.Mapper.Map <RequisitionCancelHeader, RequisitionCancelHeaderViewModel>(pt);
PrepareViewBag(pt.DocTypeId);
if (pt == null)
{
return(HttpNotFound());
}
if (String.IsNullOrEmpty(transactionType) || transactionType == "detail")
{
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = pt.DocTypeId,
DocId = pt.RequisitionCancelHeaderId,
ActivityType = (int)ActivityTypeContants.Detail,
DocNo = pt.DocNo,
DocDate = pt.DocDate,
DocStatus = pt.Status,
}));
}
return(View("Create", temp));
}
public ActionResult DeleteAfter_Submit(int id)
{
RequisitionCancelHeader header = _RequisitionCancelHeaderService.Find(id);
if (header.Status == (int)StatusConstants.Submitted || header.Status == (int)StatusConstants.Modified)
{
return(Remove(id));
}
else
{
return(HttpNotFound());
}
}
public ActionResult Delete(int id)
{
RequisitionCancelHeader header = _RequisitionCancelHeaderService.Find(id);
if (header.Status == (int)StatusConstants.Drafted || header.Status == (int)StatusConstants.Import)
{
return(Remove(id));
}
else
{
return(HttpNotFound());
}
}
public ActionResult ModifyAfter_Submit(int id, string IndexType)
{
RequisitionCancelHeader header = _RequisitionCancelHeaderService.Find(id);
if (header.Status == (int)StatusConstants.Submitted || header.Status == (int)StatusConstants.Modified)
{
return(Edit(id, IndexType));
}
else
{
return(HttpNotFound());
}
}
// GET: /ProductMaster/Delete/5
private ActionResult Remove(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RequisitionCancelHeader RequisitionCancelHeader = db.RequisitionCancelHeader.Find(id);
if (RequisitionCancelHeader == null)
{
return(HttpNotFound());
}
if (new RolePermissionService(_unitOfWork).IsActionAllowed(UserRoles, RequisitionCancelHeader.DocTypeId, null, this.ControllerContext.RouteData.Values["controller"].ToString(), "Remove") == false)
{
return(PartialView("~/Views/Shared/PermissionDenied_Modal.cshtml").Warning("You don't have permission to do this task."));
}
#region DocTypeTimeLineValidation
try
{
TimePlanValidation = DocumentValidation.ValidateDocument(Mapper.Map <DocumentUniqueId>(RequisitionCancelHeader), DocumentTimePlanTypeConstants.Delete, User.Identity.Name, out ExceptionMsg, out Continue);
TempData["CSEXC"] += ExceptionMsg;
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
TimePlanValidation = false;
}
if (!TimePlanValidation && !Continue)
{
return(PartialView("AjaxError"));
}
#endregion
ReasonViewModel vm = new ReasonViewModel()
{
id = id,
};
return(PartialView("_Reason", vm));
}
public ActionResult Submit(int id, string IndexType, string TransactionType)
{
RequisitionCancelHeader s = db.RequisitionCancelHeader.Find(id);
if (new RolePermissionService(_unitOfWork).IsActionAllowed(UserRoles, s.DocTypeId, null, this.ControllerContext.RouteData.Values["controller"].ToString(), "Submit") == false)
{
return(View("~/Views/Shared/PermissionDenied.cshtml").Warning("You don't have permission to do this task."));
}
#region DocTypeTimeLineValidation
try
{
TimePlanValidation = Submitvalidation(id, out ExceptionMsg);
TempData["CSEXC"] += ExceptionMsg;
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
TimePlanValidation = false;
}
try
{
TimePlanValidation = DocumentValidation.ValidateDocument(Mapper.Map <DocumentUniqueId>(s), DocumentTimePlanTypeConstants.Submit, User.Identity.Name, out ExceptionMsg, out Continue);
TempData["CSEXC"] += ExceptionMsg;
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
TimePlanValidation = false;
}
if (!TimePlanValidation && !Continue)
{
return(RedirectToAction("Index", new { id = s.DocTypeId, IndexType = IndexType }));
}
#endregion
return(RedirectToAction("Detail", new { id = id, IndexType = IndexType, transactionType = string.IsNullOrEmpty(TransactionType) ? "submit" : TransactionType }));
}
public ActionResult Print(int id)
{
RequisitionCancelHeader header = _RequisitionCancelHeaderService.Find(id);
if (header.Status == (int)StatusConstants.Drafted)
{
var SEttings = new RequisitionSettingService(_unitOfWork).GetRequisitionSettingForDocument(header.DocTypeId, header.DivisionId, header.SiteId);
if (string.IsNullOrEmpty(SEttings.SqlProcDocumentPrint))
{
throw new Exception("Document Print Not Configured");
}
else
{
return(PrintOut(id, SEttings.SqlProcDocumentPrint));
}
}
else
{
return(HttpNotFound());
}
}
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));
}
// GET: /ProductMaster/Edit/5
private ActionResult Edit(int id, string IndexType)
{
ViewBag.IndexStatus = IndexType;
RequisitionCancelHeader pt = _RequisitionCancelHeaderService.Find(id);
if (pt == null)
{
return(HttpNotFound());
}
if (new RolePermissionService(_unitOfWork).IsActionAllowed(UserRoles, pt.DocTypeId, null, this.ControllerContext.RouteData.Values["controller"].ToString(), "Edit") == false)
{
return(View("~/Views/Shared/PermissionDenied.cshtml").Warning("You don't have permission to do this task."));
}
RequisitionCancelHeaderViewModel temp = AutoMapper.Mapper.Map <RequisitionCancelHeader, RequisitionCancelHeaderViewModel>(pt);
#region DocTypeTimeLineValidation
try
{
TimePlanValidation = DocumentValidation.ValidateDocument(Mapper.Map <DocumentUniqueId>(pt), 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 ((!TimePlanValidation && !Continue))
{
return(RedirectToAction("DetailInformation", new { id = id, IndexType = IndexType }));
}
//Getting Settings
var settings = new RequisitionSettingService(_unitOfWork).GetRequisitionSettingForDocument(pt.DocTypeId, pt.DivisionId, pt.SiteId);
if (settings == null && UserRoles.Contains("SysAdmin"))
{
return(RedirectToAction("CreateRequisitionCancel", "RequisitionSetting", new { id = pt.DocTypeId }).Warning("Please create job order settings"));
}
else if (settings == null && !UserRoles.Contains("SysAdmin"))
{
return(View("~/Views/Shared/InValidSettings.cshtml"));
}
temp.RequisitionSettings = Mapper.Map <RequisitionSetting, RequisitionSettingsViewModel>(settings);
PrepareViewBag(pt.DocTypeId);
ViewBag.Mode = "Edit";
if (!(System.Web.HttpContext.Current.Request.UrlReferrer.PathAndQuery).Contains("Create"))
{
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = pt.DocTypeId,
DocId = pt.RequisitionCancelHeaderId,
ActivityType = (int)ActivityTypeContants.Detail,
DocNo = pt.DocNo,
DocDate = pt.DocDate,
DocStatus = pt.Status,
}));
}
return(View("Create", temp));
}
public ActionResult Post(RequisitionCancelHeaderViewModel vm)
{
RequisitionCancelHeader pt = AutoMapper.Mapper.Map <RequisitionCancelHeaderViewModel, RequisitionCancelHeader>(vm);
if (vm.PersonId <= 0)
{
ModelState.AddModelError("PersonId", "The Person field is required");
}
#region BeforeSave
bool BeforeSave = true;
try
{
if (vm.RequisitionCancelHeaderId <= 0)
{
BeforeSave = MaterialRequestCancelDocEvents.beforeHeaderSaveEvent(this, new StockEventArgs(vm.RequisitionCancelHeaderId, EventModeConstants.Add), ref db);
}
else
{
BeforeSave = MaterialRequestCancelDocEvents.beforeHeaderSaveEvent(this, new StockEventArgs(vm.RequisitionCancelHeaderId, 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.RequisitionCancelHeaderId <= 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.RequisitionCancelHeaderId <= 0)
{
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;
pt.ObjectState = Model.ObjectState.Added;
db.RequisitionCancelHeader.Add(pt);
//_RequisitionCancelHeaderService.Create(pt);
try
{
MaterialRequestCancelDocEvents.onHeaderSaveEvent(this, new StockEventArgs(pt.RequisitionCancelHeaderId, 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();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
PrepareViewBag(vm.DocTypeId);
ViewBag.Mode = "Add";
return(View("Create", vm));
}
try
{
MaterialRequestCancelDocEvents.afterHeaderSaveEvent(this, new StockEventArgs(pt.RequisitionCancelHeaderId, 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.RequisitionCancelHeaderId,
DocNo = pt.DocNo,
ActivityType = (int)ActivityTypeContants.Added,
}));
return(RedirectToAction("Modify", new { id = pt.RequisitionCancelHeaderId }).Success("Data saved Successfully"));
}
#endregion
#region EditRecord
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
RequisitionCancelHeader temp = _RequisitionCancelHeaderService.Find(pt.RequisitionCancelHeaderId);
RequisitionCancelHeader ExRec = new RequisitionCancelHeader();
ExRec = Mapper.Map <RequisitionCancelHeader>(temp);
if (temp.Status != (int)StatusConstants.Drafted)
{
temp.Status = (int)StatusConstants.Modified;
}
temp.DocDate = pt.DocDate;
temp.DocNo = pt.DocNo;
temp.ReasonId = pt.ReasonId;
temp.Remark = pt.Remark;
temp.PersonId = pt.PersonId;
temp.ModifiedDate = DateTime.Now;
temp.ModifiedBy = User.Identity.Name;
temp.ObjectState = Model.ObjectState.Modified;
db.RequisitionCancelHeader.Add(temp);
//_RequisitionCancelHeaderService.Update(temp);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = temp,
});
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
MaterialRequestCancelDocEvents.onHeaderSaveEvent(this, new StockEventArgs(temp.RequisitionCancelHeaderId, 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["CSEXC"] += message;
PrepareViewBag(vm.DocTypeId);
ViewBag.Mode = "Edit";
return(View("Create", pt));
}
try
{
MaterialRequestCancelDocEvents.afterHeaderSaveEvent(this, new StockEventArgs(temp.RequisitionCancelHeaderId, 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.RequisitionCancelHeaderId,
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));
}
public void Update(RequisitionCancelHeader pt)
{
pt.ObjectState = ObjectState.Modified;
_unitOfWork.Repository <RequisitionCancelHeader>().Update(pt);
}
public void Delete(RequisitionCancelHeader pt)
{
_unitOfWork.Repository <RequisitionCancelHeader>().Delete(pt);
}
public RequisitionCancelHeader Create(RequisitionCancelHeader pt)
{
pt.ObjectState = ObjectState.Added;
_unitOfWork.Repository <RequisitionCancelHeader>().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);
}
public RequisitionCancelHeader Add(RequisitionCancelHeader pt)
{
_unitOfWork.Repository <RequisitionCancelHeader>().Insert(pt);
return(pt);
}
