public static bool Delete(DatCho dc) { object rs = DataProvider.Instance.ExecuteNonQuery("DatCho_Delete", dc.MChuyen, dc.MKHang); return(MyConvert.ToInt32(rs) > 0); }
/// <summary> /// Count of orders /// </summary> /// <returns>Count</returns> public static int Count() { object rs = DataProvider.Instance.ExecuteScalar("Orders_Count"); return(MyConvert.ToInt32(rs)); }
/// <summary> /// Xóa thông tin của một nhà cung cấp theo khóa chính /// </summary> /// <param name="supplier">Supplier</param> /// <returns>Số dòng bị xóa</returns> public static bool Delete(int supplierID) { object rs = DataProvider.Instance.ExecuteNonQuery("Suppliers_Delete", supplierID); return(MyConvert.ToInt32(rs) > 0); }
/// <summary> /// Thêm một nhân viên vào csdl /// </summary> /// <param name="empl">New employee</param> /// <returns>(int)EmployeeID</returns> public static int Add(Employee empl) { object rs = DataProvider.Instance.ExecuteNonQueryWithOutput("@EmployeeID", "Employees_Add", 0, empl.LastName, empl.FirstName, empl.BirthDate, empl.HireDate, empl.Address, empl.PostalCode, empl.Country, empl.HomePhone); return(MyConvert.ToInt32(rs)); }
/// <summary> /// Xóa theo khóa chính /// </summary> /// <param name="product">The product you want to remove</param> /// <returns>productID Which was removed</returns> public static bool Delete(int productID) { object rs = DataProvider.Instance.ExecuteNonQuery("Products_Delete", productID); return(MyConvert.ToInt32(rs) > 0); }
public static bool Add(HuongDanVien hdv) { object rs = DataProvider.Instance.ExecuteNonQuery("HDV_Add", hdv.ID, hdv.Ho, hdv.Ten, hdv.NgaySinh, hdv.GioiTinh, hdv.DiaChi, hdv.QuocGia, hdv.DienThoai, hdv.TrangThai); return(MyConvert.ToInt32(rs) > 0); }
public static bool Update(Login log) { object rs = DataProvider.Instance.ExecuteNonQuery("Login_Update", log.Powers, log.User, log.Pass); return(MyConvert.ToInt32(rs) > 0); }
public static bool Delete(string _User) { object rs = DataProvider.Instance.ExecuteNonQuery("Login_Delete", _User); return(MyConvert.ToInt32(rs) > 0); }
public static int Add(DiemDen dd) { object rs = DataProvider.Instance.ExecuteNonQuery("DiemDen_Add", dd.MTour, dd.MDiemDL, dd.MaKS, dd.MaPT); return(MyConvert.ToInt32(rs)); }
public static int DeleteByMTour(int _MTour) { object rs = DataProvider.Instance.ExecuteNonQuery("DiemDen_DeleteByMTour", _MTour); return(MyConvert.ToInt32(rs)); }
public static bool Add(HDV_Tour thongThuoc) { object rs = DataProvider.Instance.ExecuteNonQuery("HDV_Tour_Add", thongThuoc.MHDV, thongThuoc.MTour); return(MyConvert.ToInt32(rs) > 0); }
public static bool Delete(int _MaChuyen) { object rs = DataProvider.Instance.ExecuteNonQuery("Chuyen_Delete", _MaChuyen); return(MyConvert.ToInt32(rs) > 0 ? true : false); }
public static bool Update(Chuyen c) { object rs = DataProvider.Instance.ExecuteNonQuery("Chuyen_Update", c.MChuyen, c.MTour, c.NgayDi, c.NgayVe, c.Gia, c.TrangThai); return(MyConvert.ToInt32(rs) > 0 ? true : false); }
public static int Add(Chuyen c) { object rs = DataProvider.Instance.ExecuteNonQueryWithOutput("@MChuyen", "Chuyen_Add", c.MChuyen, c.MTour, c.NgayDi, c.NgayVe, c.Gia, c.TrangThai); return(MyConvert.ToInt32(rs)); }
public static bool Delete(string _maKHang) { object rs = DataProvider.Instance.ExecuteNonQuery("KhachHang_Delete", _maKHang); return(MyConvert.ToInt32(rs) > 0); }