// Method ListForExcel
public List <PlaceStuffsModel> ListForExcel(string keyword, string sortColumn, string sortBy)
{
DataTable dt = DataProvider.Instance.Query(PlaceStuffsQuerys.ListForExcel(keyword, sortColumn, sortBy));
return(HelperDao.GenerateList <PlaceStuffsModel>(dt));
}
// Method Delete
public int Delete(PlaceStuffsModel placeStuff, string[] parameters)
{
Dictionary <string, object> dicParameters = HelperDao.GenerateParameter <PlaceStuffsModel>(placeStuff, parameters);
return(DataProvider.Instance.Execute(PlaceStuffsQuerys.Delete(parameters), dicParameters));
}
// Method CheckExist
public int CheckExist(PlaceStuffsModel placeStuff, string[] parameters)
{
Dictionary <string, object> dicParameters = HelperDao.GenerateParameter <PlaceStuffsModel>(placeStuff, parameters);
return(DataProvider.Instance.Count(PlaceStuffsQuerys.CheckExsist(parameters, placeStuff.Id), dicParameters));
}
// Method CheckForeignKey
public int CheckForeignKey(int id)
{
return(DataProvider.Instance.Count(PlaceStuffsQuerys.CheckForeignKey(id)));
}
// Method List
public List <PlaceStuffsModel> List()
{
DataTable dt = DataProvider.Instance.Query(PlaceStuffsQuerys.List());
return(HelperDao.GenerateList <PlaceStuffsModel>(dt));
}
