public List <MainBannerDto> GetAllMainBanner(int BannerId, int IsActive) { List <MainBannerDto> lstMainBannerDto = new List <MainBannerDto>(); SqlCommand cmd = new SqlCommand("GetAndEditMainBanner", connectionRepository.con); cmd.Parameters.AddWithValue("@BannerId", BannerId); cmd.Parameters.AddWithValue("@IsActive", IsActive); cmd.CommandType = CommandType.StoredProcedure; connectionRepository.con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { MainBannerDto mainBannerDto = new MainBannerDto(); mainBannerDto.BannerId = Convert.ToInt32(dr["BannerId"]); mainBannerDto.BannerName = Convert.ToString(dr["BannerName"]); mainBannerDto.ItemId = Convert.ToInt32(dr["ItemId"]); mainBannerDto.ItemName = Convert.ToString(dr["ItemName"]); mainBannerDto.BannerDesc = Convert.ToString(dr["BannerDesc"]); mainBannerDto.BannerImage = Convert.ToString(dr["BannerImage"]); mainBannerDto.CreatedBy = Convert.ToInt32(dr["CreatedBy"]); mainBannerDto.CreatedDate = Convert.ToString(dr["CreatedDate"]); mainBannerDto.ModifiedBy = Convert.ToInt32(dr["ModifiedBy"] != DBNull.Value ? dr["ModifiedBy"] : 0); mainBannerDto.ModifiedDate = Convert.ToString(dr["ModifiedDate"] != DBNull.Value ? dr["ModifiedDate"] : ""); mainBannerDto.IsActive = Convert.ToInt32(dr["IsActive"]); lstMainBannerDto.Add(mainBannerDto); } connectionRepository.con.Close(); return(lstMainBannerDto); }
public int SaveAndUpdateMainBanner(MainBannerDto mainBannerDto) { try { SqlCommand cmd = new SqlCommand("SaveAndUpdateMainBanner", connectionRepository.con); cmd.Parameters.AddWithValue("@BannerId", mainBannerDto.BannerId); cmd.Parameters.AddWithValue("@ItemId", mainBannerDto.ItemId); cmd.Parameters.AddWithValue("@BannerName", mainBannerDto.BannerName); cmd.Parameters.AddWithValue("@BannerDesc", mainBannerDto.BannerDesc); cmd.Parameters.AddWithValue("@BannerImage", mainBannerDto.BannerImage); cmd.Parameters.AddWithValue("@CreatedBy", mainBannerDto.CreatedBy); cmd.Parameters.AddWithValue("@ModifiedBy", mainBannerDto.ModifiedBy); cmd.Parameters.AddWithValue("@IsActive", mainBannerDto.IsActive); cmd.CommandType = CommandType.StoredProcedure; connectionRepository.con.Open(); int i = cmd.ExecuteNonQuery(); connectionRepository.con.Close(); return(i); } catch (Exception ex) { throw ex; } }
public ActionResult SaveMainBanner() { try { MainBannerDal mainBannerDal = new MainBannerDal(); MainBannerDto mainBannerDto = new MainBannerDto(); mainBannerDto.BannerId = Convert.ToInt32(System.Web.HttpContext.Current.Request["BannerId"] == "" ? "0" : System.Web.HttpContext.Current.Request["BannerId"]); string Message, fileName, actualFileName; Message = fileName = actualFileName = string.Empty; if (Request.Files.Count > 0) { var fileContent = Request.Files[0]; if (fileContent != null && fileContent.ContentLength > 0) { actualFileName = fileContent.FileName; fileName = Guid.NewGuid() + Path.GetExtension(fileContent.FileName); using (Bitmap bmp = new Bitmap(fileContent.InputStream, false)) { using (Graphics grp = Graphics.FromImage(bmp)) { string filePath = Server.MapPath(Url.Content("~/fonts/watermark.png")); Image logoImage = Image.FromFile(filePath); Image TargetImg = Image.FromStream(fileContent.InputStream); RectangleF rectf = grp.VisibleClipBounds; var destX = (TargetImg.Width - logoImage.Width) - 30; var destY = (TargetImg.Height - logoImage.Height) - 30; float cxImage = grp.DpiX * logoImage.Width / logoImage.HorizontalResolution; float cyImage = grp.DpiY * logoImage.Height / logoImage.VerticalResolution; grp.DrawImage(logoImage, (rectf.Width - cxImage) / 2, (rectf.Height - cyImage) / 2); // grp.DrawImage(logoImage, new Point(TargetImg.Width - logoImage.Width - 10, 10)); bmp.Save(Path.Combine(Server.MapPath("~/UploadImages/"), fileName)); } } mainBannerDto.BannerImage = fileName; } } else { fileName = ""; if (mainBannerDto.BannerId > 0) { dynamic imgFile = mainBannerDal.GetAllMainBanner(mainBannerDto.BannerId, 1); mainBannerDto.BannerImage = Convert.ToString(imgFile[0].BannerImage); } else { mainBannerDto.BannerImage = fileName; } } mainBannerDto.ItemId = Convert.ToInt32(System.Web.HttpContext.Current.Request["ItemId"]); mainBannerDto.BannerName = System.Web.HttpContext.Current.Request["BannerName"]; mainBannerDto.BannerDesc = System.Web.HttpContext.Current.Request["BannerDesc"]; mainBannerDto.CreatedBy = Convert.ToInt32(Session["AdminId"]); mainBannerDto.ModifiedBy = Convert.ToInt32(Session["AdminId"]); mainBannerDto.IsActive = 1; int i = mainBannerDal.SaveAndUpdateMainBanner(mainBannerDto); return(Json(i, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }