public bool them(CHITIETHOADONBAN pmh)
{
try
{
data.CHITIETHOADONBANs.InsertOnSubmit(pmh);
data.SubmitChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool xoa(CHITIETHOADONBAN pmh)
{
try
{
CHITIETHOADONBAN mh = data.CHITIETHOADONBANs.Where(t => t.MACTHDB == pmh.MACTHDB.ToString()).FirstOrDefault();
data.CHITIETHOADONBANs.DeleteOnSubmit(mh);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool ktkc(CHITIETHOADONBAN ma)
{
int r = data.CHITIETHOADONBANs.Count(t => t.MACTHDB == ma.MACTHDB.ToString());
try
{
if (r == 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
private void buttonX3_Click(object sender, EventArgs e)
{
try
{
CHITIETHOADONBAN bb = new CHITIETHOADONBAN();
if (txtmacthdb.Text == "" || txtmahd.Text == "" || txtmasp.Text == "" || cbososize.Text == "" || txtmabh.Text == "" ||
kHUYENMAIComboBox.Text == "" || txtsl.Text == "" || txtdongia.Text == "")
{
MessageBox.Show("không được để trống");
return;
}
var ktpbh = (
from ct in db.PHIEUBAOHANHs
where ct.MABH == txtmabh.Text.ToString()
select bb).Count();
if (ktpbh == 0)
{
frm_BaoHanh bh = new frm_BaoHanh();
bh.ShowDialog();
}
var kt = from s in db.CHITIETHOADONBANs where s.MACTHDB == txtmacthdb.Text select s;
if (kt.Count() > 0)
{
MessageBox.Show("Trùng khóa chính");
return;
}
bb.MACTHDB = txtmacthdb.Text;
bb.MAHD = txtmahd.Text;
bb.MASP = txtmasp.Text;
bb.SOSIZE = Convert.ToInt16(cbososize.Text);
bb.MABH = txtmabh.Text;
bb.MAKM = kHUYENMAIComboBox.SelectedValue.ToString();
bb.SOLUONGBAN = Convert.ToInt32(txtsl.Text);
bb.DONGIABAN = Convert.ToDouble(txtdongia.Text);
db.CHITIETHOADONBANs.InsertOnSubmit(bb);
db.SubmitChanges();
insert();
MessageBox.Show("Thành công");
}
catch
{
return;
}
}
public bool xoacthdb(CHITIETHOADONBAN n)
{
return(hd.xoa(n));
}
public bool themcthd(CHITIETHOADONBAN n)
{
return(hd.them(n));
}
public bool Xoa_CTHDB(CHITIETHOADONBAN cthdb)
{
return(dal_BanHang.xoa_CTHDB(cthdb));
}
public bool KTKC_cthdb(CHITIETHOADONBAN cthdb)
{
return(dal_BanHang.ktkc_cthdb(cthdb));
}
public bool them_CTHDB(CHITIETHOADONBAN cthdb)
{
return(dal_BanHang.them_CTHoaDonBan(cthdb));
}
private void buttonX2_Click(object sender, EventArgs e)
{
try
{
Double t = 0;
CHITIETHOADONBAN hdb = new CHITIETHOADONBAN();
hdb.MACTHDB = dgv_cthdb.CurrentRow.Cells[0].Value.ToString();
hdb.MAHD = dgv_cthdb.CurrentRow.Cells[1].Value.ToString();
hdb.MASP = dgv_cthdb.CurrentRow.Cells[2].Value.ToString();
PHIEUBAOHANH pbh = new PHIEUBAOHANH();
pbh.MABH = dgv_cthdb.CurrentRow.Cells[4].Value.ToString();
Double money = Convert.ToDouble(dgv_cthdb.CurrentRow.Cells[6].Value.ToString()) * Convert.ToDouble(dgv_cthdb.CurrentRow.Cells[7].Value.ToString());
KHO kh = new KHO();
kh.MASP = dgv_cthdb.CurrentRow.Cells[2].Value.ToString();
int ktkho = bll_hdb.capnhatkho1(dgv_cthdb.CurrentRow.Cells[2].Value.ToString(), Convert.ToInt32(dgv_cthdb.CurrentRow.Cells[6].Value.ToString()));
kh.SOLUONG = ktkho;
if (bll_cthd.xoacthdb(hdb) == true)
{
MessageBox.Show("xóa thành công");
dgv_cthdb.DataSource = bll_cthd.loadbangghep_cthd();
if (bh_bll.xoapbh(pbh) == true)
{
MessageBox.Show("xóa phiếu bảo hành thành công");
}
else
{
MessageBox.Show("xóa phiếu bảo hành thất bại");
}
if (kho_bll.ktkc_kho(kh) == false)
{
if (kho_bll.suakho(kh) == true)
{
MessageBox.Show("cập nhật kho thành công");
}
}
Double tt = 0;
HOADONBAN hdb1 = new HOADONBAN();
hdb1.MAHD = txt_mahd.Text.ToString();
hdb1.NGAYLAP = Convert.ToDateTime(dateEdit_NgayLap.Text.ToString());
hdb1.MANV = txt_nvlap.Text.ToString();
if (radioButton1.Checked == true)
{
hdb1.MAKHTT = txt_khtt.Text.ToString();
tt = Convert.ToDouble(txt_chietkhau.Text.ToString());
Double gtbd = (1 - Convert.ToDouble(txt_mucgiam.Text.ToString())) / Convert.ToDouble(txt_tinhtranghang.Text.ToString());
hdb1.TONGTIEN = (gtbd - (money - (money * Convert.ToDouble(txt_mucgiam.Text.ToString())))) - (gtbd + (money - (money * Convert.ToDouble(txt_mucgiam.Text.ToString())))) * tt;
}
else
{
tt = 0;
hdb1.TONGTIEN = Convert.ToDouble(txt_tinhtranghang.Text.ToString()) - (money - (money * Convert.ToDouble(txt_mucgiam.Text.ToString())));
hdb1.KHVANGLAI = txt_kvl.Text.ToString();
}
hdb1.CHIECKHAU = tt;
if (bll_hdb.ktkc_hdb(hdb1) == false)
{
if (bll_hdb.suahdb(hdb1) == true)
{
MessageBox.Show("sửa thành công");
dgv_hdb.DataSource = bll_hdb.loadbang_hdb();
}
else
{
MessageBox.Show("thất bại");
}
}
else
{
MessageBox.Show("hóa đơn này chưa tồn tại");
}
}
else
{
MessageBox.Show("thất bại");
}
}
catch
{
return;
}
}
private void buttonX1_Click(object sender, EventArgs e)
{
try
{
Double t = 0;
CHITIETHOADONBAN hdb = new CHITIETHOADONBAN();
int b = 0;
for (int i = 1; i <= dgv_cthdb.RowCount; i++)
{
b = i;
}
hdb.MACTHDB = "CTHD" + (b + 1).ToString() + DateTime.Now.Second.ToString();
hdb.MAHD = dgv_hdb.CurrentRow.Cells[0].Value.ToString();
hdb.MASP = txt_msp.Text.ToString();
PHIEUBAOHANH pbh = new PHIEUBAOHANH();
String tem = DateTime.Now.ToString();
pbh.MABH = tem;
pbh.MASP = txt_msp.Text.ToString();
pbh.NGAYHETHANDOITRA = DateTime.Now.AddDays(7);
hdb.MAKM = null;
hdb.SOLUONGBAN = Convert.ToInt32(txt_sldat.Text.ToString());
hdb.DONGIABAN = bll_hdb.laygiasp(txt_msp.Text.ToString());
Double money = Convert.ToDouble(txt_sldat.Text.ToString()) * Convert.ToDouble(txt_gia.Text.ToString());
hdb.SIZEGIAY = Convert.ToInt32(cb_sizegiay.Text.ToString());
KHO kh = new KHO();
kh.MASP = txt_msp.Text.ToString();
int ktkho = bll_hdb.capnhatkho(txt_msp.Text.ToString(), Convert.ToInt32(txt_sldat.Text.ToString()));
if (ktkho >= 0)
{
kh.SOLUONG = ktkho;
}
else
{
MessageBox.Show("số lượng không đủ");
return;
}
if (bh_bll.thempbh(pbh) == true)
{
MessageBox.Show("thêm phiếu bảo hành thành công");
hdb.MABH = tem;
}
else
{
hdb.MABH = null;
}
if (bll_cthd.themcthd(hdb) == true)
{
MessageBox.Show("thêm thành công");
dgv_cthdb.DataSource = bll_cthd.loadbangghep_cthd();
if (kho_bll.ktkc_kho(kh) == false)
{
if (kho_bll.suakho(kh) == true)
{
MessageBox.Show("cập nhật kho thành công");
}
}
Double tt = 0;
HOADONBAN hdb1 = new HOADONBAN();
hdb1.MAHD = txt_mahd.Text.ToString();
hdb1.NGAYLAP = Convert.ToDateTime(dateEdit_NgayLap.Text.ToString());
hdb1.MANV = txt_nvlap.Text.ToString();
if (radioButton1.Checked == true)
{
hdb1.MAKHTT = txt_khtt.Text.ToString();
tt = Convert.ToDouble(txt_chietkhau.Text.ToString());
hdb1.TONGTIEN = (Convert.ToDouble(txt_tinhtranghang.Text.ToString()) + (money - (money * Convert.ToDouble(txt_mucgiam.Text.ToString())))) - (Convert.ToDouble(txt_tinhtranghang.Text.ToString()) + (money - (money * Convert.ToDouble(txt_mucgiam.Text.ToString())))) * tt;
}
else
{
tt = 0;
hdb1.TONGTIEN = Convert.ToDouble(txt_tinhtranghang.Text.ToString()) + (money - (money * Convert.ToDouble(txt_mucgiam.Text.ToString())));
hdb1.KHVANGLAI = txt_kvl.Text.ToString();
}
hdb1.CHIECKHAU = tt;
if (bll_hdb.ktkc_hdb(hdb1) == false)
{
if (bll_hdb.suahdb(hdb1) == true)
{
MessageBox.Show("sửa thành công");
dgv_hdb.DataSource = bll_hdb.loadbang_hdb();
}
else
{
MessageBox.Show("thất bại");
}
}
else
{
MessageBox.Show("hóa đơn này chưa tồn tại");
}
}
else
{
MessageBox.Show("thất bại");
}
}
catch
{
return;
}
}