public static List <EstabUserTransaction> getAllTransactions()
{
List <EstabUserTransaction> transactions = new List <EstabUserTransaction>();
try
{
SqlCommand command = new SqlCommand("Select * from BplTransactionEstabToUser");
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
EstabUserTransaction t = new EstabUserTransaction();
t.ID = reader["bplEstabTrasactionID"].ToString();
t.Match = EstabUserMatchDB.getUserMatchByID(reader["bpMatchEstabUserID"].ToString());
t.Units = Convert.ToInt32(reader["unitsPossible"]);
t.Status = reader["status"].ToString();
transactions.Add(t);
}
reader.Close();
}
finally
{
connection.Close();
}
return(transactions);
}
protected void lbtnContact_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 contactUser = selectedTransaction.Match.Match;
Session["ldID"] = contactUser.UserId;
Session["rwEst"] = null;
Session["echat"] = null;
Server.Transfer("IndividualChatE.aspx");
}
protected void gvUserMatches_RowDeleting(object sender, GridViewDeleteEventArgs 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[e.RowIndex];
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 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");
}
public static int updateTransaction(EstabUserTransaction t)
{
int num = -1;
try
{
SqlCommand command = new SqlCommand("update bplTransactionEstabToUser set status=@status where bplEstabTrasactionID=@id");
command.Parameters.AddWithValue("@status", t.Status);
command.Parameters.AddWithValue("@id", t.ID);
command.Connection = connection;
connection.Open();
if (command.ExecuteNonQuery() > 0)
{
num = 1;
}
}
finally
{
connection.Close();
}
return(num);
}
public static int insertTransaction(EstabUserTransaction t)
{
int num = -1;
try
{
SqlCommand command = new SqlCommand("insert into bplTransactionEstabToUser values(@bpMatchEstabUserID, @unitsPossible, @status)");
command.Parameters.AddWithValue("@bpMatchEstabUserID", t.Match.ID);
command.Parameters.AddWithValue("@unitsPossible", t.Units);
command.Parameters.AddWithValue("@status", t.Status);
command.Connection = connection;
connection.Open();
if (command.ExecuteNonQuery() > 0)
{
num = 1;
}
}
finally
{
connection.Close();
}
return(num);
}
