public static DataTable select_TaiKhoan()
{
OleDbCommand cmd = new OleDbCommand("select_TaiKhoan");
cmd.CommandType = CommandType.StoredProcedure;
return(SQlDatabase.GetData(cmd));
}
public static DataTable Thongtin_Quangcao()
{
OleDbCommand cmd = new OleDbCommand("selectall_quancao");
cmd.CommandType = CommandType.StoredProcedure;
return(SQlDatabase.GetData(cmd));
}
public static DataTable Thongtin_Menu()
{
OleDbCommand cmd = new OleDbCommand("thongtin_menu");
cmd.CommandType = CommandType.StoredProcedure;
return(SQlDatabase.GetData(cmd));
}
public static DataTable selectall_TheLoai()
{
OleDbCommand cmd = new OleDbCommand("selectall_theloai");
cmd.CommandType = CommandType.StoredProcedure;
return(SQlDatabase.GetData(cmd));
}
public static DataTable selectall_tknguoidung()
{
OleDbCommand cmd = new OleDbCommand("selectall_tknguoidung");
cmd.CommandType = CommandType.StoredProcedure;
return(SQlDatabase.GetData(cmd));
}
public static DataTable select_Tin_Home()
{
OleDbCommand cmd = new OleDbCommand("selecthome_chitiet");
cmd.CommandType = CommandType.StoredProcedure;
return(SQlDatabase.GetData(cmd));
}
public static DataTable select_Tin_ID(String IDTin)
{
OleDbCommand cmd = new OleDbCommand("select_Tin_ID");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDTin", IDTin);
return(SQlDatabase.GetData(cmd));
}
public static DataTable Thongtin_Tin_by_tukhoa(string tukhoa)
{
OleDbCommand cmd = new OleDbCommand("thongtin_tintuc_by_tukhoa");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TuKhoa", tukhoa);
return(SQlDatabase.GetData(cmd));
}
public static DataTable select_Tin_IDTL_ngaunhien()
{
OleDbCommand cmd = new OleDbCommand("selectngaunhien_tintuc");
cmd.CommandType = CommandType.StoredProcedure;
return(SQlDatabase.GetData(cmd));
}
public static DataTable select_TaiKhoan_ID(String TenDangNhap)
{
OleDbCommand cmd = new OleDbCommand("select_TaiKhoan_ID");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TenDangNhap", TenDangNhap);
return(SQlDatabase.GetData(cmd));
}
public static DataTable ThongTinTL_ID(String IDTL)
{
OleDbCommand cmd = new OleDbCommand("selectid_TheLoai");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDTL", IDTL);
return(SQlDatabase.GetData(cmd));
}
public static DataTable Thongtin_NguoiDung_by_MaTK(string MaTK)
{
OleDbCommand cmd = new OleDbCommand("Thongtin_NguoiDung_by_MaTK");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaTK", MaTK);
return(SQlDatabase.GetData(cmd));
}
public static DataTable Thongtin_Menu_by_MaMenuCha(String MaMenuCha)
{
OleDbCommand cmd = new OleDbCommand("thongtin_menu_by_mamenucha");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaMenuCha", MaMenuCha);
return(SQlDatabase.GetData(cmd));
}
public static DataTable ThongTinTL_MaTLCha(String MaTLCha)
{
OleDbCommand cmd = new OleDbCommand("select_MaTLCha_TheLoai");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaTLCha", MaTLCha);
return(SQlDatabase.GetData(cmd));
}
public static DataTable Thongtin_Quangcao_by_nhomquangcaoid(string Ma)
{
OleDbCommand cmd = new OleDbCommand("select_quancao_manhomqc");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ManhomQC", Ma);
return(SQlDatabase.GetData(cmd));
}
public static DataTable Thongtin_Nhomquangcao_by_vitriqc(string ViTriQC)
{
OleDbCommand cmd = new OleDbCommand("select_nhomqc_vitri");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ViTriQC", ViTriQC);
return(SQlDatabase.GetData(cmd));
}
public static DataTable Thongtin_NguoiDung_by_email_matkhau(string Email, string MatKhau)
{
OleDbCommand cmd = new OleDbCommand("Thongtin_NguoiDung_by_email_matkhau");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Email", Email);
cmd.Parameters.AddWithValue("@MatKhau", MatKhau);
return(SQlDatabase.GetData(cmd));
}
