public ActionResult Delete_Carousel(int id, CarouselSlider carouselSlider)
{
if (userManager.ToDeleteCarousel(id, carouselSlider) == true)
{
return(RedirectToAction("SliderImage"));
}
return(View());
}
public bool ToUpdateCarousel(CarouselSlider carouselSlider)
{
using (UserDataBase userDataBase = new UserDataBase())
{
userDataBase.Entry(carouselSlider).State = EntityState.Modified;
userDataBase.SaveChanges();
return(true);
}
}
public bool ToDeleteCarousel(int UserId, CarouselSlider carouselSlider)
{
using (UserDataBase userDataBase = new UserDataBase())
{
SqlParameter id = new SqlParameter("@ID", UserId);
var data = userDataBase.Database.ExecuteSqlCommand("CarouselSlider_Delete @ID", id);
//carouselSlider = userDataBase.carouselSliders.Where(model => model.ID == UserId).FirstOrDefault();
//userDataBase.carouselSliders.Remove(carouselSlider);
//userDataBase.SaveChanges();
return(true);
}
}
public bool ToAdd(CarouselSlider carouselSlider)
{
using (UserDataBase userDataBase = new UserDataBase())
{
SqlParameter filename = new SqlParameter("@FileName", carouselSlider.FileName);
SqlParameter filesize = new SqlParameter("@FileSize", carouselSlider.FileSize);
SqlParameter filepath = new SqlParameter("@FilePath", carouselSlider.FilePath);
var data = userDataBase.Database.ExecuteSqlCommand(" CarouselSlider_Insert @FileName,@FileSize,@FilePath", filename, filesize, filepath);
//userDataBase.carouselSliders.Add(carouselSlider);
//userDataBase.SaveChanges();
return(true);
}
}
public ActionResult Update_Carousel(int id, CarouselSliderModel carouselSliderModel)
{
ViewBag.State = new SelectList(userManager.StateView(), "StateName", "StateName");
ViewBag.City = new SelectList(userManager.CityView(), "CityName", "CityName");
if (ModelState.IsValid)
{
CarouselSlider registration = Mapper.Map <CarouselSliderModel, CarouselSlider>(carouselSliderModel);
if (userManager.ToUpdateCarousel(registration) == true)
{
return(RedirectToAction("SliderImage"));
}
}
return(View());
}
public ActionResult SliderImage(HttpPostedFileBase fileupload)
{
if (fileupload != null)
{
CarouselSliderModel carouselSliderModel = new CarouselSliderModel();
carouselSliderModel.FileName = Path.GetFileName(fileupload.FileName);
carouselSliderModel.FileSize = (fileupload.ContentLength) / 1000;
fileupload.SaveAs(Server.MapPath("~/Images/" + carouselSliderModel.FileName));
carouselSliderModel.FilePath = "~/Images/" + carouselSliderModel.FileName;
CarouselSlider slider = Mapper.Map <CarouselSliderModel, CarouselSlider>(carouselSliderModel);
if (userManager.ToAdd(slider) == true)
{
return(RedirectToAction("SliderImage", "Admin"));
}
}
return(View());
}
public ActionResult UploadSliderImage()
{
List <CarouselSlider> sliderimages = new List <CarouselSlider>();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("spGetAllSliderImage", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
CarouselSlider slider = new CarouselSlider();
slider.ID = Convert.ToInt32(rdr["ID"]);
slider.Name = rdr["Name"].ToString();
slider.FileSize = Convert.ToInt32(rdr["FileSize"]);
slider.FilePath = rdr["FilePath"].ToString();
sliderimages.Add(slider);
}
}
return(View(sliderimages));
}
public bool ToDeleteCarousel(int UserId, CarouselSlider carouselSlider)
{
return(sliderRepository.ToDeleteCarousel(UserId, carouselSlider));
}
public bool ToUpdateCarousel(CarouselSlider carouselSlider)
{
return(sliderRepository.ToUpdateCarousel(carouselSlider));
}
public bool ToAdd(CarouselSlider carouselSlider)
{
return(sliderRepository.ToAdd(carouselSlider));
}
