//public int Insert(LoaiSP obj) //{ // int result = 0; // string strQuery = "insert into SINHVIEN (MSSV,HoTen,NgaySinh,Phai,Email,SDT,Khoa) values ('" + obj.MSSV + "',N'" + obj.HoTen + "','" + obj.NgaySinh + "',N'" + obj.Phai + "','" + obj.Email + "','" + obj.SDT + "',N'" + obj.Khoa + "')"; // result = base.excuteNoneQuery("LSP_Insert"); // return result; //tra ve so ghi nhan thuc hien //} //check ID //public bool CheckID(string MaLSP) //{ // // bool result = true; // //string strQuery = "select * from SANPHAM where maSP ='" + MaSP + "'"; // DataTable DT = new DataTable(); // DT = base.GetData("LSP_SelectByID"); // if (DT.Rows.Count > 0) // return true; // return false; //} //public int Update(LoaiSP obj) //{ // int result = 0; // // string strQuery = "update SINHVIEN set HoTen=N'" + obj.HoTen + "',NgaySinh='" + obj.NgaySinh + "',Phai=N'" + obj.Phai + "',Email='" + obj.Email + "',SDT='" + obj.SDT + "' where MSSV='" + obj.MSSV + "'"; // //dbConnect config = new dbConnect(); // result = base.excuteNoneQuery("LSP_Update"); // return result; //tra ve so ghi nhan thuc hien //} // xoa //public int Delete(string MaLSP) //{ // int result = 0; // //string strQuery = "delete from SINHVIEN where MSSV='" + MaSP + "'"; // //dbConnect config = new dbConnect(); // result = base.excuteNoneQuery("LSP_Delete"); // return result; //tra ve so ghi nhan thuc hien //} public int Insert(LoaiSP obj) { SqlParameter[] para = { new SqlParameter("TenLSP", obj.tenLSP) }; return(base.ExcuteSQL("LSP_Insert", para)); }
public int Update(LoaiSP obj) { SqlParameter[] para = { new SqlParameter("MaLSP", obj.maLSP), new SqlParameter("TenLSP", obj.tenLSP) }; return(base.ExcuteSQL("LSP_Update", para)); }
public static List <LoaiSP> LayLoaiSPTheoDanhMuc(string para) { SqlDataReader reader = DataProvider.TruyVan1ParaString("LayLoaiSPTheoDanhMuc", para); List <LoaiSP> loaisp = new List <LoaiSP>(); while (reader.Read()) { LoaiSP sp = new LoaiSP(); sp.MaDanhMuc = reader.GetString(0); sp.TenLoaiSP = reader.GetString(1); sp.MaDanhMuc = reader.GetString(2); loaisp.Add(sp); } return(loaisp); }
public bool Update(LoaiSP model) { string msgError = ""; try { var result = _dbHelper.ExecuteScalarSProcedureWithTransaction(out msgError, "sp_category_update", "@maloai", model.maloai, "@tenloai", model.tenloai); if ((result != null && !string.IsNullOrEmpty(result.ToString())) || !string.IsNullOrEmpty(msgError)) { throw new Exception(Convert.ToString(result) + msgError); } return(true); } catch (Exception ex) { throw ex; } }