protected void gvUserMatches_SelectedIndexChanged(object sender, EventArgs e) { EstablishmentBPRequest selectedRequest = pendingRequests[gvRequests.PageSize * gvRequests.PageIndex + gvRequests.SelectedIndex]; List <EstabUserTransaction> allUserTransactions = EstabUserTransactionDB.getAllTransactions(); foreach (EstabUserTransaction m in allUserTransactions) { if (m.Match.Request.ID == selectedRequest.ID && m.Status == "accepted") { userTransactions.Add(m); } } EstabUserTransaction selectedTransaction = userTransactions[gvUserMatches.SelectedIndex]; selectedTransaction.Status = "complete"; EstabUserTransactionDB.updateTransaction(selectedTransaction); EstabUserMatch currentMatch = selectedTransaction.Match; currentMatch.Status = "complete"; EstabUserMatchDB.updateMatch(currentMatch); Users currentUser = currentMatch.Match; List <LastDonationDate> allLastDates = LastDonationDateDB.getAllLastDonations(); foreach (LastDonationDate ld in allLastDates) { if (ld.User.UserId == currentUser.UserId) { ld.LastDonation = DateTime.Today; ld.Type = currentMatch.Request.Type; ld.Status = "Not in transaction"; LastDonationDateDB.updateLastDonation(ld); } } if (selectedRequest.MatchedUnits == selectedRequest.Units) { selectedRequest.Status = "complete"; EstablishmentBPRequestDB.updateEstablishmentRequest(selectedRequest); foreach (EstabUserTransaction ut in allUserTransactions) { if (ut.Match.Request.ID == selectedRequest.ID) { ut.Status = "complete"; EstabUserTransactionDB.updateTransaction(ut); ut.Match.Status = "complete"; EstabUserMatchDB.updateMatch(ut.Match); } } } Server.Transfer("PendingRequests.aspx"); }
//protected void gvUserMatches_PageIndexChanging(object sender, GridViewPageEventArgs e) //{ // gvUserMatches.PageIndex = e.NewPageIndex; // gvUserMatches.DataSource = userTransactions; // gvUserMatches.DataBind(); //} //protected void gvEstabMatches_PageIndexChanging(object sender, GridViewPageEventArgs e) //{ // gvEstabMatches.PageIndex = e.NewPageIndex; // gvEstabMatches.DataSource = estabTransactions; // gvEstabMatches.DataBind(); //} protected void lbtnReport_Click(object sender, EventArgs e) { LinkButton lbtn = (LinkButton)sender; GridViewRow gvr = (GridViewRow)lbtn.NamingContainer; int i = Convert.ToInt32(gvr.RowIndex); EstablishmentBPRequest selectedRequest = pendingRequests[gvRequests.PageSize * gvRequests.PageIndex + gvRequests.SelectedIndex]; List <EstabUserTransaction> allUserTransactions = EstabUserTransactionDB.getAllTransactions(); foreach (EstabUserTransaction m in allUserTransactions) { if (m.Match.Request.ID == selectedRequest.ID && m.Status == "accepted") { userTransactions.Add(m); } } EstabUserTransaction selectedTransaction = userTransactions[i]; Users reportedUser = selectedTransaction.Match.Match; reportedUser.MedicalStatus = "cannot donate"; reportedUser.MedicalStatusUpdateBy = ((Establishment)Session["establishment"]).ID; UsersDB.updateUser(reportedUser); List <LastDonationDate> allLastDates = LastDonationDateDB.getAllLastDonations(); foreach (LastDonationDate ld in allLastDates) { if (ld.User.UserId == reportedUser.userId) { ld.LastDonation = DateTime.Today; ld.Type = selectedRequest.Type; ld.Status = "Not in transaction"; LastDonationDateDB.updateLastDonation(ld); } } selectedTransaction.Status = "cancelled"; EstabUserTransactionDB.updateTransaction(selectedTransaction); selectedTransaction.Match.Status = "declined"; EstabUserMatchDB.updateMatch(selectedTransaction.Match); selectedRequest.MatchedUnits = selectedRequest.MatchedUnits - selectedTransaction.Units; EstablishmentBPRequestDB.updateEstablishmentRequest(selectedRequest); Server.Transfer("PendingRequests.aspx"); }
protected void gvAcceptedUserRequests_SelectedIndexChanged(object sender, EventArgs e) { BloodPlateletRequestUser selectedRequest = userRequests[gvRequestInfo.PageSize * gvRequestInfo.PageIndex + gvRequestInfo.SelectedIndex]; List <BplTransactionUserToUser> allUserTransactions = BplTransactionUserToUserDB.getAllbpTransUserToUser(); foreach (BplTransactionUserToUser m in allUserTransactions) { if (m.bpMatchUsrUsr.bplUsrRequestID.bplUserRequestID == selectedRequest.bplUserRequestID && m.status == "accepted") { usersAccepted.Add(m); } } BplTransactionUserToUser selectedTransaction = usersAccepted[gvAcceptedUserRequests.PageSize * gvAcceptedUserRequests.PageIndex + gvAcceptedUserRequests.SelectedIndex]; selectedTransaction.status = "complete"; BplTransactionUserToUserDB.updateBPTranscationUserToUser(selectedTransaction); gvAcceptedUserRequests.DataBind(); BPMatchUserToUser currentMatch = selectedTransaction.bpMatchUsrUsr; currentMatch.status = "declined"; BPMatchUserToUserDB.updateMatchUserToUser(currentMatch); Users currentUser = currentMatch.matchID; List <LastDonationDate> allLastDates = LastDonationDateDB.getAllLastDonations(); foreach (LastDonationDate ld in allLastDates) { if (ld.User.UserId == currentUser.UserId) { ld.LastDonation = DateTime.Today; ld.Type = currentMatch.bplUsrRequestID.bloodOrPlatelet; ld.Status = "Not in transaction"; LastDonationDateDB.updateLastDonation(ld); } } if (selectedRequest.Units == selectedRequest.unitMatched) { selectedRequest.Status = "complete"; BloodPlateletRequestUserDB.updateBloodPlateles(selectedRequest); gvRequestInfo.DataBind(); } }
protected void lbtnReport_Click(object sender, EventArgs e) { LinkButton lbtn = (LinkButton)sender; GridViewRow gvr = (GridViewRow)lbtn.NamingContainer; int i = Convert.ToInt32(gvr.RowIndex); BloodPlateletRequestUser selectedRequest = userRequests[gvRequestInfo.PageSize * gvRequestInfo.PageIndex + gvRequestInfo.SelectedIndex]; List <BplTransactionUserToUser> allUserTransactions = BplTransactionUserToUserDB.getAllbpTransUserToUser(); foreach (BplTransactionUserToUser m in allUserTransactions) { if (m.bpMatchUsrUsr.bplUsrRequestID.bplUserRequestID == selectedRequest.bplUserRequestID && m.status == "accepted") { usersAccepted.Add(m); } } BplTransactionUserToUser selectedTransaction = usersAccepted[i]; Users reportedUser = selectedTransaction.bpMatchUsrUsr.matchID; reportedUser.MedicalStatus = "cannot donate"; reportedUser.MedicalStatusUpdateBy = ((Establishment)Session["establishment"]).ID; UsersDB.updateUser(reportedUser); List <LastDonationDate> allLastDates = LastDonationDateDB.getAllLastDonations(); foreach (LastDonationDate ld in allLastDates) { if (ld.User.UserId == reportedUser.userId) { ld.LastDonation = DateTime.Today; ld.Type = selectedRequest.bloodOrPlatelet; ld.Status = "Not in transaction"; LastDonationDateDB.updateLastDonation(ld); } } selectedTransaction.status = "cancelled"; BplTransactionUserToUserDB.updateBPTranscationUserToUser(selectedTransaction); selectedTransaction.bpMatchUsrUsr.status = "declined"; BPMatchUserToUserDB.updateMatchUserToUser(selectedTransaction.bpMatchUsrUsr); selectedRequest.unitMatched = selectedRequest.unitMatched - selectedTransaction.unitsPossible; BloodPlateletRequestUserDB.updateBloodPlateles(selectedRequest); Server.Transfer("UserDonations.aspx"); }
protected void btnSubmit_Click(object sender, EventArgs e) { //sending request if the amount is greater than 1 if (Convert.ToInt32(tbxAmount.Text) > 0) { Establishment currentEstab = (Establishment)Session["establishment"]; EstablishmentBPRequest currentRequestBP = new EstablishmentBPRequest(); currentRequestBP.BloodGroup = ddlBloodType.SelectedValue; currentRequestBP.Units = Convert.ToInt32(tbxAmount.Text); currentRequestBP.MatchedUnits = 0; currentRequestBP.Type = ddlRequestType.SelectedValue; currentRequestBP.Establishment = currentEstab; currentRequestBP.Status = "pending"; currentRequestBP.RequestDate = DateTime.Today; int num = EstablishmentBPRequestDB.insertEstablishmentRequest(currentRequestBP); if (num != 1) { lblOutput.Text = "Cannot"; } else { List <EstablishmentBPRequest> establishmentBPRequest = EstablishmentBPRequestDB.getAllEstablishmentRequests(); //get inserted request string x = establishmentBPRequest[0].ID; int tempId = Convert.ToInt32(x.Substring(4, x.Length - 4)); foreach (EstablishmentBPRequest tempReq in establishmentBPRequest) { int t = Convert.ToInt32(tempReq.ID.Substring(4, tempReq.ID.Length - 4)); if (tempId <= t && tempReq.Establishment.ID == currentEstab.ID) { tempId = Convert.ToInt32(tempReq.ID.Substring(4, tempReq.ID.Length - 4)); } } EstablishmentBPRequest request = EstablishmentBPRequestDB.getRequestByID("bper" + Convert.ToString(tempId)); lblOutput.Text = "Your request ID is bper" + tempId; List <Establishment> establishments = EstablishmentDB.getAllEstablishments(); foreach (Establishment est in establishments) { EstabEstabMatch newMatch = new EstabEstabMatch(); if ((est.Type == "Hospital" || est.Type == "Blood Bank") && currentEstab.ID != est.ID) { int d = getDistance(est.Address, currentEstab.Address); if (d < 3600) { newMatch.Request = request; newMatch.Match = est; newMatch.Distance = d; newMatch.Status = "pending"; EstabEstabMatchDB.insertMatch(newMatch); } } } List <Users> users = UsersDB.getallUsers(); List <LastDonationDate> allDates = LastDonationDateDB.getAllLastDonations(); foreach (Users tusr in users) { EstabUserMatch newMatch = new EstabUserMatch(); string userGroup = tusr.BloodType; string requestGroup = request.BloodGroup; bool f = false; //check blood to match with other user if (requestGroup == "AB+") { f = true; } else if (requestGroup == "AB-" && (userGroup == "O-" || userGroup == "B-" || userGroup == "A-" || userGroup == "AB-")) { f = true; } else if (requestGroup == "A+" && (userGroup == "O-" || userGroup == "O+" || userGroup == "A-" || userGroup == "A+")) { f = true; } else if (requestGroup == "A-" && (userGroup == "O-" || userGroup == "A-")) { f = true; } else if (requestGroup == "B+" && (userGroup == "O-" || userGroup == "O+" || userGroup == "B-" || userGroup == "B+")) { f = true; } else if (requestGroup == "B-" && (userGroup == "O-" || userGroup == "B-")) { f = true; } else if (requestGroup == "O+" && (userGroup == "O-" || userGroup == "O+")) { f = true; } else if (requestGroup == "O-" && (userGroup == "O-")) { f = true; } //if match found check his medical status and status if (f == true && tusr.medicalStatus.ToLower() == "can donate" && tusr.Status == "Allow") { foreach (LastDonationDate d in allDates) { if (d.User.userId == tusr.userId) { if ((d.LastDonation < System.DateTime.Now.AddDays(-90) && d.Type == "blood") || (d.LastDonation < System.DateTime.Now.AddDays(-14) && d.Type == "platelet") && d.Status == "Not in transaction") { int d1 = getDistance(Convert.ToString(tusr.latitude) + "," + Convert.ToString(tusr.longtitude), currentEstab.Address); if (d1 < 3600) { newMatch.Match = tusr; newMatch.Request = request; newMatch.Status = "pending"; newMatch.Distance = d1; EstabUserMatchDB.insertMatch(newMatch); } } } } } } tbxAmount.Text = ""; ddlBloodType.SelectedIndex = 0; ddlRequestType.SelectedIndex = 0; string MyAccountUrl = "RequestBlood.aspx"; Page.Header.Controls.Add(new LiteralControl(string.Format(@" <META http-equiv='REFRESH' content=4;url={0}> ", MyAccountUrl))); } } else { lblOutput.Text = "Blood amount cannot be 0 or less than that"; return; } }
protected void btnRequest_Click(object sender, EventArgs e) { string groups, estname, type; int unit; if (RadioBlood.Checked) { groups = "blood"; } else { groups = "platelet"; } if (tbxAmount.Text == "") { lblAmount.Visible = true; return; } else { lblAmount.Visible = false; unit = Convert.ToInt32(tbxAmount.Text); } estname = ddlEstablish.SelectedItem.Text; Establishment es = EstablishmentDB.getEstablishmentByName(estname); Users u = UsersDB.getUserbyEmail(Session["email"].ToString()); type = ddlBloodType.SelectedValue; BloodPlateletRequestUser b = new BloodPlateletRequestUser(unit, 0, es, u, type, "pending", groups, DateTime.Now); int num = BloodPlateletRequestUserDB.insertBloodRequestByUser(b); if (num != 1) { lblOutput.Text = "Cannot Request Blood!"; return; } else { lblOutput.Text = "Request Successful!"; List <BloodPlateletRequestUser> bloodPlateletRequestUser = BloodPlateletRequestUserDB.getAllUserBloodRequests(); string x = bloodPlateletRequestUser[0].bplUserRequestID; int tempID = Convert.ToInt32(x.Substring(4, x.Length - 4)); foreach (BloodPlateletRequestUser bpr in bloodPlateletRequestUser) { if (tempID < Convert.ToInt32(bpr.bplUserRequestID.Substring(4, bpr.bplUserRequestID.Length - 4)) && bpr.requestorID.UserId == u.UserId) { tempID = Convert.ToInt32(bpr.bplUserRequestID.Substring(4, bpr.bplUserRequestID.Length - 4)); } } BloodPlateletRequestUser request = BloodPlateletRequestUserDB.getUserBloodRequestsbyID("bpur" + Convert.ToString(tempID)); List <Establishment> establishments = EstablishmentDB.getAllEstablishments(); foreach (Establishment est in establishments) { BPMatchUserToEstab newMatch = new BPMatchUserToEstab(); if ((est.Type == "Hospital" || est.Type == "Blood Bank") && request.Establishment.ID != est.ID) { int d = getDistance(est.Address, request.Establishment.Address); if (d < 3600 && d > 0) { newMatch.bpRequestID = request; newMatch.matchID = est; newMatch.distance = d; newMatch.status = "pending"; int nums = BPMatchUserToEstabDB.insertbp(newMatch); if (nums != 1) { lblOutput.Text = "Cannot Request Blood!"; return; } else { lblOutput.Text = "Request Successful!"; } } } } List <Users> users = UsersDB.getallUsers(); List <LastDonationDate> lastDate = LastDonationDateDB.getAllLastDonations(); foreach (Users usr in users) { BPMatchUserToUser newMatchU = new BPMatchUserToUser(); string userGroup = usr.BloodType; string requestGroup = request.Type; bool f = false; if (requestGroup == "AB+") { f = true; } else if (requestGroup == "AB-" && (userGroup == "O-" || userGroup == "B-" || userGroup == "A-" || userGroup == "AB-")) { f = true; } else if (requestGroup == "A+" && (userGroup == "O-" || userGroup == "O+" || userGroup == "A-" || userGroup == "A+")) { f = true; } else if (requestGroup == "A-" && (userGroup == "O-" || userGroup == "A-")) { f = true; } else if (requestGroup == "B+" && (userGroup == "O-" || userGroup == "O+" || userGroup == "B-" || userGroup == "B+")) { f = true; } else if (requestGroup == "B-" && (userGroup == "O-" || userGroup == "B-")) { f = true; } else if (requestGroup == "O+" && (userGroup == "O-" || userGroup == "O+")) { f = true; } else if (requestGroup == "O-" && (userGroup == "O-")) { f = true; } if ((request.requestorID.UserId != usr.UserId) && (f == true) && (usr.MedicalStatus.ToLower() == "can donate") && (usr.status == "Allow")) { foreach (LastDonationDate lddate in lastDate) { if ((lddate.User.UserId == usr.UserId)) { if ((lddate.LastDonation < System.DateTime.Now.AddDays(-90) && lddate.Type == "blood") || (lddate.LastDonation < System.DateTime.Now.AddDays(-14) && lddate.Type == "platelet") && lddate.Status == "Not in transaction") { string origin = usr.Latitude + "," + usr.Longtitude; int d = getDistance(origin, request.Establishment.Address); if (d < 3600) { newMatchU.bplUsrRequestID = request; newMatchU.matchID = usr; newMatchU.distance = d; newMatchU.status = "pending"; BPMatchUserToUserDB.insertbpusertoUser(newMatchU); } } } } } } string DRUrl = "DonateAndRequest.aspx"; Page.Header.Controls.Add(new LiteralControl(string.Format(@" <META http-equiv='REFRESH' content=3;url={0}> ", DRUrl))); } //} }