public static void AddDonor(Donor _new)
{
using (var db = new BloodBankEntities1())
{
db.Donor.Add(_new);
db.SaveChanges();
}
}
public static List <Donor> GetDonnorsbyGroupAndRh(string _bloodGroup, string _Rh)
{
using (var context = new BloodBankEntities1())
{
var _allDonors = (from d in context.Donor where d.BloodGroup == _bloodGroup && d.RH == _Rh select d).ToList();
return(_allDonors);
}
}
public static List <Donor> GetAllDonnors()
{
using (var context = new BloodBankEntities1())
{
var _allDonors = (from d in context.Donor select d).ToList();
return(_allDonors);
}
}
public static void DeleteDonor(int index)
{
using (var db = new BloodBankEntities1())
{
var query = (from c in db.Donor
where c.DonorId == index
select c).SingleOrDefault();
db.Donor.Remove(query);
db.SaveChanges();
}
}
public static List <Donor> GetDonnorsbyName(string searchString)
{
using (var context = new BloodBankEntities1())
{
var _allDonors = (from d in context.Donor
where d.Name.Contains(searchString)
select d).ToList();
return(_allDonors);
}
}
public static Donor GetDonorById(int index)
{
Donor query;
using (var db = new BloodBankEntities1())
{
query = (from c in db.Donor
where c.DonorId == index
select c).SingleOrDefault();
}
return(query);
}
public static List <Donor> GetDonorsForInvite(string BloodGroup, string Rh)
{
List <Donor> Donors;
using (var db = new BloodBankEntities1())
{
Donors = (from d in db.Donor
where d.BloodGroup == BloodGroup && d.RH == Rh
select d).ToList();
}
return(Donors);
}
public static void UpdateDonor(int index, string Name, string BloodGroup, string Rh, string Email, string Phone)
{
using (var db = new BloodBankEntities1())
{
var query = (from c in db.Donor
where c.DonorId == index
select c).SingleOrDefault();
query.Name = Name;
query.BloodGroup = BloodGroup;
query.RH = Rh;
query.MailAdress = Email;
query.PhoneNumber = Phone;
db.SaveChanges();
}
}