public SliderDTO GetSlider(int id) { try { using (DbConnection dbConnection = DbFactory.CreateConnection(DbConnectionString)) { DbCommand cmd = DbFactory.CreateCommand(); cmd.Connection = dbConnection; cmd.CommandText = "SELECT id,image_name,title, description FROM [slider_images] where id=@Id"; cmd.CommandType = CommandType.Text; cmd.AddParameter("@Id", id, DbType.Int32); dbConnection.Open(); using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { SliderDTO sliderDto = new SliderDTO { Id = Convert.ToInt32(reader["Id"].ToString()), ImageUrl = reader["image_name"].ToString(), Title = reader["title"].ToString(), Description = reader["description"].ToString() }; return(sliderDto); } } } return(null); } catch (Exception ex) { throw ex; } }
public bool DeleteSlider(int id) { try { // Get the images and remove upon successfull deletion SliderDTO slider = GetSlider(id); using (DbConnection dbConnection = DbFactory.CreateConnection(DbConnectionString)) { DbCommand cmd = DbFactory.CreateCommand(); cmd.Connection = dbConnection; cmd.CommandType = CommandType.Text; cmd.CommandText = "Delete from slider_images where id=@Id"; cmd.AddParameter("@Id", id, DbType.Int32); dbConnection.Open(); cmd.ExecuteNonQuery(); if (slider.ImageUrl != null) { var filePath = HttpContext.Current.Server.MapPath("~/Content/Images/" + slider.ImageUrl); if (File.Exists(filePath)) { File.Delete(filePath); } } return(true); } } catch (Exception ex) { throw ex; } }
public ActionResult SliderUpdate(SliderDTO data) { Slider slider = _sliderService.GetByID(data.ID); slider.Queue = data.Queue; _sliderService.Update(slider); return(Redirect("/Admin/CMS/SliderList")); }
public ActionResult SliderUpdate(Guid id) { Slider slider = _sliderService.GetByID(id); SliderDTO model = new SliderDTO(); model.ID = slider.ID; model.Queue = slider.Queue; return(View(model)); }
public SliderDTO AddOrUpdateSlider(int?Id, SliderDTO slider) { try { SliderDTO sliderDTO = null; if (Id != null) { sliderDTO = GetSlider((int)Id); } using (DbConnection dbConnection = DbFactory.CreateConnection(DbConnectionString)) { DbCommand cmd = DbFactory.CreateCommand(); cmd.Connection = dbConnection; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "CreateUpdateSlider"; cmd.AddParameter("@Id", Id, DbType.Int32); cmd.AddParameterWithValue("@Name", slider.ImageUrl); cmd.AddParameterWithValue("@Title", slider.Title); cmd.AddParameterWithValue("@Description", slider.Description); dbConnection.Open(); using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { SliderDTO sliderDto = new SliderDTO { Id = Convert.ToInt32(reader["Id"].ToString()), ImageUrl = reader["image_name"].ToString(), Title = reader["title"].ToString(), Description = reader["description"].ToString() }; if (Id != null) { if (sliderDTO.ImageUrl != slider.ImageUrl) { var filePath = HttpContext.Current.Server.MapPath("~/Content/Images/" + sliderDTO.ImageUrl); if (File.Exists(filePath)) { File.Delete(filePath); } } } return(sliderDto); } } } } catch (Exception ex) { throw ex; } return(null); }
public SliderDTO GetSliderById(int sliderId) { try { SliderDTO sliderDTO = SliderManager.GetSlider(sliderId); return(sliderDTO); } catch (Exception) { return(null); } }
public SliderDTO AddOrUpdateSlider(int?id, SliderDTO slider) { try { SliderDTO sliderDto = SliderManager.AddOrUpdateSlider(id, slider); return(sliderDto); } catch { return(null); } }
public ActionResult Update(SliderDTO SliderDTO) { Slider Slider = _SliderService.GetByID(SliderDTO.ID); Slider.Content = SliderDTO.Content; Slider.Header = SliderDTO.Header; Slider.ImageUrl = SliderDTO.ImageUrl; Slider.Name = SliderDTO.Name; Slider.SliderUrl1 = SliderDTO.SliderUrl1; Slider.SliderUrl2 = SliderDTO.SliderUrl2; _SliderService.Update(Slider); return(Redirect("/SysAdmin/Slider/List")); }
public ActionResult Update(int id) { Slider Slider = _SliderService.GetByID(id); SliderDTO SliderDTO = new SliderDTO() { ID = Slider.ID, Content = Slider.Content, Header = Slider.Header, ImageUrl = Slider.ImageUrl, Name = Slider.Name, SliderUrl1 = Slider.SliderUrl1, SliderUrl2 = Slider.SliderUrl2, }; return(View(SliderDTO)); }
public async Task <SliderDTO> RegsiterSliderPhoto(SliderDTO SldierDTO, IFormFile files) { string name = Guid.NewGuid().ToString(); var path = Path.Combine(_hosting.WebRootPath, "img/banner/" + name + ".jpg"); var patName = name + ".jpg"; if (files.Length > 0) { using (var steam = new FileStream(path, FileMode.Create)) { await files.CopyToAsync(steam); } } SldierDTO.Path = patName; SldierDTO.Status = 1; var slider = SldierDTO.ToEntity <Eduction.Core.Domains.Slider>(); await _sliderRepository.InsertAsync(slider); SldierDTO.ID = slider.ID; return(SldierDTO); }
public List <SliderDTO> GetSliders() { List <SliderDTO> sliders = null; try { using (DbConnection dbConnection = DbFactory.CreateConnection(DbConnectionString)) { DbCommand cmd = DbFactory.CreateCommand(); cmd.Connection = dbConnection; cmd.CommandText = "SELECT id,image_name,title, description FROM [slider_images]"; cmd.CommandType = CommandType.Text; dbConnection.Open(); using (DbDataReader reader = cmd.ExecuteReader()) { sliders = new List <SliderDTO>(); while (reader.Read()) { SliderDTO sliderDto = new SliderDTO { Id = Convert.ToInt32(reader["Id"].ToString()), ImageUrl = reader["image_name"].ToString(), Title = reader["title"].ToString(), Description = reader["description"].ToString() }; sliders.Add(sliderDto); } } } } catch (Exception ex) { throw ex; } return(sliders); }
public async Task <IActionResult> Create(SliderDTO dTO, IFormFile files) { await _sliderService.RegsiterSliderPhoto(dTO, files); return(RedirectToAction("List")); }
public async Task <IActionResult> Create() { SliderDTO dTO = new SliderDTO(); return(View(dTO)); }