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;
}
}
