public bool ENT_Pack_Update(IEnumerable <ENT_Pack> items, string ModifiedBy) { string ENT_Pack_List = string.Empty; string ENT_Pack_List_Serialized = string.Empty; string ENT_Pack_Items_Serialized = string.Empty; string result = string.Empty; bool flag = true; try { WMS.Models.DBContext model = new DBContext(); foreach (ENT_Pack item in items) { ENT_Pack dbItem = model.DBSet_ENT_Pack.Where(d => d.ID == item.ID).FirstOrDefault(); if (dbItem != null) { ENT_Pack_List += "[" + item.ID + "] "; item.ModifiedBy = ModifiedBy; item.ModifiedDate = Common.getUTCDate(); if (item.CreatedDate == DateTime.MinValue) { item.CreatedDate = dbItem.CreatedDate; } dbItem.IsSelected = item.IsSelected; dbItem.TagStr = item.TagStr; dbItem.Carton_ID = item.Carton_ID; dbItem.Cartonize_Case = item.Cartonize_Case; dbItem.Cartonize_innerPack = item.Cartonize_innerPack; dbItem.Cartonize_Layer = item.Cartonize_Layer; dbItem.Cartonize_MasterUnit = item.Cartonize_MasterUnit; dbItem.Cartonize_Pallet = item.Cartonize_Pallet; dbItem.Case_Height = item.Case_Height; dbItem.Case_Length = item.Case_Length; dbItem.Case_Width = item.Case_Width; dbItem.CreatedBy = item.CreatedBy; dbItem.CreatedDate = item.CreatedDate; dbItem.Description = item.Description; dbItem.ID = item.ID; dbItem.Innerpack_Height = item.Innerpack_Height; dbItem.Innerpack_Length = item.Innerpack_Length; dbItem.Innerpack_Width = item.Innerpack_Width; dbItem.IsDeleted = item.IsDeleted; dbItem.Layer_Height = item.Layer_Height; dbItem.Layer_Lenght = item.Layer_Lenght; dbItem.Layer_Width = item.Layer_Width; dbItem.Master_Unit_Height = item.Master_Unit_Height; dbItem.Master_Unit_Length = item.Master_Unit_Length; dbItem.Master_Unit_Width = item.Master_Unit_Width; dbItem.ModifiedBy = item.ModifiedBy; dbItem.ModifiedDate = item.ModifiedDate; dbItem.Number_of_cases_per_tier = item.Number_of_cases_per_tier; dbItem.Number_of_tiers_high_per_pallet = item.Number_of_tiers_high_per_pallet; dbItem.Pack_Code = item.Pack_Code; dbItem.Pallet_Height = item.Pallet_Height; dbItem.Pallet_Length = item.Pallet_Length; dbItem.Pallet_Width = item.Pallet_Width; dbItem.Pallet_Wood_Height = item.Pallet_Wood_Height; dbItem.Pallet_Wood_Length = item.Pallet_Wood_Length; dbItem.Pallet_Wood_Width = item.Pallet_Wood_Width; dbItem.Unit_Per_Mesure_1 = item.Unit_Per_Mesure_1; dbItem.Unit_Per_Mesure_2 = item.Unit_Per_Mesure_2; dbItem.Unit_Per_Mesure_3 = item.Unit_Per_Mesure_3; dbItem.Unit_Per_Mesure_4 = item.Unit_Per_Mesure_4; dbItem.UOM_CubeDetail_ID = item.UOM_CubeDetail_ID; dbItem.UOM_PackageDetail_ID = item.UOM_PackageDetail_ID; dbItem.UOM_QuantityDetail_ID = item.UOM_QuantityDetail_ID; dbItem.UOM_WeightDetail_ID = item.UOM_WeightDetail_ID; ENT_Pack_Items_Serialized += Common.SerializeObject(item); Common.SaveChanges(model); ENT_Pack_List_Serialized += Common.SerializeObject(item); } } } catch (Exception ex) { flag = false; result = ex.Message; Common.log.Error(ENT_Pack_Items_Serialized, ex); } finally { if (!string.IsNullOrEmpty(result)) { Common.log.Warn(ModifiedBy + " => " + ENT_Pack_Items_Serialized, new Exception(result)); } Common.log.Info(string.Format("User: {0} - [end] - ENT_Pack_Update: {1} - {2}", ModifiedBy, ENT_Pack_List, ENT_Pack_List_Serialized)); } return(flag); }
public DataSourceResult ENT_Pack_Create(ENT_Pack item, string CreatedBy) { string ENT_Pack_List = string.Empty; string ENT_Pack_List_Serialized = string.Empty; string ENT_Pack_Items_Serialized = string.Empty; string message = string.Empty; List <ENT_Pack> result = new List <ENT_Pack>(); try { WMS.Models.DBContext model = new DBContext(); ENT_Pack dbItem = new ENT_Pack(); item.CreatedBy = item.ModifiedBy = CreatedBy; item.CreatedDate = item.ModifiedDate = Common.getUTCDate(); dbItem.IsSelected = item.IsSelected; dbItem.TagStr = item.TagStr; dbItem.Carton_ID = item.Carton_ID; dbItem.Cartonize_Case = item.Cartonize_Case; dbItem.Cartonize_innerPack = item.Cartonize_innerPack; dbItem.Cartonize_Layer = item.Cartonize_Layer; dbItem.Cartonize_MasterUnit = item.Cartonize_MasterUnit; dbItem.Cartonize_Pallet = item.Cartonize_Pallet; dbItem.Case_Height = item.Case_Height; dbItem.Case_Length = item.Case_Length; dbItem.Case_Width = item.Case_Width; dbItem.CreatedBy = item.CreatedBy; dbItem.CreatedDate = item.CreatedDate; dbItem.Description = item.Description; dbItem.ID = item.ID; dbItem.Innerpack_Height = item.Innerpack_Height; dbItem.Innerpack_Length = item.Innerpack_Length; dbItem.Innerpack_Width = item.Innerpack_Width; dbItem.IsDeleted = item.IsDeleted; dbItem.Layer_Height = item.Layer_Height; dbItem.Layer_Lenght = item.Layer_Lenght; dbItem.Layer_Width = item.Layer_Width; dbItem.Master_Unit_Height = item.Master_Unit_Height; dbItem.Master_Unit_Length = item.Master_Unit_Length; dbItem.Master_Unit_Width = item.Master_Unit_Width; dbItem.ModifiedBy = item.ModifiedBy; dbItem.ModifiedDate = item.ModifiedDate; dbItem.Number_of_cases_per_tier = item.Number_of_cases_per_tier; dbItem.Number_of_tiers_high_per_pallet = item.Number_of_tiers_high_per_pallet; dbItem.Pack_Code = item.Pack_Code; dbItem.Pallet_Height = item.Pallet_Height; dbItem.Pallet_Length = item.Pallet_Length; dbItem.Pallet_Width = item.Pallet_Width; dbItem.Pallet_Wood_Height = item.Pallet_Wood_Height; dbItem.Pallet_Wood_Length = item.Pallet_Wood_Length; dbItem.Pallet_Wood_Width = item.Pallet_Wood_Width; dbItem.Unit_Per_Mesure_1 = item.Unit_Per_Mesure_1; dbItem.Unit_Per_Mesure_2 = item.Unit_Per_Mesure_2; dbItem.Unit_Per_Mesure_3 = item.Unit_Per_Mesure_3; dbItem.Unit_Per_Mesure_4 = item.Unit_Per_Mesure_4; dbItem.UOM_CubeDetail_ID = item.UOM_CubeDetail_ID; dbItem.UOM_PackageDetail_ID = item.UOM_PackageDetail_ID; dbItem.UOM_QuantityDetail_ID = item.UOM_QuantityDetail_ID; dbItem.UOM_WeightDetail_ID = item.UOM_WeightDetail_ID; ENT_Pack_Items_Serialized += Common.SerializeObject(item); model.DBSet_ENT_Pack.Add(dbItem); Common.SaveChanges(model); item.ID = dbItem.ID; ENT_Pack_List += "[" + item.ID + "] "; result.Add(item); ENT_Pack_List_Serialized += Common.SerializeObject(item); } catch (Exception ex) { message = ex.Message; Common.log.Error(ENT_Pack_Items_Serialized, ex); } finally { if (!string.IsNullOrEmpty(message)) { Common.log.Warn(CreatedBy + " => " + ENT_Pack_Items_Serialized, new Exception(message)); } Common.log.Info(string.Format("User: {0} - [end] - ENT_Pack_Create: {1} - {2}", CreatedBy, ENT_Pack_List, ENT_Pack_List_Serialized)); } return(result.ToDataSourceResult(new DataSourceRequest())); }