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