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