// GET: /PurchaseOrderHeader/Delete/5
private ActionResult Remove(int id)
{
PurchaseIndentCancelHeader PurchaseIndentCancelHeader = _PurchaseIndentCancelHeaderService.Find(id);
if (PurchaseIndentCancelHeader == null)
{
return(HttpNotFound());
}
#region DocTypeTimeLineValidation
try
{
TimePlanValidation = DocumentValidation.ValidateDocument(Mapper.Map <DocumentUniqueId>(PurchaseIndentCancelHeader), 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 rvm = new ReasonViewModel()
{
id = id,
};
return(PartialView("_Reason", rvm));
}
public ActionResult Submit(int id, string IndexType, string TransactionType)
{
#region DocTypeTimeLineValidation
PurchaseIndentCancelHeader s = db.PurchaseIndentCancelHeader.Find(id);
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 DeleteAfter_Submit(int id)
{
PurchaseIndentCancelHeader header = _PurchaseIndentCancelHeaderService.Find(id);
if (header.Status == (int)StatusConstants.Submitted || header.Status == (int)StatusConstants.Modified || header.Status == (int)StatusConstants.ModificationSubmitted)
{
return(Remove(id));
}
else
{
return(HttpNotFound());
}
}
public ActionResult Delete(int id)
{
PurchaseIndentCancelHeader header = _PurchaseIndentCancelHeaderService.Find(id);
if (header.Status == (int)StatusConstants.Drafted)
{
return(Remove(id));
}
else
{
return(HttpNotFound());
}
}
public ActionResult ModifyAfter_Submit(int id, string IndexType)
{
PurchaseIndentCancelHeader header = _PurchaseIndentCancelHeaderService.Find(id);
if (header.Status == (int)StatusConstants.Submitted || header.Status == (int)StatusConstants.Modified || header.Status == (int)StatusConstants.ModificationSubmitted)
{
return(Edit(id, IndexType));
}
else
{
return(HttpNotFound());
}
}
public ActionResult Detail(int id, string IndexType, string transactionType)
{
ViewBag.transactionType = transactionType;
ViewBag.IndexStatus = IndexType;
PurchaseIndentCancelHeader s = _PurchaseIndentCancelHeaderService.Find(id);
PurchaseIndentCancelHeaderViewModel svm = Mapper.Map <PurchaseIndentCancelHeader, PurchaseIndentCancelHeaderViewModel>(s);
PrepareViewBag(s.DocTypeId);
//Job Order Settings
var settings = new PurchaseIndentSettingService(_unitOfWork).GetPurchaseIndentSettingForDocument(s.DocTypeId, s.DivisionId, s.SiteId);
if (settings == null)
{
return(RedirectToAction("Create", "PurchaseIndentSetting", new { id = s.DocTypeId }).Warning("Please create Purchase Indent cancel settings"));
}
svm.PurchaseIndentSettings = Mapper.Map <PurchaseIndentSetting, PurchaseIndentSettingsViewModel>(settings);
if (s == null)
{
return(HttpNotFound());
}
if (String.IsNullOrEmpty(transactionType) || transactionType == "detail")
{
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = s.DocTypeId,
DocId = s.PurchaseIndentCancelHeaderId,
ActivityType = (int)ActivityTypeContants.Detail,
DocNo = s.DocNo,
DocDate = s.DocDate,
DocStatus = s.Status,
}));
}
return(View("Create", svm));
}
public void Update(PurchaseIndentCancelHeader p)
{
p.ObjectState = ObjectState.Modified;
_unitOfWork.Repository <PurchaseIndentCancelHeader>().Update(p);
}
public void Delete(PurchaseIndentCancelHeader p)
{
_unitOfWork.Repository <PurchaseIndentCancelHeader>().Delete(p);
}
public PurchaseIndentCancelHeader Create(PurchaseIndentCancelHeader p)
{
p.ObjectState = ObjectState.Added;
_unitOfWork.Repository <PurchaseIndentCancelHeader>().Insert(p);
return(p);
}
public PurchaseIndentCancelHeader Add(PurchaseIndentCancelHeader p)
{
_unitOfWork.Repository <PurchaseIndentCancelHeader>().Insert(p);
return(p);
}
public ActionResult _ResultsPost(MaterialPlanCancelLineListViewModel vm)
{
MaterialPlanCancelHeader header = new MaterialPlanCancelHeaderService(_unitOfWork).Find(vm.MaterialPlanCancelLineViewModel.FirstOrDefault().MaterialPlanCancelHeaderId);
MaterialPlanSettings Setting = new MaterialPlanSettingsService(_unitOfWork).GetMaterialPlanSettingsForDocument(header.DocTypeId, header.DivisionId, header.SiteId);
if (ModelState.IsValid)
{
var ProductIds = vm.MaterialPlanCancelLineViewModel.Select(m => m.ProductId).ToArray();
List <MaterialPlanCancelLineViewModel> Line = new List <MaterialPlanCancelLineViewModel>();
int i = 0;
int si = 0;
int linePk = 0;
int Cnt = 0;
var mPlanLineIds = vm.MaterialPlanCancelLineViewModel.Where(m => m.Qty > 0 && m.Qty <= m.BalanceQty).Select(m => m.MaterialPlanLineId).ToList();
//var mPlanRecords = db.ViewMaterialPlanForSaleOrderBalance.AsNoTracking().Where(m => mPlanLineIds.Contains(m.MaterialPlanLineId.Value)).ToList();
//Changed because ViewMaterialPlanForSaleOrderBalance is not required.
var mPlanRecords = db.MaterialPlanForSaleOrder.AsNoTracking().Where(m => mPlanLineIds.Contains(m.MaterialPlanLineId.Value)).ToList();
foreach (var item in vm.MaterialPlanCancelLineViewModel.Where(m => m.Qty > 0 && m.Qty <= m.BalanceQty))
{
MaterialPlanCancelLine cline = new MaterialPlanCancelLine();
cline.MaterialPlanCancelHeaderId = header.MaterialPlanCancelHeaderId;
cline.CreatedBy = User.Identity.Name;
cline.CreatedDate = DateTime.Now;
cline.MaterialPlanLineId = item.MaterialPlanLineId;
cline.CreatedBy = User.Identity.Name;
cline.CreatedDate = DateTime.Now;
cline.ModifiedBy = User.Identity.Name;
cline.ModifiedDate = DateTime.Now;
cline.ObjectState = Model.ObjectState.Added;
cline.Qty = item.Qty;
cline.Remark = item.Remark;
cline.Sr = i++;
cline.MaterialPlanCancelLineId = linePk++;
cline.ObjectState = Model.ObjectState.Added;
db.MaterialPlanCancelLine.Add(cline);
SqlParameter SqlParameterMaterialPlanLineId = new SqlParameter("@MaterialPlanLineId", cline.MaterialPlanLineId);
SqlParameter SqlParameterQty = new SqlParameter("@Qty", cline.Qty);
IEnumerable <MaterialPlanForSaleOrderFifo> MaterialPlanForSaleOrderFifo = db.Database.SqlQuery <MaterialPlanForSaleOrderFifo>("" + ConfigurationManager.AppSettings["DataBaseSchema"] + ".sp_GetMaterialPlanForSaleOrderFifo @MaterialPlanLineId, @Qty", SqlParameterMaterialPlanLineId, SqlParameterQty).ToList();
//foreach (var detailSo in mPlanRecords.Where(m => m.MaterialPlanLineId == item.MaterialPlanLineId).ToList())
foreach (var detailSo in MaterialPlanForSaleOrderFifo)
{
MaterialPlanCancelForSaleOrder cso = new MaterialPlanCancelForSaleOrder();
cso.CreatedBy = User.Identity.Name;
cso.CreatedDate = DateTime.Now;
cso.ModifiedBy = User.Identity.Name;
cso.ModifiedDate = DateTime.Now;
cso.MaterialPlanCancelHeaderId = header.MaterialPlanCancelHeaderId;
cso.MaterialPlanCancelLineId = cline.MaterialPlanCancelLineId;
cso.MaterialPlanForSaleOrderId = detailSo.MaterialPlanForSaleOrderId;
cso.Qty = detailSo.Qty;
cso.Sr = si++;
cso.ObjectState = Model.ObjectState.Added;
db.MaterialPlanCancelForSaleOrder.Add(cso);
}
var MaterialPlanLine = new MaterialPlanLineService(_unitOfWork).Find(item.MaterialPlanLineId);
int ProdOrderCancelHeaderId = 0;
if (MaterialPlanLine.ProdPlanQty > 0)
{
ProdOrderCancelHeader ExistingProdOrderCancel = new ProdOrderCancelHeaderService(_unitOfWork).GetProdOrderCancelForMaterialPlan(header.MaterialPlanCancelHeaderId);
ProdOrderCancelHeader ProdOrderCancelHeader = new ProdOrderCancelHeader();
if (ExistingProdOrderCancel == null && Cnt == 0)
{
ProdOrderCancelHeader.CreatedBy = User.Identity.Name;
ProdOrderCancelHeader.CreatedDate = DateTime.Now;
ProdOrderCancelHeader.DivisionId = header.DivisionId;
ProdOrderCancelHeader.DocDate = header.DocDate;
ProdOrderCancelHeader.DocNo = header.DocNo;
ProdOrderCancelHeader.DocTypeId = Setting.DocTypeProductionOrderId.Value;
ProdOrderCancelHeader.MaterialPlanCancelHeaderId = header.MaterialPlanCancelHeaderId;
ProdOrderCancelHeader.ModifiedBy = User.Identity.Name;
ProdOrderCancelHeader.ModifiedDate = DateTime.Now;
ProdOrderCancelHeader.Remark = header.Remark;
ProdOrderCancelHeader.SiteId = header.SiteId;
ProdOrderCancelHeader.Status = (int)StatusConstants.System;
ProdOrderCancelHeader.ObjectState = Model.ObjectState.Added;
db.ProdOrderCancelHeader.Add(ProdOrderCancelHeader);
ProdOrderCancelHeaderId = ProdOrderCancelHeader.ProdOrderCancelHeaderId;
Cnt = Cnt + 1;
}
else
{
if (ExistingProdOrderCancel == null)
{
ProdOrderCancelHeaderId = ProdOrderCancelHeader.ProdOrderCancelHeaderId;
}
else
{
ProdOrderCancelHeaderId = ExistingProdOrderCancel.ProdOrderCancelHeaderId;
}
}
var ProdOrderLine = new ProdOrderLineService(_unitOfWork).GetProdOrderLineForMaterialPlan(item.MaterialPlanLineId);
int ProdOrderCancelLineKey = 0;
ProdOrderCancelLine ProdOrderCancelLine = new ProdOrderCancelLine();
ProdOrderCancelLine.ProdOrderCancelLineId = linePk++;
ProdOrderCancelLine.CreatedBy = User.Identity.Name;
ProdOrderCancelLine.CreatedDate = DateTime.Now;
ProdOrderCancelLine.ProdOrderLineId = ProdOrderLine.FirstOrDefault().ProdOrderLineId;
ProdOrderCancelLine.ModifiedBy = User.Identity.Name;
ProdOrderCancelLine.ModifiedDate = DateTime.Now;
ProdOrderCancelLine.ProdOrderCancelHeaderId = ProdOrderCancelHeaderId;
ProdOrderCancelLine.MaterialPlanCancelLineId = cline.MaterialPlanCancelLineId;
ProdOrderCancelLine.Qty = item.Qty;
ProdOrderCancelLine.ProdOrderCancelLineId = ProdOrderCancelLineKey--;
ProdOrderCancelLine.ObjectState = Model.ObjectState.Added;
db.ProdOrderCancelLine.Add(ProdOrderCancelLine);
}
if (MaterialPlanLine.PurchPlanQty > 0)
{
PurchaseIndentCancelHeader ExistingPurchaseIndentCancel = new PurchaseIndentCancelHeaderService(_unitOfWork).GetPurchaseIndentCancelForMaterialPlan(header.MaterialPlanCancelHeaderId);
if (ExistingPurchaseIndentCancel == null)
{
PurchaseIndentCancelHeader PurchaseIndentCancelHeader = new PurchaseIndentCancelHeader();
PurchaseIndentCancelHeader.CreatedBy = User.Identity.Name;
PurchaseIndentCancelHeader.CreatedDate = DateTime.Now;
PurchaseIndentCancelHeader.DivisionId = header.DivisionId;
PurchaseIndentCancelHeader.DocDate = header.DocDate;
PurchaseIndentCancelHeader.DocNo = header.DocNo;
PurchaseIndentCancelHeader.DocTypeId = Setting.DocTypeProductionOrderId.Value;
PurchaseIndentCancelHeader.MaterialPlanCancelHeaderId = header.MaterialPlanCancelHeaderId;
PurchaseIndentCancelHeader.ModifiedBy = User.Identity.Name;
PurchaseIndentCancelHeader.ModifiedDate = DateTime.Now;
PurchaseIndentCancelHeader.Remark = header.Remark;
PurchaseIndentCancelHeader.SiteId = header.SiteId;
PurchaseIndentCancelHeader.Status = (int)StatusConstants.System;
PurchaseIndentCancelHeader.ObjectState = Model.ObjectState.Added;
db.PurchaseIndentCancelHeader.Add(PurchaseIndentCancelHeader);
}
var PurchaseIndentLine = new PurchaseIndentLineService(_unitOfWork).GetPurchaseIndentLineForMaterialPlan(item.MaterialPlanLineId);
int PurchaseIndentCancelLineKey = 0;
PurchaseIndentCancelLine PurchaseIndentCancelLine = new PurchaseIndentCancelLine();
PurchaseIndentCancelLine.CreatedBy = User.Identity.Name;
PurchaseIndentCancelLine.CreatedDate = DateTime.Now;
PurchaseIndentCancelLine.PurchaseIndentLineId = PurchaseIndentLine.FirstOrDefault().PurchaseIndentLineId;
PurchaseIndentCancelLine.ModifiedBy = User.Identity.Name;
PurchaseIndentCancelLine.ModifiedDate = DateTime.Now;
PurchaseIndentCancelLine.PurchaseIndentCancelHeaderId = ExistingPurchaseIndentCancel.PurchaseIndentCancelHeaderId;
PurchaseIndentCancelLine.MaterialPlanCancelLineId = cline.MaterialPlanCancelLineId;
PurchaseIndentCancelLine.Qty = item.Qty;
PurchaseIndentCancelLine.PurchaseIndentCancelLineId = PurchaseIndentCancelLineKey--;
PurchaseIndentCancelLine.ObjectState = Model.ObjectState.Added;
db.PurchaseIndentCancelLine.Add(PurchaseIndentCancelLine);
}
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return(PartialView("_Results", vm));
}
return(Json(new { success = true }));
}
return(PartialView("_Results", vm));
}
public ActionResult _ResultsPostProduction(MaterialPlanCancelLineListViewModel vm)
{
MaterialPlanCancelHeader header = new MaterialPlanCancelHeaderService(_unitOfWork).Find(vm.MaterialPlanCancelLineViewModel.FirstOrDefault().MaterialPlanCancelHeaderId);
MaterialPlanSettings Setting = new MaterialPlanSettingsService(_unitOfWork).GetMaterialPlanSettingsForDocument(header.DocTypeId, header.DivisionId, header.SiteId);
if (ModelState.IsValid)
{
var ProductIds = vm.MaterialPlanCancelLineViewModel.Select(m => m.ProductId).ToArray();
List <MaterialPlanCancelLineViewModel> Line = new List <MaterialPlanCancelLineViewModel>();
int i = 0;
int si = 0;
int linePk = 0;
int poLinePK = 0;
var mPlanLineIds = vm.MaterialPlanCancelLineViewModel.Where(m => m.Qty > 0 && m.Qty == m.BalanceQty).Select(m => m.MaterialPlanLineId).ToList();
var mPlanProdOrderLineRecords = db.ViewMaterialPlanForProdOrderLineBalance.AsNoTracking().Where(m => mPlanLineIds.Contains(m.MaterialPlanLineId.Value)).ToList();
var mPlanProdOrderIds = mPlanProdOrderLineRecords.Select(m => m.MaterialPlanForProdOrderId).Distinct().ToList();
var mPlanProdOrderRecords = db.ViewMaterialPlanForProdOrderBalance.AsNoTracking().Where(m => mPlanProdOrderIds.Contains(m.MaterialPlanForProdOrderId)).ToList();
foreach (var item in vm.MaterialPlanCancelLineViewModel.Where(m => m.Qty > 0 && m.Qty == m.BalanceQty))
{
MaterialPlanCancelLine cline = new MaterialPlanCancelLine();
cline.MaterialPlanCancelHeaderId = header.MaterialPlanCancelHeaderId;
cline.CreatedBy = User.Identity.Name;
cline.CreatedDate = DateTime.Now;
cline.MaterialPlanLineId = item.MaterialPlanLineId;
cline.CreatedBy = User.Identity.Name;
cline.CreatedDate = DateTime.Now;
cline.ModifiedBy = User.Identity.Name;
cline.ModifiedDate = DateTime.Now;
cline.ObjectState = Model.ObjectState.Added;
cline.Qty = item.Qty;
cline.Remark = item.Remark;
cline.Sr = i++;
cline.MaterialPlanCancelLineId = linePk++;
cline.ObjectState = Model.ObjectState.Added;
db.MaterialPlanCancelLine.Add(cline);
var poLineRecords = mPlanProdOrderLineRecords.Where(m => m.MaterialPlanLineId == item.MaterialPlanLineId).ToList();
var ProdOrder = mPlanProdOrderRecords.Where(m => m.MaterialPlanForProdOrderId == poLineRecords.Select(t => t.MaterialPlanForProdOrderId).FirstOrDefault()).FirstOrDefault();
MaterialPlanCancelForProdOrder poLine = new MaterialPlanCancelForProdOrder();
poLine.CreatedBy = User.Identity.Name;
poLine.CreatedDate = DateTime.Now;
poLine.MaterialPlanCancelHeaderId = header.MaterialPlanCancelHeaderId;
poLine.MaterialPlanLineId = cline.MaterialPlanLineId;
poLine.MaterialPlanCancelForProdOrderId = poLinePK++;
poLine.ModifiedDate = DateTime.Now;
poLine.ModifiedBy = User.Identity.Name;
poLine.ObjectState = Model.ObjectState.Added;
poLine.Qty = ProdOrder.BalanceQty;
poLine.Sr = cline.Sr;
poLine.ObjectState = Model.ObjectState.Added;
db.MaterialPlanCancelForProdOrder.Add(poLine);
foreach (var detailSo in poLineRecords)
{
MaterialPlanCancelForProdOrderLine cso = new MaterialPlanCancelForProdOrderLine();
cso.MaterialPlanCancelLineId = cline.MaterialPlanCancelLineId;
cso.MaterialPlanCancelForProdOrderId = poLine.MaterialPlanCancelForProdOrderId;
cso.Qty = detailSo.BalanceQty;
cso.Sr = si++;
cso.ObjectState = Model.ObjectState.Added;
db.MaterialPlanCancelForProdOrderLine.Add(cso);
}
var MaterialPlanLine = new MaterialPlanLineService(_unitOfWork).Find(item.MaterialPlanLineId);
if (MaterialPlanLine.ProdPlanQty > 0)
{
ProdOrderCancelHeader ExistingProdOrderCancel = new ProdOrderCancelHeaderService(_unitOfWork).GetProdOrderCancelForMaterialPlan(header.MaterialPlanCancelHeaderId);
if (ExistingProdOrderCancel == null)
{
ProdOrderCancelHeader ProdOrderCancelHeader = new ProdOrderCancelHeader();
ProdOrderCancelHeader.CreatedBy = User.Identity.Name;
ProdOrderCancelHeader.CreatedDate = DateTime.Now;
ProdOrderCancelHeader.DivisionId = header.DivisionId;
ProdOrderCancelHeader.DocDate = header.DocDate;
ProdOrderCancelHeader.DocNo = header.DocNo;
ProdOrderCancelHeader.DocTypeId = Setting.DocTypeProductionOrderId.Value;
ProdOrderCancelHeader.MaterialPlanCancelHeaderId = header.MaterialPlanCancelHeaderId;
ProdOrderCancelHeader.ModifiedBy = User.Identity.Name;
ProdOrderCancelHeader.ModifiedDate = DateTime.Now;
ProdOrderCancelHeader.Remark = header.Remark;
ProdOrderCancelHeader.SiteId = header.SiteId;
ProdOrderCancelHeader.Status = (int)StatusConstants.System;
ProdOrderCancelHeader.ObjectState = Model.ObjectState.Added;
db.ProdOrderCancelHeader.Add(ProdOrderCancelHeader);
}
var ProdOrderLine = new ProdOrderLineService(_unitOfWork).GetProdOrderLineForMaterialPlan(item.MaterialPlanLineId);
int ProdOrderCancelLineKey = 0;
ProdOrderCancelLine ProdOrderCancelLine = new ProdOrderCancelLine();
ProdOrderCancelLine.CreatedBy = User.Identity.Name;
ProdOrderCancelLine.CreatedDate = DateTime.Now;
ProdOrderCancelLine.ProdOrderLineId = ProdOrderLine.FirstOrDefault().ProdOrderLineId;
ProdOrderCancelLine.ModifiedBy = User.Identity.Name;
ProdOrderCancelLine.ModifiedDate = DateTime.Now;
ProdOrderCancelLine.ProdOrderCancelHeaderId = ExistingProdOrderCancel.ProdOrderCancelHeaderId;
ProdOrderCancelLine.Qty = item.Qty;
ProdOrderCancelLine.ProdOrderCancelLineId = ProdOrderCancelLineKey--;
ProdOrderCancelLine.ObjectState = Model.ObjectState.Added;
db.ProdOrderCancelLine.Add(ProdOrderCancelLine);
}
if (MaterialPlanLine.PurchPlanQty > 0)
{
PurchaseIndentCancelHeader ExistingPurchaseIndentCancel = new PurchaseIndentCancelHeaderService(_unitOfWork).GetPurchaseIndentCancelForMaterialPlan(header.MaterialPlanCancelHeaderId);
if (ExistingPurchaseIndentCancel == null)
{
PurchaseIndentCancelHeader PurchaseIndentCancelHeader = new PurchaseIndentCancelHeader();
PurchaseIndentCancelHeader.CreatedBy = User.Identity.Name;
PurchaseIndentCancelHeader.CreatedDate = DateTime.Now;
PurchaseIndentCancelHeader.DivisionId = header.DivisionId;
PurchaseIndentCancelHeader.DocDate = header.DocDate;
PurchaseIndentCancelHeader.DocNo = header.DocNo;
PurchaseIndentCancelHeader.DocTypeId = Setting.DocTypeProductionOrderId.Value;
PurchaseIndentCancelHeader.MaterialPlanCancelHeaderId = header.MaterialPlanCancelHeaderId;
PurchaseIndentCancelHeader.ModifiedBy = User.Identity.Name;
PurchaseIndentCancelHeader.ModifiedDate = DateTime.Now;
PurchaseIndentCancelHeader.Remark = header.Remark;
PurchaseIndentCancelHeader.SiteId = header.SiteId;
PurchaseIndentCancelHeader.Status = (int)StatusConstants.System;
PurchaseIndentCancelHeader.ObjectState = Model.ObjectState.Added;
db.PurchaseIndentCancelHeader.Add(PurchaseIndentCancelHeader);
}
var PurchaseIndentLine = new PurchaseIndentLineService(_unitOfWork).GetPurchaseIndentLineForMaterialPlan(item.MaterialPlanLineId);
int PurchaseIndentCancelLineKey = 0;
PurchaseIndentCancelLine PurchaseIndentCancelLine = new PurchaseIndentCancelLine();
PurchaseIndentCancelLine.CreatedBy = User.Identity.Name;
PurchaseIndentCancelLine.CreatedDate = DateTime.Now;
PurchaseIndentCancelLine.PurchaseIndentLineId = PurchaseIndentLine.FirstOrDefault().PurchaseIndentLineId;
PurchaseIndentCancelLine.ModifiedBy = User.Identity.Name;
PurchaseIndentCancelLine.ModifiedDate = DateTime.Now;
PurchaseIndentCancelLine.PurchaseIndentCancelHeaderId = ExistingPurchaseIndentCancel.PurchaseIndentCancelHeaderId;
PurchaseIndentCancelLine.Qty = item.Qty;
PurchaseIndentCancelLine.PurchaseIndentCancelLineId = PurchaseIndentCancelLineKey--;
PurchaseIndentCancelLine.ObjectState = Model.ObjectState.Added;
db.PurchaseIndentCancelLine.Add(PurchaseIndentCancelLine);
}
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return(PartialView("_Results", vm));
}
return(Json(new { success = true }));
}
return(PartialView("_Results", vm));
}
public ActionResult Reviewed(int Id, string IndexType, string UserRemark, string IsContinue)
{
PurchaseIndentCancelHeader pd = new PurchaseIndentCancelHeaderService(_unitOfWork).Find(Id);
bool BeforeSave = true;
try
{
BeforeSave = PurchaseIndentCancelDocEvents.beforeHeaderReviewEvent(this, new PurchaseEventArgs(Id), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
EventException = true;
}
if (!BeforeSave)
{
TempData["CSEXC"] += "Falied validation before submit.";
}
if (ModelState.IsValid && BeforeSave && !EventException)
{
pd.ReviewCount = (pd.ReviewCount ?? 0) + 1;
pd.ReviewBy += User.Identity.Name + ", ";
pd.ObjectState = Model.ObjectState.Modified;
db.PurchaseIndentCancelHeader.Add(pd);
try
{
PurchaseIndentCancelDocEvents.onHeaderReviewEvent(this, new PurchaseEventArgs(Id), 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;
return(RedirectToAction("Index", new { id = pd.DocTypeId }));
}
try
{
PurchaseIndentCancelDocEvents.afterHeaderReviewEvent(this, new PurchaseEventArgs(Id), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = pd.DocTypeId,
DocId = pd.PurchaseIndentCancelHeaderId,
ActivityType = (int)ActivityTypeContants.Reviewed,
UserRemark = UserRemark,
DocNo = pd.DocNo,
DocDate = pd.DocDate,
DocStatus = pd.Status,
}));
if (!string.IsNullOrEmpty(IsContinue) && IsContinue == "True")
{
PurchaseIndentCancelHeader HEader = _PurchaseIndentCancelHeaderService.Find(Id);
int nextId = new NextPrevIdService(_unitOfWork).GetNextPrevId(Id, HEader.DocTypeId, User.Identity.Name, ForActionConstants.PendingToReview, "Web.PurchaseIndentCancelHeaders", "PurchaseIndentCancelHeaderId", PrevNextConstants.Next);
if (nextId == 0)
{
var PendingtoSubmitCount = _PurchaseIndentCancelHeaderService.GetPurchaseIndentCancelPendingToReview(HEader.DocTypeId, User.Identity.Name).Count();
if (PendingtoSubmitCount > 0)
{
return(RedirectToAction("Index_PendingToReview", new { id = HEader.DocTypeId, IndexType = IndexType }).Success("Record Reviewed Successfully"));
}
else
{
return(RedirectToAction("Index", new { id = HEader.DocTypeId, IndexType = IndexType }).Success("Record Reviewed Successfully"));
};
}
ViewBag.PendingToReview = PendingToReviewCount(Id);
return(RedirectToAction("Detail", new { id = nextId, transactionType = "ReviewContinue", IndexType = IndexType }).Success("Record Reviewed Successfully"));;
}
else
{
return(RedirectToAction("Index", new { id = pd.DocTypeId, IndexType = IndexType }).Success("Record Reviewed Successfully"));
}
}
return(RedirectToAction("Index", new { id = pd.DocTypeId, IndexType = IndexType }));
}
// GET: /PurchaseIndentCancelHeader/Edit/5
private ActionResult Edit(int id, string IndexType)
{
ViewBag.IndexStatus = IndexType;
PurchaseIndentCancelHeader s = _PurchaseIndentCancelHeaderService.Find(id);
PurchaseIndentCancelHeaderViewModel svm = Mapper.Map <PurchaseIndentCancelHeader, PurchaseIndentCancelHeaderViewModel>(s);
if (svm == null)
{
return(HttpNotFound());
}
#region DocTypeTimeLineValidation
try
{
TimePlanValidation = DocumentValidation.ValidateDocument(Mapper.Map <DocumentUniqueId>(s), 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 }));
}
PrepareViewBag(s.DocTypeId);
//Job Order Settings
var settings = new PurchaseIndentSettingService(_unitOfWork).GetPurchaseIndentSettingForDocument(s.DocTypeId, svm.DivisionId, svm.SiteId);
if (settings == null && UserRoles.Contains("SysAdmin"))
{
return(RedirectToAction("CreatePurchaseIndentCancel", "PurchaseIndentSetting", new { id = s.DocTypeId }).Warning("Please create Purchase Indent cancel settings"));
}
else if (settings == null && !UserRoles.Contains("SysAdmin"))
{
return(View("~/Views/Shared/InValidSettings.cshtml"));
}
svm.PurchaseIndentSettings = Mapper.Map <PurchaseIndentSetting, PurchaseIndentSettingsViewModel>(settings);
ViewBag.Mode = "Edit";
if (!(System.Web.HttpContext.Current.Request.UrlReferrer.PathAndQuery).Contains("Create"))
{
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = s.DocTypeId,
DocId = s.PurchaseIndentCancelHeaderId,
ActivityType = (int)ActivityTypeContants.Detail,
DocNo = s.DocNo,
DocDate = s.DocDate,
DocStatus = s.Status,
}));
}
return(View("Create", svm));
}
public ActionResult HeaderPost(PurchaseIndentCancelHeaderViewModel svm)
{
#region BeforeSave
bool BeforeSave = true;
try
{
if (svm.PurchaseIndentCancelHeaderId <= 0)
{
BeforeSave = PurchaseIndentCancelDocEvents.beforeHeaderSaveEvent(this, new PurchaseEventArgs(svm.PurchaseIndentCancelHeaderId, EventModeConstants.Add), ref db);
}
else
{
BeforeSave = PurchaseIndentCancelDocEvents.beforeHeaderSaveEvent(this, new PurchaseEventArgs(svm.PurchaseIndentCancelHeaderId, 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 (svm.PurchaseIndentCancelHeaderId <= 0)
{
TimePlanValidation = DocumentValidation.ValidateDocument(Mapper.Map <DocumentUniqueId>(svm), DocumentTimePlanTypeConstants.Create, User.Identity.Name, out ExceptionMsg, out Continue);
}
else
{
TimePlanValidation = DocumentValidation.ValidateDocument(Mapper.Map <DocumentUniqueId>(svm), 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 (svm.PurchaseIndentCancelHeaderId <= 0)
{
PurchaseIndentCancelHeader s = new PurchaseIndentCancelHeader();
s.DocTypeId = svm.DocTypeId;
s.DocDate = svm.DocDate;
s.DocNo = svm.DocNo;
s.Remark = svm.Remark;
s.CreatedDate = DateTime.Now;
s.SiteId = svm.SiteId;
s.ReasonId = svm.ReasonId;
s.DivisionId = svm.DivisionId;
s.ModifiedDate = DateTime.Now;
s.CreatedBy = User.Identity.Name;
s.ModifiedBy = User.Identity.Name;
s.Status = (int)StatusConstants.Drafted;
//_PurchaseIndentCancelHeaderService.Create(s);
s.ObjectState = Model.ObjectState.Added;
db.PurchaseIndentCancelHeader.Add(s);
try
{
PurchaseIndentCancelDocEvents.onHeaderSaveEvent(this, new PurchaseEventArgs(s.PurchaseIndentCancelHeaderId, 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)
{
PrepareViewBag(svm.DocTypeId);
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
ViewBag.Mode = "Add";
return(View("Create", svm));
}
try
{
PurchaseIndentCancelDocEvents.afterHeaderSaveEvent(this, new PurchaseEventArgs(s.PurchaseIndentCancelHeaderId, EventModeConstants.Add), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = s.DocTypeId,
DocId = s.PurchaseIndentCancelHeaderId,
ActivityType = (int)ActivityTypeContants.Added,
DocNo = s.DocNo,
DocDate = s.DocDate,
DocStatus = s.Status,
}));
//return Edit(s.PurchaseIndentCancelHeaderId).Success("Data saved Successfully");
return(RedirectToAction("Modify", new { id = s.PurchaseIndentCancelHeaderId }).Success("Data saved Successfully"));
}
#endregion
#region EditRecord
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
StringBuilder logstring = new StringBuilder();
PurchaseIndentCancelHeader temp = _PurchaseIndentCancelHeaderService.Find(svm.PurchaseIndentCancelHeaderId);
PurchaseIndentCancelHeader ExRec = new PurchaseIndentCancelHeader();
ExRec = Mapper.Map <PurchaseIndentCancelHeader>(temp);
int status = temp.Status;
if (temp.Status != (int)StatusConstants.Drafted && temp.Status != (int)StatusConstants.Import)
{
temp.Status = (int)StatusConstants.Modified;
}
temp.DocTypeId = svm.DocTypeId;
temp.DocDate = svm.DocDate;
temp.DocNo = svm.DocNo;
temp.Remark = svm.Remark;
temp.ReasonId = svm.ReasonId;
temp.ModifiedDate = DateTime.Now;
temp.ModifiedBy = User.Identity.Name;
temp.ObjectState = Model.ObjectState.Modified;
db.PurchaseIndentCancelHeader.Add(temp);
//_PurchaseIndentCancelHeaderService.Update(temp);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = temp,
});
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
PurchaseIndentCancelDocEvents.onHeaderSaveEvent(this, new PurchaseEventArgs(temp.PurchaseIndentCancelHeaderId, 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)
{
PrepareViewBag(svm.DocTypeId);
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
ViewBag.Mode = "Edit";
return(View("Create", svm));
}
try
{
PurchaseIndentCancelDocEvents.afterHeaderSaveEvent(this, new PurchaseEventArgs(temp.PurchaseIndentCancelHeaderId, 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.PurchaseIndentCancelHeaderId,
ActivityType = (int)ActivityTypeContants.Modified,
DocNo = temp.DocNo,
xEModifications = Modifications,
DocDate = temp.DocDate,
DocStatus = temp.Status,
}));
return(RedirectToAction("Index", new { id = svm.DocTypeId }).Success("Data saved successfully"));
}
#endregion
}
PrepareViewBag(svm.DocTypeId);
ViewBag.Mode = "Add";
return(View("Create", svm));
}
public ActionResult _ResultsPost(PurchaseIndentCancelMasterDetailModel vm)
{
int Serial = _PurchaseIndentCancelLineService.GetMaxSr(vm.PurchaseIndentCancelViewModels.FirstOrDefault().PurchaseIndentCancelHeaderId);
bool BeforeSave = true;
try
{
BeforeSave = PurchaseIndentCancelDocEvents.beforeLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseIndentCancelViewModels.FirstOrDefault().PurchaseIndentCancelHeaderId), 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.PurchaseIndentCancelViewModels)
{
decimal balqty = (from p in db.ViewPurchaseIndentBalance
where p.PurchaseIndentLineId == item.PurchaseIndentLineId
select p.BalanceQty).FirstOrDefault();
if (balqty < item.Qty)
{
ModelState.AddModelError("", "Qty Exceeding Balance Qty");
return(PartialView("_Results", vm));
}
if (item.Qty > 0)
{
PurchaseIndentCancelLine line = new PurchaseIndentCancelLine();
line.PurchaseIndentCancelHeaderId = item.PurchaseIndentCancelHeaderId;
line.PurchaseIndentLineId = item.PurchaseIndentLineId;
line.Qty = item.Qty;
line.CreatedDate = DateTime.Now;
line.ModifiedDate = DateTime.Now;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
line.ObjectState = Model.ObjectState.Added;
db.PurchaseIndentCancelLine.Add(line);
//_PurchaseIndentCancelLineService.Create(line);
}
}
PurchaseIndentCancelHeader Header = db.PurchaseIndentCancelHeader.Find(vm.PurchaseIndentCancelViewModels.FirstOrDefault().PurchaseIndentCancelHeaderId);
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.PurchaseIndentCancelHeader.Add(Header);
}
try
{
PurchaseIndentCancelDocEvents.onLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseIndentCancelViewModels.FirstOrDefault().PurchaseIndentCancelHeaderId), 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
{
PurchaseIndentCancelDocEvents.afterLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseIndentCancelViewModels.FirstOrDefault().PurchaseIndentCancelHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Header.DocTypeId,
DocId = Header.PurchaseIndentCancelHeaderId,
ActivityType = (int)ActivityTypeContants.MultipleCreate,
DocNo = Header.DocNo,
DocDate = Header.DocDate,
DocStatus = Header.Status,
}));
return(Json(new { success = true }));
}
return(PartialView("_Results", vm));
}
