public bool Insert(NhaCCDTO nhaCCDTO)
{
var lenh = "insert into NhaCungCap values(" +
"N'" + nhaCCDTO.MaNCC.Trim() + "'," +
"N'" + nhaCCDTO.TenNCC.Trim() + "'," +
"N'" + nhaCCDTO.DiaChi.Trim() + "'," +
"N'" + nhaCCDTO.DienThoai.Trim() + "'," +
"N'" + nhaCCDTO.Fax.Trim() + "'," +
"N'" + nhaCCDTO.Email.Trim() + "'" +
")";
try
{
var cmd = new SqlCommand(lenh, Connection.Cnn);
Connection.Open();
int kq = cmd.ExecuteNonQuery();
Connection.Close();
if (kq <= 0)
{
return(false);
}
}
catch (Exception ex)
{
_error = ex.Message;
return(false);
}
return(true);
}
/// <summary>
/// delete NCC
/// </summary>
/// <param name="ncc"></param>
public static void Delete_NCC(NhaCCDTO ncc)
{
try
{
cnn = DataProvider.ConnectData();
string insert = string.Format("DELETE FROM db_nha_cung_cap WHERE ma_ncc='{0}'", ncc.ma_ncc);
DataProvider.Execute(cnn, insert);
cnn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// update nha cung cap
/// </summary>
/// <param name="ncc"></param>
public static void Update_NCC(NhaCCDTO ncc)
{
try
{
cnn = DataProvider.ConnectData();
string insert = string.Format("UPDATE db_nha_cung_cap SET ten_ncc='{1}',sdt_ncc='{2}',email='{3}' WHERE ma_ncc='{0}'", ncc.ma_ncc, ncc.ten_ncc, ncc.sdt_ncc, ncc.email);
DataProvider.Execute(cnn, insert);
cnn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// them ncc
/// </summary>
/// <param name="ncc"></param>
public static void Insert_NCC(NhaCCDTO ncc)
{
try
{
cnn = DataProvider.ConnectData();
string insert = string.Format("insert into db_nha_cung_cap(ma_ncc,ten_ncc,sdt_ncc,email) values ('{0}','{1}','{2}','{3}')", ncc.ma_ncc, ncc.ten_ncc, ncc.sdt_ncc, ncc.email);
DataProvider.Execute(cnn, insert);
cnn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
private void btnThem_Click(object sender, EventArgs e)
{
_nhaCCDTO = new NhaCCDTO {
MaNCC = txtMaNCC.Text, TenNCC = txtNhaCC.Text, DiaChi = txtDiaChi.Text, DienThoai = txtDienThoai.Text, Fax = txtFax.Text, Email = txtEmail.Text
};
_nhaCCBLO.nhaCCDTO = _nhaCCDTO;
if (!_nhaCCBLO.Insert())
{
MessageBox.Show(_nhaCCBLO.Error, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("Đã thêm thành công nhà cung cấp", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void button1_Click_1(object sender, EventArgs e)
{
NhaCCDTO ncc = new NhaCCDTO();
ncc.ma_ncc = txtMaNCC.Text;
ncc.ten_ncc = txtTenNCC.Text;
ncc.email = txtEmailNCC.Text;
ncc.sdt_ncc = txtSDTNCC.Text;
NhaCCBUS.Insert_NCC(ncc);
txtMaNCC.Clear();
txtTenNCC.Clear();
txtEmailNCC.Clear();
txtSDTNCC.Clear();
load_data();
}
/// <summary>
/// tìm theo ten ncc
/// </summary>
/// <returns></returns>
public static DataTable Search_tenNCC(NhaCCDTO ncc)
{
try
{
DataTable dt = new DataTable();
cnn = DataProvider.ConnectData();
string select = string.Format("SELECT * FROM db_nha_cung_cap WHERE ten_ncc = '{0}'", ncc.ten_ncc);
dt = DataProvider.Load_database(select, cnn);
cnn.Close();
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// tìm theo nhà cung cấp
/// </summary>
/// <param name="pn"></param>
/// <returns></returns>
public static DataTable Search_NCC(NhaCCDTO ncc)
{
try
{
cnn = DataProvider.ConnectData();
string Search_ma = string.Format("SELECT ma_phieu_nhap,db_nhanvien.ten_nv,db_nha_cung_cap.ten_ncc,ngay_lap_pn,tong_tien FROM db_phieu_nhap inner join db_nhanvien on db_phieu_nhap.ma_nv = db_nhanvien.ma_nv inner join db_nha_cung_cap on db_phieu_nhap.ma_ncc = db_nha_cung_cap.ma_ncc WHERE db_nha_cung_cap.ten_ncc='{0}'", ncc.ten_ncc);
DataTable dt = new DataTable();
dt = DataProvider.Load_database(Search_ma, cnn);
cnn.Close();
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable Search_NCC(NhaCCDTO ncc)
{
return(PhieuNhapDAO.Search_NCC(ncc));
}
public NhaCCBLO()
{
_error = "";
_nhaCCDTO = new NhaCCDTO();
_nhaCCDAO = new NhaCCDAO();
}
public static DataTable Search_tenNCC(NhaCCDTO ncc)
{
return(NhaCCDAO.Search_tenNCC(ncc));
}
public static void Delete_NCC(NhaCCDTO ncc)
{
NhaCCDAO.Delete_NCC(ncc);
}
public static void Update_NCC(NhaCCDTO ncc)
{
NhaCCDAO.Update_NCC(ncc);
}
public static void Insert_NCC(NhaCCDTO ncc)
{
NhaCCDAO.Insert_NCC(ncc);
}
