public void BindToDialog(string id)
{
DataRow dr = NhaPhanPhoi.GetNPPFromDB(id);
btnAdd.Text = "Cập nhật";
txtMaLoaiHangHoa.Text = dr["MaLoaiHangHoa"].ToString();
txtTenLoaiHangHoa.Text = dr["TenLoaiHangHoa"].ToString();
}
public string GetLastMaNhaPhanPhois()
{
NhaPhanPhoi npp = qlhh.NhaPhanPhois.Where(t => t.MaNhaPhanPhoi == "NPP001").FirstOrDefault();
if (npp == null)
{
return("NPP001");
}
return(qlhh.NhaPhanPhois.OrderByDescending(t => t.MaNhaPhanPhoi).FirstOrDefault().MaNhaPhanPhoi);
}
public void BindToDialog(string id)
{
DataRow dr = NhaPhanPhoi.GetNPPFromDB(id);
btnAdd.Text = "Cập nhật";
txtMaNPP.Text = dr["MaNhaPhanPhoi"].ToString();
txtTenNPP.Text = dr["TenNhaPhanPhoi"].ToString();
txtLoaiNPP.Text = dr["LoaiNhaPhanPhoi"].ToString();
txtDiaChi.Text = dr["DiaChi"].ToString();
txtSDT.Text = dr["SoDienThoai"].ToString();
}
public int Insert(NhaPhanPhoi obj)
{
SqlParameter[] para =
{
new SqlParameter("TENNPP", obj.TENNPP),
new SqlParameter("DIACHI", obj.DIACHI),
new SqlParameter("DIENTHOAI", obj.DIENTHOAI),
new SqlParameter("FAX", obj.FAX),
new SqlParameter("EMAIL", obj.EMAIL)
};
return(base.ExecuteSQL("NPP_INSERT", para));
}
public int Update(NhaPhanPhoi obj)
{
SqlParameter[] para =
{
new SqlParameter("MANPP", obj.MANPP),
new SqlParameter("TENNPP", obj.TENNPP),
new SqlParameter("DIACHI", obj.DIACHI),
new SqlParameter("DIENTHOAI", obj.DIENTHOAI),
new SqlParameter("EMAIL", obj.EMAIL),
new SqlParameter("FAX", obj.FAX)
};
return(base.ExecuteSQL("NPP_UPDATE", para));
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (btnAdd.Text == "Thêm")
{
NhaPhanPhoi nhaPhanPhoi = GetDataFromDialog();
nhaPhanPhoi.SaveToDatabase();
}
else
{
NhaPhanPhoi nhaPhanPhoi = GetDataFromDialog();
nhaPhanPhoi.UpdateNPPToDatabase();
}
mainForm.LoadToDataGridView();
this.Close();
}
public int DeleteNhaPhanPhois(string qMaNPP)
{
NhaPhanPhoi nhaPhanPhois = qlhh.NhaPhanPhois.Where(t => t.MaNhaPhanPhoi == qMaNPP).FirstOrDefault();
if (nhaPhanPhois != null)
{
qlhh.NhaPhanPhois.DeleteOnSubmit(nhaPhanPhois);
qlhh.SubmitChanges();
return(1);
}
else
{
return(0);
}
}
public int UpdateNhaPhanPhois(string qMaNPP, string qTenNPP, string qDiaChi, string qDienThoai, string qEmail)
{
NhaPhanPhoi nhaPhanPhois = qlhh.NhaPhanPhois.Where(t => t.MaNhaPhanPhoi == qMaNPP).FirstOrDefault();
if (nhaPhanPhois != null)
{
nhaPhanPhois.TenNhaPhanPhoi = qTenNPP;
nhaPhanPhois.DiaChi = qDiaChi;
nhaPhanPhois.SDT = qDienThoai;
nhaPhanPhois.Email = qEmail;
qlhh.SubmitChanges();
return(1);
}
else
{
return(0);
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
NhaPhanPhoi obj = new NhaPhanPhoi();
obj.TENNPP = txtTenNPP.Text;
obj.DIACHI = txtDiaChi.Text;
obj.DIENTHOAI = txtSoDT.Text;
obj.FAX = txtSoFax.Text;
obj.EMAIL = txtEmail.Text;
nppBus.Insert(obj);
DataTable dt = nppBus.GetNPP();
getData(dt);
XtraMessageBox.Show("Thêm thành công");
this.Close();
}
public int AddNhaPhanPhois(string qMaNPP, string qTenNPP, string qDiaChi, string qDienThoai, string qEmail)
{
NhaPhanPhoi nhaPhanPhois = qlhh.NhaPhanPhois.Where(t => t.MaNhaPhanPhoi == qMaNPP).FirstOrDefault();
if (nhaPhanPhois == null)
{
NhaPhanPhoi npp = new NhaPhanPhoi();
npp.MaNhaPhanPhoi = qMaNPP;
npp.TenNhaPhanPhoi = qTenNPP;
npp.DiaChi = qDiaChi;
npp.SDT = qDienThoai;
npp.Email = qEmail;
qlhh.NhaPhanPhois.InsertOnSubmit(npp);
qlhh.SubmitChanges();
return(1);
}
else
{
return(0);
}
}
public NhaPhanPhoi GetDataFromDialog()
{
NhaPhanPhoi nhaPhanPhoi = new NhaPhanPhoi(txtMaNPP.Text, txtTenNPP.Text, txtLoaiNPP.Text, txtDiaChi.Text, txtSDT.Text);
return(nhaPhanPhoi);
}
public int Update(NhaPhanPhoi obj)
{
return(dao.Update(obj));
}
public int Insert(NhaPhanPhoi obj)
{
return(dao.Insert(obj));
}
