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 <PurchaseIndentLine> PurchaseIndentLines = new List <PurchaseIndentLine>();
var materialplanline = new MaterialPlanLineService(_unitOfWork).GetMaterialPlanForDelete(vm.id).ToList();
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;
//new ProdOrderLineService(_unitOfWork).Delete(item2.ProdOrderLineId);
db.ProdOrderLine.Attach(item2);
db.ProdOrderLine.Remove(item2);
}
//Deleting PurchaseIndentLines & Headers
PurchaseIndentLines = new PurchaseIndentLineService(_unitOfWork).GetPurchaseIndentLineForMaterialPlan(item.MaterialPlanLineId).ToList();
foreach (var item2 in PurchaseIndentLines)
{
LogList.Add(new LogTypeViewModel
{
ExObj = item2,
});
item2.ObjectState = Model.ObjectState.Deleted;
//new PurchaseIndentLineService(_unitOfWork).Delete(item2);
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 _ResultsPost(PurchaseQuotationMasterDetailModel vm)
{
List <HeaderChargeViewModel> HeaderCharges = new List <HeaderChargeViewModel>();
List <LineChargeViewModel> LineCharges = new List <LineChargeViewModel>();
int pk = 0;
int ReceiptLinepk = 0;
int StockPk = 0;
int Cnt = 0;
int Serial = _PurchaseQuotationLineService.GetMaxSr(vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId);
bool HeaderChargeEdit = false;
PurchaseQuotationHeader Header = _PurchaseQuotationHeaderService.Find(vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId);
PurchaseQuotationSetting Settings = new PurchaseQuotationSettingService(_unitOfWork).GetPurchaseQuotationSettingForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId);
int?MaxLineId = new PurchaseQuotationLineChargeService(_unitOfWork).GetMaxProductCharge(Header.PurchaseQuotationHeaderId, "Web.PurchaseQuotationLines", "PurchaseQuotationHeaderId", "PurchaseQuotationLineId");
int PersonCount = 0;
int CalculationId = Settings.CalculationId;
List <LineDetailListViewModel> LineList = new List <LineDetailListViewModel>();
bool BeforeSave = true;
//try
//{
// BeforeSave = PurchaseQuotationReceiveDocEvents.beforeLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId), 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)
{
int ProcessId = new ProcessService(_unitOfWork).Find(ProcessConstants.FullFinishing).ProcessId;
var IndentLineIds = vm.PurchaseQuotationLineViewModel.Select(m => m.PurchaseIndentLineId).ToArray();
var IndentBalRecords = (from p in db.ViewPurchaseIndentBalance
where IndentLineIds.Contains(p.PurchaseIndentLineId)
select new
{
LineId = p.PurchaseIndentLineId,
BalQty = p.BalanceQty,
}).ToList();
foreach (var item in vm.PurchaseQuotationLineViewModel)
{
decimal balqty = IndentBalRecords.Where(m => m.LineId == item.PurchaseIndentLineId).FirstOrDefault().BalQty;
if (item.Qty > 0 && (Settings.isMandatoryRate == true ? item.Rate > 0 : 1 == 1) && item.Qty <= balqty)
{
PurchaseGoodsReceiptLine ReceiptLine = new PurchaseGoodsReceiptLine();
var PurchaseIndentLine = new PurchaseIndentLineService(_unitOfWork).Find(item.PurchaseIndentLineId.Value);
PurchaseQuotationLine line = new PurchaseQuotationLine();
line.PurchaseQuotationHeaderId = item.PurchaseQuotationHeaderId;
line.UnitConversionMultiplier = item.UnitConversionMultiplier;
line.Rate = item.Rate;
line.PurchaseIndentLineId = item.PurchaseIndentLineId;
line.DiscountPer = item.DiscountPer;
line.Qty = item.Qty;
line.DealUnitId = item.DealUnitId;
line.DealQty = item.Qty * item.UnitConversionMultiplier;
line.Amount = (line.DealQty * item.Rate);
line.CreatedDate = DateTime.Now;
line.ProductId = PurchaseIndentLine.ProductId;
line.Dimension1Id = PurchaseIndentLine.Dimension1Id;
line.Dimension2Id = PurchaseIndentLine.Dimension2Id;
line.Specification = PurchaseIndentLine.Specification;
line.Sr = Serial++;
line.ModifiedDate = DateTime.Now;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
line.PurchaseQuotationLineId = pk;
line.ObjectState = Model.ObjectState.Added;
//_PurchaseQuotationLineService.Create(line);
db.PurchaseQuotationLine.Add(line);
LineList.Add(new LineDetailListViewModel {
Amount = line.Amount, Rate = line.Rate, LineTableId = line.PurchaseQuotationLineId, HeaderTableId = item.PurchaseQuotationHeaderId, PersonID = Header.SupplierId
});
pk++;
StockPk++;
}
}
if (Header.Status != (int)StatusConstants.Drafted)
{
Header.Status = (int)StatusConstants.Modified;
Header.ModifiedBy = User.Identity.Name;
Header.ModifiedDate = DateTime.Now;
}
Header.ObjectState = Model.ObjectState.Modified;
db.PurchaseQuotationHeader.Add(Header);
//new PurchaseGoodsReceiptHeaderService(_unitOfWork).Update(ReceiptHeader);
new ChargesCalculationService(_unitOfWork).CalculateCharges(LineList, vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId, CalculationId, MaxLineId, out LineCharges, out HeaderChargeEdit, out HeaderCharges, "Web.PurchaseQuotationHeaderCharges", "Web.PurchaseQuotationLineCharges", out PersonCount, Header.DocTypeId, Header.SiteId, Header.DivisionId);
//Saving Charges
foreach (var item in LineCharges)
{
PurchaseQuotationLineCharge PoLineCharge = Mapper.Map <LineChargeViewModel, PurchaseQuotationLineCharge>(item);
PoLineCharge.ObjectState = Model.ObjectState.Added;
db.PurchaseQuotationLineCharge.Add(PoLineCharge);
//new PurchaseQuotationLineChargeService(_unitOfWork).Create(PoLineCharge);
}
//Saving Header charges
for (int i = 0; i < HeaderCharges.Count(); i++)
{
if (!HeaderChargeEdit)
{
PurchaseQuotationHeaderCharge POHeaderCharge = Mapper.Map <HeaderChargeViewModel, PurchaseQuotationHeaderCharge>(HeaderCharges[i]);
POHeaderCharge.HeaderTableId = vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId;
POHeaderCharge.PersonID = Header.SupplierId;
POHeaderCharge.ObjectState = Model.ObjectState.Added;
db.PurchaseQuotationHeaderCharge.Add(POHeaderCharge);
//new PurchaseQuotationHeaderChargeService(_unitOfWork).Create(POHeaderCharge);
}
else
{
var footercharge = new PurchaseQuotationHeaderChargeService(_unitOfWork).Find(HeaderCharges[i].Id);
footercharge.Rate = HeaderCharges[i].Rate;
footercharge.Amount = HeaderCharges[i].Amount;
footercharge.ObjectState = Model.ObjectState.Modified;
db.PurchaseQuotationHeaderCharge.Add(footercharge);
//new PurchaseQuotationHeaderChargeService(_unitOfWork).Update(footercharge);
}
}
//try
//{
// PurchaseQuotationReceiveDocEvents.onLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId), 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("_IndentResults", vm));
}
//try
//{
// PurchaseQuotationReceiveDocEvents.afterLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId), ref db);
//}
//catch (Exception ex)
//{
// string message = _exception.HandleException(ex);
// TempData["CSEXC"] += message;
//}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Header.DocTypeId,
DocId = Header.PurchaseQuotationHeaderId,
ActivityType = (int)ActivityTypeContants.MultipleCreate,
DocNo = Header.DocNo,
DocDate = Header.DocDate,
DocStatus = Header.Status,
}));
return(Json(new { success = true }));
}
return(PartialView("_IndentResults", 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 _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 Post(MaterialPlanHeaderViewModel vm)
{
MaterialPlanHeader pt = AutoMapper.Mapper.Map <MaterialPlanHeaderViewModel, MaterialPlanHeader>(vm);
//#region DocTypeTimeLineValidation
//try
//{
// if (vm.MaterialPlanHeaderId <= 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 && (TimePlanValidation || Continue))
{
#region CreateRecord
if (vm.MaterialPlanHeaderId <= 0)
{
using (var context = new ApplicationDbContext())
{
pt.CreatedDate = DateTime.Now;
pt.ModifiedDate = DateTime.Now;
pt.CreatedBy = User.Identity.Name;
pt.ModifiedBy = User.Identity.Name;
pt.ObjectState = Model.ObjectState.Added;
context.MaterialPlanHeader.Add(pt);
int Serial = 0;
MaterialPlanLineListViewModel svm = new MaterialPlanLineListViewModel();
svm.MaterialPlanLineViewModel = (List <MaterialPlanForSaleOrderViewModel>)System.Web.HttpContext.Current.Session["SODyeingPlan"];
var Summary = (IEnumerable <MaterialPlanLineViewModel>)System.Web.HttpContext.Current.Session["SODyeingPlanSummary"];
MaterialPlanSettings Settings = new MaterialPlanSettingsService(_unitOfWork).GetMaterialPlanSettingsForDocument(pt.DocTypeId, pt.DivisionId, pt.SiteId);
bool isPr = false;
bool isPP = false;
int j = 0;
foreach (var item in Summary)
{
{
MaterialPlanLine planLine = new MaterialPlanLine();
planLine.RequiredQty = item.RequiredQty;
planLine.ExcessStockQty = item.ExcessStockQty;
planLine.MaterialPlanHeaderId = item.MaterialPlanHeaderId;
planLine.ProductId = item.ProductId;
planLine.Dimension1Id = item.Dimension1Id;
planLine.Dimension2Id = item.Dimension2Id;
planLine.ProdPlanQty = item.ProdPlanQty;
planLine.CreatedBy = User.Identity.Name;
planLine.CreatedDate = DateTime.Now;
planLine.Sr = Serial++;
planLine.Specification = item.Specification;
planLine.ModifiedBy = User.Identity.Name;
planLine.MaterialPlanLineId = j;
planLine.ModifiedDate = DateTime.Now;
planLine.ProcessId = item.ProcessId;
planLine.Remark = item.Remark;
planLine.PurchPlanQty = item.PurchPlanQty;
planLine.StockPlanQty = item.StockPlanQty;
planLine.GeneratedFor = MaterialPlanConstants.SaleOrder;
planLine.ObjectState = Model.ObjectState.Added;
context.MaterialPlanLine.Add(planLine);
if (!isPr)
{
if (item.ProdPlanQty > 0)
{
isPr = true;
}
}
if (!isPP)
{
if (item.PurchPlanQty > 0)
{
isPP = true;
}
}
}
j++;
}
if (isPr)
{
ProdOrderHeader ExistingProdOrder = new ProdOrderHeaderService(_unitOfWork).GetProdOrderForMaterialPlan(pt.MaterialPlanHeaderId);
int ProdORderSerial = 1;
if (ExistingProdOrder == null)
{
ProdOrderHeader prodOrderHeader = new ProdOrderHeader();
prodOrderHeader.CreatedBy = User.Identity.Name;
prodOrderHeader.CreatedDate = DateTime.Now;
prodOrderHeader.DivisionId = pt.DivisionId;
prodOrderHeader.DocDate = pt.DocDate;
prodOrderHeader.DocNo = pt.DocNo;
prodOrderHeader.DocTypeId = Settings.DocTypeProductionOrderId.Value;
prodOrderHeader.DueDate = pt.DueDate;
prodOrderHeader.MaterialPlanHeaderId = pt.MaterialPlanHeaderId;
prodOrderHeader.ModifiedBy = User.Identity.Name;
prodOrderHeader.ModifiedDate = DateTime.Now;
prodOrderHeader.Remark = pt.Remark;
prodOrderHeader.BuyerId = pt.BuyerId;
prodOrderHeader.SiteId = pt.SiteId;
//prodOrderHeader.Status = header.Status;
prodOrderHeader.Status = (int)StatusConstants.System;
prodOrderHeader.ObjectState = Model.ObjectState.Added;
context.ProdOrderHeader.Add(prodOrderHeader);
//ForCreating ProdOrderStatus
ProdOrderHeaderStatus pts = new ProdOrderHeaderStatus();
pts.ProdOrderHeaderId = prodOrderHeader.ProdOrderHeaderId;
pts.ObjectState = Model.ObjectState.Added;
context.ProdOrderHeaderStatus.Add(pts);
int ProdOrderLineKey = 0;
foreach (var item in context.MaterialPlanLine.Local.Where(m => m.ProdPlanQty > 0))
{
ProdOrderLine prodOrderLine = new ProdOrderLine();
prodOrderLine.CreatedBy = User.Identity.Name;
prodOrderLine.CreatedDate = DateTime.Now;
prodOrderLine.MaterialPlanLineId = item.MaterialPlanLineId;
prodOrderLine.ModifiedBy = User.Identity.Name;
prodOrderLine.ModifiedDate = DateTime.Now;
prodOrderLine.ProdOrderHeaderId = prodOrderHeader.ProdOrderHeaderId;
prodOrderLine.Specification = item.Specification;
prodOrderLine.ProductId = item.ProductId;
prodOrderLine.Dimension1Id = item.Dimension1Id;
prodOrderLine.Dimension2Id = item.Dimension2Id;
prodOrderLine.Sr = ProdORderSerial++;
prodOrderLine.Qty = item.ProdPlanQty;
prodOrderLine.Remark = item.Remark;
prodOrderLine.ProdOrderLineId = ProdOrderLineKey++;
prodOrderLine.ObjectState = Model.ObjectState.Added;
context.ProdOrderLine.Add(prodOrderLine);
//ForAdding ProdrderLinestatus
ProdOrderLineStatus ptl = new ProdOrderLineStatus();
ptl.ProdOrderLineId = prodOrderLine.ProdOrderLineId;
ptl.ObjectState = Model.ObjectState.Added;
context.ProdOrderLineStatus.Add(ptl);
}
}
else
{
ProdORderSerial = new ProdOrderLineService(_unitOfWork).GetMaxSr(ExistingProdOrder.ProdOrderHeaderId);
int ProdOrderLineKey = 0;
foreach (var item in context.MaterialPlanLine.Local.Where(m => m.ProdPlanQty > 0))
{
ProdOrderLine prodOrderLine = new ProdOrderLine();
prodOrderLine.CreatedBy = User.Identity.Name;
prodOrderLine.CreatedDate = DateTime.Now;
prodOrderLine.MaterialPlanLineId = item.MaterialPlanLineId;
prodOrderLine.ModifiedBy = User.Identity.Name;
prodOrderLine.ModifiedDate = DateTime.Now;
prodOrderLine.ProdOrderHeaderId = ExistingProdOrder.ProdOrderHeaderId;
prodOrderLine.ProductId = item.ProductId;
prodOrderLine.Dimension1Id = item.Dimension1Id;
prodOrderLine.Dimension2Id = item.Dimension2Id;
prodOrderLine.Specification = item.Specification;
prodOrderLine.Qty = item.ProdPlanQty;
prodOrderLine.Sr = ProdORderSerial++;
prodOrderLine.Remark = item.Remark;
prodOrderLine.ProdOrderLineId = ProdOrderLineKey++;
prodOrderLine.ObjectState = Model.ObjectState.Added;
context.ProdOrderLine.Add(prodOrderLine);
//ForAdding ProdrderLinestatus
ProdOrderLineStatus ptl = new ProdOrderLineStatus();
ptl.ProdOrderLineId = prodOrderLine.ProdOrderLineId;
ptl.ObjectState = Model.ObjectState.Added;
context.ProdOrderLineStatus.Add(ptl);
}
}
}
if (isPP)
{
PurchaseIndentHeader ExistingIndent = new PurchaseIndentHeaderService(_unitOfWork).GetPurchaseIndentForMaterialPlan(pt.MaterialPlanHeaderId);
int PurchaseIndentSr = 1;
if (ExistingIndent == null)
{
PurchaseIndentHeader indentHeader = new PurchaseIndentHeader();
indentHeader.CreatedBy = User.Identity.Name;
indentHeader.CreatedDate = DateTime.Now;
indentHeader.DivisionId = pt.DivisionId;
indentHeader.DocDate = pt.DocDate;
indentHeader.DocNo = pt.DocNo;
indentHeader.DocTypeId = Settings.DocTypePurchaseIndentId.Value;
indentHeader.ModifiedBy = User.Identity.Name;
indentHeader.MaterialPlanHeaderId = pt.MaterialPlanHeaderId;
indentHeader.ModifiedDate = DateTime.Now;
indentHeader.Remark = pt.Remark;
indentHeader.SiteId = pt.SiteId;
//indentHeader.Status = header.Status;
indentHeader.Status = (int)StatusConstants.System;
indentHeader.DepartmentId = (int)DepartmentConstants.Production;
indentHeader.ObjectState = Model.ObjectState.Added;
context.PurchaseIndentHeader.Add(indentHeader);
foreach (var item in context.MaterialPlanLine.Local.Where(m => m.PurchPlanQty > 0))
{
PurchaseIndentLine indentLine = new PurchaseIndentLine();
indentLine.CreatedBy = User.Identity.Name;
indentLine.CreatedDate = DateTime.Now;
indentLine.MaterialPlanLineId = item.MaterialPlanLineId;
indentLine.ModifiedBy = User.Identity.Name;
indentLine.ModifiedDate = DateTime.Now;
indentLine.ProductId = item.ProductId;
indentLine.Dimension1Id = item.Dimension1Id;
indentLine.Dimension2Id = item.Dimension2Id;
indentLine.Specification = item.Specification;
indentLine.PurchaseIndentHeaderId = indentHeader.PurchaseIndentHeaderId;
indentLine.Qty = item.PurchPlanQty;
indentLine.Sr = PurchaseIndentSr++;
indentLine.Remark = item.Remark;
indentLine.ObjectState = Model.ObjectState.Added;
context.PurchaseIndentLine.Add(indentLine);
}
}
else
{
PurchaseIndentSr = new PurchaseIndentLineService(_unitOfWork).GetMaxSr(ExistingIndent.PurchaseIndentHeaderId);
foreach (var item in context.MaterialPlanLine.Local.Where(m => m.PurchPlanQty > 0))
{
PurchaseIndentLine indentLine = new PurchaseIndentLine();
indentLine.CreatedBy = User.Identity.Name;
indentLine.CreatedDate = DateTime.Now;
indentLine.MaterialPlanLineId = item.MaterialPlanLineId;
indentLine.ModifiedBy = User.Identity.Name;
indentLine.Specification = item.Specification;
indentLine.ModifiedDate = DateTime.Now;
indentLine.ProductId = item.ProductId;
indentLine.Dimension1Id = item.Dimension1Id;
indentLine.Dimension2Id = item.Dimension2Id;
indentLine.Sr = PurchaseIndentSr++;
indentLine.PurchaseIndentHeaderId = ExistingIndent.PurchaseIndentHeaderId;
indentLine.Qty = item.PurchPlanQty;
indentLine.Remark = item.Remark;
indentLine.ObjectState = Model.ObjectState.Added;
context.PurchaseIndentLine.Add(indentLine);
}
}
}
int i = 0;
int MaterialPlanForSaleOrderSr = new MaterialPlanForSaleOrderService(_unitOfWork).GetMaxSr(svm.MaterialPlanLineViewModel.FirstOrDefault().MaterialPlanHeaderId);
foreach (var item in svm.MaterialPlanLineViewModel)
{
if (item.Qty > 0)
{
MaterialPlanForSaleOrder order = new MaterialPlanForSaleOrder();
order.MaterialPlanHeaderId = item.MaterialPlanHeaderId;
order.Qty = item.Qty;
order.SaleOrderLineId = item.SaleOrderLineId;
order.MaterialPlanForSaleOrderId = i;
order.Sr = MaterialPlanForSaleOrderSr++;
order.CreatedBy = User.Identity.Name;
order.CreatedDate = DateTime.Now;
order.ModifiedBy = User.Identity.Name;
order.ModifiedDate = DateTime.Now;
//if (item.Dimension1Id != null)
//{
// var MaterialPlan = context.MaterialPlanLine.Local.Where(m => m.ProductId == item.ProductId && m.Dimension1Id == item.Dimension1Id).FirstOrDefault();
// if (order != null)
// {
// order.MaterialPlanLineId = MaterialPlan.MaterialPlanLineId;
// }
//}
//else
//{
// var MaterialPlan = context.MaterialPlanLine.Local.Where(m => m.ProductId == item.ProductId).FirstOrDefault();
// if (order != null)
// {
// order.MaterialPlanLineId = MaterialPlan.MaterialPlanLineId;
// }
//}
order.ObjectState = Model.ObjectState.Added;
context.MaterialPlanForSaleOrder.Add(order);
i++;
}
}
try
{
context.SaveChanges();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
ViewBag.Mode = "Add";
ViewBag.Name = new DocumentTypeService(_unitOfWork).Find(vm.DocTypeId).DocumentTypeName;
ViewBag.id = vm.DocTypeId;
return(View("Create", vm));
}
//LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
//{
// DocTypeId = pt.DocTypeId,
// DocId = pt.MaterialPlanHeaderId,
// ActivityType = (int)ActivityTypeContants.Added,
// DocNo = pt.DocNo,
// DocDate = pt.DocDate,
// DocStatus = pt.Status,
//}));
return(RedirectToAction("Index", "MaterialPlanHeader", new { id = pt.DocTypeId }));
}
}
#endregion
}
ViewBag.Name = new DocumentTypeService(_unitOfWork).Find(vm.DocTypeId).DocumentTypeName;
ViewBag.id = vm.DocTypeId;
ViewBag.Mode = "Add";
return(View("Create", vm));
}
