public AppointmentApproval(Donor donor) { InitializeComponent(); this.donor = donor; DC = new BloodBankDBDataContext(); if (donor != null) { txt_Name.Text = donor.Name; txt_bloodGroup.Text = DC.BloodGroups.First(d => d.Id == donor.BloodGroup).Name; txt_Donor_No.Text = donor.Id.ToString(); if (donor.Date > DateTime.UtcNow) { MessageBox.Show("Donor already have an appointment"); btn_Submit.Visibility = Visibility.Hidden; } else { btn_Submit.Visibility = Visibility.Visible; } } }
private City[] cityList; // array of city public EditDonor(Donor donor) { InitializeComponent(); this.donor = donor; DC = new BloodBankDBDataContext(); // get all provinces, add into array and show in combobox var provinces = from P in DC.Provinces select P; provinceList = new Province[provinces.ToList().Count]; int i = 0; foreach (var p in provinces.ToList()) { provinceList[i] = p; i++; } ddlProvince.ItemsSource = provinces.Distinct(); ddlCity.DisplayMemberPath = "ProvinceName"; var cities = from P in DC.Cities select P; cityList = new City[cities.ToList().Count]; i = 0; foreach (var p in cities.ToList()) { cityList[i] = p; i++; } ddlCity.ItemsSource = cities.Distinct(); ddlCity.DisplayMemberPath = "CityName"; if (donor != null) { NameTextBox.Text = donor.Name; txtPhone.Text = donor.Phone; } }
// On click add button, validate all data and save into database private void AddButton_Click(object sender, RoutedEventArgs e) { AddButton.Focusable = false; if (NameTextBox.Text == null || NameTextBox.Text.Length == 0 || PhoneTextBox.Text == null || PhoneTextBox.Text.Length == 0 || AgeTextBox.Text == null || AgeTextBox.Text.Length == 0 || BloodGroupComboBox.SelectedIndex < 0 || CityComboBox.SelectedIndex < 0 || ProvinceComboBox.SelectedIndex < 0) { MessageBox.Show("Please fill all fields"); return; } int provinceId = provinceList[ProvinceComboBox.SelectedIndex].Id; int bloodGroupId = bloodgroupList[BloodGroupComboBox.SelectedIndex].Id; int cityId = cityList[CityComboBox.SelectedIndex].Id; Donor Dnrobj = new Donor(); Dnrobj.Name = NameTextBox.Text; Dnrobj.Age = int.Parse(AgeTextBox.Text); Dnrobj.Gender = Male.IsChecked.GetValueOrDefault() ? "Male" : "Female"; Dnrobj.City = cityId; Dnrobj.Province = provinceId; Dnrobj.Phone = PhoneTextBox.Text; Dnrobj.BloodGroup = bloodGroupId; Dnrobj.BloodAvailable = Yes.IsChecked.GetValueOrDefault() ? 1 : 0; Dnrobj.Date = DateTime.Now; DC.Donors.InsertOnSubmit(Dnrobj); DC.SubmitChanges(); MessageBox.Show("Donor is added successfully!"); Close(); }
private void detach_Donors(Donor entity) { this.SendPropertyChanging(); entity.City1 = null; }
private void attach_Donors(Donor entity) { this.SendPropertyChanging(); entity.City1 = this; }
partial void DeleteDonor(Donor instance);
partial void UpdateDonor(Donor instance);
partial void InsertDonor(Donor instance);