public ActionResult Create()
{
OSlide data = new OSlide();
data.TrangThai = false;
data.ThuTu = 0;
return(View("Update", data));
}
public void Delete(OSlide slide)
{
conn.connect();
var comm = new SqlCommand("Slide_Delete", conn.db);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@SlideId", SqlDbType.Int).Value = slide.MaSlide;
comm.ExecuteNonQuery();
}
public OSlide Get(int id)
{
conn.connect();
var comm = new SqlCommand("Slide_Get", conn.db);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@SlideId", SqlDbType.Int).Value = id;
OSlide item = new OSlide();
DataTable dt = new DataTable();
dt.Load(comm.ExecuteReader());
item = Help.DAL.ConvertDataTable <OSlide>(dt).FirstOrDefault();
return(item);
}
public void Update(OSlide slide)
{
conn.connect();
var comm = new SqlCommand("Slide_Update", conn.db);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@SlideId", SqlDbType.NVarChar).Value = slide.MaSlide;
comm.Parameters.Add(new SqlParameter("@SlideName", slide.Ten ?? (object)DBNull.Value));
comm.Parameters.Add(new SqlParameter("@SlideDescription", slide.MoTa ?? (object)DBNull.Value));
comm.Parameters.Add(new SqlParameter("@SlideImage", slide.Anh ?? (object)DBNull.Value));
comm.Parameters.Add("@IsActive", SqlDbType.Bit).Value = slide.TrangThai;
comm.Parameters.Add("@OrderNo", SqlDbType.Int).Value = slide.ThuTu;
comm.ExecuteNonQuery();
}
public void Add(OSlide slide)
{
conn.connect();
var comm = new SqlCommand("Slide_Insert", conn.db);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add(new SqlParameter("@SlideName", slide.Ten ?? (object)DBNull.Value));
comm.Parameters.Add(new SqlParameter("@SlideDescription", slide.MoTa ?? (object)DBNull.Value));
comm.Parameters.Add(new SqlParameter("@SlideImage", slide.Anh ?? (object)DBNull.Value));
comm.Parameters.Add("@IsActive", SqlDbType.Bit).Value = slide.TrangThai;
comm.Parameters.Add("@OrderNo", SqlDbType.Int).Value = slide.ThuTu;
SqlDataReader reader = comm.ExecuteReader();
}
public ActionResult Create(OSlide model)
{
if (ModelState.IsValid)
{
try
{
slideService.Add(model);
return(RedirectToAction("Search", "QuanLySlide"));
}
catch (Exception e)
{
}
}
ViewBag.IsEdit = true;
return(View("Update", model));
}
public ActionResult Update(OSlide model)
{
if (ModelState.IsValid)
{
var pro = slideService.Get(model.MaSlide);
if (pro != null)
{
try
{
slideService.Update(model);
return(RedirectToAction("Search", "QuanLySlide"));
}
catch (Exception e)
{
}
}
}
ViewBag.IsEdit = true;
return(View(model));
}
