/// \brief This method UpdateMileage for user /// \details <b>Details</b> /// This method will update mileage when finishing order /// \return void public bool UpdateMileage(Mileage mileage) { using (var myConn = new MySqlConnection(connectionString)) { try { const string sqlStatement = @" UPDATE mileage SET startCityID = @startCityID, endCityID = @endCityID, distance = @distance, workingTime = @workingTime WHERE mileageID = @mileageID; " ; var myCommand = new MySqlCommand(sqlStatement, myConn); myCommand.Parameters.AddWithValue("@startCityID", mileage.startCityID); myCommand.Parameters.AddWithValue("@endCityID", mileage.endCityID); myCommand.Parameters.AddWithValue("@distance", mileage.distance); myCommand.Parameters.AddWithValue("@workingTime", mileage.workingTime); myCommand.Parameters.AddWithValue("@mileageID", mileage.mileageID); myConn.Open(); myCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } } }
internal override object[] getRow() { MileageList mileageList = MileageList.getInstance(); Mileage mileage = mileageList.getItem(this); InvoiceList invoiceList = InvoiceList.getInstance(); Invoice invoice = invoiceList.getItem(this); PTSList ptsList = PTSList.getInstance(); PTS pts = ptsList.getItem(this); STSList stsList = STSList.getInstance(); STS sts = stsList.getItem(this); Regions regions = Regions.getInstance(); string regionName = (invoice == null) ? regions.getItem(_idRegionUsing) : regions.getItem(Convert.ToInt32(invoice.RegionToID)); int mileageInt = 0; DateTime mileageDate = DateTime.Today; if (mileage != null) { int.TryParse(mileage.Count, out mileageInt); mileageDate = mileage.MonthToString(); } return(new object[] { ID, ID, BBNumber, Grz, Mark.Name, info.Model, vin, regionName, info.Driver.GetName(NameType.Full), pts.Number, sts.Number, Year, mileageInt, mileageDate, info.Owner, info.Guarantee, GetStatus() }); }
private void SetMileage(Car car, string value) { int count; int.TryParse(value, out count); if (count == 0) { return; } MileageList mileageList = MileageList.getInstance(); Mileage mileage = mileageList.getItem(car); if (count > Convert.ToInt32(mileage.Count)) { if (mileage.Count != string.Empty) { mileage = car.createMileage(); } mileage.Date = new DateTime(_date.Year, _date.Month, DateTime.DaysInMonth(_date.Year, _date.Month)); mileage.SetCount(value); mileage.Save(); _mileageReportList.Add(new MileageReport(car, "Пробег загружен")); } else if (count < Convert.ToInt32(mileage.Count)) { _mileageReportList.Add(new MileageReport(car, "Значение пробега меньше, чем уже внесён в систему.")); } else { _mileageReportList.Add(new MileageReport(car, "Новое значение пробега равно значению пробега уже внесённому в систему.")); } }
// PUT api/Server/5 public IHttpActionResult PutMileage(int id, Mileage mileage) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != mileage.Id) { return(BadRequest()); } db.Entry(mileage).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!MileageExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public Decimal GetMileage(string originPostalCode, string destinationPostalCode) { // Decimal miles = 0; RateWareXLPortTypeClient client = new RateWareXLPortTypeClient(); try { AuthenticationToken authToken = getAuthenticationToken(); if (client.isReady(authToken)) { ShipmentLocale org = new ShipmentLocale(); org.postalCode = originPostalCode; org.countryCode = "USA"; ShipmentLocale dest = new ShipmentLocale(); dest.postalCode = destinationPostalCode; dest.countryCode = "USA"; Mileage mileage = new Mileage(); mileage.releaseVersion = "22"; mileage.routingType = "P"; mileage.systemId = 1; mileage.origin = org; mileage.destination = dest; miles = (Decimal)client.Mileage(authToken, mileage); } client.Close(); } catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); } catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); } catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); } return(miles); }
private void Button_Click(object sender, RoutedEventArgs e) { var isMileageValid = true; var date = Convert.ToDateTime(DeliveryDateDatePicker.SelectedDate); double miles; if (!double.TryParse(MileageTotalTextbox.Text, out miles)) { isMileageValid = false; MessageBox.Show("Milease is not a number"); } if (date == DateTime.MinValue) { isMileageValid = false; MessageBox.Show("Selected date is invalid"); } var mileage = new Mileage { DeliveryDate = date, Miles = miles }; if (isMileageValid) { _repository.AddMileageRecord(mileage); } LoadGrid(); }
public virtual void AdditionalInfo() { Console.WriteLine("\tCost: {0} $", Cost.ToString("#.##")); Console.WriteLine("\tMileage: {0} km", Mileage.ToString("#.##")); Console.WriteLine("\tWeight: {0} kg", Weight.ToString("#.###")); Console.WriteLine("\tMax speed: {0} km/h", MaxSpeed.ToString("#.##")); }
/// \brief This method InsertMileage for user /// \details <b>Details</b> /// This method will insert mileage for making order /// \return void public bool InsertMileage(Mileage mileage) { using (var myConn = new MySqlConnection(connectionString)) { try { const string sqlStatement = @" INSERT INTO mileage (mileageID, startCityID, endCityID, distance, workingTime) VALUES (@mileageID, @depotCity, @endCityID, @distance, @workingTime); " ; var myCommand = new MySqlCommand(sqlStatement, myConn); myCommand.Parameters.AddWithValue("@startCityID", mileage.startCityID); myCommand.Parameters.AddWithValue("@endCityID", mileage.endCityID); myCommand.Parameters.AddWithValue("@distance", mileage.distance); myCommand.Parameters.AddWithValue("@workingTime", mileage.workingTime); myCommand.Parameters.AddWithValue("@mileageID", mileage.mileageID); myConn.Open(); myCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } } }
public void Delete(int idMileage) { Mileage mileage = getItem(idMileage); list.Remove(mileage); mileage.Delete(); }
public IActionResult Delete(Mileage m) { _context.Mileage.Remove(m); _context.SaveChanges(); return(RedirectToAction("List")); }
public ActionResult DeleteConfirmed(int id) { Mileage mileage = db.Mileages.Find(id); db.Mileages.Remove(mileage); db.SaveChanges(); return(RedirectToAction("Index")); }
public List <Mileage> calculateAverageDistance(List <Mileage> allMileages) { //bool foundOdometerValue = false; Mileage previousMileage = new Mileage(); List <Mileage> exactDayMileages = new List <Mileage>(); List <Mileage> result = new List <Mileage>(); foreach (Mileage mileage in allMileages) { if (previousMileage.OdometerMileage == 0 && mileage.OdometerMileage == 0) { continue; } if (previousMileage.OdometerMileage == 0 && mileage.OdometerMileage > 0) { previousMileage = mileage; result.Add(mileage); continue; } if (mileage.Distance > 0) { exactDayMileages.Add(mileage); } if (mileage.OdometerMileage > 0 && mileage.OdometerMileage > previousMileage.OdometerMileage) { //means that we have full period for odometr prediction result.Add(mileage); int dailyMileageKnown = 0; int daysKnown = 0; foreach (Mileage mileagePerDay in exactDayMileages) { dailyMileageKnown += mileagePerDay.Distance; daysKnown++; } int daysBetween = (mileage.Date - previousMileage.Date).Days - daysKnown; int mileageBetween = mileage.OdometerMileage - previousMileage.OdometerMileage - dailyMileageKnown; double dailyMileage = mileageBetween / daysBetween; foreach (Mileage mileagePerDay in exactDayMileages) { if (mileagePerDay.OdometerMileage == 0) { int daysFromPreviousMileage = (mileagePerDay.Date - previousMileage.Date).Days; int mileagePredicted = previousMileage.OdometerMileage + (int)(dailyMileage * daysFromPreviousMileage + mileagePerDay.Distance); result.Add(new Mileage(mileagePerDay.Date, mileagePredicted)); //allMileages.First(x => x.Id == mileagePerDay.Id).OdometerMileage = mileagePredicted; if (daysFromPreviousMileage > 1) { mileagePredicted -= mileagePerDay.Distance; result.Add(new Mileage(mileagePerDay.Date.AddDays(-1), mileagePredicted)); } } } exactDayMileages = new List <Mileage>(); previousMileage = mileage; } } return(result.OrderBy(x => x.Date).ToList());//allMileages; }
public void Add(Mileage mileage) { if (list.Exists(item => item == mileage)) { return; } list.Add(mileage); }
public void GetAnswer() { Decimal Mileage, Distance, Gallons; Distance = Convert.ToDecimal(txtDistance.Text); Gallons = Convert.ToDecimal(txtGallons.Text); Mileage = Distance / Gallons; MessageBox.Show(Mileage.ToString(), "Answer"); }
protected override void loadFromSql() { DataTable dt = _provider.Select("Mileage"); foreach (DataRow row in dt.Rows) { Mileage mileage = new Mileage(row); Add(mileage); } }
void Start () { stageMove = GameObject.FindObjectOfType<StageMove>(); creatorsManager = GameObject.FindObjectOfType<CreatorsManager>(); mileage = GameObject.FindObjectOfType<Mileage>(); isMoving = false; currentGrid = 0; nextGrid = Time.time; interval = gridLength / stageMove.fowardSpeed; }
//[Authorize(Roles = UtilityClass.AdminUserRole)] public IActionResult Create(Mileage m) { if (!ModelState.IsValid) { return(View()); } _context.Mileage.Add(m); _context.SaveChanges(); return(RedirectToAction("List")); }
public IHttpActionResult GetMileage(int id) { Mileage mileage = db.Mileages.Find(id); if (mileage == null) { return(NotFound()); } return(Ok(mileage)); }
protected static void Display(Mileage data, int indent, string description = null) { if (data == null) { return; } DisplayLabel(description ?? "Mileage", indent); DisplayValue("Miles", data.miles, indent + 1); DisplayValue("Method", data.method, indent + 1); }
//Create a Method to calculate Mileage public void GetAnswer() { //Create 3 variables to work with Decimal Mileage, Distance, Gallons; //Add code to set these values from the UI Distance = Convert.ToDecimal(txtDistance.Text); Gallons = Convert.ToDecimal(txtGallons.Text); Mileage = Distance / Gallons; MessageBox.Show(Mileage.ToString(), "Answer"); }
/// <summary> /// Compared the value of the <see cref="Mileage"/> property with that of another <see cref="Location"/> instance. /// </summary> /// <param name="other">A <see cref="Location"/> object to compare.</param> /// <returns>An integer indicating whether the <see cref="Mileage"/> property of this object is less than, equal to or greater than that of the parameter.</returns> public int CompareTo(Location other) { if (other is null || other.Mileage == null) { return(Mileage == null ? 0 : 1); } if (Mileage == null) { return(-1); } return(Mileage.CompareTo(other.Mileage)); }
public IActionResult AddMileage(Mileage mileage) { //Request.Form.Keys if (ModelState.IsValid) { this.db.Mileages.Add(mileage); this.db.SaveChanges(); return(this.RedirectToAction("Index", "Home")); } return(new EmptyResult()); }
public IHttpActionResult PostMileage(Mileage mileage) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Mileages.Add(mileage); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = mileage.Id }, mileage)); }
/// <summary> /// Compares the value of the <see cref="Mileage"/> property with a <see cref="Distance"/> parameter. /// </summary> /// <param name="other">A <see cref="Distance"/> parameter to compare.</param> /// <returns>An integer indicating whether the <see cref="Mileage"/> property is less than, equal to or greater than the parameter.</returns> public int CompareTo(Distance other) { if (other is null) { return(Mileage == null ? 0 : 1); } if (Mileage == null) { return(-1); } return(Mileage.CompareTo(other)); }
public IActionResult Edit(Mileage m) { if (!ModelState.IsValid) { return(View()); } _context.Mileage.Attach(m); _context.Entry(m).State = EntityState.Modified; _context.SaveChanges(); return(RedirectToAction("List")); }
private void _dgvMileage_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { int idMileage = Convert.ToInt32(_dgvMileage.Rows[e.RowIndex].Cells[0].Value); Mileage mileage = _mileageList.getItem(idMileage); Mileage_AddEdit mAE = new Mileage_AddEdit(mileage); if (mAE.ShowDialog() == System.Windows.Forms.DialogResult.OK) { loadMileage(); } }
private void btnAddMileage_Click(object sender, EventArgs e) { Mileage mileage = _car.createMileage(); Mileage_AddEdit mAE = new Mileage_AddEdit(mileage); if (mAE.ShowDialog() == System.Windows.Forms.DialogResult.OK) { _mileageList.Add(mileage); loadMileage(); } }
// GET: Mileages/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Mileage mileage = db.Mileages.Find(id); if (mileage == null) { return(HttpNotFound()); } return(View(mileage)); }
public ActionResult EditAdmin([Bind(Include = "ID,TravelDate,StartAddress,EndAddress,Kilometres,Feedback,StatusID,EmployeeID,ApplicationID")] Mileage mileage) { if (ModelState.IsValid) { db.Entry(mileage).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("IndexAdmin")); } PopulateDropDownLists(); ViewBag.ApplicationID = new SelectList(db.Applications, "ID", "Rationale", mileage.ApplicationID); ViewBag.EmployeeID = new SelectList(db.Employees, "ID", "FirstName", mileage.EmployeeID); ViewBag.StatusID = new SelectList(db.Statuses, "ID", "Description", mileage.StatusID); return(View(mileage)); }
public IHttpActionResult DeleteMileage(int id) { Mileage mileage = db.Mileages.Find(id); if (mileage == null) { return(NotFound()); } db.Mileages.Remove(mileage); db.SaveChanges(); return(Ok(mileage)); }
void ReleaseDesignerOutlets() { if (appraisalDate != null) { appraisalDate.Dispose(); appraisalDate = null; } if (ContainerView != null) { ContainerView.Dispose(); ContainerView = null; } if (Mileage != null) { Mileage.Dispose(); Mileage = null; } if (sacComment != null) { sacComment.Dispose(); sacComment = null; } if (SacCommentsWidth != null) { SacCommentsWidth.Dispose(); SacCommentsWidth = null; } if (Trim != null) { Trim.Dispose(); Trim = null; } if (Vin != null) { Vin.Dispose(); Vin = null; } if (YearMakeModel != null) { YearMakeModel.Dispose(); YearMakeModel = null; } }
protected void Button1_Click(object sender, EventArgs e) { //declare variables double price; double gallons; int miles; double cost=0; //create an instance of the service Mileage m = new Mileage(); //get the values from the text boxes //the try parse tests the values and returns a boolean //true if they are valid, false if not //if try it assigns the value to the outside //variable bool goodPrice= double.TryParse(txtPrice.Text, out price); bool goodGallons = double.TryParse(txtGallons.Text, out gallons); bool goodMiles = int.TryParse(txtTotalMiles.Text, out miles); if (goodPrice && goodGallons && goodMiles) { //if everything is ok pass the values to the service method //and get the response cost = m.CalculateCostPerMile(price, gallons, miles); } else { //otherwise create a javascript alert Response.Write("<script type='text/JavaScript'>alert('Make sure you only enter numbers')</script>"); return; } lblResult.Text = "Your cost per mile was " + cost.ToString("c"); }