public int DeleteArea(string maKv)
{
string sql = string.Format("Delete from KhuVuc where MaKV = '{0}'", maKv);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int UpdateArea(string maKV, string tenKV, string ghiChu, bool active)
{
string sql = string.Format("Update KhuVuc set TenKV = N'{0}', GhiChu = N'{1}', Active = '{2}' where MaKV = '{3}'", tenKV, ghiChu, active, maKV);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int InsertArea(string maKV, string tenKV, string ghiChu, bool active)
{
string sql = string.Format("INSERT INTO KHUVUC Values(N'{0}', N'{1}', N'{2}', '{3}')", maKV, tenKV, ghiChu, active);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int UpdateTongTien(float tongTienMua, string maPhieu, float TongTienTra)
{
string sql = string.Format("UPDATE THONGTIN_PHIEUNHAPHANG SET TongTienMua = {0}, TongTienTra = {1} WHERE MaPhieu = '{2}'", tongTienMua, TongTienTra, maPhieu);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int UpdateIsCheck(string maPhieu, int isCheck)
{
string sql = string.Format("UPDATE [THONGTIN_PHIEU_BANHANG] SET IsCheck = {0} WHERE MaPhieu = '{1}' ", isCheck, maPhieu);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int InsertInforTranWarehouse(InforTransWarehouseDTO infor)
{
string sql = string.Format("INSERT INTO [THONGTIN_CHUYENKHO] VALUES('{0}', '{1}', '{2}', '{3}', N'{4}', '{5}', '{6}', N'{7}', {8})", infor.MaPhieuChuyen,
infor.MaKhoXuat, infor.MaKhoNhan, infor.NgayLap, infor.GhiChu, infor.MaNVXuat, infor.MaNVNhan, infor.SoPhieuChuyenTay, infor.TongTienChuyen);
return(ConnectionDB.ExcuteNonQuery(sql));
}
public int DeleteInforDetailBuy(string maPhieu)
{
string sql = string.Format("DELETE FROM THONGTIN_PHIEUNHAPHANG WHERE MaPhieu = '{0}' ", maPhieu);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int DeleteTonKhoHaveMaHang(string maHang)
{
string sql = string.Format("DELETE FROM TONKHO WHERE Mahang = '{0}'", maHang);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int DeleteDepartment(string mabp)
{
string sql = string.Format("Delete from BOPHAN where MaBP = '{0}'", mabp);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int DeleteListFromMa(string maNhomHang)
{
string sql = string.Format("Delete from [NHOMHANG] where MaNhom = '{0}'", maNhomHang);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int DeleteGood(string mahang)
{
string sql = string.Format("Delete from HANGHOA_DICHVU where MaHang = '{0}'", mahang);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int DeleteKhachHang(string Makh)
{
string sql = string.Format("Delete from KHACHHANG where MaKH = '{0}'", Makh);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int insertTonKho(TonKho tk, int sl)
{
string sql = string.Format("INSERT INTO TONKHO VALUES('{0}', N'{1}',{2},{3}, '{4}')", tk.MaKho, tk.MaHang, sl, 1, true);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int CapNhatMatKhau(string username, string newPass)
{
string sql = string.Format("update NGUOIDUNG set Password = '******' where TenDangNhap = '{1}'",
newPass, username);
return(ConnectionDB.ExcuteNonQuery(sql));
}
public int DeleteSupplierFromNCC(string maNCC)
{
string sql = string.Format("Delete from NCC where MaNCC = '{0}'", maNCC);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int DeleteDetailSell(string maPhieu)
{
string sql = string.Format("DELETE FROM CT_PHIEUXUAT WHERE [MaPhieuXuat] = '{0}' ", maPhieu);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int UpdateIsDeleteDetail(string maPhieu)
{
string sql = string.Format("UPDATE [CT_PHIEUXUAT] SET ISDELETE = {0} WHERE MaPhieu = '{1}' ", 0, maPhieu);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int UpdateInforTranWarehouse(InforTransWarehouseDTO infor)
{
string sql = string.Format("UPDATE [THONGTIN_CHUYENKHO] SET MaKhoXuat = '{0}', MaKhoNhan = '{1}',NgayLap = '{2}', GhiChu = N'{3}', MaNVXuat = '{4}', MaNVNhan = '{5}', SoPhieuChuyenTay = '{6}', TongTienChuyen = {7} WHERE MaPhieuChuyen = '{8}'",
infor.MaKhoXuat, infor.MaKhoNhan, infor.NgayLap, infor.GhiChu, infor.MaNVXuat, infor.MaNVNhan, infor.SoPhieuChuyenTay, infor.TongTienChuyen, infor.MaPhieuChuyen);
return(ConnectionDB.ExcuteNonQuery(sql));
}
public int DeleteInforDetailSell(string maPhieu)
{
string sql = string.Format("Delete from [THONGTIN_PHIEU_BANHANG] WHERE MaPhieu = '{0}' ", maPhieu);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int DeleteEmployees(string manv)
{
string sql = string.Format("Delete from _NHANVIEN where MaNV = '{0}'", manv);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int InsertDetailTransWarehouse(DetailTransWarehouseDTO detailTrans)
{
string sql = string.Format("INSERT INTO [CT_CHUYENKHO](MAPHIEUCHUYEN, MAHANG, TENHANG, DONVI, DONGIA, SOLUONG, THANHTIEN) VALUES('{0}', '{1}', N'{2}', N'{3}', {4}, {5}, {6})", detailTrans.MaPhieuChuyen,
detailTrans.MaHang, detailTrans.TenHang, detailTrans.DonVi, detailTrans.DonGia, detailTrans.SoLuong, detailTrans.ThanhTien);
return(ConnectionDB.ExcuteNonQuery(sql));
}
public int SuaVTCN(VaiTro_ChucNangDTO vtcn)
{
string sql = "update VAITRO_CHUCNANG " +
string.Format("set TatCa={0} , TruyCap={1} , Them={2} , Xoa={3} , Sua={4} , InAn={5} , Nhap={6} , Xuat={7} where MaVaiTro ='{8}' and MaChucNang={9}",
vtcn.TatCa, vtcn.TruyCap, vtcn.Them, vtcn.Xoa, vtcn.Sua, vtcn.InAn, vtcn.Nhap, vtcn.Xuat, vtcn.MaVaiTro, vtcn.MaChucNang);
return(ConnectionDB.ExcuteNonQuery(sql));
}
public int InsertDepartment(string mabp, string tenbp, string ghichu, bool active)
{
string id = IDAuto();
string sql = string.Format("INSERT INTO BOPHAN Values(N'{0}', N'{1}', N'{2}', '{3}')", id, tenbp, ghichu, active);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int ThemNguoiDung(NguoiDung nd)
{
int cql = nd.ConQuanLy == true ? 1 : 0;
string sql = string.Format("insert into NGUOIDUNG values(" +
"'{0}', '{1}', '{2}', '{3}', N'{4}', {5})", nd.TenDangNhap, nd.Password, nd.MaVaiTro, nd.MaNV, nd.DienGiai, cql);
return(ConnectionDB.ExcuteNonQuery(sql));
}
public int InsertDetailSell(DetailSellGoods detailSell)
{
string sql = string.Format("INSERT INTO CT_PHIEUXUAT VALUES('{0}', N'{1}', N'{2}', N'{3}'," +
" {4}, {5}, {6}, {7}, {8})", detailSell.MaPhieuXuat, detailSell.MaHang, detailSell.TenHang,
detailSell.DonVi, detailSell.SoLuong, detailSell.DonGia, detailSell.ThanhTien, detailSell.CK, detailSell.ThanhToan);
return(ConnectionDB.ExcuteNonQuery(sql));
}
public int SuaVaiTro(VaiTro vt)
{
int kichhoat = vt.KichHoat == true ? 1 : 0;
string sql = string.Format("update VAITRO " +
"set TenVaiTro = '{0}', DienGiai = N'{1}', KichHoat = {2} where MaVaiTro = '{3}'", vt.TenVaiTro, vt.DienGiai, kichhoat, vt.MaVaiTro);
return(ConnectionDB.ExcuteNonQuery(sql));
}
public int InsertNhomHang(string ma, string ten, string ghichu, bool active)
{
string id = IDAuto();
string sql = string.Format("INSERT INTO NHOMHANG Values(N'{0}', N'{1}', N'{2}', '{3}')", ma, ten, ghichu, active);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int InsertKhachHang(CustomerDTO cusDTO)
{
string sql = string.Format("INSERT INTO KHACHHANG values('{0}', N'{1}', N'{2}',N'{3}', N'{4}'," +
" N'{5}',N'{6}', N'{7}', N'{8}',N'{9}', N'{10}', N'{11}','{12}', N'{13}')", cusDTO.MaKH, cusDTO.TenKH, cusDTO.NguoiLienHe, cusDTO.DiaChi, cusDTO.DienThoai
, cusDTO.DiDong, cusDTO.Fax, cusDTO.Email, cusDTO.Website, cusDTO.MaSoThue, cusDTO.SoTK, cusDTO.TenNganHang, cusDTO.Active, cusDTO.MaKV);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int InsertDetailBuyGoods(DetailBuyGoods detailBuy)
{
string sql = string.Format("INSERT INTO [CT_PHIEUNHAP](MaPhieu, MaHang, TenHang, DonVi, SoLuong, DonGia, " +
"ThanhTien, GhiChu) " +
"VALUES ('{0}', '{1}', N'{2}',N'{3}', {4}, {5}, {6}, N'{7}')", detailBuy.MaPhieu,
detailBuy.MaHang, detailBuy.TenHang, detailBuy.DonVi, detailBuy.SoLuong, detailBuy.DonGia, detailBuy.ThanhTien, detailBuy.GhiChu);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
public int UpdateDetailBuy(DetailBuyGoods detailBuy)
{
string sql = string.Format("UPDATE [CT_PHIEUNHAP] set MaHang ='{1}' , TenHang = N'{2}', DonVi = N'{3}', SoLuong = {4}, DonGia = {5}, " +
"ThanhTien = {6}, GhiChu = N'{7}' WHERE MaPhieu = '{0}'"
, detailBuy.MaPhieu,
detailBuy.MaHang, detailBuy.TenHang, detailBuy.DonVi, detailBuy.SoLuong, detailBuy.DonGia, detailBuy.ThanhTien, detailBuy.GhiChu);
int check = ConnectionDB.ExcuteNonQuery(sql);
return(check);
}
