//get all blood and platelet transaction list from database
public static List <BplTransactionUserToUser> getAllbpTransUserToUser()
{
List <BplTransactionUserToUser> matches = new List <BplTransactionUserToUser>();
try
{
SqlCommand command = new SqlCommand("Select * from BplTransactionUserToUser");
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
BplTransactionUserToUser m = new BplTransactionUserToUser();
m.bplUserTrasactionID = reader["bplUserTrasactionID"].ToString();
BPMatchUserToUser es = BPMatchUserToUserDB.getUserBloodRequestsbyMatchID(reader["bpMatchUsrUsr"].ToString());
m.bpMatchUsrUsr = es;
m.unitsPossible = 1;
m.status = reader["status"].ToString();
matches.Add(m);
}
reader.Close();
}
finally
{
connection.Close();
}
return(matches);
}
//cancel the current donation which are not yet accept by any individual
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
BloodPlateletRequestUser bpr = BloodPlateletRequestUserDB.getUserBloodRequestsbyID(lblRID.Text);
userTransactions = BplTransactionUserToUserDB.getAllbpTransUserToUser();
List <BplTransactionUserToUser> alluserTransactions = new List <BplTransactionUserToUser>();
foreach (BplTransactionUserToUser btu in userTransactions)
{
if (btu.bpMatchUsrUsr.bplUsrRequestID.bplUserRequestID == bpr.bplUserRequestID && btu.status == "accepted")
{
alluserTransactions.Add(btu);
}
}
BplTransactionUserToUser selectedTransaction = alluserTransactions[GridView1.PageSize * GridView1.PageIndex + e.RowIndex];
selectedTransaction.status = "cancelled";
BplTransactionUserToUserDB.updateBPTranscationUserToUser(selectedTransaction);
BloodPlateletRequestUser selectedRequest = bpr;
selectedRequest.unitMatched = selectedRequest.unitMatched - selectedTransaction.unitsPossible;
BloodPlateletRequestUserDB.updateBloodPlateles(selectedRequest);
Server.Transfer("DonateAndRequest.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");
}
public static int updateBPTranscationUserToUser(BplTransactionUserToUser u)
{
int result;
try
{
SqlCommand command = new SqlCommand("Update BplTransactionUserToUser set status=@status where bplUserTrasactionID=@bplUserTrasactionID");
command.Parameters.AddWithValue("@bplUserTrasactionID", u.bplUserTrasactionID);
command.Parameters.AddWithValue("@status", u.status);
command.Connection = connection;
connection.Open();
result = command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
return(result);
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
BloodPlateletRequestUser bpr = BloodPlateletRequestUserDB.getUserBloodRequestsbyID(lblRID.Text);
userTransactions = BplTransactionUserToUserDB.getAllbpTransUserToUser();
List <BplTransactionUserToUser> alluserTransactions = new List <BplTransactionUserToUser>();
foreach (BplTransactionUserToUser btu in userTransactions)
{
if (btu.bpMatchUsrUsr.bplUsrRequestID.bplUserRequestID == bpr.bplUserRequestID && btu.status == "accepted")
{
alluserTransactions.Add(btu);
}
}
BplTransactionUserToUser selectedTransaction = alluserTransactions[GridView1.PageSize * GridView1.PageIndex + GridView1.SelectedIndex];
//take the session for individual chatting
Session["chat"] = selectedTransaction.bpMatchUsrUsr.matchID.userId;
Session["echat"] = null;
Server.Transfer("IndividualChatUU.aspx");
}
//add new blood and plateles matches to database
public static int insertbpTrans(BplTransactionUserToUser m)
{
int num = -1;
try
{
SqlCommand command = new SqlCommand("insert into BplTransactionUserToUser values( @bpMatchUsrUsr, @status)");
command.Parameters.AddWithValue("@bpMatchUsrUsr", m.bpMatchUsrUsr.bpMatchUsrUsrID);
command.Parameters.AddWithValue("@status", m.status);
command.Connection = connection;
connection.Open();
if (command.ExecuteNonQuery() > 0)
{
num = 1;
}
}
finally
{
connection.Close();
}
return(num);
}
