//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);
}
}
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.ClientSearchFormData GetListClient(Hashtable filters, out Library.DTO.Notification notification)
{
DTO.ClientSearchFormData Data = new DTO.ClientSearchFormData();
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
Module.Support.DAL.DataFactory supportFactory = new Support.DAL.DataFactory();
//search info
string clientUD = string.Empty;
string articleCode = string.Empty;
string description = string.Empty;
if (filters.ContainsKey("clientUD"))
{
clientUD = filters["clientUD"].ToString();
}
if (filters.ContainsKey("articleCode"))
{
articleCode = filters["articleCode"].ToString();
}
if (filters.ContainsKey("description"))
{
description = filters["description"].ToString();
}
//pager info
int pageSize = 20;
int pageIndex = 1;
string sortedBy = string.Empty;
string sortedDirection = string.Empty;
if (filters.ContainsKey("pageSize"))
{
pageSize = Convert.ToInt32(filters["pageSize"].ToString());
}
if (filters.ContainsKey("pageIndex"))
{
pageIndex = Convert.ToInt32(filters["pageIndex"].ToString());
}
if (filters.ContainsKey("sortedBy"))
{
sortedBy = filters["sortedBy"].ToString();
}
if (filters.ContainsKey("sortedDirection"))
{
sortedDirection = filters["sortedDirection"].ToString();
}
try
{
Data.Seasons = supportFactory.GetSeason();
using (FactoryOrderNormEntities context = CreateContext())
{
//get clients
Data.TotalRows = context.FactoryOrderNormMng_function_SearchClient(sortedBy, sortedDirection, clientUD, articleCode, description).Count();
var result = context.FactoryOrderNormMng_function_SearchClient(sortedBy, sortedDirection, clientUD, articleCode, description);
Data.Data = converter.DB2DTO_Client(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList());
//get client products
List <int?> clientIDs = Data.Data.Select(o => o.ClientID).ToList();
List <DTO.ClientProduct> clientProducts = converter.DB2DTO_ClientProduct(context.FactoryOrderNormMng_ClientProduct_View.Where(o =>
clientIDs.Contains(o.ClientID) &&
o.ArticleCode.Contains(articleCode != "" ? articleCode : o.ArticleCode) &&
o.Description.Contains(description != "" ? description : o.Description)
).ToList());
//get material standard norm
List <int?> productIDs = clientProducts.Select(o => o.ProductID).ToList();
foreach (var item in Data.Data)
{
item.ClientProducts = converter.DTO2DTO_ClientProduct(clientProducts.Where(o => o.ClientID == item.ClientID).ToList());
}
}
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(Data);
}
}