Beispiel #1
0
        public ResultStatus Add(GEMA_TM_PRICEL_LIST priceList)
        {
            try
            {
                _ctx.GEMA_TM_PRICEL_LIST.Add(priceList);
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Beispiel #2
0
        public ResultStatus Delete(int id, string modifiedBy, DateTime modifiedTime)
        {
            try
            {
                GEMA_TM_PRICEL_LIST priceList = _ctx.GEMA_TM_PRICEL_LIST.Find(id);
                priceList.LAST_MODIFIED_TIME = modifiedTime;
                priceList.LAST_MODIFIED_BY   = modifiedBy;
                priceList.ROW_STATUS         = eStat.fg.NotActive;

                _ctx.Entry(priceList).State = EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Beispiel #3
0
        public ResultStatus Edit(GEMA_TM_PRICEL_LIST priceList)
        {
            try
            {
                GEMA_TM_PRICEL_LIST priceListNew = _ctx.GEMA_TM_PRICEL_LIST.Find(priceList.ID);
                priceListNew.TYPE               = priceList.TYPE;
                priceListNew.DESCRIPTION        = priceList.DESCRIPTION;
                priceListNew.PRICE              = priceList.PRICE;
                priceListNew.IMAGE_BIT          = priceList.IMAGE_BIT;
                priceListNew.IMAGE_PATH         = priceList.IMAGE_PATH;
                priceListNew.LAST_MODIFIED_TIME = priceList.LAST_MODIFIED_TIME;
                priceListNew.LAST_MODIFIED_BY   = priceList.LAST_MODIFIED_BY;
                _ctx.Entry(priceListNew).State  = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }