public static void Them(NCC_DTO ncc)
{
SqlConnection conn = NCC_DAO.KetNoi();
string sqlInsert = "INSERT INTO NHACUNGCAP VALUES(@MaNCC,@TenNCC,@DCNCC,@SDTNCC)";
SqlCommand cmd = new SqlCommand(sqlInsert, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@MaNCC", SqlDbType.VarChar, 10);
cmd.Parameters.Add("@TenNCC", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@DCNCC", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@SDTNCC", SqlDbType.VarChar, 11);
cmd.Parameters["@MaNCC"].Value = ncc.MaNCC;
cmd.Parameters["@TenNCC"].Value = ncc.TenNCC;
cmd.Parameters["@DCNCC"].Value = ncc.DCNCC;
cmd.Parameters["@SDTNCC"].Value = ncc.SDTNCC;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.ExecuteNonQuery();
conn.Close();
}
public bool XoaNCC(NCC_DTO nccDTO)
{
string strDelete = "delete NHACUNGCAP where MaNCC = @MaNCC";
List <SqlParameter> lsparamas = new List <SqlParameter>();
lsparamas.Add(new SqlParameter("@MaNCC", nccDTO.MaNCC));
lsparamas.Add(new SqlParameter("@TenNCC", nccDTO.TenNCC));
lsparamas.Add(new SqlParameter("@DiaChi", nccDTO.DiaChi));
lsparamas.Add(new SqlParameter("@SDT", nccDTO.SDT));
lsparamas.Add(new SqlParameter("@TrangThai", nccDTO.TrangThai));
SqlConnection conn = DataProvider.TaoKetNoi();
bool thucthi = DataProvider.ThucThiCauLenh(strDelete, lsparamas.ToArray(), conn);
conn.Close();
return(thucthi);
}
public bool ThemMoiNCC(NCC_DTO nccDTO)
{
string strInsert = "Insert into NHACUNGCAP (MaNCC, TenNCC, DiaChi, SDT, TrangThai)"
+ "Values ("
+ "@MaNCC, @TenNCC, @DiaChi, @SDT, 1)";
List <SqlParameter> lsparamas = new List <SqlParameter>();
lsparamas.Add(new SqlParameter("@MaNCC", nccDTO.MaNCC));
lsparamas.Add(new SqlParameter("@TenNCC", nccDTO.TenNCC));
lsparamas.Add(new SqlParameter("@DiaChi", nccDTO.DiaChi));
lsparamas.Add(new SqlParameter("@SDT", nccDTO.SDT));
SqlConnection con = DataProvider.TaoKetNoi();
bool thucthi = DataProvider.ThucThiCauLenh(strInsert, lsparamas.ToArray(), con);
con.Close();
return(thucthi);
}
private void btnLuuNCC_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
string MaNCC = txtMaNCC.Text;
string TenNCC = txtTenNCC.Text;
string DCNCC = txtDCNCC.Text;
string SDTNCC = txtSDTNCC.Text;
NCC_DTO ncc = new NCC_DTO(MaNCC, TenNCC, DCNCC, SDTNCC);
if (MaNCC == "" || TenNCC == "" || DCNCC == "" || SDTNCC == "")
{
XtraMessageBox.Show("Bạn phải nhập đầy đủ thông tin của nhà cung cấp!", "Thông báo");
}
else
{
if (Them == true)
{
try
{
NCC_BUS.ThemNCC(ncc);
LoadDataNCC();
XtraMessageBox.Show("Thêm thông tin nhà cung cấp hàng thành công!", "Thông báo");
LockControl();
}
catch (SqlException ex)
{
XtraMessageBox.Show(ex.Message);
}
}
else
{
try
{
NCC_BUS.SuaNCC(ncc);
LoadDataNCC();
XtraMessageBox.Show("Sửa thông tin nhà cung cấp thành công!", "Thông báo!");
LockControl();
}
catch (SqlException ex)
{
XtraMessageBox.Show(ex.Message);
}
}
}
}
public bool CapNhatNCC(NCC_DTO nccDTO)
{
string strUpdate = "UPDATE NHACUNGCAP set TenNCC = @TenNCC,DiaChi = @DiaChi,SDT = @SDT,TrangThai = 1" +
"WHERE MaNCC = @MaNCC";
List <SqlParameter> lsparamas = new List <SqlParameter>();
lsparamas.Add(new SqlParameter("@MaNCC", nccDTO.MaNCC));
lsparamas.Add(new SqlParameter("@TenNCC", nccDTO.TenNCC));
lsparamas.Add(new SqlParameter("@DiaChi", nccDTO.DiaChi));
lsparamas.Add(new SqlParameter("@SDT", nccDTO.SDT));
lsparamas.Add(new SqlParameter("@TrangThai", nccDTO.TrangThai));
SqlConnection conn = DataProvider.TaoKetNoi();
bool thucthi = DataProvider.ThucThiCauLenh(strUpdate, lsparamas.ToArray(), conn);
conn.Close();
return(thucthi);
}
public static void Sua(NCC_DTO ncc)
{
SqlConnection conn = NCC_DAO.KetNoi();
string sqlUpdate = "UPDATE NHACUNGCAP SET TenNCC=@TenNCC, DCNCC=@DCNCC, SDTNCC=@SDTNCC WHERE MaNCC=@MaNCC";
SqlCommand cmd = new SqlCommand(sqlUpdate, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@TenNCC", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@DCNCC", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@SDTNCC", SqlDbType.VarChar, 11);
cmd.Parameters.Add("@MaNCC", SqlDbType.VarChar, 11);
cmd.Parameters["@TenNCC"].Value = ncc.TenNCC;
cmd.Parameters["@DCNCC"].Value = ncc.DCNCC;
cmd.Parameters["@SDTNCC"].Value = ncc.SDTNCC;
cmd.Parameters["@MaNCC"].Value = ncc.MaNCC;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.ExecuteNonQuery(); conn.Close();
}
public List <NCC_DTO> LayDanhSachNCC()
{
List <NCC_DTO> lsKQ = new List <NCC_DTO>();
SqlConnection conn = DataProvider.TaoKetNoi();
string strTruyVan = "Select * From NHACUNGCAP Where TrangThai = 1";
SqlDataReader sdr = DataProvider.TruyVanDuLieu(strTruyVan, conn);
while (sdr.Read())
{
NCC_DTO ncc = new NCC_DTO();
ncc.MaNCC = sdr["MaNCC"].ToString();
ncc.TenNCC = sdr["TenNCC"].ToString();
ncc.DiaChi = sdr["DiaChi"].ToString();
ncc.SDT = sdr["SDT"].ToString();
ncc.TrangThai = int.Parse(sdr["TrangThai"].ToString());
lsKQ.Add(ncc);
}
sdr.Close();
conn.Close();
return(lsKQ);
}
public static void SuaNCC(NCC_DTO ncc)
{
NCC.Sua(ncc);
}
public static void ThemNCC(NCC_DTO ncc)
{
NCC.Them(ncc);
}
public bool XoaNCC(NCC_DTO nccDTO)
{
NCC_DAO nccDao = new NCC_DAO();
return(nccDao.XoaNCC(nccDTO));
}
public bool CapNhatNCC(NCC_DTO nccDTO)
{
NCC_DAO nccDao = new NCC_DAO();
return(nccDao.CapNhatNCC(nccDTO));
}
public bool ThemNCC(NCC_DTO nccDTO)
{
NCC_DAO nccDao = new NCC_DAO();
return(nccDao.ThemMoiNCC(nccDTO));
}
