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()));
}
