public static DataTable select_TaiKhoan()
{
OleDbCommand cmd = new OleDbCommand("select_TaiKhoan");
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 Thongtin_Menu()
{
OleDbCommand cmd = new OleDbCommand("thongtin_menu");
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 Thongtin_Quangcao()
{
OleDbCommand cmd = new OleDbCommand("selectall_quancao");
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 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 void delete_tknguoidung(string MaTK)
{
OleDbCommand cmd = new OleDbCommand("delete_tknguoidung");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaTK", MaTK);
SQlDatabase.ExecuteNoneQuery(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 void Quangcao_Delete(string MaQC)
{
OleDbCommand cmd = new OleDbCommand("delete_quancao");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaQC", MaQC);
SQlDatabase.ExecuteNoneQuery(cmd);
}
public static void Menu_Delete(String mamenu)
{
OleDbCommand cmd = new OleDbCommand("menu_delete");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mamenu", mamenu);
SQlDatabase.ExecuteNoneQuery(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));
}
/// <summary>
/// Phương Thức Xóa Tin theo Mã Tin Truyền Vào
/// </summary>
/// <param name="IDTin"></param>
public static void Tin_delete(String IDTin)
{
OleDbCommand cmd = new OleDbCommand("delete_tin");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDTin", IDTin);
SQlDatabase.ExecuteNoneQuery(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 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 void CapNhatLuotXem(String IDTin)
{
OleDbCommand cmd = new OleDbCommand("capnhatluotxem");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDTin", IDTin);
SQlDatabase.ExecuteNoneQuery(cmd);
}
public static DataTable select_Tin_IDTL_ngaunhien()
{
OleDbCommand cmd = new OleDbCommand("selectngaunhien_tintuc");
cmd.CommandType = CommandType.StoredProcedure;
return(SQlDatabase.GetData(cmd));
}
public static void delete_DangKi(String TenDangNhap)
{
OleDbCommand cmd = new OleDbCommand("delete_DangKi");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TenDangNhap", TenDangNhap);
SQlDatabase.ExecuteNoneQuery(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_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_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 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_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));
}
public static void TheLoai_insert(String TenTL, String ThuTu, String MaTLCha, String ret)
{
OleDbCommand cmd = new OleDbCommand("theloai_insert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDTin", TenTL);
cmd.Parameters.AddWithValue("@TieuD", ThuTu);
cmd.Parameters.AddWithValue("@Hinh", MaTLCha);
cmd.Parameters.AddWithValue("@NgayDang", ret);
SQlDatabase.ExecuteNoneQuery(cmd);
}
public static void TheLoai_update(String IDTL, String TenTL, String ThuTu, String MaTLCha)
{
OleDbCommand cmd = new OleDbCommand("update_TheLoai");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDTL", IDTL);
cmd.Parameters.AddWithValue("@TenTL", TenTL);
cmd.Parameters.AddWithValue("@ThuTu", ThuTu);
cmd.Parameters.AddWithValue("@MaTLCha", MaTLCha);
SQlDatabase.ExecuteNoneQuery(cmd);
}
public static void Nhomquangcao_Inser(string TenNhomQuanCao, string ViTriQuanCao, string AnhDaiDien, string ThuTu)
{
OleDbCommand cmd = new OleDbCommand("insert_nhomqc");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TenNhomQC", TenNhomQuanCao);
cmd.Parameters.AddWithValue("@ViTriQC", ViTriQuanCao);
cmd.Parameters.AddWithValue("@AnhDaiDien", AnhDaiDien);
cmd.Parameters.AddWithValue("@ThuTuNhomQC", ThuTu);
SQlDatabase.ExecuteNoneQuery(cmd);
}
public static void binhluan_insert(String Name, String NoiDung, String NgayDang, String IDTin)
{
OleDbCommand cmd = new OleDbCommand("insert_DangKi");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", Name);
cmd.Parameters.AddWithValue("@NoiDung", NoiDung);
cmd.Parameters.AddWithValue("@NgayDang", NgayDang);
cmd.Parameters.AddWithValue("@IDTin ", IDTin);
SQlDatabase.ExecuteNoneQuery(cmd);
}
public static void Menu_Update(String mamenu, String tenmenu, String lienket, String mamenucha, String thutumenu)
{
OleDbCommand cmd = new OleDbCommand("menu_update");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mamenu", mamenu);
cmd.Parameters.AddWithValue("@tenmenu", tenmenu);
cmd.Parameters.AddWithValue("@lienket", lienket);
cmd.Parameters.AddWithValue("@mamenucha", mamenucha);
cmd.Parameters.AddWithValue("@thutumenu", thutumenu);
SQlDatabase.ExecuteNoneQuery(cmd);
}
public static void insert_tknguoidung(string TenNguoiDung, string SDT, string DiaChi, string Email, string MatKhau)
{
OleDbCommand cmd = new OleDbCommand("insert_tknguoidung");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TenNguoiDung", TenNguoiDung);
cmd.Parameters.AddWithValue("@SDT", SDT);
cmd.Parameters.AddWithValue("@DiaChi", DiaChi);
cmd.Parameters.AddWithValue("@Email", Email);
cmd.Parameters.AddWithValue("@MatKhau", MatKhau);
SQlDatabase.ExecuteNoneQuery(cmd);
}
public static void Quangcao_Inser(string TenQuanCao, string LoaiQuanCao, string AnhQuanCao,
string LienKet, string ThuTucQC, string Ma)
{
OleDbCommand cmd = new OleDbCommand("insert_quancao");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TenQC", TenQuanCao);
cmd.Parameters.AddWithValue("@LoaiQC", LoaiQuanCao);
cmd.Parameters.AddWithValue("@AnhQC", AnhQuanCao);
cmd.Parameters.AddWithValue("@LienKet", LienKet);
cmd.Parameters.AddWithValue("@ThuTucQC", ThuTucQC);
cmd.Parameters.AddWithValue("@Ma", Ma);
SQlDatabase.ExecuteNoneQuery(cmd);
}
