Example #1
0
        public bool ENT_Carrier_Update(IEnumerable <ENT_Carrier> items, string ModifiedBy)
        {
            string ENT_Carrier_List             = string.Empty;
            string ENT_Carrier_List_Serialized  = string.Empty;
            string ENT_Carrier_Items_Serialized = string.Empty;

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

            try
            {
                WMS.Models.DBContext model = new DBContext();
                foreach (ENT_Carrier item in items)
                {
                    ENT_Carrier dbItem = model.DBSet_ENT_Carrier.Where(d => d.ID == item.ID).FirstOrDefault();
                    if (dbItem != null)
                    {
                        ENT_Carrier_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.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_Code     = item.Carrier_Code;
                        dbItem.City             = item.City;
                        dbItem.Company          = item.Company;
                        dbItem.CreatedBy        = item.CreatedBy;
                        dbItem.CreatedDate      = item.CreatedDate;
                        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_ID     = item.Owner_ID;
                        dbItem.Phone1       = item.Phone1;
                        dbItem.Phone2       = item.Phone2;
                        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;


                        ENT_Carrier_Items_Serialized += Common.SerializeObject(item);
                        Common.SaveChanges(model);
                        ENT_Carrier_List_Serialized += Common.SerializeObject(item);
                    }
                }
            }
            catch (Exception ex)
            {
                flag   = false;
                result = ex.Message;
                Common.log.Error(ENT_Carrier_Items_Serialized, ex);
            }
            finally
            {
                if (!string.IsNullOrEmpty(result))
                {
                    Common.log.Warn(ModifiedBy + " => " + ENT_Carrier_Items_Serialized, new Exception(result));
                }
                Common.log.Info(string.Format("User: {0} - [end] - ENT_Carrier_Update: {1} - {2}", ModifiedBy, ENT_Carrier_List, ENT_Carrier_List_Serialized));
            }
            return(flag);
        }
Example #2
0
        public DataSourceResult ENT_Carrier_Create(ENT_Carrier item, string CreatedBy)
        {
            string ENT_Carrier_List             = string.Empty;
            string ENT_Carrier_List_Serialized  = string.Empty;
            string ENT_Carrier_Items_Serialized = string.Empty;

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

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

                ENT_Carrier dbItem = new ENT_Carrier();

                item.CreatedBy          = item.ModifiedBy = CreatedBy;
                item.CreatedDate        = item.ModifiedDate = Common.getUTCDate();
                dbItem.IsSelected       = item.IsSelected;
                dbItem.TagStr           = item.TagStr;
                dbItem.Address          = item.Address;
                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_Code     = item.Carrier_Code;
                dbItem.City             = item.City;
                dbItem.Company          = item.Company;
                dbItem.CreatedBy        = item.CreatedBy;
                dbItem.CreatedDate      = item.CreatedDate;
                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_ID               = item.Owner_ID;
                dbItem.Phone1                 = item.Phone1;
                dbItem.Phone2                 = item.Phone2;
                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;
                ENT_Carrier_Items_Serialized += Common.SerializeObject(item);
                model.DBSet_ENT_Carrier.Add(dbItem);
                Common.SaveChanges(model);

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

                result.Add(item);
                ENT_Carrier_List_Serialized += Common.SerializeObject(item);
            }
            catch (Exception ex)
            {
                message = ex.Message;
                Common.log.Error(ENT_Carrier_Items_Serialized, ex);
            }
            finally
            {
                if (!string.IsNullOrEmpty(message))
                {
                    Common.log.Warn(CreatedBy + " => " + ENT_Carrier_Items_Serialized, new Exception(message));
                }
                Common.log.Info(string.Format("User: {0} - [end] - ENT_Carrier_Create: {1} - {2}", CreatedBy, ENT_Carrier_List, ENT_Carrier_List_Serialized));
            }
            return(result.ToDataSourceResult(new DataSourceRequest()));
        }