// Method ListDataByColumn public List <string> ListDataByColumn(string column) { DataTable dt = DataProvider.Instance.Query(StuffsQuerys.ListDataByColumn(column)); List <string> data = new List <string>(); foreach (DataRow row in dt.Rows) { data.Add(row[column].ToString()); } return(data); }
// Method DeleteStuffs public int DeleteStuffs(int[] ids) { int execute = 0; foreach (int id in ids) { DataProvider.Instance.Execute(StuffsQuerys.DeleteStuffsPlaceStuffs(id)); execute += DataProvider.Instance.Execute(StuffsQuerys.Delete(id)); } return(execute); }
// Method ListForExcel public List <StuffsModel> ListForExcel(string keyword, string sortColumn, string sortBy, string columnFilter, object filterValue) { DataTable dt = DataProvider.Instance.Query(StuffsQuerys.ListForExcel(keyword, sortColumn, sortBy, columnFilter, filterValue)); return(HelperDao.GenerateList <StuffsModel>(dt)); }
// Method Insert public int Edit(StuffsModel stuff, string[] paramters) { Dictionary <string, object> dicParamters = HelperDao.GenerateParameter <StuffsModel>(stuff, paramters); return(DataProvider.Instance.Execute(StuffsQuerys.Edit(paramters, stuff.Id), dicParamters)); }
// Method CheckExist public int CheckExist(StuffsModel stuff, string[] parameters) { Dictionary <string, object> dicParameters = HelperDao.GenerateParameter <StuffsModel>(stuff, parameters); return(DataProvider.Instance.Count(StuffsQuerys.CheckExsist(parameters, stuff.Id), dicParameters)); }
// Method List public List <StuffsModel> List(bool?status = null) { DataTable dt = DataProvider.Instance.Query(StuffsQuerys.List(status)); return(HelperDao.GenerateList <StuffsModel>(dt)); }
// Method ListPaging public List <StuffsModel> ListPaging(int pageSizes, int pages = 1) { DataTable dt = DataProvider.Instance.Query(StuffsQuerys.ListPaging(pageSizes, pages)); return(HelperDao.GenerateList <StuffsModel>(dt)); }
// Method ListStuffsByPlaceStuff public List <StuffsModel> ListStuffsByPlaceStuff(int idPlaceStuff) { DataTable dt = DataProvider.Instance.Query(StuffsQuerys.ListStuffsByPlaceStuff(idPlaceStuff)); return(HelperDao.GenerateList <StuffsModel>(dt)); }
// Method ListStuffsNotHavePlacePaging public List <StuffsModel> ListStuffsNotHavePlace() { DataTable dt = DataProvider.Instance.Query(StuffsQuerys.ListStuffsNotHavePlace()); return(HelperDao.GenerateList <StuffsModel>(dt)); }