public ActionResult List()
{
ListViewModel model = new ListViewModel();
model.Filter = new ListFilterViewModel();
model.CurrentPage = 1;
model.PageSize = 10;
AuthSearchFilter searchFilter = new AuthSearchFilter();
searchFilter.CurrentPage = model.CurrentPage.HasValue ? model.CurrentPage.Value : 1;
searchFilter.PageSize = model.PageSize.HasValue ? model.PageSize.Value : 10;
searchFilter.SortOn = model.SortOn;
searchFilter.SortDirection = model.SortDirection;
searchFilter.Filter_Code = model.Filter.Filter_Code;
searchFilter.Filter_Name = model.Filter.Filter_Name;
try
{
model.DataList = _authService.GetAllPaginatedWithDetailBySearchFilter(searchFilter);
}
catch
{
model.DataList = new PaginatedList <Auth>(new List <Auth>(), 0, searchFilter.CurrentPage, searchFilter.PageSize, searchFilter.SortOn, searchFilter.SortDirection);
ViewBag.ErrorMessage = "Error";
}
return(View(model));
}
public ActionResult List()
{
ListViewModel model = new ListViewModel();
model.Filter = new ListFilterViewModel();
model.CurrentPage = 1;
model.PageSize = 10;
AuthSearchFilter searchFilter = new AuthSearchFilter();
searchFilter.CurrentPage = model.CurrentPage.HasValue ? model.CurrentPage.Value : 1;
searchFilter.PageSize = model.PageSize.HasValue ? model.PageSize.Value : 10;
searchFilter.SortOn = model.SortOn;
searchFilter.SortDirection = model.SortDirection;
searchFilter.Filter_Code = model.Filter.Filter_Code;
searchFilter.Filter_NameTR = model.Filter.Filter_NameTR;
searchFilter.Filter_NameEN = model.Filter.Filter_NameEN;
model.CurrentLanguageTwoChar = SessionHelper.CurrentLanguageTwoChar;
var apiResponseModel = _authService.GetAllPaginatedWithDetailBySearchFilter(SessionHelper.CurrentUser.UserToken, SessionHelper.CurrentLanguageTwoChar, searchFilter);
if (apiResponseModel.ResultStatusCode == ResultStatusCodeStatic.Success)
{
model.DataList = apiResponseModel.Data;
}
else
{
ViewBag.ErrorMessage = apiResponseModel.ResultStatusMessage;
ViewBag.ErrorMessageList = apiResponseModel.ErrorMessageList;
return(View(model));
}
return(View(model));
}
public IActionResult GetAllPaginatedWithDetail([FromQuery] GetAllPaginatedRequestModel requestModel, [FromHeader] string displayLanguage)
{
var responseModel = new ApiResponseModel <PaginatedList <Auth> >();
responseModel.DisplayLanguage = displayLanguage;
try
{
var searchFilter = new AuthSearchFilter();
searchFilter.CurrentPage = requestModel.CurrentPage.HasValue ? requestModel.CurrentPage.Value : 1;
searchFilter.PageSize = requestModel.PageSize.HasValue ? requestModel.PageSize.Value : 10;
searchFilter.SortOn = requestModel.SortOn;
searchFilter.SortDirection = requestModel.SortDirection;
searchFilter.Filter_Code = requestModel.Code;
searchFilter.Filter_Name = requestModel.Name;
responseModel.Data = _authService.GetAllPaginatedWithDetailBySearchFilter(searchFilter);
responseModel.ResultStatusCode = ResultStatusCodeStatic.Success;
responseModel.ResultStatusMessage = "Success";
return(Ok(responseModel));
}
catch (Exception ex)
{
responseModel.ResultStatusCode = ResultStatusCodeStatic.Error;
responseModel.ResultStatusMessage = ex.Message;
responseModel.Data = null;
return(StatusCode(StatusCodes.Status500InternalServerError, responseModel));
}
}
public ActionResult List(ListViewModel model)
{
// filter bilgilerinin default boş değerlerle doldurulması sağlanıyor
if (model.Filter == null)
{
model.Filter = new ListFilterViewModel();
}
if (!model.CurrentPage.HasValue)
{
model.CurrentPage = 1;
}
if (!model.PageSize.HasValue)
{
model.PageSize = 10;
}
AuthSearchFilter searchFilter = new AuthSearchFilter();
searchFilter.CurrentPage = model.CurrentPage.HasValue ? model.CurrentPage.Value : 1;
searchFilter.PageSize = model.PageSize.HasValue ? model.PageSize.Value : 10;
searchFilter.SortOn = model.SortOn;
searchFilter.SortDirection = model.SortDirection;
searchFilter.Filter_Code = model.Filter.Filter_Code;
searchFilter.Filter_Name = model.Filter.Filter_Name;
model.DataList = _authService.GetAllPaginatedWithDetailBySearchFilter(searchFilter);
return(View(model));
}
public PaginatedList <Auth> GetAllPaginatedWithDetailBySearchFilter(AuthSearchFilter searchFilter)
{
PaginatedList <Auth> resultList = new PaginatedList <Auth>(new List <Auth>(), 0, searchFilter.CurrentPage, searchFilter.PageSize, searchFilter.SortOn, searchFilter.SortDirection);
using (AppDBContext dbContext = new AppDBContext(_config))
{
var query = from a in dbContext.Auth
where a.IsDeleted == false
select a;
// filtering
if (!string.IsNullOrEmpty(searchFilter.Filter_Code))
{
query = query.Where(r => r.Code.Contains(searchFilter.Filter_Code));
}
if (!string.IsNullOrEmpty(searchFilter.Filter_Name))
{
query = query.Where(r => r.Name.Contains(searchFilter.Filter_Name));
}
// asnotracking
query = query.AsNoTracking();
//total count
var totalCount = query.Count();
//sorting
if (!string.IsNullOrEmpty(searchFilter.SortOn))
{
// using System.Linq.Dynamic.Core; nuget paketi ve namespace eklenmelidir, dynamic order by yapmak icindir
query = query.OrderBy(searchFilter.SortOn + " " + searchFilter.SortDirection.ToUpper());
}
else
{
// deefault sıralama vermek gerekiyor yoksa skip metodu hata veriyor ef 6'da -- 28.10.2019 15:40
// https://stackoverflow.com/questions/3437178/the-method-skip-is-only-supported-for-sorted-input-in-linq-to-entities
query = query.OrderBy(r => r.Id);
}
//paging
query = query.Skip((searchFilter.CurrentPage - 1) * searchFilter.PageSize).Take(searchFilter.PageSize);
resultList = new PaginatedList <Auth>(
query.ToList(),
totalCount,
searchFilter.CurrentPage,
searchFilter.PageSize,
searchFilter.SortOn,
searchFilter.SortDirection
);
}
return(resultList);
}
public ActionResult List()
{
ListViewModel model = new ListViewModel();
model.Filter = new ListFilterViewModel();
model.CurrentPage = 1;
model.PageSize = 10;
AuthSearchFilter searchFilter = new AuthSearchFilter();
searchFilter.CurrentPage = model.CurrentPage.HasValue ? model.CurrentPage.Value : 1;
searchFilter.PageSize = model.PageSize.HasValue ? model.PageSize.Value : 10;
searchFilter.SortOn = model.SortOn;
searchFilter.SortDirection = model.SortDirection;
searchFilter.Filter_Code = model.Filter.Filter_Code;
searchFilter.Filter_Name = model.Filter.Filter_Name;
model.DataList = _authService.GetAllPaginatedWithDetailBySearchFilter(searchFilter);
return(View(model));
}
public ActionResult List(ListViewModel model)
{
// filter bilgilerinin default boş değerlerle doldurulması sağlanıyor
if (model.Filter == null)
{
model.Filter = new ListFilterViewModel();
}
if (!model.CurrentPage.HasValue)
{
model.CurrentPage = 1;
}
if (!model.PageSize.HasValue)
{
model.PageSize = 10;
}
AuthSearchFilter searchFilter = new AuthSearchFilter();
searchFilter.CurrentPage = model.CurrentPage.HasValue ? model.CurrentPage.Value : 1;
searchFilter.PageSize = model.PageSize.HasValue ? model.PageSize.Value : 10;
searchFilter.SortOn = model.SortOn;
searchFilter.SortDirection = model.SortDirection;
searchFilter.Filter_Code = model.Filter.Filter_Code;
searchFilter.Filter_Name = model.Filter.Filter_Name;
model.CurrentLanguageTwoChar = SessionHelper.CurrentLanguageTwoChar;
var apiResponseModel = _authService.GetAllPaginatedWithDetailBySearchFilter(SessionHelper.CurrentUser.UserToken, SessionHelper.CurrentLanguageTwoChar, searchFilter);
if (apiResponseModel.ResultStatusCode == ResultStatusCodeStatic.Success)
{
model.DataList = apiResponseModel.Data;
}
else
{
ViewBag.ErrorMessage = apiResponseModel.ResultStatusMessage;
ViewBag.ErrorMessageList = apiResponseModel.ErrorMessageList;
return(View(model));
}
return(View(model));
}
public ActionResult List(ListViewModel model)
{
if (model.Filter == null)
{
model.Filter = new ListFilterViewModel();
}
if (!model.CurrentPage.HasValue)
{
model.CurrentPage = 1;
}
if (!model.PageSize.HasValue)
{
model.PageSize = 10;
}
AuthSearchFilter searchFilter = new AuthSearchFilter();
searchFilter.CurrentPage = model.CurrentPage.HasValue ? model.CurrentPage.Value : 1;
searchFilter.PageSize = model.PageSize.HasValue ? model.PageSize.Value : 10;
searchFilter.SortOn = model.SortOn;
searchFilter.SortDirection = model.SortDirection;
searchFilter.Filter_Code = model.Filter.Filter_Code;
searchFilter.Filter_Name = model.Filter.Filter_Name;
var apiResponseModel = _authService.GetAllPaginatedWithDetailBySearchFilter(SessionHelper.CurrentUser.UserToken, searchFilter);
if (apiResponseModel.ResultStatusCode == ResultStatusCodeStatic.Success)
{
model.DataList = apiResponseModel.Data;
}
else
{
ViewBag.ErrorMessage = apiResponseModel.ResultStatusMessage;
model.DataList = new Business.Models.PaginatedList <Auth>(new List <Auth>(), 0, model.CurrentPage.Value, model.PageSize.Value, model.SortOn, model.SortDirection);
return(View(model));
}
// select lists
return(View(model));
}
public IActionResult GetAllPaginatedWithDetail([FromQuery] GetAllPaginatedRequestModel requestModel, [FromHeader] string displayLanguage)
{
var responseModel = new Return <PaginatedList <Auth> >();
responseModel.DisplayLanguage = displayLanguage;
try
{
var searchFilter = new AuthSearchFilter();
searchFilter.CurrentPage = requestModel.CurrentPage.HasValue ? requestModel.CurrentPage.Value : 1;
searchFilter.PageSize = requestModel.PageSize.HasValue ? requestModel.PageSize.Value : 10;
searchFilter.SortOn = requestModel.SortOn;
searchFilter.SortDirection = requestModel.SortDirection;
searchFilter.Filter_Code = requestModel.Code;
searchFilter.Filter_Name = requestModel.Name;
responseModel.Data = _authService.GetAllPaginatedWithDetailBySearchFilter(searchFilter);
responseModel.Status = ResultStatusCodeStatic.Success;
responseModel.Message = "Success";
responseModel.Success = true;
return(Ok(responseModel));
}
catch (Exception ex)
{
responseModel.Status = ResultStatusCodeStatic.InternalServerError;
responseModel.Message = "An error occurred";
responseModel.Success = false;
ReturnError error = new ReturnError();
error.Key = "500";
error.Message = ex.Message;
error.Code = 500;
responseModel.Errors = new List <ReturnError>();
responseModel.Errors.Add(error);
responseModel.Data = null; //hata oluştugundan dolayı Data null olarak dönülür.
return(StatusCode(StatusCodes.Status500InternalServerError, responseModel));
}
}
//api ile bağlandıgımız servisler
public ApiResponseModel <PaginatedList <Auth> > GetAllPaginatedWithDetailBySearchFilter(string userToken, string displayLanguage, AuthSearchFilter searchFilter)
{
ApiResponseModel <PaginatedList <Auth> > result = new ApiResponseModel <PaginatedList <Auth> >()
{
Data = new PaginatedList <Auth>(new List <Auth>(), 0, searchFilter.CurrentPage, searchFilter.PageSize, searchFilter.SortOn, searchFilter.SortDirection)
};
//portal api'den çekme işlemi
using (HttpClient httpClient = new HttpClient())
{
httpClient.BaseAddress = new Uri(ConfigHelper.ApiUrl);
httpClient.DefaultRequestHeaders.Accept.Clear();
httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", userToken);
httpClient.DefaultRequestHeaders.Add("DisplayLanguage", displayLanguage);
HttpResponseMessage response = httpClient.GetAsync(string.Format("v1/Auths?CurrentPage={0}&PageSize={1}&SortOn={2}&SortDirection={3}&Code={4}&NameTR={5}&NameEN={6}",
searchFilter.CurrentPage, searchFilter.PageSize, searchFilter.SortOn, searchFilter.SortDirection, searchFilter.Filter_Code, searchFilter.Filter_NameTR, searchFilter.Filter_NameEN)).Result;
result = response.Content.ReadAsJsonAsync <ApiResponseModel <PaginatedList <Auth> > >().Result;
}
return(result);
}
public ApiResponseModel <PaginatedList <Auth> > GetAllPaginatedWithDetailBySearchFilter(string userToken, AuthSearchFilter searchFilter)
{
ApiResponseModel <PaginatedList <Auth> > result = new ApiResponseModel <PaginatedList <Auth> >()
{
Data = new PaginatedList <Auth>(new List <Auth>(), 0, searchFilter.CurrentPage, searchFilter.PageSize, searchFilter.SortOn, searchFilter.SortDirection)
};
using (HttpClient httpClient = new HttpClient())
{
httpClient.BaseAddress = new Uri(ConfigHelper.ApiUrl);
httpClient.DefaultRequestHeaders.Accept.Clear();
httpClient.DefaultRequestHeaders.Accept.Add(
new MediaTypeWithQualityHeaderValue("application/json"));
httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", userToken);
var portalApiRequestModel = new GetAllPaginatedRequestModel();
portalApiRequestModel.UserToken = userToken;
portalApiRequestModel.CurrentPage = searchFilter.CurrentPage;
portalApiRequestModel.PageSize = searchFilter.PageSize;
portalApiRequestModel.SortOn = searchFilter.SortOn;
portalApiRequestModel.SortDirection = searchFilter.SortDirection;
ListFilterRequestModel listFilter = new ListFilterRequestModel();
listFilter.Filter_Name = searchFilter.Filter_Name;
listFilter.Filter_Code = searchFilter.Filter_Code;
portalApiRequestModel.Filter = listFilter;
HttpResponseMessage response = httpClient.PostAsJsonAsync(string.Format("Auth/GetAllPaginatedWithDetail"), portalApiRequestModel).Result;
result = response.Content.ReadAsAsync <ApiResponseModel <PaginatedList <Auth> > >().Result;
}
return(result);
}
