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(); }