public int capnhap_tt_khachhang(string _tendangnhap, bool _trangthai, ref string errMsg)
{
try
{
errMsg = "";
int i = 0;
int result = 0;
SqlParameter[] prms = new SqlParameter[4];
prms[i] = new SqlParameter("@tendangnhap", _tendangnhap);
i = i + 1;
prms[i] = new SqlParameter("@trangthai", _trangthai);
i = i + 1;
prms[i] = new SqlParameter("@outreturn", SqlDbType.Int, 1);
prms[i].Direction = ParameterDirection.Output;
result = SQLExecute.ExcuteSPOutput("dbo.sp_trangthai_khachhang", ref prms, 3, ref errMsg, "@outreturn");
return(result);
}
catch (Exception ex)
{
errMsg = ex.Message;
return(0);
}
}
public int duyet_hoadon(string _mahoadon, bool _trangthai, ref string errMsg)
{
try
{
errMsg = "";
int i = 0;
int result = 0;
SqlParameter[] prms = new SqlParameter[4];
prms[i] = new SqlParameter("@mahoadon", _mahoadon);
i = i + 1;
prms[i] = new SqlParameter("@trangthai", _trangthai);
i = i + 1;
prms[i] = new SqlParameter("@outreturn", SqlDbType.Int, 1);
prms[i].Direction = ParameterDirection.Output;
result = SQLExecute.ExcuteSPOutput("dbo.sp_duyet_hoadon", ref prms, 3, ref errMsg, "@outreturn");
return(result);
}
catch (Exception ex)
{
errMsg = ex.Message;
return(0);
}
}
public int update_soluong_sp(int _masp, int _ma_size, int _soluong, ref string errMsg)
{
try
{
errMsg = "";
int i = 0;
int result = 0;
SqlParameter[] prms = new SqlParameter[5];
prms[i] = new SqlParameter("@MaSP", _masp);
i = i + 1;
prms[i] = new SqlParameter("@MaSize", _ma_size);
i = i + 1;
prms[i] = new SqlParameter("@SoLuong", _soluong);
i = i + 1;
prms[i] = new SqlParameter("@outreturn", SqlDbType.Int, 1);
prms[i].Direction = ParameterDirection.Output;
result = SQLExecute.ExcuteSPOutput("[dbo].[sp_update_soluong_sp]", ref prms, 4, ref errMsg, "@outreturn");
return(result);
}
catch (Exception ex)
{
errMsg = ex.Message;
return(0);
}
}
public int save_Size(Size vsize, ref string errMsg)
{
try
{
errMsg = "";
int i = 0;
int result = 0;
SqlParameter[] prms = new SqlParameter[4];
prms[i] = new SqlParameter("@MaSize", vsize.Masize);
i = i + 1;
prms[i] = new SqlParameter("@Size", vsize.Size1);
i = i + 1;
prms[i] = new SqlParameter("@outreturn", SqlDbType.Int, 1);
prms[i].Direction = ParameterDirection.Output;
result = SQLExecute.ExcuteSPOutput("[dbo].[sp_save_Size]", ref prms, 3, ref errMsg, "@outreturn");
return(result);
}
catch (Exception ex)
{
errMsg = ex.Message;
return(0);
}
}
public int Login_khachhang(bool _laadmin, string _username, string _password, ref string errMsg)
{
try
{
errMsg = "";
int i = 0;
int result = 0;
SqlParameter[] prms = new SqlParameter[5];
prms[i] = new SqlParameter("@laadmin", _laadmin);
i = i + 1;
prms[i] = new SqlParameter("@username", _username);
i = i + 1;
prms[i] = new SqlParameter("@password", _password);
i = i + 1;
prms[i] = new SqlParameter("@outreturn", SqlDbType.Int, 1);
prms[i].Direction = ParameterDirection.Output;
result = SQLExecute.ExcuteSPOutput("dbo.sp_login_khachhang", ref prms, 4, ref errMsg, "@outreturn");
return(result);
}
catch (Exception ex)
{
errMsg = ex.Message;
return(0);
}
}
public int sp_save_sanpham(int _masp, string _tensp, decimal _giamua, decimal _giaban, int _loaisp, int _chude, string _thongtin, int _gioitinh, DateTime _ngaynhap, string _hinhanh, int _masize, int _soluong, ref string errMsg)
{
try
{
errMsg = "";
int i = 0;
int result = 0;
SqlParameter[] prms = new SqlParameter[14];
prms[i] = new SqlParameter("@MaSP", _masp);
i = i + 1;
prms[i] = new SqlParameter("@TenSP", _tensp);
i = i + 1;
prms[i] = new SqlParameter("@GiaMua", _giamua);
i = i + 1;
prms[i] = new SqlParameter("@GiaBan", _giaban);
i = i + 1;
prms[i] = new SqlParameter("@LoaiSP", _loaisp);
i = i + 1;
prms[i] = new SqlParameter("@ChuDe", _chude);
i = i + 1;
prms[i] = new SqlParameter("@ThongTin", _thongtin);
i = i + 1;
prms[i] = new SqlParameter("@GioiTinh", _gioitinh);
i = i + 1;
prms[i] = new SqlParameter("@NgayNhapHang", _ngaynhap);
i = i + 1;
prms[i] = new SqlParameter("@HinhAnh", _hinhanh);
i = i + 1;
prms[i] = new SqlParameter("@MaSize", _masize);
i = i + 1;
prms[i] = new SqlParameter("@SoLuong", _soluong);
i = i + 1;
prms[i] = new SqlParameter("@outreturn", SqlDbType.Int, 1);
prms[i].Direction = ParameterDirection.Output;
result = SQLExecute.ExcuteSPOutput("[dbo].[sp_save_sanpham]", ref prms, 13, ref errMsg, "@outreturn");
return(result);
}
catch (Exception ex)
{
errMsg = ex.Message;
return(0);
}
}
public int save_khachhang(KhachHang vkhachhang, ref string errMsg)
{
try
{
errMsg = "";
int i = 0;
int result = 0;
SqlParameter[] prms = new SqlParameter[12];
prms[i] = new SqlParameter("@khachhangid", vkhachhang.MaKH);
i = i + 1;
prms[i] = new SqlParameter("@tendangnhap", vkhachhang.Tendangnhap);
i = i + 1;
prms[i] = new SqlParameter("@matkhau", vkhachhang.Matkhau);
i = i + 1;
prms[i] = new SqlParameter("@hoten", vkhachhang.Hoten);
i = i + 1;
prms[i] = new SqlParameter("@gioitinh", vkhachhang.Gioitinh);
i = i + 1;
prms[i] = new SqlParameter("@diachi", vkhachhang.Diachi);
i = i + 1;
prms[i] = new SqlParameter("@emai", vkhachhang.Email);
i = i + 1;
prms[i] = new SqlParameter("@sodienthoai", vkhachhang.Sodienthoai);
i = i + 1;
prms[i] = new SqlParameter("@laadmin", vkhachhang.Laadmin);
i = i + 1;
prms[i] = new SqlParameter("@trangthai", vkhachhang.Trangthai);
i = i + 1;
prms[i] = new SqlParameter("@outreturn", SqlDbType.Int, 1);
prms[i].Direction = ParameterDirection.Output;
result = SQLExecute.ExcuteSPOutput("dbo.sp_save_khachhang", ref prms, 11, ref errMsg, "@outreturn");
return(result);
}
catch (Exception ex)
{
errMsg = ex.Message;
return(0);
}
}
public int save_tintuc(tintuc vtintuc, ref string errMsg)
{
try
{
errMsg = "";
int i = 0;
int result = 0;
SqlParameter[] prms = new SqlParameter[11];
prms[i] = new SqlParameter("@matintuc", vtintuc.Matintuc);
i = i + 1;
prms[i] = new SqlParameter("@teude", vtintuc.Teude);
i = i + 1;
prms[i] = new SqlParameter("@mota", vtintuc.Mota);
i = i + 1;
prms[i] = new SqlParameter("@noidung", vtintuc.Noidung);
i = i + 1;
prms[i] = new SqlParameter("@anh", vtintuc.Anh);
i = i + 1;
prms[i] = new SqlParameter("@nguoidang", vtintuc.Nguoidang);
i = i + 1;
prms[i] = new SqlParameter("@nguoitao", vtintuc.Nguoitao);
i = i + 1;
prms[i] = new SqlParameter("@trangthai", vtintuc.Trangthai);
i = i + 1;
prms[i] = new SqlParameter("@ngaydang", vtintuc.Ngaydang);
i = i + 1;
prms[i] = new SqlParameter("@outreturn", SqlDbType.Int, 1);
prms[i].Direction = ParameterDirection.Output;
result = SQLExecute.ExcuteSPOutput("[dbo].[sp_save_tintuc]", ref prms, 10, ref errMsg, "@outreturn");
return(result);
}
catch (Exception ex)
{
errMsg = ex.Message;
return(0);
}
}