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);
