/// <summary> /// Add trip function /// </summary> /// <param name="dateoftrip">Date of trip</param> /// <param name="days">Days of trip</param> /// <param name="numberofplaces">Number of places</param> /// <param name="pilotid">ID of pilot</param> /// <param name="priceperperson">Price per person</param> /// <returns></returns> public bool AddTrip(int priceperperson, int numberofplaces, string dateoftrip, int days, string pilotid, string city) { return(CallStoredProcedure(TravelAgencyStoredProcedures.spAddTrip, new List <Parameter> { new Parameter { Name = spAddTripParameters.pPPP.ToString(), Value = priceperperson }, new Parameter { Name = spAddTripParameters.pNOP.ToString(), Value = numberofplaces }, new Parameter { Name = spAddTripParameters.pTrips_date.ToString(), Value = dateoftrip }, new Parameter { Name = spAddTripParameters.pDays.ToString(), Value = days }, new Parameter { Name = spAddTripParameters.pPilot_id.ToString(), Value = DatabasetablesHelpers.ConvertNameToInt(pilotid) }, new Parameter { Name = spAddTripParameters.pCity.ToString(), Value = city }, })); }
/// <summary> /// Update trip function /// </summary> /// <param name="columnName">Name of updateing column</param> /// <param name="id">ID of updating trip</param> /// <param name="value">Value of updating column</param> public bool UpdateTrip(string columnName, int id, object value) { if (columnName == TripsColumn.name.ToString()) { value = DatabasetablesHelpers.ConvertNameToInt((string)value); } if (columnName == TripsColumn.pilot.ToString()) { value = DatabasetablesHelpers.ConvertNameToInt((string)value); } return(CallStoredProcedure(TravelAgencyStoredProcedures.spUpdateTrip, new List <Parameter> { new Parameter { Name = spUpdateTripParameters.pColumnName.ToString(), Value = columnName }, new Parameter { Name = spUpdateTripParameters.pId.ToString(), Value = id }, new Parameter { Name = spUpdateTripParameters.pValue.ToString(), Value = value }, })); }
/// <summary> /// Updates <see cref="CurrentInvoice"/> property /// </summary> /// <param name="invoice"></param> /// <returns></returns> public bool UpdateCurrentInvoice(string invoice) { CurrentInvoice.Clear(); foreach (DataRow row in Table.Rows) { if (int.Parse(row[0].ToString()) == DatabasetablesHelpers.ConvertNameToInt(invoice)) { for (int i = 0; i < Table.Columns.Count; i++) { if (i == 3 || i == 4) { string date = row[i].ToString(); string date2 = ""; for (int k = 0; date[k] != ' '; k++) { date2 += date[k]; } CurrentInvoice.Add(date2); continue; } CurrentInvoice.Add(row[i].ToString()); } break; } } return(true); }
/// <summary> /// Get list of places for specified trip as <see cref="List{int}<"/> /// </summary> /// <param name="tripId">Trip ID</param> /// <returns></returns> public List <int> BookedPlacesToList(string tripId) { List <int> places = new List <int>(); for (int i = 1; i <= GetBookedPlaces(DatabasetablesHelpers.ConvertNameToInt(tripId)); i++) { places.Add(i); } return(places); }
/// <summary> /// Add order function /// </summary> /// <param name="bookedplaces">Number of booked places</param> /// <param name="clientid">ID of client</param> /// <param name="tripid">ID of trip</param> /// <returns></returns> public bool AddOrder(string clientid, int bookedplaces, string tripid) { return(CallStoredProcedure(TravelAgencyStoredProcedures.spAddOrder, new List <Parameter> { new Parameter { Name = spAddOrderParameters.pClient_id.ToString(), Value = DatabasetablesHelpers.ConvertNameToInt(clientid) }, new Parameter { Name = spAddOrderParameters.pBooked_places.ToString(), Value = bookedplaces }, new Parameter { Name = spAddOrderParameters.pTrip_id.ToString(), Value = DatabasetablesHelpers.ConvertNameToInt(tripid) } })); }
/// <summary> /// Add client function /// </summary> /// <param name="bookedplaces">Number of booked places</param> /// <param name="clientid">ID of client</param> /// <param name="tripid">ID of trip</param> /// <returns></returns> public bool AddPayment(string invoiceid, double amount, string paymentMethod) { return(CallStoredProcedure(TravelAgencyStoredProcedures.spAddPayment, new List <Parameter> { new Parameter { Name = spAddPaymentParameters.pInvoice_id.ToString(), Value = DatabasetablesHelpers.ConvertNameToInt(invoiceid) }, new Parameter { Name = spAddPaymentParameters.pAmount.ToString(), Value = amount }, new Parameter { Name = spAddPaymentParameters.pPayment_method.ToString(), Value = DatabasetablesHelpers.ConvertNameToInt(paymentMethod) } })); }
/// <summary> /// Update order function /// </summary> /// <param name="columnName">Name of updating column</param> /// <param name="id">ID of updating order</param> /// <param name="value">Value of updating column</param> public bool UpdateOrder(string columnName, string id, object value) { if (columnName == OrdersColumn.orders_status.ToString()) { value = DatabasetablesHelpers.ConvertNameToInt((string)value); } return(CallStoredProcedure(TravelAgencyStoredProcedures.spUpdateOrders, new List <Parameter> { new Parameter { Name = spUpdateOrdersParameters.pColumnName.ToString(), Value = columnName }, new Parameter { Name = spUpdateOrdersParameters.pId.ToString(), Value = DatabasetablesHelpers.ConvertNameToInt(id) }, new Parameter { Name = spUpdateOrdersParameters.pValue.ToString(), Value = value }, })); }
/// <summary> /// Update employee function /// </summary> /// <param name="columnName">Name of updating column</param> /// <param name="id">ID of updating employee</param> /// <param name="value">Value of updating column</param> public bool UpdateEmployee(string columnName, string id, object value) { if (columnName == EmployeesColumn.gender.ToString()) { value = (bool)value == true ? 'M' : 'F'; } return(CallStoredProcedure(TravelAgencyStoredProcedures.spUpdateEmployee, new List <Parameter> { new Parameter { Name = spUpdateEmployeeParameters.pColumnName.ToString(), Value = columnName }, new Parameter { Name = spUpdateEmployeeParameters.pId.ToString(), Value = DatabasetablesHelpers.ConvertNameToInt(id) }, new Parameter { Name = spUpdateEmployeeParameters.pValue.ToString(), Value = value }, })); }
/// <summary> /// Add employee function /// </summary> /// <param name="firstName">Name</param> /// <param name="lastName">Last name</param> /// <param name="phone">Phone number</param> /// <param name="email">Email</param> /// <param name="birthDate">Birth date</param> /// <param name="locality">Locality</param> /// <param name="zip">ZIP code</param> /// <param name="throughfore">Throughfore</param> /// <param name="gender">Gender</param> /// <param name="position">Position</param> /// <returns></returns> public bool AddEmploee(string firstName, string lastName, string phone, string email, string birthDate, string locality, string zip, string throughfore, string gender, string position) { return(CallStoredProcedure(TravelAgencyStoredProcedures.spAddEmployee, new List <Parameter> { new Parameter { Name = spAddEmployeeParameters.pFirst_name.ToString(), Value = firstName }, new Parameter { Name = spAddEmployeeParameters.pLast_name.ToString(), Value = lastName }, new Parameter { Name = spAddEmployeeParameters.pPhone.ToString(), Value = phone }, new Parameter { Name = spAddEmployeeParameters.pEmail.ToString(), Value = email }, new Parameter { Name = spAddEmployeeParameters.pBirth_date.ToString(), Value = birthDate }, new Parameter { Name = spAddEmployeeParameters.pLocality.ToString(), Value = locality }, new Parameter { Name = spAddEmployeeParameters.pZip.ToString(), Value = zip }, new Parameter { Name = spAddEmployeeParameters.pThoroughfore.ToString(), Value = throughfore }, new Parameter { Name = spAddEmployeeParameters.pGender.ToString(), Value = gender }, new Parameter { Name = spAddEmployeeParameters.pPosition.ToString(), Value = DatabasetablesHelpers.ConvertNameToInt(position) } })); }
/// <summary> /// Delete reservation function /// </summary> /// <param name="reservationId">ID of reservation</param> public bool DeleteReservation(string reservationId) { return(CallStoredProcedure(TravelAgencyStoredProcedures.spDeleteReservation, new List <Parameter> { new Parameter { Name = spDeleteReservationParameters.pOrder_id.ToString(), Value = DatabasetablesHelpers.ConvertNameToInt(reservationId) } })); }