public static bool deleteNCC(EC_NhaCungCap ncc) { conn = GetData.KetNoi(); string sTruyVan = "NhaCungCap_Delete"; cmd = new SqlCommand(sTruyVan, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MANCC", SqlDbType.NVarChar).Value = ncc.MaNCC; cmd.ExecuteNonQuery(); cmd.Dispose(); conn.Close(); try { GetData.ThucThiTruyVanNonQuery(sTruyVan, conn); //Đóng kết nối GetData.DongKetNoi(conn); return(true); } catch (Exception ex) { //Đóng kết nối GetData.DongKetNoi(conn); return(false); } }
public static bool updateNCC(EC_NhaCungCap ncc) { conn = GetData.KetNoi(); string sTruyVan = "NhaCungCap_Update"; cmd = new SqlCommand(sTruyVan, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MANCC", SqlDbType.NVarChar).Value = ncc.MaNCC; cmd.Parameters.Add("@TENNCC", SqlDbType.NVarChar).Value = ncc.TenNCC; cmd.Parameters.Add("@DIENTHOAI", SqlDbType.NVarChar).Value = ncc.DienThoai; cmd.Parameters.Add("@DIACHI", SqlDbType.NVarChar).Value = ncc.DiaChi; cmd.Parameters.Add("@EMAIL", SqlDbType.NVarChar).Value = ncc.Email; cmd.ExecuteNonQuery(); cmd.Dispose(); try { GetData.ThucThiTruyVanNonQuery(sTruyVan, conn); //Đóng kết nối GetData.DongKetNoi(conn); return(true); } catch (Exception ex) { //Đóng kết nối GetData.DongKetNoi(conn); return(false); } }
public bool deleteNCC(EC_NhaCungCap nsx) { return(DA_NhaCungCap.deleteNCC(nsx)); }
public bool updateNCC(EC_NhaCungCap nsx) { return(DA_NhaCungCap.updateNCC(nsx)); }
public bool insertNCC(EC_NhaCungCap nsx) { return(DA_NhaCungCap.insertNCC(nsx)); }
public DataTable LoadNhaCungCap(EC_NhaCungCap etNCC) { return(cn.LayDuLieu("SELECT * FROM NhaCungCap where IDNhaCC=" + etNCC.IDNhaCC)); }
public void XoaDuLieu(EC_NhaCungCap et) { cn.ThucThiSQL("DELETE FROM NhaCungCap where IDNhaCC=" + et.IDNhaCC); }
public void SuaDuLieu(EC_NhaCungCap et) { cn.ThucThiSQL(@"UPDATE NhaCungCap SET TenNhaCC =N'" + et.TenNhaCC + "', DiaChi =N'" + et.DiaChi + "', Phone =N'" + et.Phone + "', Email =N'" + et.Email + "' where IDNhaCC=" + et.IDNhaCC); }
public void ThemDuLieu(EC_NhaCungCap et) { cn.ThucThiSQL(@"INSERT INTO NhaCungCap (TenNhaCC, DiaChi, Phone, Email) VALUES (N'" + et.TenNhaCC + "',N'" + et.DiaChi + "',N'" + et.Phone + "',N'" + et.Email + "')"); }
public DataTable LoadNhaCungCap(EC_NhaCungCap etNCC) { return(SQL.LoadNhaCungCap(etNCC)); }
public void XoaDuLieu(EC_NhaCungCap et) { SQL.XoaDuLieu(et); }
public void SuaDuLieu(EC_NhaCungCap et) { SQL.SuaDuLieu(et); }
public void ThemDuLieu(EC_NhaCungCap et) { SQL.ThemDuLieu(et); }