public bool ENT_Owner_Update(IEnumerable <ENT_Owner> items, string ModifiedBy) { string ENT_Owner_List = string.Empty; string ENT_Owner_List_Serialized = string.Empty; string ENT_Owner_Items_Serialized = string.Empty; string result = string.Empty; bool flag = true; try { WMS.Models.DBContext model = new DBContext(); foreach (ENT_Owner item in items) { ENT_Owner dbItem = model.DBSet_ENT_Owner.Where(d => d.ID == item.ID).FirstOrDefault(); if (dbItem != null) { ENT_Owner_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.Address = item.Address; dbItem.Allocation_Strategy_ID = item.Allocation_Strategy_ID; dbItem.Billing_Address = item.Billing_Address; dbItem.Billing_City = item.Billing_City; dbItem.Billing_District = item.Billing_District; dbItem.Billing_Email1 = item.Billing_Email1; dbItem.Billing_Email2 = item.Billing_Email2; dbItem.Billing_Fax1 = item.Billing_Fax1; dbItem.Billing_Fax2 = item.Billing_Fax2; dbItem.Billing_Phone1 = item.Billing_Phone1; dbItem.Billing_Phone2 = item.Billing_Phone2; dbItem.Carrier_ID = item.Carrier_ID; dbItem.Cartonization_ID = item.Cartonization_ID; dbItem.City = item.City; dbItem.Company = item.Company; dbItem.CreatedBy = item.CreatedBy; dbItem.CreatedDate = item.CreatedDate; dbItem.Customer_ID = item.Customer_ID; dbItem.Cycle_Class_ID = item.Cycle_Class_ID; dbItem.District = item.District; dbItem.Email1 = item.Email1; dbItem.Email2 = item.Email2; dbItem.Fax1 = item.Fax1; dbItem.Fax2 = item.Fax2; dbItem.ID = item.ID; dbItem.IsDeleted = item.IsDeleted; dbItem.ModifiedBy = item.ModifiedBy; dbItem.ModifiedDate = item.ModifiedDate; dbItem.Notes = item.Notes; dbItem.Owner_Code = item.Owner_Code; dbItem.Phone1 = item.Phone1; dbItem.Phone2 = item.Phone2; dbItem.Putaway_Strategy_ID = item.Putaway_Strategy_ID; dbItem.Receipt_Validation_Detail_ID = item.Receipt_Validation_Detail_ID; dbItem.Rotation_Detail_By = item.Rotation_Detail_By; dbItem.Rotation_Detail_ID = item.Rotation_Detail_ID; dbItem.Supplier_ID = item.Supplier_ID; dbItem.UDF_1 = item.UDF_1; dbItem.UDF_2 = item.UDF_2; dbItem.UDF_3 = item.UDF_3; dbItem.UDF_4 = item.UDF_4; dbItem.UDF_5 = item.UDF_5; dbItem.V_Cycle_Count_ID = item.V_Cycle_Count_ID; ENT_Owner_Items_Serialized += Common.SerializeObject(item); Common.SaveChanges(model); ENT_Owner_List_Serialized += Common.SerializeObject(item); } } } catch (Exception ex) { flag = false; result = ex.Message; Common.log.Error(ENT_Owner_Items_Serialized, ex); } finally { if (!string.IsNullOrEmpty(result)) { Common.log.Warn(ModifiedBy + " => " + ENT_Owner_Items_Serialized, new Exception(result)); } Common.log.Info(string.Format("User: {0} - [end] - ENT_Owner_Update: {1} - {2}", ModifiedBy, ENT_Owner_List, ENT_Owner_List_Serialized)); } return(flag); }
public DataSourceResult ENT_Owner_Create(ENT_Owner item, string CreatedBy) { string ENT_Owner_List = string.Empty; string ENT_Owner_List_Serialized = string.Empty; string ENT_Owner_Items_Serialized = string.Empty; string message = string.Empty; List <ENT_Owner> result = new List <ENT_Owner>(); try { WMS.Models.DBContext model = new DBContext(); ENT_Owner dbItem = new ENT_Owner(); item.CreatedBy = item.ModifiedBy = CreatedBy; item.CreatedDate = item.ModifiedDate = Common.getUTCDate(); dbItem.IsSelected = item.IsSelected; dbItem.TagStr = item.TagStr; dbItem.Address = item.Address; dbItem.Allocation_Strategy_ID = item.Allocation_Strategy_ID; dbItem.Billing_Address = item.Billing_Address; dbItem.Billing_City = item.Billing_City; dbItem.Billing_District = item.Billing_District; dbItem.Billing_Email1 = item.Billing_Email1; dbItem.Billing_Email2 = item.Billing_Email2; dbItem.Billing_Fax1 = item.Billing_Fax1; dbItem.Billing_Fax2 = item.Billing_Fax2; dbItem.Billing_Phone1 = item.Billing_Phone1; dbItem.Billing_Phone2 = item.Billing_Phone2; dbItem.Carrier_ID = item.Carrier_ID; dbItem.Cartonization_ID = item.Cartonization_ID; dbItem.City = item.City; dbItem.Company = item.Company; dbItem.CreatedBy = item.CreatedBy; dbItem.CreatedDate = item.CreatedDate; dbItem.Customer_ID = item.Customer_ID; dbItem.Cycle_Class_ID = item.Cycle_Class_ID; dbItem.District = item.District; dbItem.Email1 = item.Email1; dbItem.Email2 = item.Email2; dbItem.Fax1 = item.Fax1; dbItem.Fax2 = item.Fax2; dbItem.ID = item.ID; dbItem.IsDeleted = item.IsDeleted; dbItem.ModifiedBy = item.ModifiedBy; dbItem.ModifiedDate = item.ModifiedDate; dbItem.Notes = item.Notes; dbItem.Owner_Code = item.Owner_Code; dbItem.Phone1 = item.Phone1; dbItem.Phone2 = item.Phone2; dbItem.Putaway_Strategy_ID = item.Putaway_Strategy_ID; dbItem.Receipt_Validation_Detail_ID = item.Receipt_Validation_Detail_ID; dbItem.Rotation_Detail_By = item.Rotation_Detail_By; dbItem.Rotation_Detail_ID = item.Rotation_Detail_ID; dbItem.Supplier_ID = item.Supplier_ID; dbItem.UDF_1 = item.UDF_1; dbItem.UDF_2 = item.UDF_2; dbItem.UDF_3 = item.UDF_3; dbItem.UDF_4 = item.UDF_4; dbItem.UDF_5 = item.UDF_5; dbItem.V_Cycle_Count_ID = item.V_Cycle_Count_ID; ENT_Owner_Items_Serialized += Common.SerializeObject(item); model.DBSet_ENT_Owner.Add(dbItem); Common.SaveChanges(model); item.ID = dbItem.ID; ENT_Owner_List += "[" + item.ID + "] "; result.Add(item); ENT_Owner_List_Serialized += Common.SerializeObject(item); } catch (Exception ex) { message = ex.Message; Common.log.Error(ENT_Owner_Items_Serialized, ex); } finally { if (!string.IsNullOrEmpty(message)) { Common.log.Warn(CreatedBy + " => " + ENT_Owner_Items_Serialized, new Exception(message)); } Common.log.Info(string.Format("User: {0} - [end] - ENT_Owner_Create: {1} - {2}", CreatedBy, ENT_Owner_List, ENT_Owner_List_Serialized)); } return(result.ToDataSourceResult(new DataSourceRequest())); }