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