public async Task <IActionResult> Edit(long id, [Bind("Id,PolicyNumber,ExpirationDate,InsuranceBusinessName")] VehicleInsurance vehicleInsurance)
{
if (id != vehicleInsurance.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(vehicleInsurance);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VehicleInsuranceExists(vehicleInsurance.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(vehicleInsurance));
}
public async Task <IActionResult> Create([Bind("Id,PolicyNumber,ExpirationDate,InsuranceBusinessName")] VehicleInsurance vehicleInsurance)
{
if (ModelState.IsValid)
{
_context.Add(vehicleInsurance);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(vehicleInsurance));
}
public async Task <IActionResult> GetVehicleDetails(GeneralFilter generalFilter)
{
var user = HttpContext.Session.GetString("user");
var insurance = new VehicleInsurance();
var outputHandler = new OutputHandler();
try
{
var requestUrl = $"{BaseUrl}{apiUri}/GetInsuranceDetails?loggedInUser={user}&RegistrationNumber={generalFilter.RegistrationNumber}";
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(requestUrl);
var response = await client.GetAsync(requestUrl);
if (response.StatusCode == HttpStatusCode.OK)
{
outputHandler = await response.Content.ReadAsAsync <OutputHandler>();
if (!outputHandler.IsErrorOccured
)
{
insurance = JsonConvert.DeserializeObject <VehicleInsurance>(outputHandler.Result.ToString());
}
}
else
{
outputHandler = await response.Content.ReadAsAsync <OutputHandler>();
outputHandler.IsErrorOccured = true;
}
};
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
if (outputHandler.IsErrorOccured)
{
VehicleInsuranceNotFound(outputHandler);
return(View(nameof(VehicleInsuranceNotFound)));
}
return(View(insurance));
}
public static VehicleInsurance ToModel(this VehicleInsuranceViewModel vm, VehicleInsurance model = null)
{
if (model == null)
{
model = new VehicleInsurance();
}
model.Id = vm.Id;
model.VehicleId = vm.VehicleId;
model.ValidTill = new DateTime(vm.ValidTillYear, vm.ValidTillMonth, vm.ValidTillDay);
model.InsuranceDate = new DateTime(vm.InsuranceYear, vm.InsuranceMonth, vm.InsuranceDay);
model.CreatedOn = DateTime.UtcNow;
model.UpdatedOn = DateTime.UtcNow;
model.Note = vm.Note;
model.IsActive = vm.IsActive;
return(model);
}
public static VehicleInsuranceViewModel ToVm(this VehicleInsurance model, IConfiguration config, VehicleInsuranceViewModel vm = null)
{
if (vm == null)
{
vm = new VehicleInsuranceViewModel();
}
vm.Id = model.Id;
vm.VehicleId = model.VehicleId;
vm.ValidTill = model.ValidTill.ToString("MMMM dd, yyyy");
vm.InsuranceDate = model.InsuranceDate.ToString("MMMM dd, yyyy");
vm.CreatedOn = model.CreatedOn.ToString("MMMM dd, yyyy");
vm.UpdatedOn = model.UpdatedOn.ToString("MMMM dd, yyyy");
vm.CreatedBy = string.Format("{0} {1}", model.CreatedByNavigation.FirstName, model.CreatedByNavigation.LastName);
vm.UpdatedBy = string.Format("{0} {1}", model.UpdatedByNavigation.FirstName, model.UpdatedByNavigation.LastName);
vm.IsActive = model.IsActive;
vm.ValidTillYear = model.ValidTill.Year;
vm.ValidTillMonth = model.ValidTill.Month;
vm.ValidTillDay = model.ValidTill.Day;
vm.RegistrationNo = model.Vehicle.RegistrationNo;
vm.InsuranceYear = model.InsuranceDate.Year;
vm.InsuranceMonth = model.InsuranceDate.Month;
vm.InsuranceDay = model.InsuranceDate.Day;
vm.ImageName = model.Attachment;
vm.Note = model.Note;
if (!string.IsNullOrEmpty(model.Attachment))
{
//vm.ImageURL = string.Format("{0}/{1}/{2}/{3}", config.GetSection("FileUploadUrl").Value, FolderNames.INSURANCE, model.Vehicle.Id, model.Attachment);
var imagePath = string.Format(@"{0}{1}\{2}\{3}", config.GetSection("FileUploadPath").Value, FolderNames.INSURANCE, model.Vehicle.Id, model.Attachment);
if (File.Exists(imagePath))
{
vm.ImageURL = "data:image/jpg;base64," + ImageHelper.getThumnialImage(imagePath);
}
}
return(vm);
}
/// <summary>
/// Insert/Update of Vehicle Insurance
/// </summary>
/// <param name="objIns"></param>
/// <returns></returns>
public int VehicleInsuranceInsertUpdate(VehicleInsurance objIns)
{
int i = 0;
try
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_VehicleInsuranceInsertUpdate";
cmd.Parameters.AddWithValue("@InsID", objIns.InsID);
cmd.Parameters.AddWithValue("@VehicleID", objIns.VehicleID);
cmd.Parameters.AddWithValue("@InsTypeID", objIns.InsTypeID);
cmd.Parameters.AddWithValue("@InsCompanyID", objIns.InsCompanyID);
cmd.Parameters.AddWithValue("@InsPolicyNo", objIns.InsPolicyNo);
cmd.Parameters.AddWithValue("@InsCost", objIns.InsCost);
cmd.Parameters.AddWithValue("@InsStart", objIns.InsStart);
cmd.Parameters.AddWithValue("@InsExpiry", objIns.InsExpiry);
cmd.Parameters.AddWithValue("@UserId", objIns.UserId);
cmd.Parameters.AddWithValue("@IsActive", objIns.IsActive);
//SqlParameter output = new SqlParameter("@Return_Value", SqlDbType.Int);
//output.Direction = ParameterDirection.ReturnValue;
//cmd.Parameters.Add(output);
cmd.ExecuteNonQuery();
i = 1;
}
}
catch (Exception ex)
{
i = 0;
throw ex;
}
return(i);
}
/// <summary>
/// Insert/Update of Vehicle Insurance
/// </summary>
/// <param name="objIns"></param>
/// <returns></returns>
public int VehicleInsuranceInsertUpdate(VehicleInsurance objIns)
{
return(objDal.VehicleInsuranceInsertUpdate(objIns));
}
public static string GetVehicleInsuranceImageName(this VehicleInsurance model, string extension)
{
return(string.Format(@"Insurance-Image-{0}{1}", model.InsuranceDate.Year, extension));
}
public static string GetVehicleInsuranceImagePath(this VehicleInsurance model, IConfiguration config)
{
return(string.Format(@"{0}{1}\{2}\{3}", config.GetSection("FileUploadPath").Value, FolderNames.INSURANCE, model.Vehicle.Id, model.Attachment));
}
