public RequestApproval(BloodRequest bloodRequest)
{
InitializeComponent();
DC = new BloodBankDBDataContext();
this.request = bloodRequest;
txt_requestNumber.Text = bloodRequest.Id.ToString();
txt_HospitalName.Text = request.HospitalId.ToString();
availabledonors = DC.Donors.Where(x => x.Date > DateTime.Now.AddMonths(+3) &&
x.BloodGroup == request.BloodGroupId).ToList();
if (availabledonors != null && availabledonors.Count > 0)
{
btn_Approve.Visibility = Visibility.Visible;
btn_Reject.Visibility = Visibility.Hidden;
ddl_donors.ItemsSource = availabledonors;
ddl_donors.DisplayMemberPath = "Name";
lbl_Donor.Visibility = Visibility.Visible;
lbl_Donor_Date.Visibility = Visibility.Visible;
ddl_donors.Visibility = Visibility.Visible;
dtp_date.Visibility = Visibility.Visible;
}
else
{
MessageBox.Show("No Donors available");
btn_Approve.Visibility = Visibility.Hidden;
btn_Reject.Visibility = Visibility.Visible;
lbl_Donor.Visibility = Visibility.Hidden;
lbl_Donor_Date.Visibility = Visibility.Hidden;
ddl_donors.Visibility = Visibility.Hidden;
dtp_date.Visibility = Visibility.Hidden;
}
}
public RequestList()
{
InitializeComponent();
DC = new BloodBankDBDataContext();
IdList = new List <int>();
LoadData();
}
public ViewDonors()
{
InitializeComponent();
DC = new BloodBankDBDataContext();
IdList = new List <int>();
LoadData();
}
private void btn_Reject_Click(object sender, RoutedEventArgs e)
{
var DC = new BloodBankDBDataContext();
var requests = DC.BloodRequests.First(x => x.Id == request.Id);
requests.Status = "REJECTED";
DC.SubmitChanges();
RequestList requestList = new RequestList();
requestList.ShowDialog();
}
private BloodGroup[] bloodgroupList; // array of blood groups
public AddNewDonor()
{
InitializeComponent();
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++;
}
ProvinceComboBox.ItemsSource = provinces.Distinct();
ProvinceComboBox.DisplayMemberPath = "ProvinceName";
// get all blood groups, add into array and show in combobox
var bloodGroups = from BG in DC.BloodGroups select BG;
bloodgroupList = new BloodGroup[bloodGroups.ToList().Count];
i = 0;
foreach (var bg in bloodGroups.ToList())
{
bloodgroupList[i] = bg;
i++;
}
BloodGroupComboBox.ItemsSource = bloodGroups.Distinct();
BloodGroupComboBox.DisplayMemberPath = "Name";
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++;
}
CityComboBox.ItemsSource = cities.Distinct();
CityComboBox.DisplayMemberPath = "CityName";
// show current date-time in form
DateTime dateTime = DateTime.Now;
DateTextBox.Text = dateTime.Date.ToShortDateString();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
var DC = new BloodBankDBDataContext();
var donordb = DC.Donors.First(x => x.Id == donor.Id);
int provinceId = provinceList[ddlProvince.SelectedIndex].Id;
int cityId = cityList[ddlCity.SelectedIndex].Id;
donordb.City = cityId;
donordb.Province = provinceId;
donordb.Phone = txtPhone.Text;
donordb.BloodAvailable = Yes.IsChecked.GetValueOrDefault() ? 1 : 0;
MessageBox.Show("Donor is added successfully!");
Close();
}
private bool isValidAdmin(string username, string password)
{
//querying db for validating admin credentials
BloodBankDBDataContext dc = new BloodBankDBDataContext();
var q = from p in dc.Credentials where p.Username == username && p.Password == password && p.Type == "admin" select p;
if (q.Any())
{
return(true);
}
else
{
return(false);
}
}
private void EditDonor_Click(object sender, RoutedEventArgs e)
{
if (DonorsDataGridPending.CurrentItem == null)
{
return;
}
DC = new BloodBankDBDataContext();
int selectedRowIndex = DonorsDataGridPending.Items.IndexOf(DonorsDataGridPending.CurrentItem);
int Id = IdList[selectedRowIndex];
var bloodrequests = (from D in DC.BloodRequests where D.Id == Id select D).Single();
RequestApproval form = new RequestApproval(bloodrequests);
form.ShowDialog();
Close();
DonorsDataGridPending.UnselectAll();
}
private void EditDonor_Click(object sender, RoutedEventArgs e)
{
if (DonorsDataGrid.CurrentItem == null)
{
return;
}
DC = new BloodBankDBDataContext();
int selectedRowIndex = DonorsDataGrid.Items.IndexOf(DonorsDataGrid.CurrentItem);
int Id = IdList[selectedRowIndex];
var Donor = (from D in DC.Donors where D.Id == Id select D).Single();
EditDonor form = new EditDonor(Donor);
form.ShowDialog();
ApplyFilter();
DonorsDataGrid.UnselectAll();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (dtpDonorDate.SelectedDate > DateTime.UtcNow.AddMonths(+3))
{
MessageBox.Show("Donor not able to donate blood on this Date");
}
else if (dtpDonorDate.SelectedDate < DateTime.UtcNow)
{
MessageBox.Show("Please Select Future Date");
}
else
{
var DC = new BloodBankDBDataContext();
var donordb = DC.Donors.First(x => x.Id == donor.Id);
donordb.Date = dtpDonorDate.SelectedDate;
DC.SubmitChanges();
this.Close();
}
}
public SearchByBloodGroup(bool isAdmin, string username)
{
InitializeComponent();
BloodAvailibility = new Dictionary <string, bool>();
this.isAdmin = isAdmin;
user = username;
BloodBankDBDataContext DC = new BloodBankDBDataContext();
//Querying db for stored blood groups
var result = from b in DC.BloodGroups select b;
foreach (var b in result)
{
//for each blood group search in db for for availability
var result2 = from d in DC.Donors where d.BloodGroup == b.Id && d.BloodAvailable == 1 select d;
//store available blood groups in dictionary
BloodAvailibility.Add(b.Name, result2.Any());
}
if (isAdmin)
{
LogoutButton.Visibility = Visibility.Hidden;
}
var table = from D in DC.BloodRequests
join C in DC.Credentials on D.HospitalId equals C.Id
join us in DC.Donors on D.DonorId equals us.Id into ps
from us in ps.DefaultIfEmpty()
join BG in DC.BloodGroups on D.BloodGroupId equals BG.Id
select new
{
No = D.Id,
HospitalName = C.Username,
BloodGroup = BG.Name,
D.Status,
D.DonarDate,
DonorName = us.Name,
D.RequestDate
};
DonorsDataGridPending.ItemsSource = table;
}
// validate input and show availibility
private void Button_Click(object sender, RoutedEventArgs e)
{
Request.Focusable = false;
if (BloodGroup.SelectedIndex <= 0)
{
resultBox.Text = "Choose a Blood Group to Search";
return;
}
bool available = BloodAvailibility[BloodGroup.Text];
BloodBankDBDataContext DC = new BloodBankDBDataContext();
BloodRequest bloodRequest = new BloodRequest();
bloodRequest.Id = Convert.ToInt16(DC.BloodRequests.Max(x => x.Id)) + 1;
bloodRequest.BloodGroupId = DC.BloodGroups.FirstOrDefault(x => x.Name == BloodGroup.Text).Id;
bloodRequest.HospitalId = DC.Credentials.FirstOrDefault(x => x.Username == user).Id;
bloodRequest.Status = "REQUESTED";
bloodRequest.RequestDate = DateTime.UtcNow;
DC.BloodRequests.InsertOnSubmit(bloodRequest);
DC.SubmitChanges();
resultBox.Text = "Blood requested.";
var table = from D in DC.BloodRequests
join C in DC.Credentials on D.HospitalId equals C.Id
join us in DC.Donors on D.DonorId equals us.Id into ps
from us in ps.DefaultIfEmpty()
join BG in DC.BloodGroups on D.BloodGroupId equals BG.Id
select new
{
No = D.Id,
HospitalName = C.Username,
BloodGroup = BG.Name,
D.Status,
D.DonarDate,
DonorName = us.Name,
D.RequestDate
};
DonorsDataGridPending.ItemsSource = table;
}
private void btn_Approve_Click(object sender, RoutedEventArgs e)
{
if (dtp_date.SelectedDate == null || dtp_date.SelectedDate < DateTime.Now)
{
MessageBox.Show("Please Enter Valid Date");
}
else
{
int donorId = availabledonors[ddl_donors.SelectedIndex].Id;
var DC = new BloodBankDBDataContext();
var donor = DC.Donors.First(x => x.Id == donorId);
donor.Date = dtp_date.SelectedDate;
var requests = DC.BloodRequests.First(x => x.Id == request.Id);
requests.Status = "APPROVED";
requests.DonorId = donor.Id;
requests.DonarDate = dtp_date.SelectedDate;
DC.SubmitChanges();
RequestList requestList = new RequestList();
requestList.ShowDialog();
}
}
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;
}
}
public SearchHelper()
{
DC = new BloodBankDBDataContext();
}