//Fixed charges async private void UpdateFixedChargeButton(object sender, EventArgs e) { try { yearPicker = YearPicker as Picker; int yearCost = 0; var fixedCharges = new FixedCharges(); fixedCharges.yearName = yearPicker.SelectedItem.ToString(); try { fixedCharges.cost = int.Parse(FixedChargeCost.Text); } catch (Exception) { DisplayAlert(alertTitle, notNumberErrorMessage, alertCheck); } await App.Database.SaveFixedChargesAsync(fixedCharges); toast.ShowToast(uploadSuccessfullMessage); } catch (Exception) { DisplayAlert(alertTitle, nullNameErrorMessage, alertCheck); } }
public ActionResult NewOrEdit(FixedCharges model) { try { var db = DB.Entities; if (model.ID == 0) { // Edit db.FixedCharges.AddObject(model); } else { // Add new db.AttachTo("FixedCharges", model); db.ObjectStateManager.ChangeObjectState(model, System.Data.EntityState.Modified); } db.SaveChanges(); return(RedirectToAction("Index")); } catch { } SelectOption(model); return(View(model)); }
void SelectOption(FixedCharges obj) { #region SELECT OPTION string dataDriver_Info = "<option value=''>--Select Driver_Info--</option>"; foreach (var item in NationalIT.DB.Entities.Driver_Info) { if (obj.DriverID.HasValue && item.ID == obj.DriverID.Value) { dataDriver_Info += string.Format("<option value='{0}' selected='selected'>{1} {2}</option>", item.ID, item.Last_name, item.First_name); } else { dataDriver_Info += string.Format("<option value='{0}'>{1} {2}</option>", item.ID, item.Last_name, item.First_name); } } ViewBag.dataDriver_Info = dataDriver_Info; string dataFrequency = "<option value='0'>-:-</option>"; foreach (var item in NationalIT.DB.Entities.Frequency) { if (obj.Frequency != 0) { dataFrequency += string.Format("<option value='{0}' selected='selected'>{1}</option>", item.ID, item.Title); } else { dataFrequency += string.Format("<option value='{0}'>{1}</option>", item.ID, item.Title); } } ViewBag.dataFrequency = dataFrequency; #endregion }
public ActionResult NewOrEdit(int?driverID, int?id = 0) { var obj = DB.Entities.FixedCharges.FirstOrDefault(m => m.ID == id); if (obj == null) { obj = new FixedCharges() { DriverID = driverID.HasValue ? driverID.Value : 0 }; } SelectOption(obj); return(View(obj)); }
async public Task <int> SaveFixedChargesAsync(FixedCharges fixedCharges) { var checkIfexists = new FixedCharges(); checkIfexists = await GetFixedChargesAsync(fixedCharges.yearName); if (checkIfexists != null) { return(await _database.UpdateAsync(fixedCharges)); } else { return(await _database.InsertAsync(fixedCharges)); } }
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 fixed charges button async private void SetFixedCharges(object sender, EventArgs e) { int cost = 0; var fixedCharges = new FixedCharges();; if (!(string.IsNullOrEmpty(FixedChargesYear.Text))) { try { cost = int.Parse(FixedChargesCost.Text); } catch (Exception) { DisplayAlert(alertTitle, notNumberErrorMessage, alertCheck); } try { fixedCharges.yearName = FixedChargesYear.Text; await App.Database.SaveFixedChargesAsync(fixedCharges); fixedCharges = await App.Database.GetFixedChargesAsync(FixedChargesYear.Text); errorFixedChargesCostMessage.IsVisible = false; fixedCharges.cost = cost; await Navigation.PushAsync(new SetParameters()); toast.ShowToast(uploadSuccessfullMessage); } catch (Exception) { DisplayAlert(alertTitle, nullNameErrorMessage, alertCheck); } } else { DisplayAlert(alertTitle, nullNameErrorMessage, alertCheck); } }
async public void addFixedCharges(String year, int cost) { FixedCharges fixedCharges = new FixedCharges(); fixedCharges.yearName = year; fixedCharges.cost = cost; await App.Database.SaveFixedChargesAsync(fixedCharges); }
//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> DeleteFixedChargesAsync(FixedCharges fixedCharges) { return(_database.DeleteAsync(fixedCharges)); }