public ActionResult Create()
{
OTinTuc data = new OTinTuc();
data.TrangThai = false;
var listCate = loaiTinService.GetAllActive();
ViewBag.ListCates = new SelectList(listCate, "MaLoaiTin", "Ten");
return(View("Update", data));
}
public void Delete(OTinTuc item)
{
conn.connect();
var comm = new SqlCommand("TinTuc_Update", conn.db);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@MaTin", SqlDbType.NVarChar).Value = item.MaTin;
comm.ExecuteNonQuery();
conn.Close();
}
public void Add(OTinTuc item)
{
conn.connect();
var comm = new SqlCommand("TinTuc_Add", conn.db);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@TieuDe", SqlDbType.NVarChar).Value = item.TieuDe;
comm.Parameters.Add(new SqlParameter("@MoTa", item.MoTa ?? (object)DBNull.Value));
comm.Parameters.Add("@NoiDung", SqlDbType.NVarChar).Value = item.NoiDung;
comm.Parameters.Add("@Anh", SqlDbType.NVarChar).Value = item.Anh;
comm.Parameters.Add("@IsActive", SqlDbType.Bit).Value = item.TrangThai;
comm.Parameters.Add("@MaLoaiTin", SqlDbType.Int).Value = item.MaLoaiTin;
comm.Parameters.Add("@ShortName", SqlDbType.NVarChar).Value = item.TenVanTat;
comm.ExecuteNonQuery();
conn.Close();
}
public OTinTuc Get(int id)
{
conn.connect();
var comm = new SqlCommand("TinTuc_Get", conn.db);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@MaTin", SqlDbType.Int).Value = id;
OTinTuc item = new OTinTuc();
DataTable dt = new DataTable();
dt.Load(comm.ExecuteReader());
item = Help.DAL.ConvertDataTable <OTinTuc>(dt).FirstOrDefault();
conn.Close();
return(item);
}
public ActionResult Create(OTinTuc model)
{
if (ModelState.IsValid)
{
// var pro = ServiceFactory.NewsgoryManager.Get(new Newsgories { NewsgoryId = model.NewsgoryId });
try
{
model.TenVanTat = Help.Helper.convertToUnSign3(model.TieuDe);
tinTucService.Add(model);
return(RedirectToAction("Search", "QuanLyTinTuc"));
}
catch (Exception e)
{
}
}
var listCate = loaiTinService.GetAllActive();
ViewBag.ListCates = new SelectList(listCate, "MaLoaiTin", "Ten");
ViewBag.IsEdit = true;
return(View("Update", model));
}
public ActionResult Update(OTinTuc model)
{
if (ModelState.IsValid)
{
var pro = tinTucService.Get(model.MaTin);
if (pro != null)
{
try
{
model.TenVanTat = Help.Helper.convertToUnSign3(model.TieuDe);
tinTucService.Update(model);
return(RedirectToAction("Search", "QuanLyTinTuc"));
}
catch (Exception e)
{
}
}
}
ViewBag.ListCates = new SelectList(loaiTinService.GetAllActive(), "MaLoaiTin", "Ten");
ViewBag.IsEdit = true;
return(View(model));
}
public OTinTuc GetShortName(string shortname)
{
conn.connect();
var comm = new SqlCommand("TinTuc_GetShortName", conn.db);
if (comm == null)
{
return(null);
}
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@ShortName", SqlDbType.NVarChar).Value = shortname;
OTinTuc item = new OTinTuc();
DataTable dt = new DataTable();
dt.Load(comm.ExecuteReader());
item = Help.DAL.ConvertDataTable <OTinTuc>(dt).FirstOrDefault();
conn.Close();
return(item);
}
