public List <DTO.FactoryMaterial> EstimateMaterial(int userId, string factoryOrderIds, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification {
Type = Library.DTO.NotificationType.Success
};
List <DTO.FactoryMaterial> data = new List <DTO.FactoryMaterial>();
try
{
if (string.IsNullOrEmpty(factoryOrderIds))
{
return(data);
}
int[] fIDs = factoryOrderIds.Split(';').Where(o => !string.IsNullOrEmpty(o)).Select(o => Convert.ToInt32(o)).ToArray();
//search
DTO.FactoryMaterial material;
using (FactoryEstimateMaterialEntities context = CreateContext())
{
List <DTO.FactoryOrderDetail> factoryOrderDetails = converter.DB2DTO_FactoryOrderDetail(context.FactoryEstimateMaterialMng_FactoryOrderDetail_View.Where(o => fIDs.Contains(o.FactoryOrderID.Value)).ToList());
var factoryMaterial = from item in factoryOrderDetails
group item by new { item.FactoryMaterialID } into g
select new { g.Key.FactoryMaterialID, TotalOrderQnt = g.Sum(o => o.OrderQnt * o.NormValue) };
foreach (var item in factoryMaterial)
{
//get material entry
var fOrderDetail = factoryOrderDetails.Where(o => o.FactoryMaterialID == item.FactoryMaterialID).FirstOrDefault();
//init material object
material = new DTO.FactoryMaterial();
material.IsSelected = item.FactoryMaterialID.HasValue;
material.FactoryMaterialID = item.FactoryMaterialID;
material.Quantity = item.TotalOrderQnt;
material.FactoryMaterialUD = fOrderDetail.FactoryMaterialUD;
material.FactoryMaterialNM = fOrderDetail.FactoryMaterialNM;
material.UnitID = fOrderDetail.UnitID;
material.UnitNM = fOrderDetail.UnitNM;
material.TotalStockQnt = fOrderDetail.TotalStockQnt;
//init order info
material.FactoryOrderDetails = converter.DTO2DTO_FactoryOrderDetail(factoryOrderDetails.Where(o => o.FactoryMaterialID == item.FactoryMaterialID).ToList());
//add to object
data.Add(material);
}
}
return(data);
}
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(new List <DTO.FactoryMaterial>());;
}
}
public int ImportMaterial(int userID, object dtoItem, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification {
Type = Library.DTO.NotificationType.Success, Message = "System have just created import material receipt success"
};
int factoryMaterialReceiptID = -1;
List <DTO.FactoryMaterial> data = ((Newtonsoft.Json.Linq.JArray)dtoItem).ToObject <List <DTO.FactoryMaterial> >();
try
{
using (FactoryEstimateMaterialEntities context = CreateContext())
{
FactoryMaterialReceipt dbReceipt = new FactoryMaterialReceipt();
context.FactoryMaterialReceipt.Add(dbReceipt);
dbReceipt.ReceiptTypeID = 1; //1 :Import, 2: Export
dbReceipt.Season = Library.Helper.GetCurrentSeason();
dbReceipt.ReceiptDate = DateTime.Now;
dbReceipt.CreatedBy = userID;
dbReceipt.CreatedDate = DateTime.Now;
dbReceipt.UpdatedBy = userID;
dbReceipt.UpdatedDate = DateTime.Now;
//create receipt detail
FactoryMaterialReceiptDetail dbDetail;
foreach (var material in data.Where(o => o.FactoryMaterialID.HasValue))
{
if (material.FactoryAreaID.HasValue)
{
foreach (var item in material.FactoryOrderDetails.Where(o => o.IsSelected.HasValue && o.IsSelected.Value))
{
dbDetail = new FactoryMaterialReceiptDetail();
dbReceipt.FactoryMaterialReceiptDetail.Add(dbDetail);
dbDetail.FactoryOrderDetailID = item.FactoryOrderDetailID;
dbDetail.FactoryMaterialID = material.FactoryMaterialID;
dbDetail.FactoryAreaID = material.FactoryAreaID;
dbDetail.Quantity = item.AmountQnt;
dbDetail.FactoryFinishedProductID = item.FactoryFinishedProductID;
}
}
else
{
throw new Exception("Area is empty. You need select Area before import to stock");
}
}
//save receipt
context.SaveChanges();
//get return id
factoryMaterialReceiptID = dbReceipt.FactoryMaterialReceiptID;
//update receipt no
context.FactoryMaterialReceiptMng_function_GenerateReceipNo(factoryMaterialReceiptID, dbReceipt.Season, dbReceipt.ReceiptTypeID);
}
}
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(factoryMaterialReceiptID);
}