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);
}
/// <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 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 void CapNhatLuotXem(String IDTin)
{
OleDbCommand cmd = new OleDbCommand("capnhatluotxem");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDTin", IDTin);
SQlDatabase.ExecuteNoneQuery(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 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 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 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 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 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 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 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 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);
}
/// <summary>
/// Cập nhật sản phẩm
/// </summary>
/// <param name="IDTin"></param>
/// <param name="TieuDe"></param>
/// <param name="Hinh"></param>
/// <param name="NgayDang"></param>
/// <param name="IDuser"></param>
/// <param name="NoiDung"></param>
/// <param name="IDTL"></param>
/// <param name="SoLanXem"></param>
/// <param name="Mota"></param>
public static void Tin_update(String IDTin, String TieuDe, String Hinh, String NgayDang,
String NoiDung, String IDTL, String Mota)
{
OleDbCommand cmd = new OleDbCommand("update_tin");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDTin", IDTin);
cmd.Parameters.AddWithValue("@TieuD", TieuDe);
cmd.Parameters.AddWithValue("@Hinh", Hinh);
cmd.Parameters.AddWithValue("@NgayDang", NgayDang);
cmd.Parameters.AddWithValue("@NoiDung", NoiDung);
cmd.Parameters.AddWithValue("@IDTL ", IDTL);
cmd.Parameters.AddWithValue("@Mota", Mota);
SQlDatabase.ExecuteNoneQuery(cmd);
}
public static void TaiKhoan_update(String TenDangNhap, String MatKhau, String EmailDK, String DiaChiDK, String TenDayDu,
String NgaySinh, String GioiTinh, String MaQuyen)
{
OleDbCommand cmd = new OleDbCommand("update_TaiKhoan");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TenDangNhap", TenDangNhap);
cmd.Parameters.AddWithValue("@MatKhau", MatKhau);
cmd.Parameters.AddWithValue("@EmailDK", EmailDK);
cmd.Parameters.AddWithValue("@DiaChiDK", DiaChiDK);
cmd.Parameters.AddWithValue("@TenDayDu", TenDayDu);
cmd.Parameters.AddWithValue("@NgaySinh", NgaySinh);
cmd.Parameters.AddWithValue("@GioiTinh", GioiTinh);
cmd.Parameters.AddWithValue("@MaQuyen", MaQuyen);
SQlDatabase.ExecuteNoneQuery(cmd);
}
