public bool ThemSanPham(clsSanPham_DTO sanPham)
{
string strMaSP = "SP" + (ThaoTacDuLieu.DemSoDongCuaBang("SanPham") + 1);
string query = string.Format("insert into SanPham values('{0}',N'{1}','{2}','{3}','{4}','{5}',N'{6}','{7}','{8}','{9}','{10}','{11}',N'{12}','{13}')", strMaSP, sanPham.TenSanPham, sanPham.Hinh, sanPham.GiaMua, sanPham.GiaBan, sanPham.KhuyenMai, sanPham.MoTa, sanPham.BaoHanh, sanPham.SoLuong, sanPham.DonViTinh, sanPham.MaLoaiSanPham, sanPham.MaHangSanXuat, sanPham.GhiChu, 1);
return(ThaoTacDuLieu.ThucThi(query));
}
public bool ThemNhanVien(clsNhanVien_DTO nhanvien)
{
string MaNV = "NV" + (ThaoTacDuLieu.DemSoDongCuaBang("NhanVien") + 1);
string query = string.Format("insert into NhanVien values('{0}',N'{1}','{2}','{3}','{4}',N'{5}','{6}','{7}','{8}','{9}','{10}','{11}')", MaNV, nhanvien.TenNV, nhanvien.TenDangNhap, nhanvien.MatKhau, nhanvien.Hinh, nhanvien.DiaChi, nhanvien.CMND, nhanvien.SDT, nhanvien.Email, nhanvien.Quyen, "", 1);
return(ThaoTacDuLieu.ThucThi(query));
}
public bool ThemLoai(clsLoai_DTO loai)
{
string strMaLoai = "LSP" + (ThaoTacDuLieu.DemSoDongCuaBang("LoaiSanPham") + 1);
string query = string.Format("insert into LoaiSanPham values('{0}',N'{1}',N'{2}','{3}')", strMaLoai, loai.TenLoaiSanPham, loai.GhiChu, 1);
return(ThaoTacDuLieu.ThucThi(query));
}
public bool ThemHSX(clsHangSanXuat_DTO HSX)
{
string strMaHSX = "HSX" + (ThaoTacDuLieu.DemSoDongCuaBang("HangSanXuat") + 1);
string query = string.Format("insert into HangSanXuat values('{0}',N'{1}',N'{2}','{3}')", strMaHSX, HSX.TenHangSanXuat, HSX.GhiChu, 1);
return(ThaoTacDuLieu.ThucThi(query));
}
public string TaoPhieuNhap(clsPhieuNhap_DTO phieuNhap)
{
string strMaPhieu = "PN" + (ThaoTacDuLieu.DemSoDongCuaBang("PhieuNhap") + 1);
string query = string.Format("insert into PhieuNhap values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}',1,1)", strMaPhieu, phieuNhap.MaNhaCungCap, phieuNhap.TongTien, phieuNhap.TienNo, phieuNhap.ChietKhau, phieuNhap.Thue, phieuNhap.NgayLap, phieuNhap.MaNVLap, phieuNhap.GhiChu);
ThaoTacDuLieu.ThucThi(query);
return(strMaPhieu);
}
public string ThemBaoHanh(clsBaoHanh_DTO baoHanh)
{
string strMaBH = "BH" + (ThaoTacDuLieu.DemSoDongCuaBang("BaoHanh") + 1);
string query = string.Format("insert into BaoHanh values('{0}','{1}','{2}','{3}',1)", strMaBH, baoHanh.MaKhachHang, baoHanh.MaNhanVien, baoHanh.NgayBaoHanh);
ThaoTacDuLieu.ThucThi(query);
return(strMaBH);
}
public string ThemNCC(clsNhaCungCap_DTO NCC)
{
string strMaNCC = "NCC" + (ThaoTacDuLieu.DemSoDongCuaBang("NhaCungCap") + 1);
string query = string.Format("insert into NhaCungCap values('{0}',N'{1}',N'{2}',N'{3}',N'{4}',1)", strMaNCC, NCC.TenNhaCungCap, NCC.DiaChi, NCC.SoDT, NCC.GhiChu);
ThaoTacDuLieu.ThucThi(query);
return(strMaNCC);
}
public void ThemSoSerial(string strMaSP, int iSL, string strMaPhieu)
{
for (int i = 0; i < iSL; i++)
{
string strMaSR = "SER" + (ThaoTacDuLieu.DemSoDongCuaBang("Serial") + 1);
string strSoSerial = PhatSinhSerial();
string query = string.Format("insert into Serial values('{0}','{1}',NULL,'{2}',NULL,NULL,'{3}',1)", strMaSR, strSoSerial, strMaSP, strMaPhieu);
ThaoTacDuLieu.ThucThi(query);
}
}
public string ThemKhachHang(clsKhachHang_DTO khachHang) // thêm và lấy id kh về để thêm vào hoá đơn
{
string strMaKH = "KH" + (ThaoTacDuLieu.DemSoDongCuaBang("KhachHang") + 1);
SqlConnection conn = ThaoTacDuLieu.TaoVaMoKetNoi();
string query = string.Format("insert into KhachHang values (N'{0}',N'{1}',N'{2}',N'{3}',N'{4}',N'{5}','{6}')", strMaKH, khachHang.TenKhachHang, khachHang.CMND, khachHang.SoDT, khachHang.DiaChi, khachHang.GhiChu, 1);
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();
ThaoTacDuLieu.DongKetNoi(conn);
return(strMaKH);
}
public string TaoPhieuXuat(clsPhieuXuat_DTO phieuXuat)
{
int iResult = 0;
SqlConnection conn = ThaoTacDuLieu.TaoVaMoKetNoi();
string strMaPhieu = "PX" + (ThaoTacDuLieu.DemSoDongCuaBang("PhieuXuat") + 1); // Tạo mã mới
string sqlInsertPhieu = string.Format("insert into PhieuXuat values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}',1)", strMaPhieu, phieuXuat.MaKhachHang, phieuXuat.TongTien, phieuXuat.ChietKhau, phieuXuat.Thue, phieuXuat.NgayLap, phieuXuat.MaNVLap, phieuXuat.GhiChu, phieuXuat.Loai);
SqlCommand cmd = new SqlCommand(sqlInsertPhieu, conn);
iResult = cmd.ExecuteNonQuery();
ThaoTacDuLieu.DongKetNoi(conn);
return(strMaPhieu);
}
public bool ThemSoLuongSP(string strMaSP, int SL)
{
string queryUpdateSP = string.Format("update SanPham set SoLuong={1} where MaSanPham='{0}'", strMaSP, SL);
if (ThaoTacDuLieu.ThucThi(queryUpdateSP))
{
int SoDong = 0;
for (int i = 0; i < SL; i++)
{
string SoSR = TienIch.GenerateSerial(12);
SoDong = ThaoTacDuLieu.DemSoDongCuaBang("Serial");
string MaSR = "SER" + (SoDong + 1);
ThaoTacDuLieu.ThucThi(string.Format("insert into Serial values('{0}','{1}',NULL,'{2}',NULL,{3})", MaSR, SoSR, strMaSP, 1));
}
return(true);
}
else
{
return(false);
}
}