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 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 void DTO2DB_FactoryOrderNorm(DTO.FactoryOrderNorm dtoItem, ref FactoryOrderNorm dbItem) { //if (dtoItem.FactoryFinishedProductOrderNorms != null) //{ // //user remove factory finished product in dto => check to remove in db // foreach (var item in dbItem.FactoryFinishedProductOrderNorm.ToArray()) // { // if (!dtoItem.FactoryFinishedProductOrderNorms.Select(s => s.FactoryFinishedProductOrderNormID).Contains(item.FactoryFinishedProductOrderNormID)) // { // foreach (var mItem in item.FactoryMaterialOrderNorm.ToArray()) // { // item.FactoryMaterialOrderNorm.Remove(mItem); // } // dbItem.FactoryFinishedProductOrderNorm.Remove(item); // } // else // { // //user remove factory material in dto => check to remove in db // foreach (var mItem in item.FactoryMaterialOrderNorm.ToArray()) // { // var x = dtoItem.FactoryFinishedProductOrderNorms.Where(o => o.FactoryFinishedProductOrderNormID == item.FactoryFinishedProductOrderNormID).FirstOrDefault().FactoryMaterialOrderNorms; // if (!x.Select(s => s.FactoryMaterialOrderNormID).Contains(mItem.FactoryMaterialOrderNormID)) // { // item.FactoryMaterialOrderNorm.Remove(mItem); // } // } // } // } // //read factory finished product // FactoryFinishedProductOrderNorm dbFinishedProductNorm; // FactoryMaterialOrderNorm dbMaterialNorm; // foreach (var item in dtoItem.FactoryFinishedProductOrderNorms) // { // if (item.FactoryFinishedProductOrderNormID > 0) // { // dbFinishedProductNorm = dbItem.FactoryFinishedProductOrderNorm.Where(o => o.FactoryFinishedProductOrderNormID == item.FactoryFinishedProductOrderNormID).FirstOrDefault(); // if (dbFinishedProductNorm != null && item.FactoryMaterialOrderNorms != null) // { // foreach (var mItem in item.FactoryMaterialOrderNorms) // { // if (mItem.FactoryMaterialOrderNormID > 0) // { // dbMaterialNorm = dbFinishedProductNorm.FactoryMaterialOrderNorm.Where(o => o.FactoryMaterialOrderNormID == mItem.FactoryMaterialOrderNormID).FirstOrDefault(); // } // else // { // dbMaterialNorm = new FactoryMaterialOrderNorm(); // dbFinishedProductNorm.FactoryMaterialOrderNorm.Add(dbMaterialNorm); // } // if (dbMaterialNorm != null) // { // AutoMapper.Mapper.Map<DTO.FactoryMaterialOrderNorm, FactoryMaterialOrderNorm>(mItem, dbMaterialNorm); // } // } // } // } // else // { // dbFinishedProductNorm = new FactoryFinishedProductOrderNorm(); // dbItem.FactoryFinishedProductOrderNorm.Add(dbFinishedProductNorm); // if (item.FactoryMaterialOrderNorms != null) // { // foreach (var mItem in item.FactoryMaterialOrderNorms) // { // dbMaterialNorm = new FactoryMaterialOrderNorm(); // dbFinishedProductNorm.FactoryMaterialOrderNorm.Add(dbMaterialNorm); // AutoMapper.Mapper.Map<DTO.FactoryMaterialOrderNorm, FactoryMaterialOrderNorm>(mItem, dbMaterialNorm); // } // } // } // //mapping // if (dbFinishedProductNorm != null) // { // AutoMapper.Mapper.Map<DTO.FactoryFinishedProductOrderNorm, FactoryFinishedProductOrderNorm>(item, dbFinishedProductNorm); // } // } //} AutoMapper.Mapper.Map <DTO.FactoryOrderNorm, FactoryOrderNorm>(dtoItem, dbItem); }