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