private void ButtonAddClient_Click(object sender, EventArgs e) { BloodBankEntities context = new BloodBankEntities(); int id = context.Clients.Count() + 1; Client client = new Client() { // ClientId = ParseInt(textBoxAddClientID.Text), ClientId = id, ClientFirstName = textBoxAddClientFirstName.Text, ClientLastName = textBoxAddClientLastName.Text }; //check if user fills name if (client.ClientFirstName.Trim().Length == 0 || client.ClientLastName.Trim().Length == 0) { MessageBox.Show("Please enter all fields"); return; } if (Controller <BloodBankEntities, Client> .AddEntity(client) == null) { MessageBox.Show("Cannot add client to database"); return; } // dispose the context and close the form. this.DialogResult = DialogResult.OK; context.Dispose(); Close(); }
public ActionResult Signup(User model) { using (var context = new BloodBankEntities()) { context.Users.Add(model); context.SaveChanges(); } return(RedirectToAction("Login")); }
// Gets the Blood type price to populate the label private double GetBloodTypePrice(String bloodType) { var bloodTypePrice = 0.0; using (BloodBankEntities context = new BloodBankEntities()) { var b = context.BloodTypes.Single(x => x.BloodType1 == bloodType); bloodTypePrice = b.PricePerUnit; } return(bloodTypePrice); }
private void ButtonWithdraw_Click(object sender, EventArgs e) { BloodBankEntities context = new BloodBankEntities(); //create a BloodWithdrawal object BloodWithdrawal bw = new BloodWithdrawal() { BloodWithdrawalId = context.BloodWithdrawals.Count() + 1, BloodWithdrawalDate = DateTime.Now.Date, TransactionValue = float.Parse(textBoxTotal.Text), UnitQuantity = 1, ClientId = Int32.Parse(dataGridViewClient.SelectedRows[0].Cells[0].Value.ToString()) }; //validate if (dataGridViewStock.SelectedRows.Count < 1) { MessageBox.Show("Please select an item to withdraw"); return; } if (dataGridViewClient.SelectedRows.Count < 1) { MessageBox.Show("Please select a client for withdrawal"); return; } //add to db if (Controller <BloodBankEntities, BloodWithdrawal> .AddEntity(bw) == null) { MessageBox.Show("Cannot add withdrawal to database"); return; } //creates a new BloodWithdrawalUnit object BloodWithdrawalUnit bwu = new BloodWithdrawalUnit() { BloodWithdrawalUnitsId = context.BloodWithdrawalUnits.Count() + 1, UnitId = Int32.Parse(dataGridViewStock.SelectedRows[0].Cells[0].Value.ToString()), BloodWithdrawalId = context.BloodWithdrawals.Count(), }; context.Dispose(); //add to d b if (Controller <BloodBankEntities, BloodWithdrawalUnit> .AddEntity(bwu) == null) { MessageBox.Show("Cannot add withdrawal to database"); return; } // adds to the current balance after a withdrawal //this.DialogResult = DialogResult.OK; initializeDepositDGV(); BloodBankAppMainForm.SetFundsBalance += Double.Parse(textBoxTotal.Text); ReadCurrentFunds(); // re-reads the current balance }
protected void btnsubmit_Click(object sender, EventArgs e) { BloodBankEntities db = new BloodBankEntities(); Tb_Admin obj = new Tb_Admin(); obj.Username = txtadminname.Text; obj.Password = password.Text; obj.Usertype = "Admin"; db.Tb_Admin.Add(obj); db.SaveChanges(); Response.Redirect("~/Admin/ViewAdmin.aspx?msg=" + "Svd"); }
public ActionResult Login(Models.Membership model) { using (var context = new BloodBankEntities()) { bool isValid = context.Users.Any(x => x.UserName == model.UserName && x.Password == model.Password && x.Email == model.Email); if (isValid) { FormsAuthentication.SetAuthCookie(model.UserName, false); return(RedirectToAction("Index", "Employees")); } ModelState.AddModelError("", "Invalid Username,Password and Email"); return(View()); } }
private void ButtonSubmit_Click(object sender, EventArgs e) { BloodBankEntities context = new BloodBankEntities(); //get id for new donor int id = context.Donors.Count() + 1; //create new donor object Donor donor = new Donor() { DonorId = id, DonorFirstName = textBoxFirstName.Text, DonorLastName = textBoxLastName.Text, DonorBirthday = dateTimePickerBirthday.Value, DonorAddress = textBoxAddress.Text, DonorPhone = numericUpDown1.Value.ToString(), BloodTypeId = listBoxBloodType.SelectedIndex + 1, }; //validation if (!(listBoxBloodType.SelectedItem is BloodType type)) { MessageBox.Show("Must select a blood type!"); return; } if (donor.DonorFirstName.Trim().Length == 0 || donor.DonorFirstName.Trim().Length == 0 || donor.DonorBirthday == new DateTime(1900, 01, 01) || donor.DonorAddress.Trim().Length == 0 || donor.DonorPhone == "0" || donor.DonorPhone == null) { MessageBox.Show("Must fill all fields"); return; } if (!donor.DonorAddress.Contains("@") || !donor.DonorAddress.Contains(".")) { MessageBox.Show("Email is not valid"); return; } //add to db if (Controller <BloodBankEntities, Donor> .AddEntity(donor) == null) { MessageBox.Show("Cannot add course to database"); return; } // dispose the context and close the form. this.DialogResult = DialogResult.OK; context.Dispose(); Close(); }
protected void btnsave_Click2(object sender, EventArgs e) { BloodBankEntities db = new BloodBankEntities(); Tb_Admin objuser = new Tb_Admin(); if (db.Tb_Admin.Where(z => z.Username == txtusername.Text && z.Password == txtpass.Text).Count() > 0) { objuser = db.Tb_Admin.Where(z => z.Username == txtusername.Text && z.Password == txtpass.Text).FirstOrDefault(); Response.Cookies["UserName"].Value = objuser.Username; Response.Cookies["Usertype"].Value = objuser.Usertype; FormsAuthentication.RedirectFromLoginPage(txtusername.Text, false); Response.Redirect("~/Admin/Default.aspx"); Response.Cookies["UserName"].Value = objuser.Username; Response.Cookies["Usertype"].Value = objuser.Usertype; } else { Response.Redirect("~/Adminlogin.aspx?msg=" + "error"); } }
private void BloodBankAppMainForm_Load() { using (BloodBankEntities context = new BloodBankEntities()) { context.SeedDatabase(); } // Initializes the first data grid view, which displays the donors database initializeDonorsDataGridView(); // search button on the main page buttonSearchDonor.Click += ButtonSearchDonor_Click; // Creating the forms DonorAddForm donorAddForm = new DonorAddForm(); buttonAddNewDonor.Click += (s, e) => AddOrUpdateForm <Donor>(dataGridViewDonorsDatabase, donorAddForm); BloodBankStatusForm bbStatForm = new BloodBankStatusForm(); buttonBloodBank.Click += (s, e) => AddOrUpdateForm <BloodBankEntities>(null, bbStatForm); WithdrawalForm withdraw = new WithdrawalForm(); buttonWithdrawBlood.Click += (s, e) => AddOrUpdateForm <BloodWithdrawal>(dataGridViewDonorsDatabase, withdraw); // Event handlers to add behavior when the form is closed withdraw.FormClosing += new FormClosingEventHandler(Form_FormClosing); // event habndler to refresh the current funds in the main form. buttonMakeDonation.Click += ButtonMakeDonation_Click; // This form was created differently, but the event handlers are similar. // Getting the current balance ReadCurrentFunds(); //Searching the donor through textboxes buttonReset.Click += ButtonReset_Click; buttonAddClient.Click += ButtonAddClient_Click; buttonReportAndReport.Click += ButtonReportAndReport_Click; }
public static void SeedDatabase(this BloodBankEntities context) { context.Database.Log = (s => Debug.Write(s)); context.Database.Delete(); context.Database.Create(); context.SaveChanges(); context.BloodDeposits.Load(); context.BloodTypes.Load(); context.BloodWithdrawals.Load(); context.BloodWithdrawalUnits.Load(); context.Clients.Load(); context.Donations.Load(); context.Donors.Load(); List <BloodType> bloodTypesList = new List <BloodType> { new BloodType { BloodTypeId = 1, BloodType1 = "A+", PricePerUnit = 150.00f }, new BloodType { BloodTypeId = 2, BloodType1 = "A-", PricePerUnit = 300.00f }, new BloodType { BloodTypeId = 3, BloodType1 = "B+", PricePerUnit = 300.00f }, new BloodType { BloodTypeId = 4, BloodType1 = "B-", PricePerUnit = 400.00f }, new BloodType { BloodTypeId = 5, BloodType1 = "AB+", PricePerUnit = 400.00f }, new BloodType { BloodTypeId = 6, BloodType1 = "AB-", PricePerUnit = 500.00f }, new BloodType { BloodTypeId = 7, BloodType1 = "O+", PricePerUnit = 150.00f }, new BloodType { BloodTypeId = 8, BloodType1 = "O-", PricePerUnit = 400.00f }, }; Dictionary <int, BloodType> bloodTypes = bloodTypesList.ToDictionary(x => x.BloodTypeId, x => x); context.BloodTypes.AddRange(bloodTypesList); context.SaveChanges(); List <Donor> donorList = new List <Donor> { new Donor { DonorId = 1, DonorFirstName = "Pierre", DonorLastName = "Lovelady", DonorBirthday = new DateTime(1994, 9, 13), DonorAddress = "*****@*****.**", DonorPhone = "4105654504", BloodTypeId = 1, BloodType = bloodTypes[1] }, new Donor { DonorId = 2, DonorFirstName = "Winnifred", DonorLastName = "Halbeard", DonorBirthday = new DateTime(1980, 3, 14), DonorAddress = "*****@*****.**", DonorPhone = "1118282421", BloodTypeId = 3, BloodType = bloodTypes[3] }, new Donor { DonorId = 3, DonorFirstName = "Kaklina", DonorLastName = "Hursey", DonorBirthday = new DateTime(2000, 4, 25), DonorAddress = "*****@*****.**", DonorPhone = "5119179333", BloodTypeId = 4, BloodType = bloodTypes[4] }, new Donor { DonorId = 4, DonorFirstName = "Bunni", DonorLastName = "McDill", DonorBirthday = new DateTime(1980, 7, 4), DonorAddress = "*****@*****.**", DonorPhone = "5901915767", BloodTypeId = 6, BloodType = bloodTypes[6] }, new Donor { DonorId = 5, DonorFirstName = "Borg", DonorLastName = "Syversen", DonorBirthday = new DateTime(1976, 1, 17), DonorAddress = "*****@*****.**", DonorPhone = "2248017959", BloodTypeId = 4, BloodType = bloodTypes[4] }, new Donor { DonorId = 6, DonorFirstName = "Geralda", DonorLastName = "Kardos", DonorBirthday = new DateTime(1957, 8, 31), DonorAddress = "*****@*****.**", DonorPhone = "4486781860", BloodTypeId = 5, BloodType = bloodTypes[5] }, new Donor { DonorId = 7, DonorFirstName = "Meredithe", DonorLastName = "Vye", DonorBirthday = new DateTime(1969, 12, 30), DonorAddress = "*****@*****.**", DonorPhone = "4382975712", BloodTypeId = 2, BloodType = bloodTypes[2] }, new Donor { DonorId = 8, DonorFirstName = "Jean-Luc", DonorLastName = "Picard", DonorBirthday = new DateTime(1961, 5, 25), DonorAddress = "*****@*****.**", DonorPhone = "1828812496", BloodTypeId = 3, BloodType = bloodTypes[3] }, new Donor { DonorId = 9, DonorFirstName = "Malynda", DonorLastName = "Coram", DonorBirthday = new DateTime(1983, 3, 11), DonorAddress = "*****@*****.**", DonorPhone = "2825008266", BloodTypeId = 1, BloodType = bloodTypes[1] }, new Donor { DonorId = 10, DonorFirstName = "Darth", DonorLastName = "Vader", DonorBirthday = new DateTime(1982, 2, 3), DonorAddress = "*****@*****.**", DonorPhone = "6851611904", BloodTypeId = 8, BloodType = bloodTypes[8] }, }; Dictionary <int, Donor> donors = donorList.ToDictionary(x => x.DonorId, x => x); context.Donors.AddRange(donorList); context.SaveChanges(); List <Client> clientList = new List <Client> { new Client { ClientId = 1, ClientFirstName = "Damara", ClientLastName = "Tayler" }, new Client { ClientId = 2, ClientFirstName = "Evangelin", ClientLastName = "Sprigin" }, new Client { ClientId = 3, ClientFirstName = "Johan", ClientLastName = "Cottham" }, new Client { ClientId = 4, ClientFirstName = "Vlad", ClientLastName = "der Impalen" }, new Client { ClientId = 5, ClientFirstName = "Brody", ClientLastName = "Fiennes" }, new Client { ClientId = 6, ClientFirstName = "Kippy", ClientLastName = "Macallam" }, new Client { ClientId = 7, ClientFirstName = "Whitby", ClientLastName = "Mitchelson" }, new Client { ClientId = 8, ClientFirstName = "Lauren", ClientLastName = "Staterfield" }, new Client { ClientId = 9, ClientFirstName = "Vic", ClientLastName = "Burdge" }, new Client { ClientId = 10, ClientFirstName = "Harp", ClientLastName = "Gainforth" }, }; Dictionary <int, Client> clients = clientList.ToDictionary(x => x.ClientId, x => x); context.Clients.AddRange(clientList); context.SaveChanges(); List <BloodDeposit> bloodDepositList = new List <BloodDeposit> { new BloodDeposit { UnitId = 1, UnitPrice = Decimal.Parse(bloodTypes[1].PricePerUnit.ToString()), UnitExpiryDate = new DateTime(2021, 1, 19), BloodTypeId = 1, BloodType = bloodTypes[1] }, new BloodDeposit { UnitId = 2, UnitPrice = Decimal.Parse(bloodTypes[3].PricePerUnit.ToString()), UnitExpiryDate = new DateTime(2021, 3, 5), BloodTypeId = 3, BloodType = bloodTypes[3] }, new BloodDeposit { UnitId = 3, UnitPrice = Decimal.Parse(bloodTypes[5].PricePerUnit.ToString()), UnitExpiryDate = new DateTime(2021, 5, 13), BloodTypeId = 5, BloodType = bloodTypes[5] }, new BloodDeposit { UnitId = 4, UnitPrice = Decimal.Parse(bloodTypes[4].PricePerUnit.ToString()), UnitExpiryDate = new DateTime(2021, 2, 14), BloodTypeId = 4, BloodType = bloodTypes[4] }, new BloodDeposit { UnitId = 5, UnitPrice = Decimal.Parse(bloodTypes[6].PricePerUnit.ToString()), UnitExpiryDate = new DateTime(2021, 8, 31), BloodTypeId = 6, BloodType = bloodTypes[6] }, new BloodDeposit { UnitId = 6, UnitPrice = Decimal.Parse(bloodTypes[7].PricePerUnit.ToString()), UnitExpiryDate = new DateTime(2021, 5, 17), BloodTypeId = 7, BloodType = bloodTypes[7] }, new BloodDeposit { UnitId = 7, UnitPrice = Decimal.Parse(bloodTypes[2].PricePerUnit.ToString()), UnitExpiryDate = new DateTime(2021, 4, 29), BloodTypeId = 2, BloodType = bloodTypes[2] }, new BloodDeposit { UnitId = 8, UnitPrice = Decimal.Parse(bloodTypes[8].PricePerUnit.ToString()), UnitExpiryDate = new DateTime(2021, 2, 9), BloodTypeId = 8, BloodType = bloodTypes[8] }, new BloodDeposit { UnitId = 9, UnitPrice = Decimal.Parse(bloodTypes[6].PricePerUnit.ToString()), UnitExpiryDate = new DateTime(2021, 7, 1), BloodTypeId = 6, BloodType = bloodTypes[6] }, new BloodDeposit { UnitId = 10, UnitPrice = Decimal.Parse(bloodTypes[2].PricePerUnit.ToString()), UnitExpiryDate = new DateTime(2021, 12, 13), BloodTypeId = 2, BloodType = bloodTypes[2] }, }; Dictionary <int, BloodDeposit> bloodDeposits = bloodDepositList.ToDictionary(x => x.UnitId, x => x); context.BloodDeposits.AddRange(bloodDepositList); context.SaveChanges(); List <BloodWithdrawal> bloodWithdrawalList = new List <BloodWithdrawal> { new BloodWithdrawal { BloodWithdrawalId = 1, BloodWithdrawalDate = new DateTime(2019, 12, 23), TransactionValue = 300.00f, UnitQuantity = 1, ClientId = 1 }, new BloodWithdrawal { BloodWithdrawalId = 2, BloodWithdrawalDate = new DateTime(2020, 2, 23), TransactionValue = 450.00f, UnitQuantity = 1, ClientId = 3 }, new BloodWithdrawal { BloodWithdrawalId = 3, BloodWithdrawalDate = new DateTime(2018, 3, 13), TransactionValue = 500.00f, UnitQuantity = 1, ClientId = 6 }, new BloodWithdrawal { BloodWithdrawalId = 4, BloodWithdrawalDate = new DateTime(2020, 6, 4), TransactionValue = 400.00f, UnitQuantity = 1, ClientId = 4 }, new BloodWithdrawal { BloodWithdrawalId = 5, BloodWithdrawalDate = new DateTime(2018, 4, 22), TransactionValue = 800.00f, UnitQuantity = 2, ClientId = 2 }, }; Dictionary <int, BloodWithdrawal> bloodWithdrawals = bloodWithdrawalList.ToDictionary(x => x.BloodWithdrawalId, x => x); context.BloodWithdrawals.AddRange(bloodWithdrawalList); context.SaveChanges(); List <Donation> donationsList = new List <Donation> { new Donation { DonationId = 1, DonationBloodVolume = 1, MedicalReport = "has Diabetes", BloodTypeId = donors[1].BloodTypeId, DonorId = 1, DonationDate = new DateTime(2019, 3, 21) }, new Donation { DonationId = 2, DonationBloodVolume = 1, MedicalReport = "flu like symptoms", BloodTypeId = donors[2].BloodTypeId, DonorId = 2, DonationDate = new DateTime(2020, 4, 3) }, new Donation { DonationId = 3, DonationBloodVolume = 1, MedicalReport = "COVID-19 Symptoms", BloodTypeId = donors[3].BloodTypeId, DonorId = 3, DonationDate = new DateTime(2019, 12, 5) }, new Donation { DonationId = 4, DonationBloodVolume = 1, MedicalReport = "healthy", BloodTypeId = donors[4].BloodTypeId, DonorId = 4, DonationDate = new DateTime(2020, 10, 31) }, new Donation { DonationId = 5, DonationBloodVolume = 1, MedicalReport = "traveled to Russia", BloodTypeId = donors[5].BloodTypeId, DonorId = 5, DonationDate = new DateTime(2020, 11, 21) }, new Donation { DonationId = 6, DonationBloodVolume = 1, MedicalReport = "recently infected with Pneumonia", BloodTypeId = donors[6].BloodTypeId, DonorId = 1, DonationDate = new DateTime(2020, 5, 1) }, new Donation { DonationId = 7, DonationBloodVolume = 1, MedicalReport = "traveled to USA", BloodTypeId = donors[7].BloodTypeId, DonorId = 7, DonationDate = new DateTime(2020, 10, 24) }, new Donation { DonationId = 8, DonationBloodVolume = 1, MedicalReport = "slight cough", BloodTypeId = donors[8].BloodTypeId, DonorId = 8, DonationDate = new DateTime(2020, 7, 1) }, new Donation { DonationId = 9, DonationBloodVolume = 1, MedicalReport = "fever", BloodTypeId = donors[9].BloodTypeId, DonorId = 9, DonationDate = new DateTime(2020, 9, 25) }, new Donation { DonationId = 10, DonationBloodVolume = 1, MedicalReport = "clinically dead", BloodTypeId = donors[10].BloodTypeId, DonorId = 10, DonationDate = new DateTime(2020, 8, 12) }, }; Dictionary <int, Donation> donations = donationsList.ToDictionary(x => x.DonationId, x => x); context.Donations.AddRange(donationsList); context.SaveChanges(); List <BloodWithdrawalUnit> bloodWithdrawalUnitsList = new List <BloodWithdrawalUnit> { new BloodWithdrawalUnit { BloodWithdrawalUnitsId = 1, UnitId = 1, BloodWithdrawalId = 1 }, new BloodWithdrawalUnit { BloodWithdrawalUnitsId = 2, UnitId = 2, BloodWithdrawalId = 2 }, new BloodWithdrawalUnit { BloodWithdrawalUnitsId = 3, UnitId = 3, BloodWithdrawalId = 3 }, new BloodWithdrawalUnit { BloodWithdrawalUnitsId = 4, UnitId = 4, BloodWithdrawalId = 4 }, new BloodWithdrawalUnit { BloodWithdrawalUnitsId = 5, UnitId = 5, BloodWithdrawalId = 5 }, }; Dictionary <int, BloodWithdrawalUnit> bloodWithdrawalUnits = bloodWithdrawalUnitsList.ToDictionary(x => x.BloodWithdrawalUnitsId, x => x); context.BloodWithdrawalUnits.AddRange(bloodWithdrawalUnitsList); context.SaveChanges(); }