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