public static List <BplTransactionUserToEstab> getAllbpTransactionUserToEsta()
{
List <BplTransactionUserToEstab> matches = new List <BplTransactionUserToEstab>();
try
{
SqlCommand command = new SqlCommand("Select * from BplTransactionUserToEstab");
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
BplTransactionUserToEstab m = new BplTransactionUserToEstab();
m.bplUserToEstabTrasactionID = reader["bplUserToEstabTrasactionID"].ToString();
BPMatchUserToEstab es = BPMatchUserToEstabDB.getBloodRequestsMatchbyID(reader["bpMatchUsrEstID"].ToString());
m.bpMatchUsrEstID = es;
m.unit = Convert.ToInt32(reader["unitsPossible"]);
m.status = reader["status"].ToString();
matches.Add(m);
}
reader.Close();
}
finally
{
connection.Close();
}
return(matches);
}
protected void gvAcceptedEstabRequests_SelectedIndexChanged(object sender, EventArgs e)
{
BloodPlateletRequestUser selectedRequest = userRequests[gvRequestInfo.PageSize * gvRequestInfo.PageIndex + gvRequestInfo.SelectedIndex];
List <BplTransactionUserToEstab> allEstabTransactions = BplTransactionUserToEstabDB.getAllbpTransactionUserToEsta();
foreach (BplTransactionUserToEstab m in allEstabTransactions)
{
if (m.bpMatchUsrEstID.bpRequestID.bplUserRequestID == selectedRequest.bplUserRequestID && m.status == "accepted")
{
estabsAccepted.Add(m);
}
}
BplTransactionUserToEstab selectedTransaction = estabsAccepted[gvAcceptedEstabRequests.PageSize * gvAcceptedEstabRequests.PageIndex + gvAcceptedEstabRequests.SelectedIndex];
selectedTransaction.status = "complete";
BplTransactionUserToEstabDB.updateBPTranscationUserToEstab(selectedTransaction);
gvAcceptedEstabRequests.DataBind();
BPMatchUserToEstab currentMatch = selectedTransaction.bpMatchUsrEstID;
currentMatch.status = "declined";
BPMatchUserToEstabDB.updateBPMatchUserToEstab(currentMatch);
if (selectedRequest.Units == selectedRequest.unitMatched)
{
selectedRequest.Status = "complete";
BloodPlateletRequestUserDB.updateBloodPlateles(selectedRequest);
gvRequestInfo.DataBind();
}
}
protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
BloodPlateletRequestUser bpr = BloodPlateletRequestUserDB.getUserBloodRequestsbyID(lblRID.Text);
estabTransactions = BplTransactionUserToEstabDB.getAllbpTransactionUserToEsta();
List <BplTransactionUserToEstab> allestabTransactions = new List <BplTransactionUserToEstab>();
foreach (BplTransactionUserToEstab m in estabTransactions)
{
if (m.bpMatchUsrEstID.bpRequestID.bplUserRequestID == bpr.bplUserRequestID && m.status == "accepted")
{
allestabTransactions.Add(m);
}
}
BplTransactionUserToEstab selectedTransaction = allestabTransactions[GridView2.PageSize * GridView2.PageIndex + e.RowIndex];
selectedTransaction.status = "cancelled";
BplTransactionUserToEstabDB.updateBPTranscationUserToEstab(selectedTransaction);
BloodPlateletRequestUser selectedRequest = bpr;
selectedRequest.unitMatched = selectedRequest.unitMatched - selectedTransaction.unit;
BloodPlateletRequestUserDB.updateBloodPlateles(selectedRequest);
Server.Transfer("DonateAndRequest.aspx");
}
public static int updateBPTranscationUserToEstab(BplTransactionUserToEstab u)
{
int result;
try
{
SqlCommand command = new SqlCommand("Update BplTransactionUserToEstab set status=@status where bplUserToEstabTrasactionID=@bplUserToEstabTrasactionID");
command.Parameters.AddWithValue("@bplUserToEstabTrasactionID", u.bplUserToEstabTrasactionID);
command.Parameters.AddWithValue("@status", u.status);
command.Connection = connection;
connection.Open();
result = command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
return(result);
}
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
{
BloodPlateletRequestUser bpr = BloodPlateletRequestUserDB.getUserBloodRequestsbyID(lblRID.Text);
List <BplTransactionUserToEstab> allestabTransactions = new List <BplTransactionUserToEstab>();
estabTransactions = BplTransactionUserToEstabDB.getAllbpTransactionUserToEsta();
foreach (BplTransactionUserToEstab m in estabTransactions)
{
if (m.bpMatchUsrEstID.bpRequestID.bplUserRequestID == bpr.bplUserRequestID && m.status == "accepted")
{
allestabTransactions.Add(m);
}
}
//take the session for individual chatting
BplTransactionUserToEstab selectedTransaction = allestabTransactions[GridView2.PageSize * GridView2.PageIndex + GridView2.SelectedIndex];
Session["echat"] = selectedTransaction.bpMatchUsrEstID.matchID.ID;
Session["chat"] = null;
Server.Transfer("IndividualChatUU.aspx");
}
protected void btnUserSubmit_Click(object sender, EventArgs e)
{
Establishment currentEstab = (Establishment)Session["establishment"];
List <BPMatchUserToEstab> allUserRequests = BPMatchUserToEstabDB.getAllbpMatchUserToEsta();
List <BPMatchUserToEstab> userRequests = new List <BPMatchUserToEstab>();
foreach (BPMatchUserToEstab m in allUserRequests)
{
if (m.matchID.ID == currentEstab.ID && m.status == "pending" && m.bpRequestID.unitMatched < m.bpRequestID.Units)
{
userRequests.Add(m);
}
}
BPMatchUserToEstab currentMatch = userRequests[gvUserRequests.PageSize * gvUserRequests.PageIndex + gvUserRequests.SelectedIndex];
BloodPlateletRequestUser r = currentMatch.bpRequestID;
BplTransactionUserToEstab newTransaction = new BplTransactionUserToEstab();
int donateUnits = Convert.ToInt32(tbxUserUnits.Text);
if (donateUnits > (currentMatch.bpRequestID.Units - currentMatch.bpRequestID.unitMatched))
{
lblUserOutput.Text = "Please enter a valid amount";
}
else
{
currentMatch.status = "accepted";
BPMatchUserToEstabDB.updateBPMatchUserToEstab(currentMatch);
newTransaction.bpMatchUsrEstID = currentMatch;
newTransaction.unit = donateUnits;
newTransaction.status = "accepted";
BplTransactionUserToEstabDB.insertbptrans(newTransaction);
r.unitMatched = r.unitMatched + donateUnits;
BloodPlateletRequestUserDB.updateBloodPlateles(r);
lblOutput.Text = "Donation successfully accepted!";
pnlAcceptUser.Visible = false;
tbxUserUnits.Text = "";
Server.Transfer("IncomingRequests.aspx");
}
}
//add new blood and plateles matches to database
public static int insertbptrans(BplTransactionUserToEstab m)
{
int num = -1;
try
{
SqlCommand command = new SqlCommand("insert into BplTransactionUserToEstab values( @bpMatchUsrEstID , @unitsPossible , @status )");
command.Parameters.AddWithValue("@bpMatchUsrEstID", m.bpMatchUsrEstID.bpMatchUsrEstID);
command.Parameters.AddWithValue("@unitsPossible", m.unit);
command.Parameters.AddWithValue("@status", m.status);
command.Connection = connection;
connection.Open();
if (command.ExecuteNonQuery() > 0)
{
num = 1;
}
}
finally
{
connection.Close();
}
return(num);
}