//Thêm một nhà cung cấp mới
public bool InsertNCC(NHACUNGCAP NCC)
{
SqlConnection connection = new SqlConnection(connectionString);
string sql = @"INSERT INTO dbo.NHACUNGCAP(MANCC,TENNCC,EMAIL, SDT)
VALUES('" + NCC.MANHACUNGCAP + "',N'" + NCC.TENNHACUNGCAP + "', '" + NCC.EMAIL + "','" + NCC.SODIENTHOAI + "')";
SqlCommand cmd = new SqlCommand(sql, connection);
connection.Open();
int result = cmd.ExecuteNonQuery();
connection.Close();
if (result != 0)
{
return(true);
}
return(false);
}
//Cập nhật NCC
public bool UpDateNCC(NHACUNGCAP NCC)
{
SqlConnection connection = new SqlConnection(connectionString);
string sql = @"UPDATE dbo.NHACUNGCAP SET TENNCC = @TenNCC, EMAIL = @Email, SDT = @SoDienThoai WHERE MANCC = @MaNCC";
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.Parameters.AddWithValue("@TenNCC", NCC.TENNHACUNGCAP);
cmd.Parameters.AddWithValue("@Email", NCC.EMAIL);
cmd.Parameters.AddWithValue("@SoDienThoai", NCC.SODIENTHOAI);
cmd.Parameters.AddWithValue("@MaNCC", NCC.MANHACUNGCAP);
connection.Open();
int result = cmd.ExecuteNonQuery();
connection.Close();
if (result != 0)
{
return(true);
}
return(false);
}
//Lấy nhà cung cấp thông qua mã nhà cung cấp
public NHACUNGCAP LayNCC(string MaNCC)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sql = @"SELECT * FROM dbo.NHACUNGCAP WHERE MANCC = @MaLoai";
SqlCommand cmd = new SqlCommand(sql, connection); cmd.Parameters.AddWithValue("@MaLoai", MaNCC);
connection.Open(); SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
NHACUNGCAP NCC = new NHACUNGCAP
{
// Lấy giá trị theo tên cột trong CSDL
MANHACUNGCAP = (string)reader["MANCC"],
TENNHACUNGCAP = (string)reader["TENNCC"],
SODIENTHOAI = (string)reader["SDT"],
EMAIL = (string)reader["EMAIL"],
};
return(NCC);
}
}
return(null);
}
