public IActionResult AutoModelSave()
{
AutoModelViewModel autoModelViewModel = new AutoModelViewModel();
autoModelViewModel.AutoManufacturerLookup = autoSolutionLookupService.GetAutoManufacturerLookup();
return(PartialView("_AutoModelPanel", autoModelViewModel));
}
public IActionResult GetAutoModel(AutoModelViewModel autoModelViewModel)
{
AutoSolutionPageSet <AutoModelViewModel> result = new AutoSolutionPageSet <AutoModelViewModel>();
result = autoModelService.GetAutoModel(autoModelViewModel);
return(PartialView("_GetAutoModel", result));
}
public IActionResult AutoModelSave(AutoModelViewModel autoModelViewModel)
{
if (autoModelViewModel.Id > 0)
{
var result = autoModelService.AutoModelSave(autoModelViewModel);
return(Json(new { status = result != null ? "save" : "exist", data = result }));
}
else
{
var result = autoModelService.AutoModelSave(autoModelViewModel);
return(Json(new { status = result != null ? "save" : "exist", data = result }));
}
}
public AutoSolutionPageSet <AutoModelViewModel> GetAutoModel(AutoModelViewModel autoModelViewModel)
{
var c = unitOfWork.GetAutoSolutionContext().Database.GetDbConnection();
c.Open();
var command = c.CreateCommand();
command.CommandText = "EXEC " + AutoSolutionStoreProcedureUtility.SelectAutoModel + " @SearchTerm, @PageNo, @PageSize,@TotalCount OUT";
if (autoModelViewModel.SearchTerm == null)
{
command.Parameters.Add(new SqlParameter("SearchTerm", DBNull.Value));
}
else
{
command.Parameters.Add(new SqlParameter("SearchTerm", autoModelViewModel.SearchTerm));
}
command.Parameters.Add(new SqlParameter("@PageNo", autoModelViewModel.PageNo));
command.Parameters.Add(new SqlParameter("@PageSize", autoModelViewModel.PageSize));
command.Parameters.Add(new SqlParameter("@TotalCount", 0));
command.Parameters["@TotalCount"].Direction = ParameterDirection.Output;
List <AutoModelViewModel> finalResult = new List <AutoModelViewModel>();
int TotalCount = 0;
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
finalResult.Add(new AutoModelViewModel
{
Id = Convert.ToInt32(reader["Id"]),
ModelName = reader["ModelName"].ToString(),
AutoManufacturerName = reader["AutoManufacturerName"].ToString()
});
}
}
}
TotalCount = Convert.ToInt32(command.Parameters["@TotalCount"].Value);
AutoSolutionPageSet <AutoModelViewModel> autoSolutionPageSet = new AutoSolutionPageSet <AutoModelViewModel>()
{
Pager = new Pager(TotalCount, autoModelViewModel.PageNo, autoModelViewModel.PageSize),
Data = finalResult
};
return(autoSolutionPageSet);
}
public AutoModelViewModel AutoModelSave(AutoModelViewModel autoModelViewModel)
{
var c = unitOfWork.GetAutoSolutionContext().Database.GetDbConnection();
c.Open();
var command = c.CreateCommand();
//command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "EXEC " + AutoSolutionStoreProcedureUtility.InsertAutoModel + " @ModelName,@AutoManufacturerId";
command.Parameters.Add(new SqlParameter("ModelName", autoModelViewModel.ModelName));
command.Parameters.Add(new SqlParameter("AutoManufacturerId", autoModelViewModel.SelectedManufacturer));
int rowAffected = command.ExecuteNonQuery();
return(rowAffected > 0 ? autoModelViewModel : null);
}
public AutoSolutionLookupService(IAutoSolutionLookupRepository autoSolutionLookupRepository, AutoModelViewModel autoModelViewModel)
{
this.autoSolutionLookupRepository = autoSolutionLookupRepository;
this.autoModelViewModel = autoModelViewModel;
}
public AutoSolutionPageSet <AutoModelViewModel> GetAutoModel(AutoModelViewModel autoModelViewModel)
{
return(autoModelRepository.GetAutoModel(autoModelViewModel));
}
public AutoModelViewModel AutoModelSave(AutoModelViewModel autoModelViewModel)
{
//autoModel = autoMapper.Map<AutoModel>(autoModelViewModel);
return(autoModelRepository.AutoModelSave(autoModelViewModel));
}
