Example #1
0
File: WHS_PO.cs Project: lhthai/WMS
        public DataSourceResult WHS_PO_Create(WHS_PO item, string CreatedBy)
        {
            string WHS_PO_List             = string.Empty;
            string WHS_PO_List_Serialized  = string.Empty;
            string WHS_PO_Items_Serialized = string.Empty;

            string        message = string.Empty;
            List <WHS_PO> result  = new List <WHS_PO>();

            try
            {
                WMS.Models.DBContext model = new DBContext();

                WHS_PO dbItem = new WHS_PO();

                item.CreatedBy               = item.ModifiedBy = CreatedBy;
                item.CreatedDate             = item.ModifiedDate = Common.getUTCDate();
                dbItem.IsSelected            = item.IsSelected;
                dbItem.TagStr                = item.TagStr;
                dbItem.C_System_POStatus_ID  = item.C_System_POStatus_ID;
                dbItem.CreatedBy             = item.CreatedBy;
                dbItem.CreatedDate           = item.CreatedDate;
                dbItem.Expected_receipt_date = item.Expected_receipt_date;
                dbItem.ID                = item.ID;
                dbItem.IsDeleted         = item.IsDeleted;
                dbItem.ModifiedBy        = item.ModifiedBy;
                dbItem.ModifiedDate      = item.ModifiedDate;
                dbItem.Notes             = item.Notes;
                dbItem.Owner_ID          = item.Owner_ID;
                dbItem.PO_Code           = item.PO_Code;
                dbItem.PO_date           = item.PO_date;
                dbItem.ReceiptStatus_ID  = item.ReceiptStatus_ID;
                dbItem.Supplier_ID       = item.Supplier_ID;
                dbItem.Total_Order_Qty   = item.Total_Order_Qty;
                dbItem.UOM_ID            = item.UOM_ID;
                WHS_PO_Items_Serialized += Common.SerializeObject(item);
                model.DBSet_WHS_PO.Add(dbItem);
                Common.SaveChanges(model);

                item.ID      = dbItem.ID;
                WHS_PO_List += "[" + item.ID + "] ";

                result.Add(item);
                WHS_PO_List_Serialized += Common.SerializeObject(item);
            }
            catch (Exception ex)
            {
                message = ex.Message;
                Common.log.Error(WHS_PO_Items_Serialized, ex);
            }
            finally
            {
                if (!string.IsNullOrEmpty(message))
                {
                    Common.log.Warn(CreatedBy + " => " + WHS_PO_Items_Serialized, new Exception(message));
                }
                Common.log.Info(string.Format("User: {0} - [end] - WHS_PO_Create: {1} - {2}", CreatedBy, WHS_PO_List, WHS_PO_List_Serialized));
            }
            return(result.ToDataSourceResult(new DataSourceRequest()));
        }
Example #2
0
File: WHS_PO.cs Project: lhthai/WMS
        public bool WHS_PO_Update(IEnumerable <WHS_PO> items, string ModifiedBy)
        {
            string WHS_PO_List             = string.Empty;
            string WHS_PO_List_Serialized  = string.Empty;
            string WHS_PO_Items_Serialized = string.Empty;

            string result = string.Empty;
            bool   flag   = true;

            try
            {
                WMS.Models.DBContext model = new DBContext();
                foreach (WHS_PO item in items)
                {
                    WHS_PO dbItem = model.DBSet_WHS_PO.Where(d => d.ID == item.ID).FirstOrDefault();
                    if (dbItem != null)
                    {
                        WHS_PO_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.C_System_POStatus_ID  = item.C_System_POStatus_ID;
                        dbItem.CreatedBy             = item.CreatedBy;
                        dbItem.CreatedDate           = item.CreatedDate;
                        dbItem.Expected_receipt_date = item.Expected_receipt_date;
                        dbItem.ID               = item.ID;
                        dbItem.IsDeleted        = item.IsDeleted;
                        dbItem.ModifiedBy       = item.ModifiedBy;
                        dbItem.ModifiedDate     = item.ModifiedDate;
                        dbItem.Notes            = item.Notes;
                        dbItem.Owner_ID         = item.Owner_ID;
                        dbItem.PO_Code          = item.PO_Code;
                        dbItem.PO_date          = item.PO_date;
                        dbItem.ReceiptStatus_ID = item.ReceiptStatus_ID;
                        dbItem.Supplier_ID      = item.Supplier_ID;
                        dbItem.Total_Order_Qty  = item.Total_Order_Qty;
                        dbItem.UOM_ID           = item.UOM_ID;


                        WHS_PO_Items_Serialized += Common.SerializeObject(item);
                        Common.SaveChanges(model);
                        WHS_PO_List_Serialized += Common.SerializeObject(item);
                    }
                }
            }
            catch (Exception ex)
            {
                flag   = false;
                result = ex.Message;
                Common.log.Error(WHS_PO_Items_Serialized, ex);
            }
            finally
            {
                if (!string.IsNullOrEmpty(result))
                {
                    Common.log.Warn(ModifiedBy + " => " + WHS_PO_Items_Serialized, new Exception(result));
                }
                Common.log.Info(string.Format("User: {0} - [end] - WHS_PO_Update: {1} - {2}", ModifiedBy, WHS_PO_List, WHS_PO_List_Serialized));
            }
            return(flag);
        }