public bool InsertHoaDon(string maHoaDon, string maKH, DateTime?ngayLap, decimal?tienHang, decimal?giamGia, decimal?thue, decimal?tongTien, string nhanVien) { try { HoaDon hoadon = new HoaDon { MaHoaDon = maHoaDon, MaKH = maKH, NgayLap = ngayLap, TienHang = tienHang, GiamGia = giamGia, Thue = thue, TongTien = tongTien, NhanVien = nhanVien }; context.HoaDon.Add(hoadon); context.SaveChanges(); return(true); } catch { return(false); } }
public bool InsertLoaiKH(string maLoaiKH, string tenLoaiKH, int chietKhau) { try { LoaiKH lkh = new LoaiKH { MaLoaiKH = maLoaiKH, TenLoaiKH = tenLoaiKH, ChietKhau = chietKhau }; context.LoaiKHs.Add(lkh); context.SaveChanges(); return(true); } catch { return(false); } }
public bool InsertNhaCC(string maNCC, string tenNCC, string diaChi, string sdt) { try { NhaCungCap ncc = new NhaCungCap { MaNCC = maNCC, TenNCC = tenNCC, DiaChi = diaChi, SDT = sdt, }; context.NhaCungCaps.Add(ncc); context.SaveChanges(); return(true); } catch { return(false); } }
public bool InsertHopDong(string soHopDong, string maNCC, DateTime?ngayKy, DateTime?thoiHanHopDong) { try { HopDong hd = new HopDong { SoHopDong = soHopDong, MaNCC = maNCC, NgayKy = ngayKy, ThoiHanHopDong = thoiHanHopDong }; context.HopDong.Add(hd); context.SaveChanges(); return(true); } catch { return(false); } }
public bool InsertCTHopDong(ref string err, string soHopDong, string maSP, int soLuong, decimal?donGia) { try { ChiTietHopDong cthd = new ChiTietHopDong { SoHopDong = soHopDong, MaSP = maSP, SoLuong = soLuong, DonGia = donGia, }; context.ChiTietHopDong.Add(cthd); context.SaveChanges(); return(true); } catch (Exception e) { err = e.Message; return(false); } }
public bool InsertCTHoaDon(ref string err, string maHoaDon, string maSP, int soLuong, decimal?donGia, int ck) { try { ChiTietHoaDon cthd = new ChiTietHoaDon { MaHoaDon = maHoaDon, MaSP = maSP, SoLuong = soLuong, DonGia = donGia, ChietKhau = ck }; context.ChiTietHoaDon.Add(cthd); context.SaveChanges(); return(true); } catch (Exception e) { err = e.Message; return(false); } }
public bool InsertProduct(string maSP, string tenSP, int?soLuong, decimal?giaMua, decimal?giaban, string donViTinh) { try { SanPham sp = new SanPham { MaSP = maSP, TenSP = tenSP, SoLuong = soLuong, GiaBan = giaban, GiaMua = giaMua, DonViTinh = donViTinh }; context.SanPhams.Add(sp); context.SaveChanges(); return(true); } catch { return(false); } }
public bool InsertCustomer(string maKH, string tenKH, DateTime?ngaySinh, string gioiTinh, string diaChi, string sdt, string maLoaiKH) { try { KhachHang kh = new KhachHang { MaKH = maKH, TenKH = tenKH, NgaySinh = ngaySinh, GioiTinh = gioiTinh, DiaChi = diaChi, SDT = sdt, MaLoaiKH = maLoaiKH }; context.KhachHang.Add(kh); context.SaveChanges(); return(true); } catch { return(false); } }
public bool InsertEmployee(string maNV, string tenNV, DateTime?ngaySinh, string sdt, string diaChi, string gioiTinh, decimal?luong) { try { NhanVien nv = new NhanVien { MaNV = maNV, HoTenNV = tenNV, NgaySinh = ngaySinh, SDT = sdt, DiaChi = diaChi, GioiTinh = gioiTinh, Luong = luong }; context.NhanViens.Add(nv); context.SaveChanges(); return(true); } catch { return(false); } }
public bool ChangePassword(ref string err, string user, string newPass) { try { TaiKhoan tk = context.TaiKhoans.Single(s => s.TenDangNhap.Equals(user)); tk.MatKhau = newPass; context.SaveChanges(); return(true); } catch (Exception e) { err = e.Message; return(false); } }