public bool WHS_Strategy_Putaway_Step_Update(IEnumerable <WHS_Strategy_Putaway_Step> items, string ModifiedBy) { string WHS_Strategy_Putaway_Step_List = string.Empty; string WHS_Strategy_Putaway_Step_List_Serialized = string.Empty; string WHS_Strategy_Putaway_Step_Items_Serialized = string.Empty; string result = string.Empty; bool flag = true; try { WMS.Models.DBContext model = new DBContext(); foreach (WHS_Strategy_Putaway_Step item in items) { WHS_Strategy_Putaway_Step dbItem = model.DBSet_WHS_Strategy_Putaway_Step.Where(d => d.ID == item.ID).FirstOrDefault(); if (dbItem != null) { WHS_Strategy_Putaway_Step_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.area_restriction_1 = item.area_restriction_1; dbItem.area_restriction_2 = item.area_restriction_2; dbItem.area_restriction_3 = item.area_restriction_3; dbItem.check_restriction = item.check_restriction; dbItem.CreatedBy = item.CreatedBy; dbItem.CreatedDate = item.CreatedDate; dbItem.Demention_Restriction_1 = item.Demention_Restriction_1; dbItem.Demention_Restriction_2 = item.Demention_Restriction_2; dbItem.Demention_Restriction_3 = item.Demention_Restriction_3; dbItem.Demention_Restriction_4 = item.Demention_Restriction_4; dbItem.Demention_Restriction_5 = item.Demention_Restriction_5; dbItem.from_location = item.from_location; dbItem.ID = item.ID; dbItem.IsDeleted = item.IsDeleted; dbItem.ModifiedBy = item.ModifiedBy; dbItem.ModifiedDate = item.ModifiedDate; dbItem.Multi_Pallet = item.Multi_Pallet; dbItem.putaway_strategy_ID = item.putaway_strategy_ID; dbItem.Puttaway_Type_ID = item.Puttaway_Type_ID; dbItem.step = item.step; dbItem.to_location = item.to_location; dbItem.zone_ID = item.zone_ID; WHS_Strategy_Putaway_Step_Items_Serialized += Common.SerializeObject(item); Common.SaveChanges(model); WHS_Strategy_Putaway_Step_List_Serialized += Common.SerializeObject(item); } } } catch (Exception ex) { flag = false; result = ex.Message; Common.log.Error(WHS_Strategy_Putaway_Step_Items_Serialized, ex); } finally { if (!string.IsNullOrEmpty(result)) { Common.log.Warn(ModifiedBy + " => " + WHS_Strategy_Putaway_Step_Items_Serialized, new Exception(result)); } Common.log.Info(string.Format("User: {0} - [end] - WHS_Strategy_Putaway_Step_Update: {1} - {2}", ModifiedBy, WHS_Strategy_Putaway_Step_List, WHS_Strategy_Putaway_Step_List_Serialized)); } return(flag); }
public DataSourceResult WHS_Strategy_Putaway_Step_Create(WHS_Strategy_Putaway_Step item, string CreatedBy) { string WHS_Strategy_Putaway_Step_List = string.Empty; string WHS_Strategy_Putaway_Step_List_Serialized = string.Empty; string WHS_Strategy_Putaway_Step_Items_Serialized = string.Empty; string message = string.Empty; List <WHS_Strategy_Putaway_Step> result = new List <WHS_Strategy_Putaway_Step>(); try { WMS.Models.DBContext model = new DBContext(); WHS_Strategy_Putaway_Step dbItem = new WHS_Strategy_Putaway_Step(); item.CreatedBy = item.ModifiedBy = CreatedBy; item.CreatedDate = item.ModifiedDate = Common.getUTCDate(); dbItem.IsSelected = item.IsSelected; dbItem.TagStr = item.TagStr; dbItem.area_restriction_1 = item.area_restriction_1; dbItem.area_restriction_2 = item.area_restriction_2; dbItem.area_restriction_3 = item.area_restriction_3; dbItem.check_restriction = item.check_restriction; dbItem.CreatedBy = item.CreatedBy; dbItem.CreatedDate = item.CreatedDate; dbItem.Demention_Restriction_1 = item.Demention_Restriction_1; dbItem.Demention_Restriction_2 = item.Demention_Restriction_2; dbItem.Demention_Restriction_3 = item.Demention_Restriction_3; dbItem.Demention_Restriction_4 = item.Demention_Restriction_4; dbItem.Demention_Restriction_5 = item.Demention_Restriction_5; dbItem.from_location = item.from_location; dbItem.ID = item.ID; dbItem.IsDeleted = item.IsDeleted; dbItem.ModifiedBy = item.ModifiedBy; dbItem.ModifiedDate = item.ModifiedDate; dbItem.Multi_Pallet = item.Multi_Pallet; dbItem.putaway_strategy_ID = item.putaway_strategy_ID; dbItem.Puttaway_Type_ID = item.Puttaway_Type_ID; dbItem.step = item.step; dbItem.to_location = item.to_location; dbItem.zone_ID = item.zone_ID; WHS_Strategy_Putaway_Step_Items_Serialized += Common.SerializeObject(item); model.DBSet_WHS_Strategy_Putaway_Step.Add(dbItem); Common.SaveChanges(model); item.ID = dbItem.ID; WHS_Strategy_Putaway_Step_List += "[" + item.ID + "] "; result.Add(item); WHS_Strategy_Putaway_Step_List_Serialized += Common.SerializeObject(item); } catch (Exception ex) { message = ex.Message; Common.log.Error(WHS_Strategy_Putaway_Step_Items_Serialized, ex); } finally { if (!string.IsNullOrEmpty(message)) { Common.log.Warn(CreatedBy + " => " + WHS_Strategy_Putaway_Step_Items_Serialized, new Exception(message)); } Common.log.Info(string.Format("User: {0} - [end] - WHS_Strategy_Putaway_Step_Create: {1} - {2}", CreatedBy, WHS_Strategy_Putaway_Step_List, WHS_Strategy_Putaway_Step_List_Serialized)); } return(result.ToDataSourceResult(new DataSourceRequest())); }