public ActionResult Create()
{
OTrangTinh data = new OTrangTinh();
data.TrangThai = false;
ViewBag.LoaiTrangTinh = new SelectList(loaiTrangTinhService.GetAllActive(), "MaLoai", "TenLoai");
return(View("Update", data));
}
public bool Delete(OTrangTinh item)
{
conn.connect();
var comm = new SqlCommand("TrangTinh_Delete", conn.db);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@MaTrangTinh", SqlDbType.Int).Value = item.MaTrangTinh;
comm.ExecuteNonQuery();
conn.Close();
return(true);
}
public void Add(OTrangTinh item)
{
conn.connect();
var comm = new SqlCommand("TrangTinh_Add", conn.db);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@TenTrang", SqlDbType.NVarChar).Value = item.TenTrang;
comm.Parameters.Add(new SqlParameter("@MoTa", item.MoTa ?? (object)DBNull.Value));
comm.Parameters.Add("@Body", SqlDbType.NVarChar).Value = item.NoiDung;
comm.Parameters.Add("@IsActive", SqlDbType.Bit).Value = item.TrangThai;
comm.Parameters.Add("@TenVanTat", SqlDbType.NVarChar).Value = Help.Helper.convertToUnSign3(item.TenTrang);
comm.Parameters.Add("@MaLoai", SqlDbType.Int).Value = item.MaLoai;
SqlDataReader reader = comm.ExecuteReader();
conn.Close();
}
public OTrangTinh Get(int id)
{
conn.connect();
var comm = new SqlCommand("TrangTinh_Get", conn.db);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@MaTrangTinh", SqlDbType.Int).Value = id;
OTrangTinh item = new OTrangTinh();
DataTable dt = new DataTable();
dt.Load(comm.ExecuteReader());
item = Help.DAL.ConvertDataTable <OTrangTinh>(dt).FirstOrDefault();
conn.Close();
return(item);
}
public OTrangTinh GetByShortName(string shortname)
{
conn.connect();
var comm = new SqlCommand("TrangTinh_GetByShortName", conn.db);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@TenVanTat", SqlDbType.NVarChar).Value = shortname;
OTrangTinh item = new OTrangTinh();
DataTable dt = new DataTable();
dt.Load(comm.ExecuteReader());
item = Help.DAL.ConvertDataTable <OTrangTinh>(dt).FirstOrDefault();
conn.Close();
return(item);
}
public ActionResult Create(OTrangTinh model)
{
if (ModelState.IsValid)
{
try
{
model.TenVanTat = Help.Helper.convertToUnSign3(model.TenTrang);
htmlPageService.Add(model);
return(RedirectToAction("Search", "QuanLyTrangTinh"));
}
catch (Exception e)
{
}
}
ViewBag.LoaiTrangTinh = new SelectList(loaiTrangTinhService.GetAllActive(), "MaLoai", "TenLoai");
ViewBag.IsEdit = true;
return(View("Update", model));
}
