コード例 #1
0
        public Result Insert(EndorsedLogoEntity entity)
        {
            ImageManager imageManager = new ImageManager();

            if (entity.ImageFile != null)
            {
                var resImgCheck = imageManager.CheckFileImageAndSave(entity.ImagePath, entity.ImageFile, 100, 100, 3000, 3000);
                if (!resImgCheck.Success)
                {
                    return(resImgCheck);
                }
                entity.Image = resImgCheck.Entity.ToString();
                //entity.Text = "Image EndorsedLogo";
            }

            var con   = new DapperConnectionManager();
            var query = new QueryEntity();

            query.Entity = entity;
            query.Query  = @"INSERT INTO EndorsedLogos (Name, Image) VALUES(@Name, @Image)";
            var result = con.InsertQuery(query);

            result.Message = result.Success ? "The EndorsedLogo has been created" : "An error occurred";
            return(result);
        }
コード例 #2
0
        public Result Update(EndorsedLogoEntity entity)
        {
            ImageManager imageManager = new ImageManager();

            if (entity.ImageFile != null)
            {
                var resImgCheck = imageManager.CheckFileImageAndSave(entity.ImagePath, entity.ImageFile, 30, 30, 3000, 3000);
                if (!resImgCheck.Success)
                {
                    return(resImgCheck);
                }
                entity.Image = resImgCheck.Entity.ToString();
                //entity.Text = "Image EndorsedLogo";
            }

            var con   = new DapperConnectionManager();
            var query = new QueryEntity();

            query.Entity = entity;
            query.Query  = @"UPDATE EndorsedLogos set name = @Name, Image = @Image where EndorsedLogoId = @EndorsedLogoId";
            var result = con.ExecuteQuery(query);

            result.Message = result.Success ? "The EndorsedLogo has been updated" : "An error occurred";
            result.Entity  = entity.EndorsedLogoId;
            return(result);
        }