public void DTO2DB_FactoryMaterialReceipt(DTO.FactoryMaterialReceipt dtoItem, ref FactoryMaterialReceipt dbItem)
{
if (dtoItem.FactoryMaterialReceiptDetails != null) // allow user delete item in case receipt is export
{
//if (dtoItem.ReceiptTypeID == 2)
//{
//}
foreach (var item in dbItem.FactoryMaterialReceiptDetail.Where(o => !o.ParentID.HasValue).ToArray())
{
if (!dtoItem.FactoryMaterialReceiptDetails.Select(s => s.FactoryMaterialReceiptDetailID).Contains(item.FactoryMaterialReceiptDetailID))
{
foreach (var sItem in item.FactoryMaterialReceiptDetail1.ToArray())
{
item.FactoryMaterialReceiptDetail1.Remove(sItem);
}
dbItem.FactoryMaterialReceiptDetail.Remove(item);
}
else
{
foreach (var sItem in item.FactoryMaterialReceiptDetail1.ToArray())
{
var x = dtoItem.FactoryMaterialReceiptDetails.Where(o => o.FactoryMaterialReceiptDetailID == item.FactoryMaterialReceiptDetailID).FirstOrDefault().FactoryMaterialReceiptDetails;
if (!x.Select(s => s.FactoryMaterialReceiptDetailID).Contains(sItem.FactoryMaterialReceiptDetailID))
{
item.FactoryMaterialReceiptDetail1.Remove(sItem);
}
}
}
}
FactoryMaterialReceiptDetail dbDetail;
FactoryMaterialReceiptDetail dbDetail1;
foreach (var item in dtoItem.FactoryMaterialReceiptDetails)
{
if (item.FactoryMaterialReceiptDetailID > 0)
{
dbDetail = dbItem.FactoryMaterialReceiptDetail.Where(o => o.FactoryMaterialReceiptDetailID == item.FactoryMaterialReceiptDetailID).FirstOrDefault();
if (dbDetail != null && item.FactoryMaterialReceiptDetails != null)
{
foreach (var mItem in item.FactoryMaterialReceiptDetails)
{
if (mItem.FactoryMaterialReceiptDetailID > 0)
{
dbDetail1 = dbDetail.FactoryMaterialReceiptDetail1.Where(o => o.FactoryMaterialReceiptDetailID == mItem.FactoryMaterialReceiptDetailID).FirstOrDefault();
}
else
{
dbDetail1 = new FactoryMaterialReceiptDetail();
dbDetail.FactoryMaterialReceiptDetail1.Add(dbDetail1);
dbItem.FactoryMaterialReceiptDetail.Add(dbDetail1);
}
if (dbDetail1 != null)
{
AutoMapper.Mapper.Map <DTO.FactoryMaterialReceiptDetail, FactoryMaterialReceiptDetail>(mItem, dbDetail1);
}
}
}
}
else
{
dbDetail = new FactoryMaterialReceiptDetail();
dbItem.FactoryMaterialReceiptDetail.Add(dbDetail);
if (item.FactoryMaterialReceiptDetails != null)
{
foreach (var mItem in item.FactoryMaterialReceiptDetails)
{
dbDetail1 = new FactoryMaterialReceiptDetail();
dbDetail.FactoryMaterialReceiptDetail1.Add(dbDetail1);
dbItem.FactoryMaterialReceiptDetail.Add(dbDetail1);
AutoMapper.Mapper.Map <DTO.FactoryMaterialReceiptDetail, FactoryMaterialReceiptDetail>(mItem, dbDetail1);
}
}
}
//mapping
if (dbDetail != null)
{
AutoMapper.Mapper.Map <DTO.FactoryMaterialReceiptDetail, FactoryMaterialReceiptDetail>(item, dbDetail);
}
}
}
AutoMapper.Mapper.Map <DTO.FactoryMaterialReceipt, FactoryMaterialReceipt>(dtoItem, dbItem);
dbItem.UpdatedDate = DateTime.Now;
dbItem.UpdatedBy = dtoItem.UpdatedBy;
dbItem.ReceiptDate = dtoItem.ReceiptDate.ConvertStringToDateTime();
if (dtoItem.FactoryMaterialReceiptID == null)
{
dbItem.CreatedDate = DateTime.Now;
dbItem.CreatedBy = dtoItem.UpdatedBy;
}
}
public void ValidateQntImport(DTO.FactoryMaterialReceipt dtoReceipt)
{
if (dtoReceipt.FactoryMaterialReceiptDetails != null && dtoReceipt.FactoryMaterialReceiptDetails.Where(o => o.FactoryMaterialReceiptDetailID > 0).Count() > 0)
{
using (FactoryMaterialReceiptEntities context = CreateContext())
{
/*
* check import free item
*/
List <DTO.FactoryMaterialReceiptDetail> dtoDetail_Free = dtoReceipt.FactoryMaterialReceiptDetails.Where(o => o.FactoryOrderDetailID.HasValue == false && o.FactoryMaterialReceiptDetailID > 0).ToList();
List <int?> receiptDetailIDs_Free = dtoDetail_Free.Select(x => x.FactoryMaterialReceiptDetailID).ToList();
List <string> keyIDs = dtoDetail_Free.Select(x => x.FactoryMaterialID.ToString() + "_" + x.FactoryAreaID.ToString()).ToList();
var dbReceiptDetail_Free = context.FactoryMaterialReceiptDetail.Where(o => receiptDetailIDs_Free.Contains(o.FactoryMaterialReceiptDetailID)).ToList();
var dbStock_Free = context.FactoryMaterialReceiptMng_StockFree_View.Where(o => keyIDs.Contains(o.FactoryMaterialID.ToString() + "_" + o.FactoryAreaID.ToString())).ToList();
//begin compare to check
decimal?stockRemainQnt = 0;
decimal?totalImportedQnt = 0;
foreach (var item in dtoDetail_Free)
{
var receiptDetailFreeItem = dbReceiptDetail_Free.Where(o => o.FactoryMaterialReceiptDetailID == item.FactoryMaterialReceiptDetailID).FirstOrDefault();
var stockFreeItem = dbStock_Free.Where(o => o.FactoryMaterialID == item.FactoryMaterialID && o.FactoryAreaID == item.FactoryAreaID).FirstOrDefault();
stockRemainQnt = (stockFreeItem == null ? 0 : stockFreeItem.TotalStockQnt);
if (stockRemainQnt == 0) // stock is empting
{
if (item.Quantity < receiptDetailFreeItem.Quantity)
{
throw new Exception("You can not edit quantity of material : " + item.FactoryMaterialUD + ". Because material was exported");
}
}
else
{
totalImportedQnt = stockFreeItem.TotalImportedQnt - receiptDetailFreeItem.Quantity + item.Quantity;
if (totalImportedQnt < stockFreeItem.TotalExportedQnt)
{
throw new Exception("You can not edit quantity of material : " + item.FactoryMaterialUD + ". Because material was exported");
}
}
}
/*
* check import order item
*/
List <DTO.FactoryMaterialReceiptDetail> dtoDetail_Order = dtoReceipt.FactoryMaterialReceiptDetails.Where(o => o.FactoryOrderDetailID.HasValue == true && o.FactoryMaterialReceiptDetailID > 0).ToList();
List <int?> receiptDetailIDs_Order = dtoDetail_Order.Select(x => x.FactoryMaterialReceiptDetailID).ToList();
List <string> keyIDs_Order = dtoDetail_Order.Select(o => o.FactoryOrderDetailID.Value.ToString() + "_" + o.FactoryFinishedProductID.Value.ToString() + "_ " + o.FactoryMaterialID.Value.ToString() + "_" + o.FactoryMaterialOrderNormID.Value.ToString() + "_" + o.FactoryAreaID.Value.ToString()).ToList();
var dbReceiptDetail_Order = context.FactoryMaterialReceiptDetail.Where(o => receiptDetailIDs_Order.Contains(o.FactoryMaterialReceiptDetailID)).ToList();
var dbStock_Order = context.FactoryMaterialReceiptMng_StockRemain_View.Where(o => keyIDs_Order.Contains(o.FactoryOrderDetailID.Value.ToString() + "_" + o.FactoryFinishedProductID.Value.ToString() + "_ " + o.FactoryMaterialID.Value.ToString() + "_" + o.FactoryMaterialOrderNormID.Value.ToString() + "_" + o.FactoryAreaID.Value.ToString())).ToList();
//begin compare to check
decimal?stockQnt_Order = 0;
decimal?totalImportedQnt_Order = 0;
foreach (var item in dtoDetail_Order)
{
var receiptDetailOrderItem = dbReceiptDetail_Order.Where(o => o.FactoryMaterialReceiptDetailID == item.FactoryMaterialReceiptDetailID).FirstOrDefault();
var stockOrderItem = dbStock_Order.Where(o => o.FactoryOrderDetailID == item.FactoryOrderDetailID &&
o.FactoryFinishedProductID == item.FactoryFinishedProductID &&
o.FactoryMaterialID == item.FactoryMaterialID &&
o.FactoryMaterialOrderNormID == item.FactoryMaterialOrderNormID &&
o.FactoryAreaID == item.FactoryAreaID).FirstOrDefault();
stockQnt_Order = (stockOrderItem == null ? 0 : stockOrderItem.TotalStockQnt);
if (stockQnt_Order == 0) // stock is empting
{
if (item.Quantity < receiptDetailOrderItem.Quantity)
{
throw new Exception("You can not edit quantity of material : " + item.ClientUD + " - " + item.ProformaInvoiceNo + " - " + item.FactoryMaterialUD + ". Because material was exported");
}
}
else
{
totalImportedQnt_Order = stockOrderItem.TotalImportedQnt - receiptDetailOrderItem.Quantity + item.Quantity;
if (totalImportedQnt_Order < stockOrderItem.TotalExportedQnt)
{
throw new Exception("You can not edit quantity of material : " + item.ClientUD + " - " + item.ProformaInvoiceNo + " - " + item.FactoryMaterialUD + ". Because material was exported");
}
}
}
}
}
}
public void ValidateQntExport(DTO.FactoryMaterialReceipt dtoReceipt)
{
if (dtoReceipt.FactoryMaterialReceiptDetails != null && dtoReceipt.FactoryMaterialReceiptDetails.Count() > 0)
{
//create a copy of dto detail
List <DTO.FactoryMaterialReceiptDetail> dtoDetails = new List <DTO.FactoryMaterialReceiptDetail>();
foreach (var item in dtoReceipt.FactoryMaterialReceiptDetails)
{
dtoDetails.Add(new DTO.FactoryMaterialReceiptDetail()
{
FactoryMaterialReceiptDetailID = item.FactoryMaterialReceiptDetailID,
FactoryOrderDetailID = item.FactoryOrderDetailID,
FactoryFinishedProductID = item.FactoryFinishedProductID,
FactoryMaterialID = item.FactoryMaterialID,
FactoryMaterialOrderNormID = item.FactoryMaterialOrderNormID,
FactoryAreaID = item.FactoryAreaID,
Quantity = item.Quantity,
});
//add child item
foreach (var sItem in item.FactoryMaterialReceiptDetails)
{
dtoDetails.Add(new DTO.FactoryMaterialReceiptDetail()
{
FactoryMaterialReceiptDetailID = sItem.FactoryMaterialReceiptDetailID,
FactoryOrderDetailID = sItem.FactoryOrderDetailID,
FactoryFinishedProductID = sItem.FactoryFinishedProductID,
FactoryMaterialID = sItem.FactoryMaterialID,
FactoryMaterialOrderNormID = sItem.FactoryMaterialOrderNormID,
FactoryAreaID = sItem.FactoryAreaID,
Quantity = sItem.Quantity,
});
}
}
//
using (FactoryMaterialReceiptEntities context = CreateContext())
{
//adjust dto quantity in case factoryMaterialReceiptDetailID > 0
List <int?> factoryMaterialReceiptDetailIDs = dtoDetails.Where(o => o.FactoryMaterialReceiptDetailID > 0).Select(s => s.FactoryMaterialReceiptDetailID).ToList();
var dbDetails = context.FactoryMaterialReceiptDetail.Where(o => factoryMaterialReceiptDetailIDs.Contains(o.FactoryMaterialReceiptDetailID)).ToList();
foreach (var item in dtoDetails.Where(o => o.FactoryMaterialReceiptDetailID > 0))
{
var s = dbDetails.Where(x => x.FactoryMaterialReceiptDetailID == item.FactoryMaterialReceiptDetailID).FirstOrDefault();
item.Quantity = item.Quantity - (s.Quantity.HasValue ? s.Quantity.Value : 0);
}
//get free items
var dtoDetail_Free = from item in dtoDetails.Where(o => o.FactoryOrderDetailID.HasValue == false)
group item by new { item.FactoryMaterialID, item.FactoryAreaID } into g
select new { g.Key.FactoryMaterialID, g.Key.FactoryAreaID, TotalExportQnt = g.Sum(o => o.Quantity) };
//check with free stock
List <string> keyIDs = dtoDetail_Free.Select(o => o.FactoryMaterialID.Value.ToString() + "_" + o.FactoryAreaID.Value.ToString()).ToList();
var dbStockFree = context.FactoryMaterialReceiptMng_StockFree_View.Where(o => keyIDs.Contains(o.FactoryMaterialID.ToString() + "_" + o.FactoryAreaID.ToString())).ToList();
foreach (var item in dtoDetail_Free)
{
var x = dbStockFree.Where(o => o.FactoryMaterialID == item.FactoryMaterialID && o.FactoryAreaID == item.FactoryAreaID).FirstOrDefault();
if (item.TotalExportQnt > (x == null ? 0 : x.TotalStockQnt))
{
var s = dtoReceipt.FactoryMaterialReceiptDetails.Where(o => o.FactoryMaterialID == item.FactoryMaterialID && o.FactoryAreaID == item.FactoryAreaID).FirstOrDefault();
throw new Exception("The total quantity of material must be less than total quantity in stock." + (s == null ? "" : s.FactoryMaterialUD + " - " + s.FactoryAreaNM));
}
}
//get order items
var dtoDetail_Order = from item in dtoDetails.Where(o => o.FactoryOrderDetailID.HasValue == true)
group item by new { item.FactoryMaterialID, item.FactoryAreaID, item.FactoryOrderDetailID, item.FactoryFinishedProductID, item.FactoryMaterialOrderNormID } into g
select new { g.Key.FactoryOrderDetailID, g.Key.FactoryFinishedProductID, g.Key.FactoryMaterialID, g.Key.FactoryMaterialOrderNormID, g.Key.FactoryAreaID, TotalExportQnt = g.Sum(o => o.Quantity) };
//check with order stock remain
keyIDs = dtoDetail_Order.Select(o => o.FactoryOrderDetailID.Value.ToString() + "_" + o.FactoryFinishedProductID.Value.ToString() + "_ " + o.FactoryMaterialID.Value.ToString() + "_" + o.FactoryMaterialOrderNormID.Value.ToString() + "_" + o.FactoryAreaID.Value.ToString()).ToList();
var dbStockOrder = context.FactoryMaterialReceiptMng_StockRemain_View.Where(o => keyIDs.Contains(o.FactoryOrderDetailID.Value.ToString() + "_"
+ o.FactoryFinishedProductID.Value.ToString() + "_ "
+ o.FactoryMaterialID.Value.ToString() + "_"
+ o.FactoryMaterialOrderNormID.Value.ToString() + "_"
+ o.FactoryAreaID.Value.ToString())).ToList();
foreach (var item in dtoDetail_Order)
{
var x = dbStockOrder.Where(o => o.FactoryOrderDetailID == item.FactoryOrderDetailID &&
o.FactoryFinishedProductID == item.FactoryFinishedProductID &&
o.FactoryMaterialID == item.FactoryMaterialID &&
o.FactoryMaterialOrderNormID == item.FactoryMaterialOrderNormID &&
o.FactoryAreaID == item.FactoryAreaID).FirstOrDefault();
if (item.TotalExportQnt > (x == null ? 0 : x.TotalStockQnt))
{
var s = dtoReceipt.FactoryMaterialReceiptDetails.Where(o => o.FactoryOrderDetailID == item.FactoryOrderDetailID &&
o.FactoryFinishedProductID == item.FactoryFinishedProductID &&
o.FactoryMaterialID == item.FactoryMaterialID &&
o.FactoryMaterialOrderNormID == item.FactoryMaterialOrderNormID &&
o.FactoryAreaID == item.FactoryAreaID).FirstOrDefault();
throw new Exception("The total quantity of material must be less than total quantity in stock." + (s == null ? "" : s.FactoryUD + " - " + s.ProformaInvoiceNo + " - " + s.FactoryMaterialUD + " - " + s.FactoryAreaNM));
}
}
}
}
}
public override bool UpdateData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
DTO.FactoryMaterialReceipt dtoFactoryMaterialReceipt = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.FactoryMaterialReceipt>();
dtoFactoryMaterialReceipt.UpdatedBy = userId;
try
{
using (FactoryMaterialReceiptEntities context = CreateContext())
{
FactoryMaterialReceipt dbItem = null;
if (id == 0)
{
dbItem = new FactoryMaterialReceipt();
context.FactoryMaterialReceipt.Add(dbItem);
}
else
{
dbItem = context.FactoryMaterialReceipt.Where(o => o.FactoryMaterialReceiptID == id).FirstOrDefault();
}
if (dbItem == null)
{
notification.Message = "data not found!";
return(false);
}
else
{
//
if (dtoFactoryMaterialReceipt.ReceiptTypeID == 2 && !dtoFactoryMaterialReceipt.FactoryTeamID.HasValue) // 2 : Export
{
throw new Exception("Team is empty. You should fill-in Team");
}
if (dtoFactoryMaterialReceipt.FactoryMaterialReceiptDetails.Where(o => !o.FactoryAreaID.HasValue).Count() > 0)
{
throw new Exception("Area is empty. All product must be fill-in Area");
}
//validate quantity
if (dtoFactoryMaterialReceipt.ReceiptTypeID == 1) // import receipt
{
ValidateQntImport(dtoFactoryMaterialReceipt);
}
else if (dtoFactoryMaterialReceipt.ReceiptTypeID == 2) // export receipt
{
ValidateQntExport(dtoFactoryMaterialReceipt);
}
//convert dto to db
converter.DTO2DB_FactoryMaterialReceipt(dtoFactoryMaterialReceipt, ref dbItem);
//remove orphan item
context.FactoryMaterialReceiptDetail.Local.Where(o => o.FactoryMaterialReceipt == null).ToList().ForEach(o => context.FactoryMaterialReceiptDetail.Remove(o));
//save data
context.SaveChanges();
//update receipt no
//context.FactoryMaterialReceiptMng_function_GenerateReceipNo(dbItem.FactoryMaterialReceiptID, dbItem.Season, dbItem.ReceiptTypeID);
//get return data
dtoItem = GetData(dbItem.FactoryMaterialReceiptID, out notification).Data;
return(true);
}
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
notification.DetailMessage.Add(ex.Message);
if (ex.GetBaseException() != null)
{
notification.DetailMessage.Add(ex.GetBaseException().Message);
}
return(false);
}
}
