Example #1
0
        /// <summary>
        /// Update Town in Area
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public long UpdateTownInArea(GroupTown model, int forUser)
        {
            long result = 0;

            //Check create new customer
            StringBuilder sql = new StringBuilder();

            model.DEL_FLG = DeleteFlag.NON_DELETE;

            sql.Append(@" 
                    UPDATE [dbo].[MstTown] ");

            if (forUser == GroupForUser.Receive)
            {
                sql.Append("SET GROUP_CD_RECEIVE = @GROUP_CD, DSP_ORDER_RECEIVE = @DSP_ORDER ");
            }
            else
            {
                sql.Append("SET GROUP_CD_SENDER = @GROUP_CD, DSP_ORDER_SENDER = @DSP_ORDER ");
            }
            sql.Append("WHERE [CITY_CD] = @CITY_CD AND DISTRICT_CD = @DISTRICT_CD AND TOWN_CD = @TOWN_CD");

            result = base.DbUpdate(sql.ToString(), model, new { CITY_CD = model.CITY_CD, DISTRICT_CD = model.DISTRICT_CD, TOWN_CD = model.TOWN_CD });
            return(result);
        }
        public long UpdateTownInArea(GroupTown model, int forUser)
        {
            long res = 0;
            // Declare new DataAccess object
            ManageDistrictDa dataAccess = new ManageDistrictDa();

            using (var transaction = new TransactionScope())
            {
                res = dataAccess.UpdateTownInArea(model, forUser);
                if (res <= 0)
                {
                    transaction.Dispose();
                }
                transaction.Complete();
            }
            return(res);
        }