//Tuition fees async private void UpdateTuitionFeeButton(object sender, EventArgs e) { try { yearPicker = YearPicker as Picker; int yearCost = 0; var tuitionfees = new TuitionFees(); tuitionfees.yearName = yearPicker.SelectedItem.ToString(); try { tuitionfees.cost = int.Parse(TuitionFeeCost.Text); } catch (Exception) { DisplayAlert(alertTitle, notNumberErrorMessage, alertCheck); } await App.Database.SaveTuitionFeesAsync(tuitionfees); toast.ShowToast(uploadSuccessfullMessage); } catch (Exception) { DisplayAlert(alertTitle, nullNameErrorMessage, alertCheck); } }
public override string ToString() { var sb = new StringBuilder(); sb.Append($"Student[{ID}] ") .Append($"{User.FirstName} {User.LastName} | ") .Append($"DOB: {(DateOfBirth != null ? ((DateTime)DateOfBirth).ToString("yyyy/MM/dd") + " | " : "N/A | ")}") .Append($"Tuition fees: {(TuitionFees != null ? TuitionFees.ToString() : "N/A")}"); return(sb.ToString()); }
async public Task <int> SaveTuitionFeesAsync(TuitionFees tuitionFees) { var checkIfexists = new TuitionFees(); checkIfexists = await GetTuitionFeesAsync(tuitionFees.yearName); if (checkIfexists != null) { return(await _database.UpdateAsync(tuitionFees)); } else { return(await _database.InsertAsync(tuitionFees)); } }
async private void DeleteYearFeesButton(object sender, EventArgs e) { try { // delete tuition fees yearPicker = YearPicker as Picker; var tuitionfees = new TuitionFees(); tuitionfees.yearName = yearPicker.SelectedItem.ToString(); await App.Database.DeleteTuitionFeesAsync(tuitionfees); //delete fixed charge var fixedCharges = new FixedCharges(); fixedCharges.yearName = yearPicker.SelectedItem.ToString(); await App.Database.DeleteFixedChargesAsync(fixedCharges); // delete external examination fees var externalExaminationFees = new ExternalExaminationFees(); externalExaminationFees.yearName = yearPicker.SelectedItem.ToString(); await App.Database.DeleteExternalExaminationFeesAsync(externalExaminationFees); // delete school meals var schoolMeals = new SchoolMeals(); schoolMeals.yearName = yearPicker.SelectedItem.ToString(); await App.Database.DeleteSchoolMealsAsync(schoolMeals); //deleste wednseday meals var wednesdayMeals = new WednesdayMeals(); wednesdayMeals.yearName = yearPicker.SelectedItem.ToString(); await App.Database.DeleteWednesdayMealsAsync(wednesdayMeals); await Navigation.PushAsync(new UpdateParameters()); toast.ShowToast(deleteMessage); } catch (Exception) { DisplayAlert(alertTitle, nullNameErrorMessage, alertCheck); } }
//set tuition fees button async private void SetTuitionFees(object sender, EventArgs e) { int yearCost = 0; var tuitionfees = new TuitionFees();; if (!(string.IsNullOrEmpty(TuitionFeesYear.Text))) { try { try { yearCost = int.Parse(TuitionFeesCost.Text); errorTuitionCostMessage.IsVisible = false; } catch (Exception) { DisplayAlert(alertTitle, notNumberErrorMessage, alertCheck); } tuitionfees.yearName = TuitionFeesYear.Text; await App.Database.SaveTuitionFeesAsync(tuitionfees); tuitionfees = await App.Database.GetTuitionFeesAsync(TuitionFeesYear.Text); tuitionfees.cost = yearCost; await Navigation.PushAsync(new SetParameters()); toast.ShowToast(uploadSuccessfullMessage); } catch (Exception) { DisplayAlert(alertTitle, nullNameErrorMessage, alertCheck); } } else { DisplayAlert(alertTitle, nullNameErrorMessage, alertCheck); } }
async public void addTuitionFees(String year, int cost) { TuitionFees tuitionFees = new TuitionFees(); tuitionFees.yearName = year; tuitionFees.cost = cost; await App.Database.SaveTuitionFeesAsync(tuitionFees); }
//Calculate the total and display errors async void Button_Calculate(object sender, EventArgs e) { //scroll to the end await ChildScrollView.ScrollToAsync(ResultLabel, ScrollToPosition.End, true).ConfigureAwait(true); //set all pickers Picker yearPicker = YearPicker as Picker; Picker termDiscountPicker = TermDiscountPicker as Picker; Picker zonePicker = ZonePicker as Picker; Picker supervisionPicker = SupervisionPicker as Picker; Picker supportPicker = SupportPicker as Picker; //set all picked parameters string year; string zone; string assistanceDicountName; string siblingDicountName; string termDiscountName; string supervisionName; string supportName; child = (Child)BindingContext; try { year = yearPicker.SelectedItem.ToString(); if (year == "<Empty>") { child.yearName = null; child.tuitionFees = 0; child.fixedCharges = 0; child.externalExaminationFees = 0; child.schoolMeals = 0; child.wednesdayMeals = 0; } //Get all corresponding cost EnrolementFees enrolementFee = await App.Database.GetEnrolementFeesAsync(0); TuitionFees tuitionFees = await App.Database.GetTuitionFeesAsync(year); FixedCharges fixedCharges = await App.Database.GetFixedChargesAsync(year); ExternalExaminationFees examinationFees = await App.Database.GetExternalExaminationFeesAsync(year); //set mandatory fees Child with entries provided by user child.yearName = year; child.enrolementFee = enrolementFee.cost; child.tuitionFees = tuitionFees.cost; child.recalculatedTuitionFees = tuitionFees.cost; child.fixedCharges = fixedCharges.cost; child.externalExaminationFees = examinationFees.cost; // enrolementFeeValue.Text = n.ToNumberFormat() + devise; enrolementFeeValue.Text = n.ToNumberFormat(child.enrolementFee) + devise; tuitionFeesValue.Text = n.ToNumberFormat(child.tuitionFees) + devise; fixedChargesValue.Text = n.ToNumberFormat(child.fixedCharges) + devise; externalExaminationFeesValue.Text = n.ToNumberFormat(child.externalExaminationFees) + devise; } catch (Exception) { } // set Optionnal assistance discount try { assistanceDicountName = childrenNr[0]; if (assistanceDiscountCheckBox.IsChecked == false) { child.assistanceDiscountName = null; child.assistanceDiscount = 0; } else { AssistanceDiscount assistanceDiscount = await App.Database.GetAssistanceDiscountAsync(assistanceDicountName); child.assistanceDiscount = assistanceDiscount.discountPercentage; child.assistanceDiscountName = assistanceDicountName; } assistanceDiscountValue.Text = n.ToNumberFormat(child.assistanceDiscount * child.tuitionFees / 100) + devise; child.recalculatedTuitionFees = child.tuitionFees * (100 + child.assistanceDiscount) / 100; } catch (Exception) { } // set Optionnal sibling discount try { siblingDicountName = childrenNr[1]; if (siblingDiscountCheckBox.IsChecked == false) { child.siblingDiscountName = null; child.siblingDiscount = 0; } else { AssistanceDiscount siblingDiscount = await App.Database.GetAssistanceDiscountAsync(siblingDicountName); child.siblingDiscount = siblingDiscount.discountPercentage; child.siblingDiscountName = siblingDicountName; } siblingDiscountValue.Text = n.ToNumberFormat(child.siblingDiscount * (child.recalculatedTuitionFees) / 100) + devise; child.recalculatedTuitionFees = child.recalculatedTuitionFees * (100 + child.siblingDiscount) / 100; } catch (Exception) { } // set Optionnal term discount try { termDiscountName = termDiscountPicker.SelectedItem.ToString(); if (termDiscountName == "<Empty>") { child.termDiscountName = null; child.termDiscount = 0; } else { TermDiscount termDiscount = await App.Database.GetTermDiscountAsync(termDiscountName); child.termDiscount = termDiscount.discountPercentage; child.termDiscountName = termDiscountName; } termDiscountValue.Text = n.ToNumberFormat(child.termDiscount * (child.tuitionFees - child.assistanceDiscount) / 100) + devise; child.recalculatedTuitionFees = (child.recalculatedTuitionFees - child.assistanceDiscount - child.siblingDiscount) * (100 + child.termDiscount) / 100; } catch (Exception) { } // set Optionnal school meal try { if (schoolMealsCheckBox.IsChecked) { year = yearPicker.SelectedItem.ToString(); SchoolMeals schoolMeals = await App.Database.GetSchoolMealsAsync(year); child.schoolMeals = schoolMeals.cost; } else { child.schoolMeals = 0; } schoolMealsValue.Text = n.ToNumberFormat(child.schoolMeals) + devise; } catch (Exception) { } // set Optionnal wednesday meal try { if (wednesdayMealsCheckBox.IsChecked) { year = yearPicker.SelectedItem.ToString(); WednesdayMeals wednesdayMeals = await App.Database.GetWednesdayMealsAsync(year); child.wednesdayMeals = wednesdayMeals.cost; } else { child.wednesdayMeals = 0; } wednesdayMealsValue.Text = n.ToNumberFormat(child.wednesdayMeals) + devise; } catch (Exception) { } // set Optionnal school transport try { zone = zonePicker.SelectedItem.ToString(); if (zone == "<Empty>") { child.zoneName = null; child.schoolTransport = 0; } else { SchoolTransport schoolTransport = await App.Database.GetSchoolTransportAsync(zone); child.schoolTransport = schoolTransport.cost; child.zoneName = zone; } schoolTransportValue.Text = n.ToNumberFormat(child.schoolTransport) + devise; } catch (Exception) { } // set Optionnal supervision try { supervisionName = supervisionPicker.SelectedItem.ToString(); if (supervisionName == "<Empty>") { child.supervisionName = null; child.supervision = 0; } else { Supervision supervision = await App.Database.GetSupervisionAsync(supervisionName); child.supervision = supervision.cost; child.supervisionName = supervisionName; } supervisionValue.Text = n.ToNumberFormat(child.supervision) + devise; } catch (Exception) { } // set Optionnal support transport try { supportName = supportPicker.SelectedItem.ToString(); if (supportName == "<Empty>") { child.supportName = null; child.support = 0; } else { Support support = await App.Database.GetSupportAsync(supportName); child.support = support.cost; child.supportName = supportName; } supportValue.Text = n.ToNumberFormat(child.support) + devise; } catch (Exception) { } child.childName = ChildNameValue.Text; //set the child name if it has been modified //set total child cost child.cost = (child.fixedCharges + child.recalculatedTuitionFees + child.enrolementFee + child.externalExaminationFees + child.schoolMeals + child.schoolTransport + child.supervision + child.support); Family family = await App.Database.GetFamilyByIdAsync(child.familyId); family.totalCost = family.totalCost + child.cost; await App.Database.SaveFamilyAsync(family); //save child in database await App.Database.SaveChildAsync(child); //Display result ResultLabel.Text = n.ToNumberFormat(child.cost) + devise; }
public Task <int> DeleteTuitionFeesAsync(TuitionFees tuitionFees) { return(_database.DeleteAsync(tuitionFees)); }
public override string ToString() { return(String.Format("{0, -11} {1, -22} {2, -32} {3, -15} {4, -14}", StudentId, FirstName, LastName, DateOfBirth.ToString("dd'/'MM'/'yyyy"), TuitionFees.ToString("F"))); }