Esempio n. 1
0
        public static bool put_PRO_Tags(AppEntities db, int ID, DTO_PRO_Tags item, string Username)
        {
            bool result = false;
            var  dbitem = db.tbl_PRO_Tags.Find(ID);

            if (dbitem != null)
            {
                dbitem.IDDeTai    = item.IDDeTai;
                dbitem.IDTag      = item.IDTag;
                dbitem.IsDisabled = item.IsDisabled;
                dbitem.IsDeleted  = item.IsDeleted;

                dbitem.ModifiedBy   = Username;
                dbitem.ModifiedDate = DateTime.Now;

                try
                {
                    db.SaveChanges();

                    BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_Tags", DateTime.Now, Username);

                    result = true;
                }
                catch (DbEntityValidationException e)
                {
                    errorLog.logMessage("put_PRO_Tags", e);
                    result = false;
                }
            }
            return(result);
        }
Esempio n. 2
0
        public static DTO_PRO_Tags post_PRO_Tags(AppEntities db, DTO_PRO_Tags item, string Username)
        {
            tbl_PRO_Tags dbitem = new tbl_PRO_Tags();

            if (item != null)
            {
                dbitem.IDDeTai    = item.IDDeTai;
                dbitem.IDTag      = item.IDTag;
                dbitem.IsDisabled = item.IsDisabled;
                dbitem.IsDeleted  = item.IsDeleted;

                dbitem.CreatedBy   = Username;
                dbitem.CreatedDate = DateTime.Now;

                dbitem.ModifiedBy   = Username;
                dbitem.ModifiedDate = DateTime.Now;


                try
                {
                    db.tbl_PRO_Tags.Add(dbitem);
                    db.SaveChanges();

                    BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_Tags", DateTime.Now, Username);


                    item.ID = dbitem.ID;

                    item.CreatedBy   = dbitem.CreatedBy;
                    item.CreatedDate = dbitem.CreatedDate;

                    item.ModifiedBy   = dbitem.ModifiedBy;
                    item.ModifiedDate = dbitem.ModifiedDate;
                }
                catch (DbEntityValidationException e)
                {
                    errorLog.logMessage("post_PRO_Tags", e);
                    item = null;
                }
            }
            return(item);
        }