public IActionResult AutoVersionSave()
{
AutoVersionViewModel autoVersionViewModel = new AutoVersionViewModel();
autoVersionViewModel.AutoManufacturerLookup = autoSolutionLookupService.GetAutoManufacturerLookup();
return(PartialView("_AutoVersionPanel", autoVersionViewModel));
}
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 IActionResult AutoVersionSave(AutoVersionViewModel autoVersionViewModel)
{
if (autoVersionViewModel.Id > 0)
{
var result = autoVersionService.AutoVersionSave(autoVersionViewModel);
return(Json(new { status = result != null ? "save" : "exist", data = result }));
}
else
{
var result = autoVersionService.AutoVersionSave(autoVersionViewModel);
return(Json(new { status = result != null ? "save" : "exist", data = result }));
}
}
public AutoVersionViewModel AutoVersionSave(AutoVersionViewModel autoVersionViewModel)
{
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", autoVersionViewModel.ModelName));
command.Parameters.Add(new SqlParameter("AutoManufacturerId", autoVersionViewModel.SelectedManufacturer));
int rowAffected = command.ExecuteNonQuery();
return(rowAffected > 0 ? autoVersionViewModel : null);
}
public AutoSolutionPageSet <AutoVersionViewModel> GetAutoVersion(AutoVersionViewModel autoVersionViewModel)
{
return(autoVersionRepository.GetAutoVersion(autoVersionViewModel));
}
public AutoVersionViewModel AutoVersionSave(AutoVersionViewModel autoVersionViewModel)
{
//autoModel = autoMapper.Map<AutoModel>(autoModelViewModel);
return(autoVersionRepository.AutoVersionSave(autoVersionViewModel));
}
