public ActionResult GeneratePrints(string Ids, int DocTypeId)
{
if (!string.IsNullOrEmpty(Ids))
{
int SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
var Settings = new MaterialPlanLineService(_unitOfWork).GetMaterialPlanSettingsForDocument(DocTypeId, DivisionId, SiteId);
if (new RolePermissionService(_unitOfWork).IsActionAllowed(UserRoles, DocTypeId, null, this.ControllerContext.RouteData.Values["controller"].ToString(), "GeneratePrints") == false)
{
return(View("~/Views/Shared/PermissionDenied.cshtml").Warning("You don't have permission to do this task."));
}
string ReportSql = "";
if (Settings.DocumentPrintReportHeaderId.HasValue)
{
ReportSql = db.ReportHeader.Where((m) => m.ReportHeaderId == Settings.DocumentPrintReportHeaderId).FirstOrDefault().ReportSQL;
}
try
{
List <byte[]> PdfStream = new List <byte[]>();
foreach (var item in Ids.Split(',').Select(Int32.Parse))
{
DirectReportPrint drp = new DirectReportPrint();
var pd = db.MaterialPlanHeader.Find(item);
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = pd.DocTypeId,
DocId = pd.MaterialPlanHeaderId,
ActivityType = (int)ActivityTypeContants.Print,
DocNo = pd.DocNo,
DocDate = pd.DocDate,
DocStatus = pd.Status,
}));
byte[] Pdf;
if (!string.IsNullOrEmpty(ReportSql))
{
Pdf = drp.rsDirectDocumentPrint(ReportSql, User.Identity.Name, item);
PdfStream.Add(Pdf);
}
else
{
if (pd.Status == (int)StatusConstants.Drafted || pd.Status == (int)StatusConstants.Modified || pd.Status == (int)StatusConstants.Import)
{
//LogAct(item.ToString());
Pdf = drp.DirectDocumentPrint(Settings.SqlProcDocumentPrint, User.Identity.Name, item);
PdfStream.Add(Pdf);
}
else if (pd.Status == (int)StatusConstants.Submitted || pd.Status == (int)StatusConstants.ModificationSubmitted)
{
Pdf = drp.DirectDocumentPrint(Settings.SqlProcDocumentPrint, User.Identity.Name, item);
PdfStream.Add(Pdf);
}
else if (pd.Status == (int)StatusConstants.Approved)
{
Pdf = drp.DirectDocumentPrint(Settings.SqlProcDocumentPrint, User.Identity.Name, item);
PdfStream.Add(Pdf);
}
}
}
PdfMerger pm = new PdfMerger();
byte[] Merge = pm.MergeFiles(PdfStream);
if (Merge != null)
{
return(File(Merge, "application/pdf"));
}
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
return(Json(new { success = "Error", data = message }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = "Success" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = "Error", data = "No Records Selected." }, JsonRequestBehavior.AllowGet));
}
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 DeleteConfirmed(ReasonViewModel vm)
{
if (ModelState.IsValid)
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
db.Configuration.AutoDetectChangesEnabled = false;
var temp = _MaterialPlanHeaderService.Find(vm.id);
int status = temp.Status;
LogList.Add(new LogTypeViewModel
{
ExObj = temp,
});
List <ProdOrderLine> ProdOrderLines = new List <ProdOrderLine>();
//List<ProdOrderLine> PurchaseIndentLines = new List<ProdOrderLine>();
var materialplanline = new MaterialPlanLineService(_unitOfWork).GetMaterialPlanForDelete(vm.id).ToList();
//var MAterialPlanForProdOrderLine = new MaterialPlanForProdOrderLineService(_unitOfWork).GetMAterialPlanForProdORderForMaterialPlan(item.MaterialPlanLineId).ToList();
var MAterialPlanForProdOrderLine = (from L in db.MaterialPlanForProdOrderLine
join H in db.MaterialPlanForProdOrder on L.MaterialPlanForProdOrderId equals H.MaterialPlanForProdOrderId into MaterialPlanForProdOrderTable
from MaterialPlanForProdOrderTab in MaterialPlanForProdOrderTable.DefaultIfEmpty()
where MaterialPlanForProdOrderTab.MaterialPlanHeaderId == vm.id
select L).ToList();
foreach (var item2 in MAterialPlanForProdOrderLine)
{
LogList.Add(new LogTypeViewModel
{
ExObj = item2,
});
item2.ObjectState = Model.ObjectState.Deleted;
//new MaterialPlanForProdOrderLineService(_unitOfWork).Delete(item2.MaterialPlanForProdOrderLineId);
db.MaterialPlanForProdOrderLine.Attach(item2);
db.MaterialPlanForProdOrderLine.Remove(item2);
}
foreach (var item in materialplanline)
{
//Deleting ProdOrderLines & HEaders
ProdOrderLines = new ProdOrderLineService(_unitOfWork).GetProdOrderLineForMaterialPlan(item.MaterialPlanLineId).ToList();
int[] LineIds = ProdOrderLines.Select(m => m.ProdOrderLineId).ToArray();
List <ProdOrderLineStatus> LineStatus = (from p in db.ProdOrderLineStatus
where LineIds.Contains(p.ProdOrderLineId.Value)
select p).ToList();
foreach (var LineStatitem in LineStatus)
{
LineStatitem.ObjectState = Model.ObjectState.Deleted;
db.ProdOrderLineStatus.Attach(LineStatitem);
db.ProdOrderLineStatus.Remove(LineStatitem);
}
foreach (var item2 in ProdOrderLines)
{
LogList.Add(new LogTypeViewModel
{
ExObj = item2,
});
item2.ObjectState = Model.ObjectState.Deleted;
db.ProdOrderLine.Attach(item2);
db.ProdOrderLine.Remove(item2);
}
//Deleting PurchaseIndentLines & Headers
//PurchaseIndentLines = new ProdOrderLineService(_unitOfWork).GetPurchOrProdLineForMaterialPlan(item.MaterialPlanLineId, ).ToList();
//foreach (var item2 in PurchaseIndentLines)
//{
// LogList.Add(new LogTypeViewModel
// {
// ExObj = item2,
// });
// item2.ObjectState = Model.ObjectState.Deleted;
// db.PurchaseIndentLine.Attach(item2);
// db.PurchaseIndentLine.Remove(item2);
//}
//Deleting MaterialplanforSaleOrder
var MAterialPlanForSaleOrder = new MaterialPlanForSaleOrderService(_unitOfWork).GetMaterialPlanForSaleOrderForMaterialPlanline(item.MaterialPlanLineId).ToList();
foreach (var item2 in MAterialPlanForSaleOrder)
{
LogList.Add(new LogTypeViewModel
{
ExObj = item2,
});
item2.ObjectState = Model.ObjectState.Deleted;
//new MaterialPlanForSaleOrderService(_unitOfWork).Delete(item2);
db.MaterialPlanForSaleOrder.Attach(item2);
db.MaterialPlanForSaleOrder.Remove(item2);
}
//Deleting MaterialPlanForProdOrderLine
//var MAterialPlanForProdOrderLine = new MaterialPlanForProdOrderLineService(_unitOfWork).GetMAterialPlanForProdORderForMaterialPlan(item.MaterialPlanLineId).ToList();
//foreach (var item2 in MAterialPlanForProdOrderLine)
//{
// LogList.Add(new LogTypeViewModel
// {
// ExObj = item2,
// });
// item2.ObjectState = Model.ObjectState.Deleted;
// //new MaterialPlanForProdOrderLineService(_unitOfWork).Delete(item2.MaterialPlanForProdOrderLineId);
// db.MaterialPlanForProdOrderLine.Attach(item2);
// db.MaterialPlanForProdOrderLine.Remove(item2);
//}
//new MaterialPlanLineService(_unitOfWork).Delete(item.MaterialPlanLineId);
//MaterialPlanLine Si = (MaterialPlanLine) item;
MaterialPlanLine MPL = new MaterialPlanLineService(_unitOfWork).Find(item.MaterialPlanLineId);
LogList.Add(new LogTypeViewModel
{
ExObj = MPL,
});
MPL.ObjectState = Model.ObjectState.Deleted;
db.MaterialPlanLine.Attach(MPL);
db.MaterialPlanLine.Remove(MPL);
}
var ProdORderHeaders = new ProdOrderHeaderService(_unitOfWork).GetProdOrderListForMaterialPlan(vm.id).ToList();
int[] ProdOrderIds = ProdORderHeaders.Select(m => m.ProdOrderHeaderId).ToArray();
List <ProdOrderHeaderStatus> ProdOrderHeaderStatus = (from p in db.ProdOrderHeaderStatus
where ProdOrderIds.Contains(p.ProdOrderHeaderId.Value)
select p).ToList();
foreach (var StatItem in ProdOrderHeaderStatus)
{
StatItem.ObjectState = Model.ObjectState.Deleted;
db.ProdOrderHeaderStatus.Attach(StatItem);
db.ProdOrderHeaderStatus.Remove(StatItem);
}
foreach (var item2 in ProdORderHeaders)
{
LogList.Add(new LogTypeViewModel
{
ExObj = item2,
});
item2.ObjectState = Model.ObjectState.Deleted;
// new ProdOrderHeaderService(_unitOfWork).Delete(item2.ProdOrderHeaderId);
db.ProdOrderHeader.Attach(item2);
db.ProdOrderHeader.Remove(item2);
}
//var PurchaseIndentHeaders = new PurchaseIndentHeaderService(_unitOfWork).GetPurchaseIndentListForMAterialPlan(vm.id).ToList();
//foreach (var item2 in PurchaseIndentHeaders)
//{
// LogList.Add(new LogTypeViewModel
// {
// ExObj = item2,
// });
// item2.ObjectState = Model.ObjectState.Deleted;
// //new PurchaseIndentHeaderService(_unitOfWork).Delete(item2.PurchaseIndentHeaderId);
// db.PurchaseIndentHeader.Attach(item2);
// db.PurchaseIndentHeader.Remove(item2);
//}
//Deleting MaterialPlanForProdORder
var MaterialPlanForProdOrder = new MaterialPlanForProdOrderService(_unitOfWork).GetMAterialPlanForProdORderForMaterialPlan(vm.id).ToList();
foreach (var item2 in MaterialPlanForProdOrder)
{
LogList.Add(new LogTypeViewModel
{
ExObj = item2,
});
item2.ObjectState = Model.ObjectState.Deleted;
//new MaterialPlanForProdOrderService(_unitOfWork).Delete(item2);
db.MaterialPlanForProdOrder.Attach(item2);
db.MaterialPlanForProdOrder.Remove(item2);
}
temp.ObjectState = Model.ObjectState.Deleted;
// _MaterialPlanHeaderService.Delete(temp);
db.MaterialPlanHeader.Attach(temp);
db.MaterialPlanHeader.Remove(temp);
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
// _unitOfWork.Save();
db.SaveChanges();
db.Configuration.AutoDetectChangesEnabled = true;
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
return(PartialView("_Reason", vm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = temp.DocTypeId,
DocId = temp.MaterialPlanHeaderId,
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 _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));
}
