public async Task <ActionResult> CreateUpdateVehicle([FromBody] VehiclesModel obj) { var md = _mapper.Map <Vehicles>(obj); var res = _vehicleRepository.CreateVehicle(md); return(Ok(res)); }
public static DataTable SaveVehicle(VehiclesModel vehiclemodel, string Action) { try { string ConnectionString = Common.GetConnectionString(); List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@UserId", vehiclemodel.UserId)); parameters.Add(new SqlParameter("@VehicleId", vehiclemodel.VehicleId)); parameters.Add(new SqlParameter("@Make", vehiclemodel.Make)); parameters.Add(new SqlParameter("@Model", vehiclemodel.Model)); parameters.Add(new SqlParameter("@Year", vehiclemodel.Year)); parameters.Add(new SqlParameter("@Color", vehiclemodel.Color)); parameters.Add(new SqlParameter("@LicensePlate", vehiclemodel.LicencePlate)); parameters.Add(new SqlParameter("@SpecialNotes", vehiclemodel.SpecialNotes)); parameters.Add(new SqlParameter("@VehicleImageURL", vehiclemodel.VehicleImageURL)); parameters.Add(new SqlParameter("@ImageType", vehiclemodel.ImageType)); parameters.Add(new SqlParameter("@Action", Action)); using (DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "spSaveVehicle", parameters.ToArray()).Tables[0]) { return(dt); //int rowsAffected = SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "spSaveVehicle", parameters.ToArray()); //return rowsAffected; } } catch (Exception e) { //loggerErr.Error(e.Message + " - " + e.StackTrace); throw e; } }
/// <summary> /// Vehicles page /// </summary> /// <returns>Page with list of vehicles in incidents</returns> public IActionResult Vehicles() { VehiclesModel model = new VehiclesModel(); model.Vehicles = _context.Vehicles.ToList(); return(View(model)); }
public void Update(VehiclesModel vehicle) { var vehicleRecord = _modelContext.VehicleRecordsProperties.Include("VehicleRecords").Where(i => i.VrId == vehicle.VRId).ToList(); foreach (var record in vehicleRecord) { if (record.VpmId == 2) { record.Value = vehicle.Engine; } if (record.VpmId == 3) { record.Value = vehicle.Doors; } if (record.VpmId == 4) { record.Value = vehicle.Wheels; } if (record.VpmId == 5) { record.Value = vehicle.BodyType; } if (record.VpmId == 6) { record.Value = vehicle.Colour; } var entry = _modelContext.VehicleRecordsProperties.Update(record); entry.State = EntityState.Modified; _modelContext.SaveChanges(); } }
public List <VehiclesModel> GetFilteredVehicleSummariesByDateRange(int id, string startDate, string endDate) { string cs = CONNECTIONSTRING; var conn = new NpgsqlConnection(cs); conn.Open(); string sql = "SELECT * FROM bookings WHERE (bookingdate >= cast('" + startDate + "' AS DATE) AND bookingdate <= cast('" + endDate + "' AS DATE)) && vehicleid = " + id; var cmd = new NpgsqlCommand(sql, conn); NpgsqlDataReader dr = cmd.ExecuteReader(); var vehicles = new List <VehiclesModel>(); while (dr.Read()) { var Vehicle = new VehiclesModel { VehicleId = dr.GetInt32(0), Model = dr.GetString(1) }; vehicles.Add(Vehicle); } conn.Close(); return(vehicles); }
public List <VehiclesModel> GetVehicleDetails() { string cs = CONNECTIONSTRING; var conn = new NpgsqlConnection(cs); conn.Open(); string sql = @"SELECT * FROM vehicles"; NpgsqlCommand cmd = new NpgsqlCommand(sql, conn); NpgsqlDataReader dr = cmd.ExecuteReader(); var vehicles = new List <VehiclesModel>(); while (dr.Read()) { var vehicleModel = new VehiclesModel { VehicleId = dr.GetInt32(0), Model = dr.GetString(1), CreatedOn = dr.GetDateTime(2) }; vehicles.Add(vehicleModel); } conn.Close(); return(vehicles); }
private void Validation(VehiclesModel vehicles) { if (vehicles.VtId == 0) { ModelState.AddModelError("", "Select Vehicle"); } else if (vehicles.VmakeId == 0) { ModelState.AddModelError("", "Select Make"); } else if (vehicles.VmodelId == 0) { ModelState.AddModelError("", "Select Model"); } else if (string.IsNullOrEmpty(vehicles.Engine)) { ModelState.AddModelError("", "Select Engine"); } else if (string.IsNullOrEmpty(vehicles.Doors)) { ModelState.AddModelError("", "Select Doors"); } else if (string.IsNullOrEmpty(vehicles.Wheels)) { ModelState.AddModelError("", "Select Wheels"); } else if (string.IsNullOrEmpty(vehicles.BodyType)) { ModelState.AddModelError("", "Select Body Type"); } else if (string.IsNullOrEmpty(vehicles.Colour)) { ModelState.AddModelError("", "Select Colour"); } }
public VehiclesModel GetVehicleDetailsById(int id) { string cs = CONNECTIONSTRING; var conn = new NpgsqlConnection(cs); conn.Open(); string sql = @"SELECT vehicleid, model FROM vehicles WHERE vehicleid = " + id; NpgsqlCommand cmd = new NpgsqlCommand(sql, conn); NpgsqlDataReader dr = cmd.ExecuteReader(); var vehicle = new VehiclesModel(); while (dr.Read()) { var vehicleModel = new VehiclesModel { VehicleId = dr.GetInt32(0), Model = dr.GetString(1) }; vehicle = vehicleModel; } conn.Close(); return(vehicle); }
public void InsertIntoVehicleRecordProperties(VehiclesModel vehicles, decimal id) { if (!string.IsNullOrEmpty(vehicles.Engine)) { var recordProperty = new VehicleRecordsProperties() { VrId = id, VpmId = 2, Value = vehicles.Engine }; _modelContext.VehicleRecordsProperties.Add(recordProperty); _modelContext.SaveChanges(); } if (!string.IsNullOrEmpty(vehicles.Doors)) { var recordProperty = new VehicleRecordsProperties() { VrId = id, VpmId = 3, Value = vehicles.Doors }; _modelContext.VehicleRecordsProperties.Add(recordProperty); _modelContext.SaveChanges(); } if (!string.IsNullOrEmpty(vehicles.Wheels)) { var recordProperty = new VehicleRecordsProperties() { VrId = id, VpmId = 4, Value = vehicles.Wheels }; _modelContext.VehicleRecordsProperties.Add(recordProperty); _modelContext.SaveChanges(); } if (!string.IsNullOrEmpty(vehicles.BodyType)) { var recordProperty = new VehicleRecordsProperties() { VrId = id, VpmId = 5, Value = vehicles.BodyType }; _modelContext.VehicleRecordsProperties.Add(recordProperty); _modelContext.SaveChanges(); } if (!string.IsNullOrEmpty(vehicles.Colour)) { var recordProperty = new VehicleRecordsProperties() { VrId = id, VpmId = 6, Value = vehicles.Colour }; _modelContext.VehicleRecordsProperties.Add(recordProperty); _modelContext.SaveChanges(); } }
public int UpdateVehicle(VehiclesModel model) { try { return(MembersBAL.UpdateVehicle(model)); } catch (Exception exc) { throw new FaultException <FuneralServiceFault>(new FuneralServiceFault(exc.Message)); } }
public static string SaveUpdateVehicle([FromBody] VehiclesModel vehiclemodel, string Action) { string Result = ""; try { //if(vehiclemodel.ImageType == "") //{ // Result = "Please enter Image Type"; //} //else if (vehiclemodel.VehicleImage.ToString() != "") //{ // vehiclemodel.VehicleImageURL = AzureStorage.UploadImage(vehiclemodel.VehicleImage, Guid.NewGuid() + "." + vehiclemodel.ImageType, "vehicleimages").Result; //} //if (vehiclemodel.LicensePlate == "") //{ // Result = "Please enter License Plate" ; //} //else if (vehiclemodel.UserId <= 0) //{ // Result = "Please enter UserId"; //} //else //{ DataTable dt = Data.Vehicles.SaveVehicle(vehiclemodel, Action); //VehiclesDetails vechile = new VehiclesDetails(); if (dt.Rows[0]["VehicleId"].ToString() != "") { Result = (dt.Rows[0]["VehicleId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["VehicleId"]).ToString(); } else { Result = "Error Updating the Vehicle"; } //} return(Result); } catch (Exception e) { throw e; } }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } VehiclesModel = await _context.VehiclesModel.FirstOrDefaultAsync(m => m.ID == id); if (VehiclesModel == null) { return(NotFound()); } return(Page()); }
public IActionResult Create(VehiclesModel vehicles, IFormCollection formCollection) { IActionResult returnpath = View(vehicles); VehicleMakemodelMapping mapping = new VehicleMakemodelMapping(); //var _modelContext = new VehiclesContext(); try { Validation(vehicles); decimal VmakeId = Convert.ToDecimal(HttpContext.Request.Form["VmakeId"]); decimal VmodelId = Convert.ToDecimal(HttpContext.Request.Form["VmodelId"]); mapping = _vehicleService.GetMakeModelIDList(mapping, VmakeId, VmodelId); if (ModelState.IsValid) { if (mapping != null) { var record = new VehicleRecords() { VmmpId = mapping.VmmpId }; _modelContext.VehicleRecords.Add(record); _modelContext.SaveChanges(); decimal id = record.VrId; if (id != 0) { _vehicleService.InsertIntoVehicleRecordProperties(vehicles, id); } } returnpath = RedirectToAction("Index"); } else { ViewBag.ListOfVehicles = _vehicleService.LoadVehicleTypeList(); returnpath = View(vehicles); } } catch (Exception ex) { _logger.LogError(" Exception on creating new record: " + ex); } return(returnpath); }
protected void btnUpdateVehicle_Click(object sender, EventArgs e) { if (Page.IsValid) { try { VehiclesModel ObjVehicleModel = new VehiclesModel(); ObjVehicleModel = new VehiclesModel(); ObjVehicleModel.VehicleMake = txtVehicleMake.Text; ObjVehicleModel.VehicleModel = txtVehicleModel.Text; ObjVehicleModel.VehicleYear = txtVehicleYear.Text; ObjVehicleModel.VehicleColor = txtVehicleYear.Text; ObjVehicleModel.VehicleTrackingCompany = txtVehicleTrackingCompany.Text; ObjVehicleModel.VehicleRegNo = txtVehicleRegNo.Text; ObjVehicleModel.VehicleVinNo = txtVehicleVinNo.Text; ObjVehicleModel.VehicleEngNo = txtVehicleEngNo.Text; ObjVehicleModel.FkiMemberID = this.MemberId; ObjVehicleModel.ParlourID = this.ParlourId; ObjVehicleModel.StartDate = DateTime.Now; ObjVehicleModel.LastModified = DateTime.Now; ObjVehicleModel.ModifiedUser = this.User.Identity.Name; ObjVehicleModel.PkiVehicleID = Convert.ToInt32(hfVehicleId.Value); int documentid = client.UpdateVehicle(ObjVehicleModel); btnAddVehicle.Visible = true; btnUpdateVehicle.Visible = false; bindVehicles(); ClearVehiclesControl(); ShowMessage(ref lblMessage, MessageType.Success, "Vehicle udpated successfully"); Response.Redirect("~/admin/managemember.aspx?tabid=5&id=" + ObjVehicleModel.PkiVehicleID.ToString()); ScriptManager.RegisterStartupScript(this, this.GetType(), "gototab51", "gototab(5);", true); } catch (FaultException <FuneralServiceFault> fault) { lblMessage.Text = "<div class='ibox-content'><div class='alert alert-danger'>" + fault.Detail.Message + "</div>"; } catch (Exception ex) { ShowMessage(ref lblMessage, MessageType.Danger, ex.Message); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "gototab51", "gototab(5);", true); } }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } VehiclesModel = await _context.VehiclesModel.FindAsync(id); if (VehiclesModel != null) { _context.VehiclesModel.Remove(VehiclesModel); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
private void SelectVehicleByVehicleId(int VehicleID) { DateTime dt = new DateTime(1900, 01, 01); VehiclesModel objvehiclesmodel = new VehiclesModel(); objvehiclesmodel = client.SelectVehicleByVehicleId(VehicleID); txtVehicleMake.Text = objvehiclesmodel.VehicleMake; txtVehicleModel.Text = objvehiclesmodel.VehicleModel; txtVehicleYear.Text = objvehiclesmodel.VehicleYear; txtVehicleColor.Text = objvehiclesmodel.VehicleColor; txtVehicleTrackingCompany.Text = objvehiclesmodel.VehicleTrackingCompany; txtVehicleVinNo.Text = objvehiclesmodel.VehicleVinNo; txtVehicleRegNo.Text = objvehiclesmodel.VehicleRegNo; txtVehicleEngNo.Text = objvehiclesmodel.VehicleEngNo; hfVehicleId.Value = objvehiclesmodel.PkiVehicleID.ToString(); btnAddVehicle.Visible = false; btnUpdateVehicle.Visible = true; }
/// <summary> /// Returns a view of all of the available vehicles /// </summary> /// <param name="url"></param> /// <returns></returns> public VehiclesModel GetAllVehicles() { var vehicles = new VehiclesModel { Next = "https://swapi.co/api/vehicles/", Vehicles = new List <VehicleModel>() }; while (vehicles.Next != null) { var result = JsonConvert.DeserializeObject <VehiclesModel>(request.GetResponse(vehicles.Next)); // Update the planets object vehicles.Count = result.Count; vehicles.Next = result.Next; vehicles.Vehicles.AddRange(result.Vehicles.ToList()); } return(vehicles); }
protected void gvVehicles_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { VehiclesModel rowView = (VehiclesModel)e.Row.DataItem; // Retrieve the key value for the current row. Here it is an int. //int myDataKey = Convert.ToInt32(rowView["pkiVehicleID"]); if (rowView.PkiVehicleID == 0) { LinkButton lbtnEditVehicle = e.Row.FindControl("lbtnEditVehicle") as LinkButton; if (lbtnEditVehicle != null) { lbtnEditVehicle.Enabled = true; } LinkButton lbtnDeleteVehicle = e.Row.FindControl("lbtnDeleteVehicle") as LinkButton; if (lbtnDeleteVehicle != null) { lbtnDeleteVehicle.Enabled = false; } } } }
public async Task <IActionResult> Get() { var vehicles = await _context.Vehicles .Include(m => m.Model) .Include(m => m.Model.Make) .ToListAsync(); var model = new VehiclesModel(); vehicles.ForEach(v => model.Vehicles.Add(new VehicleModel { VehicleId = v.VehicleId, MakeId = v.Model.MakeId, MakeName = v.Model.Make.Name, ModelId = v.ModelId, ModelName = v.Model.Name, Description = v.Description, Year = v.Year, Vin = v.Vin })); return(Ok(model)); }
public ActionResult <VehiclesModel> Get(string id) { try { if (string.IsNullOrWhiteSpace(id)) { return(new StatusCodeResult((int)HttpStatusCode.BadRequest)); } int.TryParse(id, out int Id); VehiclesModel vehiclesModel = _vehicleService.GetVehicleDetailsById(Id); return(Ok(vehiclesModel)); } catch (ArgumentNullException ane) { return(BadRequest(ane.Message)); } catch (Exception ex) { _logger?.LogCritical("There was an error on '{0}' invocation: {1}", nameof(Get), ex); return(new StatusCodeResult((int)HttpStatusCode.InternalServerError)); } }
protected void btnAddVehicle_Click(object sender, EventArgs e) { if (Page.IsValid) { try { string VehicleVinNo = txtVehicleVinNo.Text; if (VehicleVinNo == "" || VehicleVinNo == string.Empty) { VehicleVinNo = "0"; } else { VehicleVinNo = txtVehicleVinNo.Text; } VehiclesModel ObjVehicleModel; ObjVehicleModel = client.GetVehicleByVinNo(VehicleVinNo, ParlourId, MemberId); if (ObjVehicleModel != null) { ShowMessage(ref lblMessage, MessageType.Danger, "Vehicle Already Exists."); } else { ObjVehicleModel = new VehiclesModel(); ObjVehicleModel.VehicleMake = txtVehicleMake.Text; ObjVehicleModel.VehicleModel = txtVehicleModel.Text; ObjVehicleModel.VehicleYear = txtVehicleYear.Text; ObjVehicleModel.VehicleColor = txtVehicleColor.Text; ObjVehicleModel.VehicleTrackingCompany = txtVehicleTrackingCompany.Text; ObjVehicleModel.VehicleRegNo = txtVehicleRegNo.Text; ObjVehicleModel.VehicleVinNo = txtVehicleVinNo.Text; ObjVehicleModel.VehicleEngNo = txtVehicleEngNo.Text; ObjVehicleModel.FkiMemberID = this.MemberId; ObjVehicleModel.ParlourID = this.ParlourId; ObjVehicleModel.StartDate = DateTime.Now; ObjVehicleModel.LastModified = DateTime.Now; ObjVehicleModel.ModifiedUser = this.User.Identity.Name; int documentId; if (ObjVehicleModel.FkiMemberID != 0) { documentId = client.SaveVehicle(ObjVehicleModel); // bindVehicles(); } if (ObjVehicleModel.FkiMemberID == 0) { List <VehiclesModel> modelList = new List <VehiclesModel>(); if (Session["Vehicle"] == null) { modelList.Add(ObjVehicleModel); } else { modelList = (List <VehiclesModel>)Session["Vehicle"]; modelList.Add(ObjVehicleModel); } Session["Vehicle"] = modelList; } bindVehicles(); ClearVehiclesControl(); ScriptManager.RegisterStartupScript(this, this.GetType(), "goToTab5", "goToTab(5);", true); ShowMessage(ref lblMessage, MessageType.Success, "Vehicle successfully saved"); IncrementVehicle++; } } catch (FaultException <FuneralServiceFault> fault) { lblMessage.Text = "<div class='ibox-content'><div class='alert alert-Danger'>" + fault.Detail.Message + "</div>"; } catch (Exception ex) { ShowMessage(ref lblMessage, MessageType.Danger, ex.Message); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "goToTab5", "goToTab(5);", true); ShowMessage(ref lblMessage, MessageType.Danger, "Vehicle not saved"); } }
public IActionResult UpdateVehicle([FromBody] VehiclesModel vehiclemodel) { string Action = "Update"; try { string Result = ""; //if (vehiclemodel.ImageType == "") //{ // return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter Image Type" } }); //} //else if (vehiclemodel.VehicleImage != null && vehiclemodel.VehicleImage.Length > 0) { if (vehiclemodel.ImageType == "") { return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter Image Type" } })); } else { vehiclemodel.VehicleImageURL = AzureStorage.UploadImage(vehiclemodel.VehicleImage, Guid.NewGuid() + "." + vehiclemodel.ImageType, "vehicleimages").Result; } } if (vehiclemodel.LicencePlate == "") { return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter LicensePlate" } })); } else if (vehiclemodel.UserId <= 0) { return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter UserId" } })); } //if (Result == "Please enter LicensePlate") //{ // return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter LicensePlate" } }); //} //else if (Result == "Please enter Image Type") //{ // return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter Image Type" } }); //} //else if (Result == "Please enter UserId") //{ // return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter UserId" } }); //} string Results = SaveUpdateVehicle(vehiclemodel, Action); if (Results != "Error Updating the Vehicle") { int VehicleId = Convert.ToInt32(Results); return(StatusCode((int)HttpStatusCode.OK, new { VehicleId, message = vehiclemodel.LicencePlate + " is updated successfully" })); } else //if (Results == "Error Updating the Vehicle") { return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = "Vehicle not saved" } })); } } catch (Exception e) { string SaveErrorLog = Data.Common.SaveErrorLog("UpdateVehicle", e.Message); return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message.ToString() } })); } }
public IActionResult GetVehicleDetailedList(int VehicleId) { List <ServiceInfo> ServiceList = new List <ServiceInfo>(); PaymentDetails paymentinfo = new PaymentDetails(); PlanInfo planInfo = new PlanInfo(); List <PlanInfo> planInfoList = new List <PlanInfo>(); try { //var SearchRes = ""; //if (Search == null) //{ // SearchRes = ""; //} //else //{ // SearchRes = Search; //} DataSet ds = Data.Vehicles.GetVehicleDetailedList(VehicleId); DataTable dt = new DataTable(); DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); DataTable dt3 = new DataTable(); UserInfo userInfo = new UserInfo(); VehiclesModel vehicleInfo = new VehiclesModel(); // DataTable dt = Data.Vehicles.GetVehicleDetailedList(VehicleId); //if (ds.Tables.Count > 0) //{ dt = ds.Tables[0]; dt1 = ds.Tables[1]; dt2 = ds.Tables[2]; dt3 = ds.Tables[3]; if (dt.Rows.Count > 0) { userInfo.UserId = (dt.Rows[0]["UserId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["UserId"]); userInfo.Email = (dt.Rows[0]["Email"] == DBNull.Value ? "" : dt.Rows[0]["Email"].ToString()); userInfo.Name = (dt.Rows[0]["Name"] == DBNull.Value ? "" : dt.Rows[0]["Name"].ToString()); userInfo.PhoneNumber = (dt.Rows[0]["PhoneNumber"] == DBNull.Value ? "" : dt.Rows[0]["PhoneNumber"].ToString()); userInfo.IsEmailVerified = (dt.Rows[0]["IsEmailVerified"] == DBNull.Value ? false : (bool)dt.Rows[0]["IsEmailVerified"]); userInfo.IsPhoneNumVerified = (dt.Rows[0]["IsPhoneNumVerified"] == DBNull.Value ? false : (bool)dt.Rows[0]["IsPhoneNumVerified"]); userInfo.LocationID = (dt.Rows[0]["LocationID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["LocationID"]); userInfo.LocationLatitude = (dt.Rows[0]["LocationLatitude"] == DBNull.Value ? "-" : dt.Rows[0]["LocationLatitude"].ToString()); userInfo.LocationLongitude = (dt.Rows[0]["LocationLongitude"] == DBNull.Value ? "-" : dt.Rows[0]["LocationLongitude"].ToString()); userInfo.LocationFullAddress = (dt.Rows[0]["LocationFullAddress"] == DBNull.Value ? "" : dt.Rows[0]["LocationFullAddress"].ToString()); vehicleInfo.VehicleId = (dt.Rows[0]["VehicleId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["VehicleId"]); vehicleInfo.UserId = (dt.Rows[0]["UserId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["UserId"]); vehicleInfo.Make = (dt.Rows[0]["Make"] == DBNull.Value ? "" : dt.Rows[0]["Make"].ToString()); vehicleInfo.Model = (dt.Rows[0]["Model"] == DBNull.Value ? "" : dt.Rows[0]["Model"].ToString()); vehicleInfo.Year = (dt.Rows[0]["Year"] == DBNull.Value ? 0 :(int)dt.Rows[0]["Year"]); vehicleInfo.Color = (dt.Rows[0]["Color"] == DBNull.Value ? "" : dt.Rows[0]["Color"].ToString()); vehicleInfo.LicencePlate = (dt.Rows[0]["LicensePlate"] == DBNull.Value ? "" : dt.Rows[0]["LicensePlate"].ToString()); vehicleInfo.VehicleImageURL = (dt.Rows[0]["VehicleImageURL"] == DBNull.Value ? "" : dt.Rows[0]["VehicleImageURL"].ToString()); if (dt2.Rows.Count > 0) { // planInfo.PlanType = (dt.Rows[0]["PlanType"] == DBNull.Value ? "" : dt.Rows[0]["PlanType"].ToString()); for (int i = 0; i < dt2.Rows.Count; i++) { PlanInfo planInfo1 = new PlanInfo(); planInfo1.PlanType = (dt.Rows[0]["PlanType"] == DBNull.Value ? "" : dt.Rows[0]["PlanType"].ToString()); planInfo1.ServiceNameList = (dt2.Rows[i]["ServiceName"] == DBNull.Value ? "" : dt2.Rows[i]["ServiceName"].ToString()); planInfo1.ServiceDescription = (dt2.Rows[i]["ServiceDescription"] == DBNull.Value ? "" : dt2.Rows[i]["ServiceDescription"].ToString()); planInfoList.Add(planInfo1); } } for (int i = 0; i < dt3.Rows.Count; i++) { ServiceInfo vechiles = new ServiceInfo(); //vechiles.UserId = (dt.Rows[i]["UserId"] == DBNull.Value ? 0 : (int)dt.Rows[i]["UserId"]); //vechiles.Email = (dt.Rows[i]["Email"] == DBNull.Value ? "" : dt.Rows[i]["Email"].ToString()); //vechiles.Name = (dt.Rows[i]["Name"] == DBNull.Value ? "" : dt.Rows[i]["Name"].ToString()); //vechiles.PhoneNumber = (dt.Rows[i]["PhoneNumber"] == DBNull.Value ? "" : dt.Rows[i]["PhoneNumber"].ToString()); //vechiles.LocationID = (dt.Rows[i]["LocationID"] == DBNull.Value ? 0 : (int)dt.Rows[i]["LocationID"]); //vechiles.LocationLatitude = (dt.Rows[i]["LocationLatitude"] == DBNull.Value ? "" : dt.Rows[i]["LocationLatitude"].ToString()); //vechiles.LocationLongitude = (dt.Rows[i]["LocationLongitude"] == DBNull.Value ? "" : dt.Rows[i]["LocationLongitude"].ToString()); //vechiles.LocationFullAddress = (dt.Rows[i]["LocationFullAddress"] == DBNull.Value ? "" : dt.Rows[i]["LocationFullAddress"].ToString()); //vechiles.IsDeleted = (dt.Rows[i]["IsDeleted"] == DBNull.Value ? false : (bool)dt.Rows[i]["IsDeleted"]); //vechiles.VehicleId = (dt.Rows[i]["VehicleId"] == DBNull.Value ? 0 : (int)dt.Rows[i]["VehicleId"]); //vechiles.Make = (dt.Rows[i]["Make"] == DBNull.Value ? "" : dt.Rows[i]["Make"].ToString()); //vechiles.Model = (dt.Rows[i]["Model"] == DBNull.Value ? "" : dt.Rows[i]["Model"].ToString()); //vechiles.Color = (dt.Rows[i]["Color"] == DBNull.Value ? "" : dt.Rows[i]["Color"].ToString()); //vechiles.LicensePlate = (dt.Rows[i]["LicensePlate"] == DBNull.Value ? "" : dt.Rows[i]["LicensePlate"].ToString()); //vechiles.VehicleImage = ((byte[])dt.Rows[i]["VehicleImage"]); //vechiles.VehicleImageURL = (dt.Rows[0]["VehicleImageURL"] == DBNull.Value ? "" : dt.Rows[0]["VehicleImageURL"].ToString()); //vechiles.ServiceDescription = (dt.Rows[i]["ServiceDescription"] == DBNull.Value ? "" : dt.Rows[i]["ServiceDescription"].ToString()); //vechiles.PlanType = (dt.Rows[i]["PlanType"] == DBNull.Value ? "" : dt.Rows[i]["PlanType"].ToString()); vechiles.ServicePlanID = (dt.Rows[i]["ServicePlanID"] == DBNull.Value ? 0 : (int)dt.Rows[i]["ServicePlanID"]); vechiles.ServiceID = (dt.Rows[i]["ServiceID"] == DBNull.Value ? 0 : (int)dt.Rows[i]["ServiceID"]); vechiles.ServiceName = (dt.Rows[1]["ServiceNameList"] == DBNull.Value ? "" : dt.Rows[1]["ServiceNameList"].ToString()); vechiles.ServiceAmount = (dt3.Rows[i]["Amount"] == DBNull.Value ? 00 : (decimal)dt3.Rows[i]["Amount"]); //(dt.Rows[i]["IsEmailVerified"] == DBNull.Value ? false : (bool)dt.Rows[i]["IsEmailVerified"]); vechiles.RequestedServiceDate = (dt3.Rows[i]["RequestedServiceDate"] == DBNull.Value ? "" : dt3.Rows[i]["RequestedServiceDate"].ToString()); vechiles.RemainderMinutes = (dt.Rows[i]["RemainderMinutes"] == DBNull.Value ? 0 : (int)dt.Rows[i]["RemainderMinutes"]); vechiles.ActualServiceDate = (dt.Rows[i]["ActualServiceDate"] == DBNull.Value ? "" : dt.Rows[i]["ActualServiceDate"].ToString()); vechiles.ServiceOutDate = (dt3.Rows[i]["ServiceOutDate"] == DBNull.Value ? "" : dt3.Rows[i]["ServiceOutDate"].ToString()); vechiles.Status = (dt3.Rows[i]["Status"] == DBNull.Value ? "" : dt3.Rows[i]["Status"].ToString()); vechiles.IsTeamsandConditionsAccepted = (dt.Rows[i]["IsTeamsandConditionsAccepted"] == DBNull.Value ? false : (bool)dt.Rows[i]["IsTeamsandConditionsAccepted"]); vechiles.ServicePriceChartId = (dt.Rows[i]["ServicePriceChartId"] == DBNull.Value ? 0 : (int)dt.Rows[i]["ServicePriceChartId"]); vechiles.ScheduleID = (dt3.Rows[i]["ScheduleID"] == DBNull.Value ? 0 : (int)dt3.Rows[i]["ScheduleID"]); vechiles.Comments = (dt3.Rows[i]["Comments"] == DBNull.Value ? "-" : dt3.Rows[i]["Comments"].ToString()); //vechiles.PaymentDetailId = (dt.Rows[i]["PaymentDetailId"] == DBNull.Value ? 0 : (int)dt.Rows[i]["PaymentDetailId"]); //vechiles.PaymentType = (dt.Rows[i]["PaymentType"] == DBNull.Value ? "" : dt.Rows[i]["PaymentType"].ToString()); //vechiles.Amount = (dt.Rows[i]["Amount"] == DBNull.Value ? 00 : (decimal)dt.Rows[i]["Amount"]); //vechiles.Promocode_ReducedAmount = (dt.Rows[i]["Promocode_ReducedAmount"] == DBNull.Value ? 00 : (decimal)dt.Rows[i]["Promocode_ReducedAmount"]); //vechiles.PaymentDate = (dt.Rows[i]["PaymentDate"] == DBNull.Value ? "" : dt.Rows[i]["PaymentDate"].ToString()); //vechiles.PaymentStatus = (dt.Rows[i]["PaymentStatus"] == DBNull.Value ? "" : dt.Rows[i]["PaymentStatus"].ToString()); ServiceList.Add(vechiles); } if (dt1.Rows.Count > 0) { paymentinfo.PaymentDetailId = (dt.Rows[0]["PaymentDetailId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PaymentDetailId"]); paymentinfo.PaymentType = (dt.Rows[0]["PaymentType"] == DBNull.Value ? "" : dt.Rows[0]["PaymentType"].ToString()); paymentinfo.TotalAmount = (dt1.Rows[0]["TotalAmount"] == DBNull.Value ? 00 : (decimal)dt1.Rows[0]["TotalAmount"]); paymentinfo.Paid = (dt.Rows[0]["Amount"] == DBNull.Value ? 00 : (decimal)dt.Rows[0]["Amount"]); paymentinfo.Due = ((dt1.Rows[0]["TotalAmount"] == DBNull.Value ? 00 : (decimal)dt1.Rows[0]["TotalAmount"]) - (dt.Rows[0]["Amount"] == DBNull.Value ? 00 : (decimal)dt.Rows[0]["Amount"])); //(dt1.Rows[0]["Amount"] == DBNull.Value ? 00 : (decimal)dt1.Rows[0]["Amount"]); paymentinfo.Promocode_ReducedAmount = (dt.Rows[0]["Promocode_ReducedAmount"] == DBNull.Value ? "" : dt.Rows[0]["Promocode_ReducedAmount"].ToString()); paymentinfo.PaymentDate = (dt.Rows[0]["PaymentDate"] == DBNull.Value ? "" : dt.Rows[0]["PaymentDate"].ToString()); paymentinfo.PaymentStatus = (dt.Rows[0]["PaymentStatus"] == DBNull.Value ? "" : dt.Rows[0]["PaymentStatus"].ToString()); } return(StatusCode((int)HttpStatusCode.OK, new { userInfo, vehicleInfo, planInfoList, ServiceList, paymentinfo })); } else { string[] data = new string[0]; return(StatusCode((int)HttpStatusCode.OK, data)); // return StatusCode((int)HttpStatusCode.OK, new { }); } //} } catch (Exception e) { string SaveErrorLog = Data.Common.SaveErrorLog("VehicleDetailsList", e.Message); return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message.ToString() } })); } }
public static int SaveVehicle(VehiclesModel model) { return(MembersDAL.SaveVehicle(model)); }
public void InsertIntoVehicleRecordProperties(VehiclesModel vehicles, decimal id) { _vehicleRepository.InsertIntoVehicleRecordProperties(vehicles, id); }
public static int UpdateVehicle(VehiclesModel model) { return(MembersDAL.UpdateVehicle(model)); }
public IActionResult SaveVehicle([FromBody] VehiclesModel vehiclemodel) //int VehicleId, int UserId, string Make, string Model, int Year, string Color, string LicensePlate, string SpecialNotes { //string GetConnectionString = VehiclesController.GetConnectionString(); string Action = "Add"; try { if (vehiclemodel.VehicleImage != null && vehiclemodel.VehicleImage.Length > 0) { if (vehiclemodel.ImageType == "") { return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter Image Type" } })); } else { vehiclemodel.VehicleImageURL = AzureStorage.UploadImage(vehiclemodel.VehicleImage, Guid.NewGuid() + "." + vehiclemodel.ImageType, "vehicleimages").Result; } } if (vehiclemodel.LicencePlate == "") { return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter LicensePlate" } })); } else if (vehiclemodel.UserId <= 0) { return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter UserId" } })); } // string Results = SaveUpdateVehicle(vehiclemodel, Action); string Results = SaveUpdateVehicle(vehiclemodel, Action); if (Results != "Error Updating the Vehicle") { int VehicleId = Convert.ToInt32(Results); return(StatusCode((int)HttpStatusCode.OK, new { VehicleId, message = vehiclemodel.LicencePlate + " is saved successfully" })); } else //if (Results == "Error Updating the Vehicle") { return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = "Vehicle not saved" } })); } //if (Results == "Please enter LicensePlate") //{ // return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter LicensePlate" } }); //} //else if (Results == "Please enter Image Type") //{ // return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter Image Type" } }); //} //else if (Results == "Success") //{ // return StatusCode((int)HttpStatusCode.OK, "Saved Successfully"); //} //else if (Results == "Please enter UserId") //{ // return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter UserId" } }); //} //else //if (Results == "Error Updating the Vehicle") //{ // return StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = "Vehicle not saved" } }); //} } catch (Exception e) { if (e.Message.Contains("UNIQUE KEY constraint") == true) { return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = "LicensePlate is already exists" } })); } else { string SaveErrorLog = Data.Common.SaveErrorLog("SaveVehicle", e.Message); return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message.ToString() } })); } } }