public bool insertHieuXe(Entity_HieuXe _hx)
{
try
{
string strSQL = "SP_INSERT_HIEUXE";
string[] pNames = { "@maHx", "@tenHx" };
object[] pValues = { _hx.MaHx, _hx.TenHx };
int count = con.ExecuteStoredProcedure(strSQL, pNames, pValues);
if (count >= 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool insertKhachHang(Entity_KhachHang _kh)
{
try
{
const string strSQL = "SP_INSERT_KHACHHANG";
string[] pNames = { "@id", "@ten", "@sdt", "@email", "@diaChi", "@ngaySinh", "@gender", "@congNo" };
object[] pValues = { _kh.KhId, _kh.Ten, _kh.Sdt, _kh.Email, _kh.DiaChi, _kh.NgaySinh, _kh.GioiTinh, _kh.CongNo };
int count = con.ExecuteStoredProcedure(strSQL, pNames, pValues);
if (count >= 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool insertDongXe(Entity_DongXe _dx)
{
try
{
const string strSQL = "SP_INSERT_DONGXE";
string[] pNames = { "@id", "@hieuXe", "@tskt" };
object[] pValues = { _dx.DongXeId, _dx.HieuXe, _dx.Tskt };
int count = con.ExecuteStoredProcedure(strSQL, pNames, pValues);
if (count >= 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool insertXe(Entity_Xe _xe)
{
try
{
const string strSQL = "SP_INSERT_XE";
string[] pNames = { "@bs", "@userId", "@ngayTN", "@dongXeId", "@mau", "@mota", "@mauTrong", "@namXX", "@xuatXu" };
object[] pValues = { _xe.BienSo, _xe.User_id, _xe.NgayTn, _xe.DongXeId, _xe.MauXe, _xe.MoTa, _xe.MauNoiThat, _xe.NamSx, _xe.XuatSu };
int count = con.ExecuteStoredProcedure(strSQL, pNames, pValues);
if (count >= 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool insertCTPSC(Entity_CTPSC _ct)
{
try
{
const string strSQL = "SP_INSERT_CTPSC";
string[] pNames = { "@maPsc", "@maVt", "@sl" };
object[] pValues = { _ct.MaPsc, _ct.MaVt, _ct.SoLuong };
int count = con.ExecuteStoredProcedure(strSQL, pNames, pValues);
if (count >= 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool insertUser(Entity_User us)
{
try
{
string strSQL = "SP_REGISTER";
string[] pNames = { "@username", "@email", "@pass", "@role", "@gender", "@birthday", "@full_name", "@phone", "@direction" };
object[] pValues = { us.Username, us.Email, us.Pass, us.Role, us.Gender, us.Birthday, us.FullName, us.Phone, us.Direction };
int count = con.ExecuteStoredProcedure(strSQL, pNames, pValues);
if (count >= 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool insertVatTu(Entity_VatTu _vt)
{
try
{
const string strSQL = "SP_INSERT_VATTU";
string[] pNames = { "@maVt", "@tenVt", "@donGia", "@sl" };
object[] pValues = { _vt.MaVt, _vt.TenVt, _vt.DonGia, _vt.SoLuong };
int count = con.ExecuteStoredProcedure(strSQL, pNames, pValues);
if (count >= 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool insertPSC(Entity_PhieuSuaChua _psc)
{
try
{
const string strSQL = "SP_INSERT_PSC";
string[] pNames = { "@maPsc", "@bs", "@uid" };
object[] pValues = { _psc.MaPsc, _psc.BienSo, _psc.User_id };
int count = con.ExecuteStoredProcedure(strSQL, pNames, pValues);
if (count >= 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool delObject(string obj)
{
try
{
const string strSQL = "SP_DEL_NHACUNGCAP";
string[] pNames = { "@id" };
object[] pValues = { obj };
int count = con.ExecuteStoredProcedure(strSQL, pNames, pValues);
if (count >= 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool insertHoaDon(Entity_PhieuThanhToan _ptt)
{
try
{
const string strSQL = "SP_INSERT_HOADON";
string[] pNames = { "@maPtt", "@maPsc" };
object[] pValues = { _ptt.MaPtt, _ptt.MaPsc };
int count = con.ExecuteStoredProcedure(strSQL, pNames, pValues);
if (count >= 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
