public ActionResult Requisition(int?id)
{
RequisitionController Moto = new RequisitionController();
var UserId = User.Identity.GetUserId();
var Hospital = db.Doctors.Where(i => i.USER_IDNO == UserId).Select(i => i.Hospital_ID).First();
ViewBag.HospitalID = Hospital;
var Blood_amount = Moto.BlodeBank(Hospital);
ViewBag.BloodGroup_A = Blood_amount.Where(a => a.Blood_type == "A").Select(a => a.Quantity).DefaultIfEmpty().First();
var A = Blood_amount.Where(a => a.Blood_type == "A").Select(a => a.Id).DefaultIfEmpty().First();
ViewBag.IDA = A;
ViewBag.BloodGroup_B = Blood_amount.Where(a => a.Blood_type == "B").Select(a => a.Quantity).DefaultIfEmpty().First();
var B = Blood_amount.Where(a => a.Blood_type == "B").Select(a => a.Id).DefaultIfEmpty().First();
ViewBag.IDB = B;
ViewBag.BloodGroup_AB = Blood_amount.Where(a => a.Blood_type == "AB").Select(a => a.Quantity).DefaultIfEmpty().First();
var AB = Blood_amount.Where(a => a.Blood_type == "AB").Select(a => a.Id).DefaultIfEmpty().First();
ViewBag.IDAB = AB;
ViewBag.BloodGroup_O_Negative = Blood_amount.Where(a => a.Blood_type == "O-").Select(a => a.Quantity).DefaultIfEmpty().First();
var O_negative = Blood_amount.Where(a => a.Blood_type == "O-").Select(a => a.Id).DefaultIfEmpty().First();
ViewBag.IDON = O_negative;
ViewBag.BloodGroup_O_Positive = Blood_amount.Where(a => a.Blood_type == "O+").Select(a => a.Quantity).DefaultIfEmpty().First();
var O_positive = Blood_amount.Where(a => a.Blood_type == "0+").Select(a => a.Id).DefaultIfEmpty().First();
ViewBag.IDOP = O_positive;
return(View());
}
// GET: Requisition
public IQueryable <BloodBank> BlodeBank(int?id)
{
RequisitionController Moto = new RequisitionController();
IQueryable <BloodBank> Blood_amount = db.BloodBanks.Where(p => p.Hospital_Id == id);
//var BloodGroup_A = Blood_amount.Where(a => a.Blood_type == "A").Count();
return(Blood_amount.AsQueryable());
}
public ActionResult Requisition(BloodBank bloodbank)
{
if (ModelState.IsValid)
{
RequisitionController Moto = new RequisitionController();
var UserId = User.Identity.GetUserId().ToString();
var Hospital = db.Doctors.Where(i => i.USER_IDNO.ToString() == UserId).Select(i => i.Hospital_ID).First();
var Blood_amount = Moto.BlodeBank(Hospital);
var A = Blood_amount.Where(a => a.Blood_type == "A").Select(a => a.Quantity).DefaultIfEmpty().First();
var B = Blood_amount.Where(a => a.Blood_type == "B").Select(a => a.Quantity).DefaultIfEmpty().First();
var AB = Blood_amount.Where(a => a.Blood_type == "AB").Select(a => a.Quantity).DefaultIfEmpty().First();
var O_negative = Blood_amount.Where(a => a.Blood_type == "O-").Select(a => a.Quantity).DefaultIfEmpty().First();
var O_positive = Blood_amount.Where(a => a.Blood_type == "O+").Select(a => a.Quantity).DefaultIfEmpty().First();
//************************************************************
if (bloodbank.Blood_type.Equals("A"))
{
var amount = bloodbank.Quantity;
var change = A - amount;
bloodbank.Quantity = change;
}
if (bloodbank.Blood_type.Equals("B"))
{
var amount = bloodbank.Quantity;
var change = B - amount;
bloodbank.Quantity = change;
}
if (bloodbank.Blood_type.Equals("AB"))
{
var amount = bloodbank.Quantity;
var change = AB - amount;
bloodbank.Quantity = change;
}
try
{
// or check on FirstName and LastName if you don't have a user id
//var updatedUser = db.BloodBanks.SingleOrDefault(x => x.Id == A);
//updatedUser.Quantity = quanity.Quantity;
db.Entry(bloodbank).State = EntityState.Modified;
db.SaveChanges();
//Boolean A=true;
//Boolean B=true;
//Boolean AB=true;
//if(bloodbank.Blood_type.Equals("A"))
//{
// A = false;
//}
//if (bloodbank.Blood_type.Equals("B"))
//{
// B = false;
//}
//if (bloodbank.Blood_type.Equals("AB"))
//{
// AB = false;
//}
//if(A==false)
// ViewBag.visibleA = "none";
//if(B==false)
// ViewBag.visibleB = "none";
//if(AB==false)
// ViewBag.visibleAB = "none";
//ViewBag.Hospital_ID = new SelectList(db.Hospitals, "id", "Name");
return(RedirectToAction("Requisition"));
}
catch (System.Data.Entity.Validation.DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
}
}
return(RedirectToAction("index", "Home"));
}
return(new HttpNotFoundResult());
}
