public IActionResult GetAutoVersion(AutoVersionViewModel autoVersionViewModel)
{
AutoSolutionPageSet <AutoVersionViewModel> result = new AutoSolutionPageSet <AutoVersionViewModel>();
result = autoVersionService.GetAutoVersion(autoVersionViewModel);
return(PartialView("_GetAutoVersion", result));
}
public AutoSolutionPageSet <AutoVersionViewModel> GetAutoVersion(AutoVersionViewModel autoVersionViewModel)
{
var c = unitOfWork.GetAutoSolutionContext().Database.GetDbConnection();
c.Open();
var command = c.CreateCommand();
command.CommandText = "EXEC " + AutoSolutionStoreProcedureUtility.SelectAutoVersion + " @SearchTerm, @PageNo, @PageSize,@TotalCount OUT";
if (autoVersionViewModel.SearchTerm == null)
{
command.Parameters.Add(new SqlParameter("SearchTerm", DBNull.Value));
}
else
{
command.Parameters.Add(new SqlParameter("SearchTerm", autoVersionViewModel.SearchTerm));
}
command.Parameters.Add(new SqlParameter("@PageNo", autoVersionViewModel.PageNo));
command.Parameters.Add(new SqlParameter("@PageSize", autoVersionViewModel.PageSize));
command.Parameters.Add(new SqlParameter("@TotalCount", 0));
command.Parameters["@TotalCount"].Direction = ParameterDirection.Output;
List <AutoVersionViewModel> finalResult = new List <AutoVersionViewModel>();
int TotalCount = 0;
try {
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
finalResult.Add(new AutoVersionViewModel
{
Id = Convert.ToInt32(reader["Id"]),
ModelName = reader["ModelName"].ToString(),
AutoManufacturerName = reader["AutoManufacturerName"].ToString(),
AutoVersionName = reader["AutoVersionName"].ToString(),
StartProductionYear = (DateTime)reader["StartProductionYear"],
EndProductionYear = (DateTime)reader["EndProductionYear"],
ImagePath = reader["ImagePath"].ToString(),
});
}
}
}
TotalCount = Convert.ToInt32(command.Parameters["@TotalCount"].Value);
AutoSolutionPageSet <AutoVersionViewModel> autoSolutionPageSet = new AutoSolutionPageSet <AutoVersionViewModel>()
{
Pager = new Pager(TotalCount, autoVersionViewModel.PageNo, autoVersionViewModel.PageSize),
Data = finalResult
};
return(autoSolutionPageSet);
}
catch (Exception ex) {
throw ex;
}
}
public AutoSolutionPageSet <UserViewModel> GetUser(UserViewModel UserViewModel)
{
List <User> finalResult = new List <User>();
IQueryable <User> result = unitOfWork.GetAutoSolutionContext().Users.AsQueryable();
//if (UserViewModel.SearchTerm != null)
//{
// result = result.Where(x => x.UserName.Contains(UserViewModel.SearchTerm));
//}
Pager pager = new Pager(result.Count(), UserViewModel.PageNo, UserViewModel.PageSize);
//finalResult = result.OrderBy(x => x.UserName).Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList();
AutoSolutionPageSet <UserViewModel> autoSolutionPageSet = new AutoSolutionPageSet <UserViewModel>()
{
Pager = pager,
Data = autoMapper.Map <List <UserViewModel> >(finalResult)
};
return(autoSolutionPageSet);
}
public AutoSolutionPageSet <AutoBodyTypeViewModel> GetAutoBodyType(AutoBodyTypeViewModel autoBodyTypeViewModel)
{
List <AutoBodyType> finalResult = new List <AutoBodyType>();
IQueryable <AutoBodyType> result = unitOfWork.GetAutoSolutionContext().AutoBodyType.AsQueryable();
if (autoBodyTypeViewModel.SearchTerm != null)
{
result = result.Where(x => x.BodyType.Contains(autoBodyTypeViewModel.SearchTerm));
}
Pager pager = new Pager(result.Count(), autoBodyTypeViewModel.PageNo, autoBodyTypeViewModel.PageSize);
finalResult = result.OrderBy(x => x.BodyType).Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList();
AutoSolutionPageSet <AutoBodyTypeViewModel> autoSolutionPageSet = new AutoSolutionPageSet <AutoBodyTypeViewModel>()
{
Pager = pager,
Data = autoMapper.Map <List <AutoBodyTypeViewModel> >(finalResult)
};
return(autoSolutionPageSet);
}
public IActionResult GetRoles(RolesViewModel rolesViewModel)
{
AutoSolutionPageSet <RolesViewModel> result = rolesService.GetRoles(rolesViewModel);
return(PartialView("_GetRoles", result));
}
public IActionResult GetAutoManufacturer(AutoManufacturerViewModel autoManufacturerViewModel)
{
AutoSolutionPageSet <AutoManufacturerViewModel> result = autoManufacturerService.GetAutoManufacturer(autoManufacturerViewModel);
return(PartialView("_GetAutoManufacturer", result));
}
public IActionResult GetUser(UserViewModel UserViewModel)
{
AutoSolutionPageSet <UserViewModel> result = UserService.GetUser(UserViewModel);
return(PartialView("_GetUsers", result));
}
public IActionResult GetAutoBodyType(AutoBodyTypeViewModel autoBodyTypeViewModel)
{
AutoSolutionPageSet <AutoBodyTypeViewModel> result = autoBodyTypeService.GetAutoBodyType(autoBodyTypeViewModel);
return(PartialView("_GetAutoBodyType", result));
}
