private void btThem_Click(object sender, EventArgs e)
{
if (nudSoLuong.Value > 0)
{
decimal gia = Convert.ToDecimal(lvDSXe.SelectedItems[0].SubItems[7].Text);
int sl = Convert.ToInt32(nudSoLuong.Value.ToString());
decimal tong = gia * sl;
lvi = new ListViewItem();
lvi.Text = lbXuatMaHoaDon.Text;
lvi.SubItems.Add(lvDSXe.SelectedItems[0].SubItems[0].Text);
lvi.SubItems.Add(lvDSXe.SelectedItems[0].SubItems[1].Text);
lvi.SubItems.Add(sl.ToString());
lvi.SubItems.Add(gia.ToString());
lvi.SubItems.Add(tong.ToString());
lvi.SubItems.Add(dtmNgayHD.Value.ToShortDateString());
lvi.SubItems.Add(lvDSXe.SelectedItems[0].SubItems[0].Text);
CTHDController.cthd_moi = CTHDC.themCTHD(lvi);
lvXeDaChon.Items.Add(CTHDController.cthd_moi);
Xe x = new Xe();
x = db.Xes.Where(s => s.maXe == lvDSXe.SelectedItems[0].SubItems[0].Text).Single();
x.soLuong -= sl;
db.SubmitChanges();
capNhap();
lvDSXe.SelectedItems.Clear();
nudSoLuong.Enabled = false;
nudSoLuong.Value = 0;
tinh_tong_tien_listview();
}
else
{
MessageBox.Show("Nhập Số Lượng Lớn Hơn 0", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
//them ncc vao database
public void themTTNSX(ListViewItem lvi_nsx, DateTimePicker ngaySX)
{
NhaSanXuat n = new NhaSanXuat();
n.maNSX = lvi_nsx.Text.ToString();
n.tenNSX = lvi_nsx.SubItems[1].Text;
n.nuocSX = lvi_nsx.SubItems[2].Text;
n.email = lvi_nsx.SubItems[3].Text;
n.namSX = Convert.ToDateTime(ngaySX.Value.ToShortDateString());
db.NhaSanXuats.InsertOnSubmit(n);
db.SubmitChanges();
}
//thay doi mat khau
public void thayDoiMK(string ma, string mk)
{
var tk = from taiKhoan in db.TaiKhoans
where taiKhoan.taiKhoan1 == ma
select taiKhoan;
foreach (TaiKhoan taiKhoan in tk)
{
taiKhoan.matKhau = mk;
}
db.SubmitChanges();
}
//them kh trong database
public void themTTKH(ListViewItem lvi_kh)
{
KhachHang k = new KhachHang();
k.maKhachHang = lvi_kh.Text.ToString();
k.tenKhachHang = lvi_kh.SubItems[1].Text;
k.soDienThoai = lvi_kh.SubItems[2].Text;
k.CMND = lvi_kh.SubItems[3].Text;
k.diaChiKhachHang = lvi_kh.SubItems[4].Text;
db.KhachHangs.InsertOnSubmit(k);
db.SubmitChanges();
}
//them xe trong database
public void themTTXe(ListViewItem lvi_Xe, string sl, string dungTich, string gN, DateTimePicker ngayNhap, string mau, string ncc, string nsx)
{
Xe k = new Xe();
k.maXe = lvi_Xe.Text.ToString();
k.nhanHieu = lvi_Xe.SubItems[1].Text;
k.maMau = db.MauXes.First(x => x.tenMau == mau).maMau;
k.dungTich = Convert.ToInt32(dungTich);
k.maNCC = db.NhaCungCaps.First(x => x.tenNCC == ncc).maNCC;
k.maNSX = Convert.ToString(nsx);
k.soLuong = Convert.ToInt32(sl);
k.giaNhap = Convert.ToDecimal(gN);
k.ngayNhap = Convert.ToDateTime(ngayNhap.Value.ToString());
db.Xes.InsertOnSubmit(k);
db.SubmitChanges();
}
public void Luu_HD(ListView.ListViewItemCollection list_cthd, string mahd, DateTimePicker ngay_dat_hang)
{
List <ListViewItem> ds = TTNV.NhanTT();
HoaDonXe hd = new HoaDonXe();
hd.maHoaDon = Convert.ToString(mahd);
hd.maNhanVien = ds[0].SubItems[0].Text;
hd.maKhachHang = frmQuanLyKhachHang.lvi_KH.SubItems[0].Text;
db.HoaDonXes.InsertOnSubmit(hd);
db.SubmitChanges();
foreach (ListViewItem lvi in list_cthd)
{
CTHoaDonXe cthd = new CTHoaDonXe();
cthd.maHoaDon = hd.maHoaDon;
cthd.maXe = lvi.SubItems[7].Text;
cthd.soLuong = Convert.ToInt32(lvi.SubItems[3].Text);
cthd.donGia = Convert.ToDecimal(lvi.SubItems[4].Text);
cthd.thanhTien = Convert.ToDecimal(lvi.SubItems[5].Text);
cthd.ngayLap = Convert.ToDateTime(ngay_dat_hang.Value.ToShortDateString());
db.CTHoaDonXes.InsertOnSubmit(cthd);
db.SubmitChanges();
}
}
public void them(ListViewItem lvi_ncc)
{
db.NhaCungCaps.InsertOnSubmit(themTTNCC(lvi_ncc));
db.SubmitChanges();
}
public void them(ListViewItem lvi_mx)
{
db.MauXes.InsertOnSubmit(themTTMX(lvi_mx));
db.SubmitChanges();
}
