// Method Login
public UsersModel Login(string username, string password)
{
DataTable dt = DataProvider.Instance.Query(UsersQuery.Login(username, password));
List <UsersModel> users = HelperDao.GenerateList <UsersModel>(dt);
return(users.FirstOrDefault());
}
// 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 List
public List <PlaceStuffsModel> List()
{
DataTable dt = DataProvider.Instance.Query(PlaceStuffsQuerys.List());
return(HelperDao.GenerateList <PlaceStuffsModel>(dt));
}
// Method Edit
public int Edit(UsersModel user, string[] parameters)
{
Dictionary <string, object> dicParas = HelperDao.GenerateParameter <UsersModel>(user, parameters);
return(DataProvider.Instance.Execute(UsersQuery.Edit(parameters, user.Id), dicParas));
}
// Method GetUserByRoleName
public List <UsersModel> GetUsersByRoleName(string roleName, string username)
{
DataTable dt = DataProvider.Instance.Query(UsersQuery.GetUsersByRoleName(roleName, username));
return(HelperDao.GenerateList <UsersModel>(dt));
}
// Method ListForExcel
public List <UsersModel> ListForExcel(string keyword, string sortColumn, string sortBy, string columnFilter, object filterValue)
{
DataTable dt = DataProvider.Instance.Query(UsersQuery.ListForExcel(keyword, sortColumn, sortBy, columnFilter, filterValue));
return(HelperDao.GenerateList <UsersModel>(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 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));
}
