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); }