/// <summary>
/// Create entity from web model
/// </summary>
/// <param name="source"></param>
/// <returns></returns>
public static DomainModels.Vehicle CreateFrom(this VehicleDetail source)
{
return(new DomainModels.Vehicle
{
VehicleId = source.VehicleId,
IsBranchOwner = source.IsBranchOwner,
PlateNumber = source.PlateNumber,
VehicleName = source.VehicleName,
ModelYear = source.ModelYear,
FleetPoolId = source.FleetPoolId,
Color = source.Color,
OperationsWorkPlaceId = source.OperationsWorkPlaceId,
FuelLevel = source.FuelLevel,
TankSize = source.TankSize,
InitialOdometer = source.InitialOdometer,
CurrentOdometer = source.CurrentOdometer,
RegistrationDate = source.RegistrationDate,
VehicleMakeId = source.VehicleMakeId,
VehicleCategoryId = source.VehicleCategoryId,
VehicleModelId = source.VehicleModelId,
VehicleStatusId = source.VehicleStatusId,
FuelTypeId = source.FuelTypeId,
TransmissionTypeId = source.TransmissionTypeId,
RegistrationExpiryDate = source.RegistrationExpiryDate,
VehicleCondition = source.VehicleCondition,
VehicleOtherDetail = source.VehicleOtherDetail.CreateFrom(),
VehiclePurchaseInfo = source.VehiclePurchaseInfo.CreateFrom(),
VehicleLeasedInfo = source.VehicleLeasedInfo.CreateFrom(),
VehicleInsuranceInfo = source.VehicleInsuranceInfo.CreateFrom(),
VehicleDepreciation = source.VehicleDepreciation.CreateFrom(),
VehicleDisposalInfo = source.VehicleDisposalInfo.CreateFrom(),
VehicleMaintenanceTypeFrequencies = source.VehicleMaintenanceTypeFrequency != null?source.VehicleMaintenanceTypeFrequency.Select(vm => vm.CreateFrom()).ToList() : null,
VehicleCheckListItems = source.VehicleCheckListItems != null?source.VehicleCheckListItems.Select(vm => vm.CreateFrom()).ToList() : null
});
}
public HttpResponseMessage update(VehicleDetail vehicledetail)
{
try
{
var response = new HttpResponseMessage();
var Currentuser = ve.VehicleDetails.SingleOrDefault(v => v.Bike_Id == vehicledetail.Bike_Id);
if (Currentuser == null)
{
return(new HttpResponseMessage(HttpStatusCode.NotFound));
}
Currentuser.Users_Id = vehicledetail.Users_Id;
Currentuser.Bike_Model = vehicledetail.Bike_Model;
Currentuser.Existing_Fuel = vehicledetail.Existing_Fuel;
Currentuser.Fuel_Refil = vehicledetail.Fuel_Refil;
Currentuser.Fuel_Left = vehicledetail.Fuel_Left;
Currentuser.Amount_Paid = vehicledetail.Amount_Paid;
Currentuser.Initial_Odometer_Reading = vehicledetail.Initial_Odometer_Reading;
Currentuser.Current_Odometer_Reading = vehicledetail.Current_Odometer_Reading;
ve.SaveChanges();
response.StatusCode = HttpStatusCode.OK;
return(response);
}
catch
{
return(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
}
public async Task <IActionResult> Edit(string id, [Bind("CarRegistration,ModelID,ManufactureYear,ColourID,FuelTypeID,CurrentMilage,VehiclePrice")] VehicleDetail vehicleDetail)
{
if (id != vehicleDetail.CarRegistration)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(vehicleDetail);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VehicleDetailExists(vehicleDetail.CarRegistration))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
PopulateFieldsDropDownList();
PopulateFieldsDropDownList2();
PopulateFieldsDropDownList3();
return(View(vehicleDetail));
}
public string UpdateVehicle(VehicleDetail vhd)
{
try {
if (vhd != null)
{
VehicleDetail lstVehicle = dbContext.VehicleDetails.Where(x => x.Id == vhd.Id).FirstOrDefault();
lstVehicle.Address = vhd.Address;
lstVehicle.Age = vhd.Age;
lstVehicle.Cubic_Capacity = vhd.Cubic_Capacity;
lstVehicle.DealerName = vhd.DealerName;
lstVehicle.Engine_Number = vhd.Engine_Number;
lstVehicle.Horse_Power = vhd.Horse_Power;
lstVehicle.Id = vhd.Id;
lstVehicle.Maker = vhd.Maker;
lstVehicle.Name = vhd.Name;
lstVehicle.PanNumber = vhd.PanNumber;
lstVehicle.Vehicle_Type = vhd.Vehicle_Type;
lstVehicle.YOM = vhd.YOM;
dbContext.SaveChanges();
return("Vehicle Updated");
}
else
{
return("Oops! something went wrong.");
}
}
catch (Exception ex) {
throw;
}
}
//View the Selected Vehicle
private void ViewSelected(object obj)
{
if (RequestProcessingList != null)
{
var vehicleModel = RequestProcessingList.FirstOrDefault();
var home = new HomeWindowVM();
var vehicleLocator = new VehicleLocatorVM();
var vehicleDetails = new VehicleDetail();
var window = new Window()
{
Content = vehicleDetails
};
window.DataContext = vehicleLocator.VehicalDetailsViewModel;
vehicleLocator.Vin = vehicleModel.Vin;
vehicleLocator.VehicleId = vehicleModel.VehiclesID;
vehicleLocator.CustomerID = vehicleModel.CustomerID;
vehicleLocator.CreatedBy = vehicleModel.CreatedBy;
vehicleLocator.SelectedItems = new ObservableCollection <object>()
{
vehicleLocator
};
var list = new List <VehicleLocatorVM>()
{
vehicleLocator
};
DelegateEventVehicle.SetValueListMethod(list);
DelegateEventVehicle.SetValueMethodTabEnable(false);
DelegateEventVehicle.SetValueMethodCmd("Edit");
window.Show();
}
}
/// <summary>
/// Vehicle Detail
/// </summary>
/// <returns></returns>
public VehicleDetail Get([FromUri] VehicleDetail vehicleDetail)
{
if (!ModelState.IsValid)
{
throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request");
}
return(vehicleService.GetVehicleDetail(vehicleDetail.VehicleId).CreateFromDetail());
}
public ActionResult DeleteConfirmed(int id)
{
VehicleDetail vehicleDetail = db.VehicleDetails.Find(id);
db.VehicleDetails.Remove(vehicleDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// Delete a Vehicle
/// </summary>
public void Delete(VehicleDetail vehicle)
{
if (vehicle == null || !ModelState.IsValid)
{
throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request");
}
vehicleService.DeleteVehicle(vehicleService.FindById(vehicle.VehicleId));
}
/// <summary>
/// Adds a VehicleDetail
/// </summary>
/// <param name="VehicleDetail">VehicleDetail</param>
public virtual void insertVehicle(VehicleDetail vehicle)
{
if (vehicle == null)
{
throw new ArgumentNullException("vehicle");
}
_vehicleDetailRepository.Insert(vehicle);
}
/// <summary>
/// Deletes a VehicleDetail
/// </summary>
/// <param name="VehicleDetail">VehicleDetail</param>
public virtual void deleteVehicle(VehicleDetail vehicle)
{
if (vehicle == null)
{
throw new ArgumentNullException("vehicle");
}
_vehicleDetailRepository.Delete(vehicle);
}
public List <InvoiceViewModel> SearchInvoice(DateTime?dateFrom, DateTime?dateTo,
DbConstant.InvoiceStatus invoiceStatus, int customerId,
int serviceCategoryId, int vehicleGroupId, string licenseNumber,
int paymentStatus)
{
List <Invoice> result = null;
if (dateFrom.HasValue && dateTo.HasValue)
{
dateFrom = dateFrom.Value.Date;
dateTo = dateTo.Value.Date.AddDays(1).AddSeconds(-1);
result = _invoiceRepository.GetMany(c => c.CreateDate >= dateFrom && c.CreateDate <= dateTo).OrderBy(c => c.CreateDate).ToList();
}
else
{
result = _invoiceRepository.GetAll().OrderBy(c => c.CreateDate).ToList();
}
if ((int)invoiceStatus != 9)
{
result = result.Where(spk => spk.Status == (int)invoiceStatus).ToList();
}
if (customerId > 0)
{
result = result.Where(inv => inv.SPK.Vehicle.CustomerId == customerId).ToList();
}
if (vehicleGroupId > 0)
{
result = result.Where(inv => inv.SPK.Vehicle.VehicleGroupId == vehicleGroupId).ToList();
}
if (!string.IsNullOrEmpty(licenseNumber))
{
VehicleDetail vehicleDetail = _vehicleDetailRepository.GetMany(v => string.Compare(v.LicenseNumber, licenseNumber, true) == 1 &&
v.Status == (int)DbConstant.DefaultDataStatus.Active).FirstOrDefault();
if (vehicleDetail != null)
{
result = result.Where(inv => inv.SPK.VehicleId == vehicleDetail.VehicleId).ToList();
}
}
if (serviceCategoryId > 0)
{
result = result.Where(inv => inv.SPK.CategoryReferenceId == serviceCategoryId).ToList();
}
if (paymentStatus > -1)
{
result = result.Where(inv => inv.PaymentStatus == paymentStatus).ToList();
}
List <InvoiceViewModel> mappedResult = new List <InvoiceViewModel>();
return(Map(result, mappedResult));
}
public VehicleListViewContent Post(VehicleDetail vehicleDetail)
{
if (vehicleDetail == null || !ModelState.IsValid)
{
throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request");
}
VehicleListViewContent vehicle = vehicleService.SaveVehicle(vehicleDetail.CreateFrom()).CreateFromListViewContent();
return(vehicle);
}
// GET: VehicleDetails/Delete/5
public ActionResult Delete(int id)
{
VehicleDetail b = db.VehicleDetails.Find(id);
if (b == null)
{
return(HttpNotFound());
}
return(View(b));
}
public IEnumerable <VehicleDetail> GetAllDetails()
{
var vehicles = new List <VehicleDetail>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("VehiclesSelectDetails", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var row = new VehicleDetail()
{
VehicleId = (int)dr["VehicleId"],
Year = (int)dr["Year"],
IsUsed = (bool)dr["IsUsed"],
IsAutomatic = (bool)dr["IsAutomatic"],
IsFeatured = (bool)dr["IsFeatured"],
SalePrice = (decimal)dr["SalePrice"],
MSRP = (decimal)dr["MSRP"],
Mileage = (decimal)dr["Mileage"],
Make = dr["Make"].ToString(),
Model = dr["Model"].ToString(),
BodyStyle = dr["BodyStyle"].ToString(),
InteriorColor = dr["InteriorColor"].ToString(),
ExteriorColor = dr["ExteriorColor"].ToString(),
UserId = dr["UserId"].ToString(),
VIN = dr["VIN"].ToString()
};
if (dr["SaleId"] != DBNull.Value)
{
row.SaleId = (int)dr["SaleId"];
}
if (dr["Description"] != DBNull.Value)
{
row.Description = dr["Description"].ToString();
}
if (dr["Image"] != DBNull.Value)
{
row.Image = dr["Image"].ToString();
}
vehicles.Add(row);
}
}
}
return(vehicles);
}
public ActionResult Edit([Bind(Include = "Id,VehicleType,Make,Model,year,userId")] VehicleDetail vehicleDetail)
{
if (ModelState.IsValid)
{
db.Entry(vehicleDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.userId = new SelectList(db.AspNetUsers, "Id", "Email", vehicleDetail.userId);
return(View(vehicleDetail));
}
public void InsertVehicle(VehicleViewModel vehicle, DateTime expirationDate,
List <VehicleWheelViewModel> vehicleWheels, int userId)
{
using (var trans = _unitOfWork.BeginTransaction())
{
try
{
DateTime serverTime = DateTime.Now;
Vehicle entity = new Vehicle();
Map(vehicle, entity);
entity.CreateDate = entity.ModifyDate = serverTime;
entity.CreateUserId = entity.ModifyUserId = userId;
entity.Status = (int)DbConstant.DefaultDataStatus.Active;
_vehicleRepository.AttachNavigation(entity.Brand);
_vehicleRepository.AttachNavigation(entity.Type);
_vehicleRepository.AttachNavigation(entity.VehicleGroup);
_vehicleRepository.AttachNavigation(entity.Customer);
_vehicleRepository.AttachNavigation(entity.CreateUser);
_vehicleRepository.AttachNavigation(entity.ModifyUser);
var insertedVehicle = _vehicleRepository.Add(entity);
_unitOfWork.SaveChanges();
VehicleDetail vehicleDetail = new VehicleDetail
{
VehicleId = insertedVehicle.Id,
LicenseNumber = insertedVehicle.ActiveLicenseNumber,
ExpirationDate = expirationDate,
CreateDate = serverTime,
ModifyDate = serverTime,
ModifyUserId = userId,
CreateUserId = userId,
Status = (int)DbConstant.LicenseNumberStatus.Active
};
_vehicleDetailRepository.AttachNavigation(vehicleDetail.Vehicle);
_vehicleDetailRepository.AttachNavigation(vehicleDetail.CreateUser);
_vehicleDetailRepository.AttachNavigation(vehicleDetail.ModifyUser);
_vehicleDetailRepository.Add(vehicleDetail);
_unitOfWork.SaveChanges();
_unitOfWork.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw;
}
}
}
public ActionResult AddVehicle(VMVehicle vMVehicle)
{
try
{
VehicleDetail vehicleDetail = new VehicleDetail();
vehicleDetail.VehicleName = vMVehicle.VehicleName;
vehicleDetail.VehicleNo = vMVehicle.VehicleNo;
vehicleDetail.BrandId = vMVehicle.BrandId;
vehicleDetail.CategoryId = vMVehicle.CategoryId;
vehicleDetail.ColorId = vMVehicle.ColorId;
vehicleDetail.Euronum = vMVehicle.Euronum;
vehicleDetail.Kilometers = vMVehicle.Kilometers;
vehicleDetail.RegistrationYear = vMVehicle.RegistrationYear;
vehicleDetail.Price = vMVehicle.Price;
vehicleDetail.Weight = vMVehicle.Weight;
vehicleDetail.NoOfSeats = vMVehicle.NoOfSeats;
vehicleDetail.IsSold = vMVehicle.IsSold;
vehicleDetail.SoldDate = vMVehicle.SoldDate;
vehicleDetail.IsActive = vMVehicle.IsActive;
vehicleDetail.IsDelete = vMVehicle.IsDelete;
vehicleDetail.CreatedDate = vMVehicle.CreatedDate;
vehicleDetail.ModifiedDate = vMVehicle.ModifiedDate;
vehicleDetail.CreatedBy = vMVehicle.CreatedBy;
vehicleDetail.ModifiedBy = vMVehicle.ModifiedBy;
db.VehicleDetails.Add(vehicleDetail);
foreach (HttpPostedFileBase file in vMVehicle.VehicleImage1)
{
VehicleImage vehicleImage = new VehicleImage();
vehicleImage.VehicleImage1 = vMVehicle.VehicleImage1;
string VFileName = Path.GetFileNameWithoutExtension(file.FileName);
string VImageExtension = Path.GetExtension(file.FileName);
VFileName = VFileName + DateTime.Now.ToString("yymmssff") + VImageExtension;
vehicleImage.VehicleImgName = "~/VehicleImages/" + VFileName;
VFileName = Path.Combine(Server.MapPath("~/VehicleImages/"), VFileName);
file.SaveAs(VFileName);
vehicleDetail.VehicleId = vehicleImage.VehicleId;
db.VehicleImages.Add(vehicleImage);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewBag.CategoryId = new SelectList(db.Categories, "CategoryId", "CategoryName");
ViewBag.BrandId = new SelectList(db.Brands, "BrandId", "BrandName");
ViewBag.ColorId = new SelectList(db.Colors, "ColorId", "ColorName");
return(View());
}
}
public VehicleDetail GetDetailById(int vehicleId)
{
VehicleDetail vehicle = null;
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("VehicleSelectDetails", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VehicleId", vehicleId);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
vehicle = new VehicleDetail();
vehicle.VehicleId = (int)dr["VehicleId"];
vehicle.Year = (int)dr["Year"];
vehicle.IsUsed = (bool)dr["IsUsed"];
vehicle.IsAutomatic = (bool)dr["IsAutomatic"];
vehicle.IsFeatured = (bool)dr["IsFeatured"];
vehicle.SalePrice = (decimal)dr["SalePrice"];
vehicle.MSRP = (decimal)dr["MSRP"];
vehicle.Mileage = (decimal)dr["Mileage"];
vehicle.Make = dr["Make"].ToString();
vehicle.Model = dr["Model"].ToString();
vehicle.BodyStyle = dr["BodyStyle"].ToString();
vehicle.InteriorColor = dr["InteriorColor"].ToString();
vehicle.ExteriorColor = dr["ExteriorColor"].ToString();
vehicle.UserId = dr["UserId"].ToString();
vehicle.VIN = dr["VIN"].ToString();
if (dr["SaleId"] != DBNull.Value)
{
vehicle.SaleId = (int)dr["SaleId"];
}
if (dr["Description"] != DBNull.Value)
{
vehicle.Description = dr["Description"].ToString();
}
if (dr["Image"] != DBNull.Value)
{
vehicle.Image = dr["Image"].ToString();
}
}
}
}
return(vehicle);
}
public ActionResult Create([Bind(Include = "Id,VehicleType,Make,Model,year,userId")] VehicleDetail vehicleDetail)
{
if (ModelState.IsValid)
{
vehicleDetail.userId = User.Identity.GetUserId();
db.VehicleDetails.Add(vehicleDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.userId = new SelectList(db.AspNetUsers, "Id", "Email", vehicleDetail.userId);
return(View(vehicleDetail));
}
public List <SPKViewModel> SearchSPK(string LicenseNumber, string code, int category, DateTime?dateFrom, DateTime?dateTo,
int isContractWork, int customer)
{
List <SPK> result = _SPKRepository.GetMany(spk => spk.Status == (int)DbConstant.DefaultDataStatus.Active && spk.StatusCompletedId == (int)DbConstant.SPKCompletionStatus.Completed && spk.CategoryReference.Code != DbConstant.REF_SPK_CATEGORY_SALE).ToList();
if (dateFrom.HasValue && dateTo.HasValue)
{
dateFrom = dateFrom.Value.Date;
dateTo = dateTo.Value.Date.AddDays(1).AddSeconds(-1);
result = result.Where(spk => spk.CreateDate >= dateFrom && spk.CreateDate <= dateTo).ToList();
}
if (!string.IsNullOrEmpty(LicenseNumber))
{
VehicleDetail vehicleDetail = _vehicleDetailRepository.GetMany(v => string.Compare(v.LicenseNumber, LicenseNumber, true) == 1 &&
v.Status == (int)DbConstant.DefaultDataStatus.Active).FirstOrDefault();
if (vehicleDetail != null)
{
result = result.Where(spk => spk.VehicleId == vehicleDetail.VehicleId).ToList();
}
}
if (customer > 0)
{
result = result.Where(spk => spk.Vehicle.CustomerId == customer).ToList();
}
if (!string.IsNullOrEmpty(code))
{
result = result.Where(spk => string.Compare(spk.Code, code, true) == 0).ToList();
}
if (category > 0)
{
result = result.Where(spk => spk.CategoryReferenceId == category).ToList();
}
if (isContractWork == 0)
{
result = result.Where(spk => spk.isContractWork == false).ToList();
}
if (isContractWork == 1)
{
result = result.Where(spk => spk.isContractWork == true).ToList();
}
List <SPKViewModel> mappedResult = new List <SPKViewModel>();
return(Map(result, mappedResult));
}
public async Task <IActionResult> Create([Bind("CarRegistration,ModelID,ManufactureYear,ColourID,FuelTypeID,CurrentMilage,VehiclePrice")] VehicleDetail vehicleDetail)
{
if (ModelState.IsValid)
{
_context.Add(vehicleDetail);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
PopulateFieldsDropDownList();
PopulateFieldsDropDownList2();
PopulateFieldsDropDownList3();
return(View(vehicleDetail));
}
internal ErrorDetail UpdateVehicleDetails(VehicleDetail vehicleDetail)
{
Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>();
cmdParameters["NRIC"] = new SqlParameter("NRIC", vehicleDetail.NRIC);
cmdParameters["Make"] = new SqlParameter("Make", vehicleDetail.Make);
cmdParameters["Model"] = new SqlParameter("Model", vehicleDetail.Model);
cmdParameters["Capacity"] = new SqlParameter("Capacity", vehicleDetail.Capacity);
cmdParameters["Tonnage"] = new SqlParameter("Tonnage", vehicleDetail.Tonnage);
cmdParameters["DateOfRegistered"] = new SqlParameter("DateOfRegistered", vehicleDetail.DateOfRegistered);
cmdParameters["YearMade"] = new SqlParameter("YearMade", vehicleDetail.YearMade);
cmdParameters["RegNo"] = new SqlParameter("RegNo", vehicleDetail.RegNo);
cmdParameters["ParallelImport"] = new SqlParameter("ParallelImport", vehicleDetail.ParallelImport);
cmdParameters["OffPeakVehicle"] = new SqlParameter("OffPeakVehicle", vehicleDetail.OffPeakVehicle);
cmdParameters["NCD"] = new SqlParameter("NCD", vehicleDetail.NCD);
cmdParameters["ExistingInsurer"] = new SqlParameter("ExistingInsurer", vehicleDetail.ExistingInsurer ?? "NIL");
cmdParameters["PreviousRegNo"] = new SqlParameter("PreviousRegNo", vehicleDetail.PreviousRegNo ?? "NIL");
cmdParameters["Claims"] = new SqlParameter("Claims", vehicleDetail.Claims ?? "NIL");
SqlParameter outPutParameter1 = new SqlParameter();
outPutParameter1.ParameterName = "ERRORNO";
outPutParameter1.SqlDbType = System.Data.SqlDbType.Int;
outPutParameter1.Size = 255;
outPutParameter1.Direction = System.Data.ParameterDirection.Output;
cmdParameters["ERRORNO"] = outPutParameter1;
SqlParameter outPutParameter2 = new SqlParameter();
outPutParameter2.ParameterName = "ERRORDESC";
outPutParameter2.SqlDbType = System.Data.SqlDbType.VarChar;
outPutParameter2.Size = 255;
outPutParameter2.Direction = System.Data.ParameterDirection.Output;
cmdParameters["ERRORDESC"] = outPutParameter2;
ErrorDetail errorDetail = new ErrorDetail();
dbutility.ExecuteNonQuery("QuotationDb", "dbo.UpdateVehicleDetails", cmdParameters);
//if (dataSet != null && dataSet.Tables.Count > 1)
//{
// var dataTable = dataSet.Tables[0];
// errorDetail.Code = dataTable.Rows[0].Field<int>("@ERRORNO");
// errorDetail.Info = dataTable.Rows[0].Field<string>("@ERRORDESC");
//}
errorDetail.Code = int.Parse(outPutParameter1.Value.ToString());
errorDetail.Info = outPutParameter2.Value.ToString();
return(errorDetail);
}
public void AddVehicle(string number = "Gj18BB1231", int id = 1)
{
using (var db = new ParkNGODBEntities())
{
if (number != null)
{
VehicleDetail details = new VehicleDetail();
details.UserID = id;
details.VehicleNumber = number;
db.VehicleDetails.Add(details);
db.SaveChanges();
}
}
}
// GET: VehicleDetails/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VehicleDetail vehicleDetail = db.VehicleDetails.Find(id);
if (vehicleDetail == null)
{
return(HttpNotFound());
}
return(View(vehicleDetail));
}
public static IList <VehicleDetail> ConvertToModel(IList <string> lines)
{
IList <VehicleDetail> vehicleDetails = new List <VehicleDetail>();
foreach (string line in lines)
{
var vm = VehicleDetail.ConvertToModel(line);
if (vm != null)
{
vehicleDetails.Add(vm);
}
}
return(vehicleDetails);
}
public HttpResponseMessage create(VehicleDetail vehicledetail)
{
try
{
var response = new HttpResponseMessage();
ve.VehicleDetails.Add(vehicledetail);
ve.SaveChanges();
response.StatusCode = HttpStatusCode.OK;
return(Request.CreateResponse(HttpStatusCode.OK, vehicledetail));
}
catch
{
return(new HttpResponseMessage(HttpStatusCode.BadGateway));
}
}
public async System.Threading.Tasks.Task <VehicleDetail> GetVehicleDetailbyIdAsync(string vehicleid)
{
int vechileidInt = Convert.ToInt32(vehicleid);
var Vechile = await _vehicleDetailrepo.GetVehicleDetailbyIdAsync(vechileidInt);
CarsbyServices.ViewModel.Mapper _mapperForConversion = new CarsbyServices.ViewModel.Mapper(_vehicleDetailrepo);
VehicleDetail objVehicleDetail = await _mapperForConversion.MapVehicleDetailWithVehicleDetail(Vechile);
for (int i = 0; i < objVehicleDetail.VehileImage.Count; i++)
{
string convertintobase64 = Utility.ByteToBase64(objVehicleDetail.VehileImage[i]);
objVehicleDetail.VehileImage[i] = convertintobase64;
}
return(objVehicleDetail);
}
public IHttpActionResult Post(string regNumber, VehicleDetail vehicleDetail)
{
try
{
return(Ok(_vservice.Update(regNumber, vehicleDetail)));
}
catch (ArgumentNullException)
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (ArgumentException)
{
return(NotFound());
}
}
// GET: VehicleDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VehicleDetail vehicleDetail = db.VehicleDetails.Find(id);
if (vehicleDetail == null)
{
return(HttpNotFound());
}
//ViewBag.userId = new SelectList(db.AspNetUsers, "Id", "Email", vehicleDetail.userId);
return(View(vehicleDetail));
}
public void UpdateVehicleDetail(VehicleDetailViewModel vehicleDetail, VehicleViewModel vehicle, int userId)
{
DateTime serverTime = DateTime.Now;
//set current active detail to expired if any
VehicleDetail toBeExpired = _vehicleDetailRepository.GetMany(vd => vd.Status == (int)DbConstant.LicenseNumberStatus.Active).FirstOrDefault();
if (toBeExpired != null)
{
toBeExpired.ModifyDate = serverTime;
toBeExpired.ModifyUserId = userId;
toBeExpired.Status = (int)DbConstant.LicenseNumberStatus.Expired;
_vehicleDetailRepository.AttachNavigation <Vehicle>(toBeExpired.Vehicle);
_vehicleDetailRepository.Update(toBeExpired);
_unitOfWork.SaveChanges();
}
//insert new detail as active detail
vehicleDetail.CreateDate = serverTime;
vehicleDetail.CreateUserId = userId;
vehicleDetail.ModifyUserId = userId;
vehicleDetail.VehicleId = vehicle.Id;
vehicleDetail.Status = (int)DbConstant.LicenseNumberStatus.Active;
VehicleDetail entityDetail = new VehicleDetail();
Map(vehicleDetail, entityDetail);
_vehicleDetailRepository.AttachNavigation <Vehicle>(entityDetail.Vehicle);
_vehicleDetailRepository.Add(entityDetail);
_unitOfWork.SaveChanges();
//update active license number in vehicle
if (vehicle != null)
{
vehicle.ModifyDate = serverTime;
vehicle.ModifyUserId = userId;
vehicle.ActiveLicenseNumber = vehicleDetail.LicenseNumber;
Vehicle entity = _vehicleRepository.GetById(vehicle.Id);
Map(vehicle, entity);
_vehicleRepository.AttachNavigation <Customer>(entity.Customer);
_vehicleRepository.Update(entity);
_unitOfWork.SaveChanges();
}
_unitOfWork.SaveChanges();
}
