public static void Sua(string MaNCC, string TenNCC, string MaKhuVuc, string DiaChi, int MaSoThue, string DienThoai, string Mobile, string Email, string TaiKhoan, int GioiHanNo, int Fax, string NganHang, string Website, int NoHienTai, string ChucVu, string NguoiLienHe, int ChietKhau, bool ConQuanLy)
{
var db = new PerfectAppEntities();
NhaCungCap n = db.NhaCungCaps.FirstOrDefault(p => p.MaNCC == MaNCC);
n.MaNCC = MaNCC;
n.TenNCC = TenNCC;
n.MaKhuVuc = MaKhuVuc;
n.DiaChi = DiaChi;
n.MaSoThue = MaSoThue;
n.DienThoai = DienThoai;
n.Mobile = Mobile;
n.Email = Email;
n.Website = Website;
n.NganHang = NganHang;
n.TaiKhoan = TaiKhoan;
n.NguoiLienHe = NguoiLienHe;
n.NoHienTai = NoHienTai;
n.GioiHanNo = GioiHanNo;
n.Fax = Fax;
n.ChietKhau = ChietKhau;
n.ConQuanLy = ConQuanLy;
n.ChucVu = ChucVu;
n.MaSoThue = MaSoThue;
db.SaveChanges();
}
public static HangHoa LayChiTiet(string MaHang)
{
var db = new PerfectAppEntities();
HangHoa hh = db.HangHoas.FirstOrDefault(h => h.MaHang == MaHang);
return(hh);
}
public static KhachHang ChiTietKH(string MaKH)
{
var db = new PerfectAppEntities();
KhachHang kh = db.KhachHangs.FirstOrDefault(k => k.MaKH == MaKH);
return(kh);
}
public static void Xoa(string MaHang)
{
var db = new PerfectAppEntities();
HangHoa hh = db.HangHoas.FirstOrDefault(h => h.MaHang == MaHang);
db.HangHoas.Remove(hh);
db.SaveChanges();
}
public static void Xoa(string MaKH)
{
var db = new PerfectAppEntities();
KhachHang kh = db.KhachHangs.Where(k => k.MaKH == MaKH).First();
db.KhachHangs.Remove(kh);
db.SaveChanges();
}
public static void Xoa(string Ma)
{
var db = new PerfectAppEntities();
var rs = db.KhuVucs.Where(k => k.MaKhuVuc == Ma).First();
db.KhuVucs.Remove(rs);
db.SaveChanges();
}
public static void Sua(string Ma, string Ten, string GhiChu, bool ConQuanLy)
{
var db = new PerfectAppEntities();
var rs = db.KhuVucs.Where(k => k.MaKhuVuc == Ma).First();
rs.TenKhuVuc = Ten;
rs.GhiChu = GhiChu;
rs.ConQuanLy = ConQuanLy;
db.SaveChanges();
}
public static bool CheckUser(string username, string password)
{
bool kq = false;
var db = new PerfectAppEntities();
var rs = db.UserIDs.SingleOrDefault(u => u.username == username && u.password == password);
if (rs != null)
{
kq = true;
}
return(kq);
}
public static void Them(string Ma, string Ten, string GhiChu, bool ConQuanLy)
{
KhuVuc kv = new KhuVuc();
kv.MaKhuVuc = Ma;
kv.TenKhuVuc = Ten;
kv.GhiChu = GhiChu;
kv.ConQuanLy = ConQuanLy;
var db = new PerfectAppEntities();
db.KhuVucs.Add(kv);
db.SaveChanges();
}
public static void Them(string MaPhieu, string MaHang, string MaDonVi, int SoLuong, double DonGia, string GhiChu)
{
var db = new PerfectAppEntities();
ChiTietPhieuNhapHang ct = new ChiTietPhieuNhapHang();
ct.MaPhieu = MaPhieu;
ct.MaHang = MaHang;
ct.MaDonVi = MaDonVi;
ct.SoLuong = SoLuong;
ct.DonGia = DonGia;
ct.GhiChu = GhiChu;
db.ChiTietPhieuNhapHangs.Add(ct);
db.SaveChanges();
}
public static List <PhieuTempDTO> DanhSachHangHienThi()
{
var db = new PerfectAppEntities();
var rs = (from dv in db.DonViTinhs
join hh in db.HangHoas on dv.MaDV equals hh.MaDV
select new PhieuTempDTO
{
MaHang = hh.MaHang,
TenHang = hh.TenHang,
MaDonVi = hh.MaDV,
TenDonVi = dv.Ten
}).ToList();
return(rs);
}
public static string LayMaHH()
{
string Ma;
var db = new PerfectAppEntities();
Ma = db.HangHoas.OrderByDescending(k => k.MaHang).FirstOrDefault().MaHang;
if (Ma != null)
{
Ma = XuLyChuoi.LayChuoi(Ma);
}
else
{
Ma = "HH0001";
}
return(Ma);
}
public static string LayMaPhieu()
{
string kq = "";
var db = new PerfectAppEntities();
var rs = db.PhieuNhapHangs.OrderByDescending(p => p.MaPhieu).FirstOrDefault();
if (rs != null)
{
kq = XuLyChuoi.LayChuoi(rs.MaPhieu);
}
else
{
kq = "PNH0001";
}
return(kq);
}
public static List <KhuVucDTO> DanhSach()
{
List <KhuVucDTO> lst = new List <KhuVucDTO>();
var db = new PerfectAppEntities();
foreach (var row in db.KhuVucs)
{
KhuVucDTO kv = new KhuVucDTO();
kv.MaKhuVuc = row.MaKhuVuc;
kv.TenKhuVuc = row.TenKhuVuc;
kv.GhiChu = row.GhiChu;
kv.ConQuanLy = row.ConQuanLy;
lst.Add(kv);
}
return(lst);
}
public static string LayMaNCC()
{
string Ma;
var db = new PerfectAppEntities();
Ma = db.NhaCungCaps.OrderByDescending(k => k.MaNCC).FirstOrDefault().MaNCC;
if (Ma != null)
{
Ma = XuLyChuoi.LayChuoi(Ma);
}
else
{
Ma = "NCC0001";
}
return(Ma);
}
public static string MaKhuVuc()
{
string Ma;
var db = new PerfectAppEntities();
Ma = db.KhuVucs.OrderByDescending(k => k.MaKhuVuc).FirstOrDefault().MaKhuVuc;
if (Ma != null)
{
Ma = XuLyChuoi.LayChuoi(Ma);
}
else
{
Ma = "KV0001";
}
return(Ma);
}
public static void Sua(string MaKH, string MaKV, string TenKH, string DiaChi, string MaSoThue, string DienThoai, string Email, string TaiKhoan, int GioiHanNo, int NoHienTai, string NganHang, string NguoiLienHe, bool ConQuanLy)
{
var db = new PerfectAppEntities();
KhachHang kh = db.KhachHangs.Where(k => k.MaKH == MaKH).First();
kh.MaKH = MaKH;
kh.MaKhuVuc = MaKV;
kh.TenKH = TenKH;
kh.DiaChi = DiaChi;
kh.MaSoThue = MaSoThue;
kh.DienThoai = DienThoai;
kh.Email = Email;
kh.TaiKhoan = TaiKhoan;
kh.GioiHanNo = GioiHanNo;
kh.NoHienTai = NoHienTai;
kh.NganHang = NganHang;
kh.NguoiLienHe = NguoiLienHe;
kh.ConQuanLy = ConQuanLy;
db.SaveChanges();
}
public static void Them(string MaPhieu, string MaNCC, string DiaChi, string DienThoai, DateTime Ngay, string GhiChu, string SoHoaDonVAT, string SoHoaDonVietTay, string MaNV, string MaKho, string MaDKTT, string MaHTTT, DateTime HTT)
{
var db = new PerfectAppEntities();
PhieuNhapHang a = new PhieuNhapHang();
a.MaPhieu = MaPhieu;
a.MaNCC = MaNCC;
a.DiaChi = DiaChi;
a.DienThoai = DienThoai;
a.Ngay = Ngay;
a.GhiChu = GhiChu;
a.SoHoaDonVAT = SoHoaDonVAT;
a.SoHoaDonVietTay = SoHoaDonVietTay;
a.MaNV = MaNV;
a.MaKho = MaKho;
a.MaDKTT = MaDKTT;
a.MaHTTT = MaHTTT;
a.HanTT = HTT;
db.PhieuNhapHangs.Add(a);
db.SaveChanges();
}
public static List <NhaCungCapDTO> DanhSach()
{
var db = new PerfectAppEntities();
var rs = (from n in db.NhaCungCaps
join k in db.KhuVucs on n.MaKhuVuc equals k.MaKhuVuc
select new NhaCungCapDTO()
{
MaNCC = n.MaNCC,
TenNCC = n.TenNCC,
TenKhuVuc = k.TenKhuVuc,
DiaChi = n.DiaChi,
DiDong = n.Mobile,
DienThoai = n.DienThoai,
Fax = n.Fax,
ConQuanLy = n.ConQuanLy,
NguoiLienHe = n.NguoiLienHe,
ChucVu = n.ChucVu
}).ToList();
return(rs);
}
public static void Sua(string MaHang, string TenHang, string MaPhanLoaiHangHoa, string MaLoaiHangHoa, string MaKho, string MaVach, string MaDonVi, string MaNhaCC, string XuatXu, int TonKhoToiThieu, int TonKhoHienTai, double GiaMua, double GiaBanLe, double GiaBanSi, bool ConQuanLy)
{
var db = new PerfectAppEntities();
HangHoa hh = db.HangHoas.FirstOrDefault(h => h.MaHang == MaHang);
hh.MaHang = MaHang;
hh.TenHang = TenHang;
hh.MaPhanLoai = MaPhanLoaiHangHoa;
hh.MaLoaiHangHoa = MaLoaiHangHoa;
hh.MaKho = MaKho;
hh.MaVachNSX = MaVach;
hh.MaDV = MaDonVi;
hh.MaNCC = MaNhaCC;
hh.XuatXu = XuatXu;
hh.TonKhoToiThieu = TonKhoToiThieu;
hh.TonHienTai = TonKhoHienTai;
hh.GiaMua = GiaMua;
hh.GiaBanSi = GiaBanSi;
hh.GiaBanLe = GiaBanLe;
hh.ConQuanLy = ConQuanLy;
db.SaveChanges();
}
public static List <HangHoaDTO> DanhSach()
{
var db = new PerfectAppEntities();
var rs = (from hh in db.HangHoas
join dv in db.DonViTinhs on hh.MaDV equals dv.MaDV
join pl in db.PhanLoaiHangHoas on hh.MaPhanLoai equals pl.MaPhanLoai
join k in db.KhoHangs on hh.MaKho equals k.MaKho
select new HangHoaDTO()
{
MaHang = hh.MaHang,
TenHang = hh.TenHang,
TenDonVi = dv.Ten,
TenKho = k.Ten,
PhanLoaiHangHoa = pl.TenPhanLoai,
TonKhoToiThieu = hh.TonKhoToiThieu,
GiaMua = hh.GiaMua,
GiaBanLe = hh.GiaBanLe,
GiaBanSi = hh.GiaBanSi,
ConQuanLy = hh.ConQuanLy
}).ToList();
return(rs);
}
public static List <KhachHangDTO> DanhSach()
{
var db = new PerfectAppEntities();
var rs = (from kh in db.KhachHangs
join kv in db.KhuVucs on kh.MaKhuVuc equals kv.MaKhuVuc
select new KhachHangDTO()
{
MaKH = kh.MaKH,
TenKV = kv.TenKhuVuc,
TenKH = kh.TenKH,
DiaChi = kh.DiaChi,
MaSoThue = kh.MaSoThue,
DienThoai = kh.DienThoai,
Email = kh.Email,
TaiKhoan = kh.TaiKhoan,
GioiHanNo = kh.GioiHanNo,
NoHienTai = kh.NoHienTai,
NganHang = kh.NganHang,
NguoiLienHe = kh.NguoiLienHe,
ConQuanLy = kh.ConQuanLy
}).ToList();
return(rs);
}
public static BindingList <PhieuTemp> DanhSach()
{
var db = new PerfectAppEntities();
return(db.PhieuTemps.Local.ToBindingList());
}
public static List <HinhThucThanhToan> DanhSach()
{
var db = new PerfectAppEntities();
return(db.HinhThucThanhToans.ToList());
}
public static List <PhanLoaiHangHoa> DanhSach()
{
var db = new PerfectAppEntities();
return(db.PhanLoaiHangHoas.ToList());
}
public static List <DonViTinh> DanhSach()
{
var db = new PerfectAppEntities();
return(db.DonViTinhs.ToList());
}
public static List <NhomHang> DanhSach()
{
var db = new PerfectAppEntities();
return(db.NhomHangs.ToList());
}
public static List <DieuKhoanThanhToan> DanhSach()
{
var db = new PerfectAppEntities();
return(db.DieuKhoanThanhToans.ToList());
}
public static NhaCungCap LayChiTiet(string MaNCC)
{
var db = new PerfectAppEntities();
return(db.NhaCungCaps.FirstOrDefault(n => n.MaNCC == MaNCC));
}
public static List <NhanVien> DanhSach()
{
var db = new PerfectAppEntities();
return(db.NhanViens.ToList());
}
