public ActionResult Create()
{
OTacGia data = new OTacGia();
data.TrangThai = false;
return(View("Update", data));
}
public void Add(OTacGia item)
{
conn.connect();
var comm = new SqlCommand("TacGia_Insert", conn.db);
comm.CommandType = CommandType.StoredProcedure;
if (comm == null)
{
return;
}
comm.Parameters.Add("@Ten", SqlDbType.NVarChar).Value = item.Ten;
comm.Parameters.Add(new SqlParameter("@DiaChi", item.DiaChi ?? (object)DBNull.Value));
comm.Parameters.Add(new SqlParameter("@DienThoai", item.DiaChi ?? (object)DBNull.Value));
comm.Parameters.Add("@TenVanTat", SqlDbType.NVarChar).Value = Help.Helper.convertToUnSign3(item.Ten);
comm.Parameters.Add("@IsActive", SqlDbType.Bit).Value = item.TrangThai;
comm.ExecuteNonQuery();
}
public ActionResult Create(OTacGia model)
{
if (ModelState.IsValid)
{
try
{
tgService.Add(model);
return(RedirectToAction("Search", "QuanLyTacGia"));
}
catch (Exception e)
{
}
}
ViewBag.IsEdit = true;
return(View("Update", model));
}
public OTacGia Get(int id)
{
conn.connect();
var comm = new SqlCommand("TacGia_Get", conn.db);
comm.CommandType = CommandType.StoredProcedure;
if (comm == null)
{
return(null);
}
comm.Parameters.Add("@MaTacGia", SqlDbType.Int).Value = id;
DataTable dt = new DataTable();
dt.Load(comm.ExecuteReader());
OTacGia item = new OTacGia();
item = Help.DAL.ConvertDataTable <OTacGia>(dt).FirstOrDefault();
return(item);
}
public OTacGia GetByShortName(string shortname)
{
conn.connect();
var comm = new SqlCommand("TacGia_GetByShortName", conn.db);
comm.CommandType = CommandType.StoredProcedure;
if (comm == null)
{
return(null);
}
comm.Parameters.Add("@TenVanTat", SqlDbType.NVarChar).Value = shortname;
DataTable dt = new DataTable();
dt.Load(comm.ExecuteReader());
OTacGia item = new OTacGia();
item = Help.DAL.ConvertDataTable <OTacGia>(dt).FirstOrDefault();
return(item);
}
public ActionResult Update(OTacGia model)
{
if (ModelState.IsValid)
{
var pro = tgService.Get(model.MaTacGia);
if (pro != null)
{
try
{
tgService.Update(model);
return(RedirectToAction("Search", "QuanLyTacGia"));
}
catch (Exception e)
{
}
}
}
ViewBag.IsEdit = true;
return(View(model));
}
public List <OTacGia> GetNameTacgia(int MaSanPham)
{
conn.connect();
var comm = new SqlCommand("Sach_TacGia_GetName", conn.db);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@MaSanPham", SqlDbType.Int).Value = MaSanPham;
List <OTacGia> list = new List <OTacGia>();
DataTable dt = new DataTable();
dt.Load(comm.ExecuteReader());
foreach (DataRow dr in dt.Rows)
{
OTacGia item = new OTacGia();
item.MaTacGia = Convert.ToInt32(dr["MaTacGia"].ToString());
item.Ten = dr["Ten"].ToString();
item.DienThoai = dr["DienThoai"].ToString();
item.DiaChi = dr["DiaChi"].ToString();
list.Add(item);
}
return(list);
}
