public bool ENT_ReceiptValidationDetail_Update(IEnumerable <ENT_ReceiptValidationDetail> items, string ModifiedBy) { string ENT_ReceiptValidationDetail_List = string.Empty; string ENT_ReceiptValidationDetail_List_Serialized = string.Empty; string ENT_ReceiptValidationDetail_Items_Serialized = string.Empty; string result = string.Empty; bool flag = true; try { WMS.Models.DBContext model = new DBContext(); foreach (ENT_ReceiptValidationDetail item in items) { ENT_ReceiptValidationDetail dbItem = model.DBSet_ENT_ReceiptValidationDetail.Where(d => d.ID == item.ID).FirstOrDefault(); if (dbItem != null) { ENT_ReceiptValidationDetail_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.Allow_error_ID = item.Allow_error_ID; dbItem.CreatedBy = item.CreatedBy; dbItem.CreatedDate = item.CreatedDate; dbItem.ID = item.ID; dbItem.IsDeleted = item.IsDeleted; dbItem.Item_Not_on_ASN = item.Item_Not_on_ASN; dbItem.Item_not_on_PO = item.Item_not_on_PO; dbItem.Lottable_Validation_detail_ID = item.Lottable_Validation_detail_ID; dbItem.ModifiedBy = item.ModifiedBy; dbItem.ModifiedDate = item.ModifiedDate; dbItem.Overage_Hard_Error = item.Overage_Hard_Error; dbItem.Overage_Message = item.Overage_Message; dbItem.Overage_Override = item.Overage_Override; dbItem.Perform_Qty_Validation = item.Perform_Qty_Validation; dbItem.Receipt_Without_ASN = item.Receipt_Without_ASN; dbItem.Receipt_without_LPN = item.Receipt_without_LPN; dbItem.Receipt_without_PO = item.Receipt_without_PO; ENT_ReceiptValidationDetail_Items_Serialized += Common.SerializeObject(item); Common.SaveChanges(model); ENT_ReceiptValidationDetail_List_Serialized += Common.SerializeObject(item); } } } catch (Exception ex) { flag = false; result = ex.Message; Common.log.Error(ENT_ReceiptValidationDetail_Items_Serialized, ex); } finally { if (!string.IsNullOrEmpty(result)) { Common.log.Warn(ModifiedBy + " => " + ENT_ReceiptValidationDetail_Items_Serialized, new Exception(result)); } Common.log.Info(string.Format("User: {0} - [end] - ENT_ReceiptValidationDetail_Update: {1} - {2}", ModifiedBy, ENT_ReceiptValidationDetail_List, ENT_ReceiptValidationDetail_List_Serialized)); } return(flag); }
public DataSourceResult ENT_ReceiptValidationDetail_Create(ENT_ReceiptValidationDetail item, string CreatedBy) { string ENT_ReceiptValidationDetail_List = string.Empty; string ENT_ReceiptValidationDetail_List_Serialized = string.Empty; string ENT_ReceiptValidationDetail_Items_Serialized = string.Empty; string message = string.Empty; List <ENT_ReceiptValidationDetail> result = new List <ENT_ReceiptValidationDetail>(); try { WMS.Models.DBContext model = new DBContext(); ENT_ReceiptValidationDetail dbItem = new ENT_ReceiptValidationDetail(); item.CreatedBy = item.ModifiedBy = CreatedBy; item.CreatedDate = item.ModifiedDate = Common.getUTCDate(); dbItem.IsSelected = item.IsSelected; dbItem.TagStr = item.TagStr; dbItem.Allow_error_ID = item.Allow_error_ID; dbItem.CreatedBy = item.CreatedBy; dbItem.CreatedDate = item.CreatedDate; dbItem.ID = item.ID; dbItem.IsDeleted = item.IsDeleted; dbItem.Item_Not_on_ASN = item.Item_Not_on_ASN; dbItem.Item_not_on_PO = item.Item_not_on_PO; dbItem.Lottable_Validation_detail_ID = item.Lottable_Validation_detail_ID; dbItem.ModifiedBy = item.ModifiedBy; dbItem.ModifiedDate = item.ModifiedDate; dbItem.Overage_Hard_Error = item.Overage_Hard_Error; dbItem.Overage_Message = item.Overage_Message; dbItem.Overage_Override = item.Overage_Override; dbItem.Perform_Qty_Validation = item.Perform_Qty_Validation; dbItem.Receipt_Without_ASN = item.Receipt_Without_ASN; dbItem.Receipt_without_LPN = item.Receipt_without_LPN; dbItem.Receipt_without_PO = item.Receipt_without_PO; ENT_ReceiptValidationDetail_Items_Serialized += Common.SerializeObject(item); model.DBSet_ENT_ReceiptValidationDetail.Add(dbItem); Common.SaveChanges(model); item.ID = dbItem.ID; ENT_ReceiptValidationDetail_List += "[" + item.ID + "] "; result.Add(item); ENT_ReceiptValidationDetail_List_Serialized += Common.SerializeObject(item); } catch (Exception ex) { message = ex.Message; Common.log.Error(ENT_ReceiptValidationDetail_Items_Serialized, ex); } finally { if (!string.IsNullOrEmpty(message)) { Common.log.Warn(CreatedBy + " => " + ENT_ReceiptValidationDetail_Items_Serialized, new Exception(message)); } Common.log.Info(string.Format("User: {0} - [end] - ENT_ReceiptValidationDetail_Create: {1} - {2}", CreatedBy, ENT_ReceiptValidationDetail_List, ENT_ReceiptValidationDetail_List_Serialized)); } return(result.ToDataSourceResult(new DataSourceRequest())); }