public int CreateFactoryMaterialNorm(int factoryFinishedProductNormID, DTO.FactoryMaterialOrderNorm dtoItem, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success, Message = "Update material norm success"
};
try
{
if (!dtoItem.FactoryMaterialID.HasValue)
{
throw new Exception("You have to select material");
}
if (!dtoItem.NormValue.HasValue)
{
throw new Exception("You have to fill-in norm value");
}
using (FactoryOrderNormEntities context = CreateContext())
{
FactoryMaterialOrderNorm dbItem;
if (dtoItem.FactoryMaterialOrderNormID > 0)
{
dbItem = context.FactoryMaterialOrderNorm.Where(o => o.FactoryMaterialOrderNormID == dtoItem.FactoryMaterialOrderNormID).FirstOrDefault();
}
else
{
dbItem = new FactoryMaterialOrderNorm();
dbItem.FactoryFinishedProductOrderNorm = context.FactoryFinishedProductOrderNorm.FirstOrDefault(o => o.FactoryFinishedProductOrderNormID == factoryFinishedProductNormID);
context.FactoryMaterialOrderNorm.Add(dbItem);
}
if (dbItem != null)
{
dbItem.FactoryMaterialID = dtoItem.FactoryMaterialID;
dbItem.NormValue = dtoItem.NormValue;
dbItem.UnitID = dtoItem.UnitID;
}
else
{
throw new Exception("Could not find data. You have to save data before update material norm");
}
context.SaveChanges();
return(dbItem.FactoryMaterialOrderNormID);
}
}
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(-1);
}
}
//public DTO.EditFormData GetEditFormData(int id, int? clientID, int? productID, out Library.DTO.Notification notification)
//{
// DTO.EditFormData editFormData = new DTO.EditFormData();
// notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success };
// Module.Support.DAL.DataFactory support_factory = new Support.DAL.DataFactory();
// try
// {
// using (FactoryOrderNormEntities context = CreateContext())
// {
// if (id > 0)
// {
// FactoryOrderNormMng_FactoryOrderNorm_View dbItem;
// dbItem = context.FactoryOrderNormMng_FactoryOrderNorm_View.FirstOrDefault(o => o.FactoryOrderNormID == id);
// editFormData.Data = converter.DB2DTO_FactoryOrderNorm(dbItem);
// }
// else
// {
// //get info client and product
// var client = context.FactoryOrderNormMng_Client_View.Where(o => o.ClientID == clientID).FirstOrDefault();
// var clientProduct = context.FactoryOrderNormMng_ClientProduct_View.Where(o => o.ClientID == clientID && o.ProductID == productID).FirstOrDefault();
// var product = context.FactoryOrderNormMng_Product_View.Where(o => o.ProductID == productID).FirstOrDefault();
// int? modelID = product.ModelID;
// var defaultNorm = context.FactoryOrderNormMng_FactoryFinishedProductNorm_View.Where(o => o.ModelID == modelID).ToList();
// //init edit form info
// editFormData.Data = new DTO.FactoryOrderNorm();
// editFormData.Data.Season = Library.Helper.GetCurrentSeason();
// editFormData.Data.ClientID = clientID;
// editFormData.Data.ProductID = productID;
// editFormData.Data.ClientUD = client.ClientUD;
// editFormData.Data.ArticleCode = clientProduct.ArticleCode;
// editFormData.Data.Description = clientProduct.Description;
// editFormData.Data.ModelUD = product.ModelUD;
// editFormData.Data.ModelNM = product.ModelNM;
// //init default material norm
// editFormData.Data.FactoryFinishedProductOrderNorms = new List<DTO.FactoryFinishedProductOrderNorm>();
// DTO.FactoryFinishedProductOrderNorm finishedProductNorm;
// DTO.FactoryMaterialOrderNorm materialNorm;
// int i = -1;
// foreach (var item in defaultNorm)
// {
// finishedProductNorm = new DTO.FactoryFinishedProductOrderNorm();
// finishedProductNorm.FactoryMaterialOrderNorms = new List<DTO.FactoryMaterialOrderNorm>();
// finishedProductNorm.FactoryFinishedProductID = item.FactoryFinishedProductID;
// finishedProductNorm.NormValue = item.NormValue;
// finishedProductNorm.UnitID = item.UnitID;
// finishedProductNorm.FactoryFinishedProductUD = item.FactoryFinishedProductUD;
// finishedProductNorm.FactoryFinishedProductNM = item.FactoryFinishedProductNM;
// finishedProductNorm.IsEditing = false;
// foreach (var mItem in item.FactoryOrderNormMng_FactoryMaterialNorm_View)
// {
// materialNorm = new DTO.FactoryMaterialOrderNorm();
// materialNorm.FactoryMaterialID = mItem.FactoryMaterialID;
// materialNorm.NormValue = mItem.NormValue;
// materialNorm.UnitID = mItem.UnitID;
// materialNorm.FactoryMaterialUD = mItem.FactoryMaterialUD;
// materialNorm.FactoryMaterialNM = mItem.FactoryMaterialNM;
// materialNorm.UnitNM = mItem.UnitNM;
// materialNorm.IsEditing = true;
// finishedProductNorm.FactoryMaterialOrderNorms.Add(materialNorm);
// }
// editFormData.Data.FactoryFinishedProductOrderNorms.Add(finishedProductNorm);
// i--;
// }
// }
// //get support list
// editFormData.Units = support_factory.GetUnit(1);
// editFormData.Seasons = support_factory.GetSeason();
// //editFormData.FactoryGoodsProcedures = support_factory.GetFactoryGoodsProcedure();
// return editFormData;
// }
// }
// 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 editFormData;
// }
//}
public int CreateOrderNorm(string season, int?clientID, int?productID, out Library.DTO.Notification notification)
{
DTO.EditFormData editFormData = new DTO.EditFormData();
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success, Message = "Create BOM Of Order success"
};
try
{
if (string.IsNullOrEmpty(season) || season == "null")
{
throw new Exception("Season is empty. You have to select season");
}
if (!clientID.HasValue)
{
throw new Exception("Client is empty. You have to select client");
}
if (!productID.HasValue)
{
throw new Exception("Product is empty. You have to select product");
}
using (FactoryOrderNormEntities context = CreateContext())
{
var product = context.FactoryOrderNormMng_Product_View.Where(o => o.ProductID == productID).FirstOrDefault();
int?modelID = product.ModelID;
var defaultNorm = context.FactoryOrderNormMng_FactoryFinishedProductNorm_View.Where(o => o.ModelID == modelID).ToList();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
try
{
//db
FactoryOrderNorm orderNorm = new FactoryOrderNorm();
context.FactoryOrderNorm.Add(orderNorm);
//init edit form info
orderNorm.Season = Library.Helper.GetCurrentSeason();
orderNorm.ClientID = clientID;
orderNorm.ProductID = productID;
//init default material norm
FactoryFinishedProductOrderNorm finishedProductNorm;
FactoryMaterialOrderNorm materialNorm;
FactoryFinishedProductOrderNormFactoryGoodsProcedure goodsProcedure;
List <DTO.TempComponentNorm> tempNormIds = new List <DTO.TempComponentNorm>();
foreach (var item in defaultNorm.Where(o => o.ParentNormID == null))
{
finishedProductNorm = new FactoryFinishedProductOrderNorm();
orderNorm.FactoryFinishedProductOrderNorm.Add(finishedProductNorm);
finishedProductNorm.FactoryFinishedProductID = item.FactoryFinishedProductID;
finishedProductNorm.NormValue = item.NormValue;
finishedProductNorm.UnitID = item.UnitID;
finishedProductNorm.MaterialGroupTypeID = item.MaterialGroupTypeID;
foreach (var mItem in item.FactoryOrderNormMng_FactoryMaterialNorm_View)
{
materialNorm = new FactoryMaterialOrderNorm();
finishedProductNorm.FactoryMaterialOrderNorm.Add(materialNorm);
materialNorm.FactoryMaterialID = mItem.FactoryMaterialID;
materialNorm.NormValue = mItem.NormValue;
materialNorm.UnitID = mItem.UnitID;
}
foreach (var pItem in item.FactoryOrderNormMng_FactoryFinishedProductNormFactoryGoodsProcedure_View)
{
goodsProcedure = new FactoryFinishedProductOrderNormFactoryGoodsProcedure();
finishedProductNorm.FactoryFinishedProductOrderNormFactoryGoodsProcedure.Add(goodsProcedure);
goodsProcedure.FactoryGoodsProcedureID = pItem.FactoryGoodsProcedureID;
goodsProcedure.IsDefault = pItem.IsDefault;
}
context.SaveChanges();
tempNormIds.Add(new DTO.TempComponentNorm {
FinishedProductNormID = item.FactoryFinishedProductNormID, FinishedProductOrderNormID = finishedProductNorm.FactoryFinishedProductOrderNormID
});
}
foreach (var item in defaultNorm.Where(o => o.ParentNormID != null))
{
finishedProductNorm = new FactoryFinishedProductOrderNorm();
orderNorm.FactoryFinishedProductOrderNorm.Add(finishedProductNorm);
finishedProductNorm.FactoryFinishedProductID = item.FactoryFinishedProductID;
finishedProductNorm.NormValue = item.NormValue;
finishedProductNorm.UnitID = item.UnitID;
finishedProductNorm.ParentNormID = tempNormIds.Where(o => o.FinishedProductNormID == item.ParentNormID).FirstOrDefault().FinishedProductOrderNormID;
finishedProductNorm.MaterialGroupTypeID = item.MaterialGroupTypeID;
foreach (var mItem in item.FactoryOrderNormMng_FactoryMaterialNorm_View)
{
materialNorm = new FactoryMaterialOrderNorm();
finishedProductNorm.FactoryMaterialOrderNorm.Add(materialNorm);
materialNorm.FactoryMaterialID = mItem.FactoryMaterialID;
materialNorm.NormValue = mItem.NormValue;
materialNorm.UnitID = mItem.UnitID;
}
foreach (var pItem in item.FactoryOrderNormMng_FactoryFinishedProductNormFactoryGoodsProcedure_View)
{
goodsProcedure = new FactoryFinishedProductOrderNormFactoryGoodsProcedure();
finishedProductNorm.FactoryFinishedProductOrderNormFactoryGoodsProcedure.Add(goodsProcedure);
goodsProcedure.FactoryGoodsProcedureID = pItem.FactoryGoodsProcedureID;
goodsProcedure.IsDefault = pItem.IsDefault;
}
}
context.SaveChanges();
dbContextTransaction.Commit();
return(orderNorm.FactoryOrderNormID);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
throw new Exception(ex.ToString());
}
}
}
}
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(-1);
}
}
