public int DeleteMaterialNorm(int id, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification {
Type = Library.DTO.NotificationType.Success, Message = "Delete success"
};
try
{
using (FactoryOrderNormEntities context = CreateContext())
{
var dbItem = context.FactoryMaterialOrderNorm.FirstOrDefault(o => o.FactoryMaterialOrderNormID == id);
context.FactoryMaterialOrderNorm.Remove(dbItem);
context.SaveChanges();
}
return(id);
}
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 override bool DeleteData(int id, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification {
Type = Library.DTO.NotificationType.Success
};
try
{
using (FactoryOrderNormEntities context = CreateContext())
{
var dbItem = context.FactoryOrderNorm.Where(o => o.FactoryOrderNormID == id).FirstOrDefault();
//foreach (var item in dbItem.FactoryFinishedProductOrderNorm.ToArray())
//{
// foreach (var mItem in item.FactoryMaterialOrderNorm.ToArray())
// {
// context.FactoryMaterialOrderNorm.Remove(mItem);
// }
// context.FactoryFinishedProductOrderNorm.Remove(item);
//}
context.FactoryOrderNorm.Remove(dbItem);
context.SaveChanges();
}
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);
}
}
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 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.FactoryOrderNorm dtoFactoryOrderNorm = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.FactoryOrderNorm>();
try
{
using (FactoryOrderNormEntities context = CreateContext())
{
FactoryOrderNorm dbItem = null;
if (id > 0)
{
dbItem = context.FactoryOrderNorm.Where(o => o.FactoryOrderNormID == id).FirstOrDefault();
}
else
{
dbItem = new FactoryOrderNorm();
context.FactoryOrderNorm.Add(dbItem);
}
if (dbItem == null)
{
notification.Message = "data not found!";
return(false);
}
else
{
//convert dto to db
converter.DTO2DB_FactoryOrderNorm(dtoFactoryOrderNorm, ref dbItem);
//remove orphan item
context.FactoryMaterialOrderNorm.Local.Where(o => o.FactoryFinishedProductOrderNorm == null).ToList().ForEach(o => context.FactoryMaterialOrderNorm.Remove(o));
context.FactoryFinishedProductOrderNorm.Local.Where(o => o.FactoryOrderNorm == null).ToList().ForEach(o => context.FactoryFinishedProductOrderNorm.Remove(o));
//save data
context.SaveChanges();
//get return data
dtoItem = GetData(dbItem.FactoryOrderNormID, 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);
}
}
public int DeleteFinishedProductNorm(int id, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification {
Type = Library.DTO.NotificationType.Success, Message = "Delete success"
};
try
{
using (FactoryOrderNormEntities context = CreateContext())
{
var dbSub = context.FactoryFinishedProductOrderNorm.Where(o => o.ParentNormID == id);
if (dbSub != null && dbSub.Count() > 0)
{
throw new Exception("You have to delete sub component first");
}
var dbItem = context.FactoryFinishedProductOrderNorm.FirstOrDefault(o => o.FactoryFinishedProductOrderNormID == id);
foreach (var cItem in dbItem.FactoryFinishedProductOrderNormFactoryGoodsProcedure.ToArray())
{
dbItem.FactoryFinishedProductOrderNormFactoryGoodsProcedure.Remove(cItem);
}
context.FactoryFinishedProductOrderNormFactoryGoodsProcedure.Local.Where(o => o.FactoryFinishedProductOrderNorm == null).ToList().ForEach(o => context.FactoryFinishedProductOrderNormFactoryGoodsProcedure.Remove(o));
context.FactoryFinishedProductOrderNorm.Remove(dbItem);
context.SaveChanges();
}
return(id);
}
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 int CreateNewFactoryFinishedProduct(string code, string name, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success, Message = "Create component success"
};
try
{
if (string.IsNullOrEmpty(code))
{
throw new Exception("You have to fill-in component code");
}
if (string.IsNullOrEmpty(name))
{
throw new Exception("You have to fill-in component name");
}
using (FactoryOrderNormEntities context = CreateContext())
{
FactoryFinishedProduct dbFinishedProduct = new FactoryFinishedProduct();
dbFinishedProduct.FactoryFinishedProductUD = code;
dbFinishedProduct.FactoryFinishedProductNM = name;
context.FactoryFinishedProduct.Add(dbFinishedProduct);
context.SaveChanges();
return(dbFinishedProduct.FactoryFinishedProductID);
}
}
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 int CreateSubComponentNorm(int parentFactoryFinishedProductNormID, DTO.FactoryFinishedProductOrderNorm dtoItem, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success, Message = "Update sub component norm success"
};
try
{
if (!dtoItem.FactoryFinishedProductID.HasValue)
{
throw new Exception("You have to select component");
}
if (!dtoItem.NormValue.HasValue)
{
throw new Exception("You have to fill-in norm value");
}
if (dtoItem.FactoryFinishedProductOrderNormFactoryGoodsProcedures == null || dtoItem.FactoryFinishedProductOrderNormFactoryGoodsProcedures.Count() == 0)
{
throw new Exception("You have to fill-in procedure");
}
if (dtoItem.FactoryFinishedProductOrderNormFactoryGoodsProcedures.Count() > 0)
{
if (dtoItem.FactoryFinishedProductOrderNormFactoryGoodsProcedures.Where(o => o.IsDefault.HasValue && o.IsDefault.Value).Count() == 0)
{
throw new Exception("You need select dedault procedure");
}
if (dtoItem.FactoryFinishedProductOrderNormFactoryGoodsProcedures.Where(o => o.IsDefault.HasValue && o.IsDefault.Value).Count() > 1)
{
throw new Exception("Only one procedure is default");
}
}
using (FactoryOrderNormEntities context = CreateContext())
{
FactoryFinishedProductOrderNorm dbItem;
FactoryFinishedProductOrderNormFactoryGoodsProcedure dbGoodsProcedure;
if (dtoItem.FactoryFinishedProductOrderNormID > 0)
{
dbItem = context.FactoryFinishedProductOrderNorm.Where(o => o.FactoryFinishedProductOrderNormID == dtoItem.FactoryFinishedProductOrderNormID).FirstOrDefault();
//goods procedure opreration
foreach (var item in dbItem.FactoryFinishedProductOrderNormFactoryGoodsProcedure.ToArray())
{
if (!dtoItem.FactoryFinishedProductOrderNormFactoryGoodsProcedures.Select(s => s.FactoryFinishedProductOrderNormFactoryGoodsProcedureID).Contains(item.FactoryFinishedProductOrderNormFactoryGoodsProcedureID))
{
dbItem.FactoryFinishedProductOrderNormFactoryGoodsProcedure.Remove(item);
}
}
foreach (var item in dtoItem.FactoryFinishedProductOrderNormFactoryGoodsProcedures)
{
if (item.FactoryFinishedProductOrderNormFactoryGoodsProcedureID > 0)
{
dbGoodsProcedure = dbItem.FactoryFinishedProductOrderNormFactoryGoodsProcedure.Where(o => o.FactoryFinishedProductOrderNormFactoryGoodsProcedureID == item.FactoryFinishedProductOrderNormFactoryGoodsProcedureID).FirstOrDefault();
}
else
{
dbGoodsProcedure = new FactoryFinishedProductOrderNormFactoryGoodsProcedure();
dbItem.FactoryFinishedProductOrderNormFactoryGoodsProcedure.Add(dbGoodsProcedure);
}
if (dbGoodsProcedure != null)
{
dbGoodsProcedure.FactoryGoodsProcedureID = item.FactoryGoodsProcedureID;
dbGoodsProcedure.IsDefault = item.IsDefault;
}
}
}
else
{
var parentComponent = context.FactoryFinishedProductOrderNorm.FirstOrDefault(o => o.FactoryFinishedProductOrderNormID == parentFactoryFinishedProductNormID);
dbItem = new FactoryFinishedProductOrderNorm();
context.FactoryFinishedProductOrderNorm.Add(dbItem);
dbItem.FactoryOrderNormID = parentComponent.FactoryOrderNormID;
dbItem.ParentNormID = parentFactoryFinishedProductNormID;
if (dtoItem.FactoryFinishedProductOrderNormFactoryGoodsProcedures != null)
{
foreach (var item in dtoItem.FactoryFinishedProductOrderNormFactoryGoodsProcedures)
{
dbGoodsProcedure = new FactoryFinishedProductOrderNormFactoryGoodsProcedure();
dbItem.FactoryFinishedProductOrderNormFactoryGoodsProcedure.Add(dbGoodsProcedure);
dbGoodsProcedure.FactoryGoodsProcedureID = item.FactoryGoodsProcedureID;
dbGoodsProcedure.IsDefault = item.IsDefault;
}
}
}
if (dbItem != null)
{
dbItem.FactoryFinishedProductID = dtoItem.FactoryFinishedProductID;
dbItem.NormValue = dtoItem.NormValue;
dbItem.MaterialGroupTypeID = dtoItem.MaterialGroupTypeID;
}
else
{
throw new Exception("Could not find data. You have to save data before update sub component norm");
}
context.FactoryFinishedProductOrderNormFactoryGoodsProcedure.Local.Where(o => o.FactoryFinishedProductOrderNorm == null).ToList().ForEach(o => context.FactoryFinishedProductOrderNormFactoryGoodsProcedure.Remove(o));
context.SaveChanges();
return(dbItem.FactoryFinishedProductOrderNormID);
}
}
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);
}
}