protected void gvEstablishment_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
lblUpdateShow.Text = "";
gvEstablishment.PageIndex = e.NewPageIndex;
gvEstablishment.DataSource = EstablishmentDB.getAllEstablishments();
gvEstablishment.DataBind();
}
protected void gvEstablishment_SelectedIndexChanged(object sender, EventArgs e)
{
lblUpdateShow.Text = "";
PanelEst.Visible = true;
if (Session["esttemp"] == null)
{
List <Establishment> estlist = EstablishmentDB.getAllEstablishments();
Establishment es = estlist[gvEstablishment.PageSize * gvEstablishment.PageIndex + gvEstablishment.SelectedIndex];
tbxEstID.Text = es.ID;
tbxEstADdress.Text = es.Address;
tbxEstEmail.Text = es.Email;
tbxEstName.Text = es.Name;
tbxEstPhone.Text = es.Phone.ToString();
tbxEstType.Text = es.Type;
ddlestatus.SelectedValue = es.Status;
}
else
{
Establishment es2 = EstablishmentDB.getEstablishmentByEmail(tbxSearch.Text);
tbxEstID.Text = es2.ID;
tbxEstADdress.Text = es2.Address;
tbxEstEmail.Text = es2.Email;
tbxEstName.Text = es2.Name;
tbxEstPhone.Text = es2.Phone.ToString();
tbxEstType.Text = es2.Type;
ddlestatus.SelectedValue = es2.Status;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["email"] == null)
{
Server.Transfer("CommonLogin.aspx");
}
else
{
List <Establishment> elist = EstablishmentDB.getAllEstablishments();
foreach (Establishment es in elist)
{
if (es.Type == "Hospital" || es.Type == "Blood Bank")
{
ddlEstablish.Items.Add(es.Name);
}
}
ddlEstablish.Items.Insert(0, "--Select--");
lblAmount.Visible = false;
u = UsersDB.getUserbyEmail(Session["email"].ToString());
pendinglist = new List <BloodPlateletRequestUser>();
bplist = BloodPlateletRequestUserDB.getUserBloodRequestsbyUserID(u.userId);
foreach (BloodPlateletRequestUser b in bplist)
{
if (b.Status == "pending")
{
pendinglist.Add(b);
}
}
if (pendinglist.Count == 0)
{
lblSorry.Visible = true;
Panel1.Visible = false;
Panel2.Visible = false;
}
else
{
lblSorry.Visible = false;
Panel1.Visible = true;
gvUser.DataSource = pendinglist;
gvUser.DataBind();
Panel2.Visible = false;
}
lblee.Visible = false;
lbleeh.Visible = false;
lbleu.Visible = false;
lbleuh.Visible = false;
}
}
protected void btnResetPassword_Click(object sender, EventArgs e)
{
List <Establishment> estlist = EstablishmentDB.getAllEstablishments();
int found = 0;
try
{
foreach (Establishment u in estlist)
{
if (tbxFgEmail.Text == u.Email)
{
found = 1;
break;
}
}
if (found == 0)
{
lblError.Visible = true;
lblError.ForeColor = System.Drawing.Color.Red;
lblError.Text = "Email Address not found! Please Try Again.";
return;
}
else
{
Users fgmail = UsersDB.getUserbyEmail(tbxFgEmail.Text);
SmtpClient client = new SmtpClient("smtp.gmail.com");
client.EnableSsl = true;
client.Credentials = new NetworkCredential("*****@*****.**", "inft.3050");
MailMessage msg = new MailMessage("*****@*****.**", tbxFgEmail.Text);
msg.Subject = "Your Current Password";
msg.Body = "Your password is: " + fgmail.password;
client.Send(msg);
lblError.Visible = true;
lblError.ForeColor = System.Drawing.Color.Green;
lblError.Text = "Reset password sent to " + tbxFgEmail.Text;
}
}
catch (Exception)
{
lblError.Visible = true;
lblError.ForeColor = System.Drawing.Color.Red;
lblError.Text = "Unable to sent email! Try Again";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["establishment"] == null)
{
Server.Transfer("Login.aspx");
}
else
{
List <Establishment> establishments = EstablishmentDB.getAllEstablishments();
Establishment es = (Establishment)Session["establishment"];
if (es.Type == "Blood Bank")
{
linkOrgans1.Visible = false;
linkOrgans2.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["email"] == null)
{
Button1.Enabled = true;
}
else
{
Button1.Enabled = false;
}
int num = 0, esnum = 0, btc = 0, numo = 0;
List <Users> userslist = UsersDB.getallUsers();
num = userslist.Count;
lblTotalUsers.Text = num.ToString();
lblOutput.Text = "";
List <Establishment> estlist = EstablishmentDB.getAllEstablishments();
esnum = estlist.Count;
lblTotalAssociates.Text = esnum.ToString();
List <GReportBloodPlatelet> listEE = GReportBloodPlateletDB.HgetAllBloodEToE();
List <GReportBloodPlatelet> listEU = GReportBloodPlateletDB.HgetAllBloodEToU();
List <GReportBloodPlatelet> listUE = GReportBloodPlateletDB.HgetAllBloodUToE();
List <GReportBloodPlatelet> listUU = GReportBloodPlateletDB.HgetAllBloodUToU();
btc = listEE.Count + listEU.Count + listUE.Count + listUU.Count;
lblSuccessfulBloodDonation.Text = btc.ToString();
List <OrganRecipient> orlist = OrganRecipientDB.getAllRecipients();
foreach (OrganRecipient o in orlist)
{
if (o.Status == "complete")
{
numo++;
}
}
lblOrganDonation.Text = numo.ToString();
}
protected void btnEUpdate_Click(object sender, EventArgs e)
{
string tempemail = tbxEstEmail.Text;
Establishment tempest = EstablishmentDB.getEstablishmentByEmail(tempemail);
tempest.Status = ddlestatus.SelectedValue;
Admins a = AdminDB.getAdminbyEmail(Session["email"].ToString());
tempest.Admin = a;
int num = EstablishmentDB.updateestStatus(tempest);
if (num != 1)
{
lblOutput.Text = "Cannot Update Establishment!";
}
else
{
lblUpdateShow.Text = "Update Successful!";
PanelEst.Visible = false;
gvEstablishment.DataSource = EstablishmentDB.getAllEstablishments();
gvEstablishment.DataBind();
gvEstablishment.SelectedIndex = -1;
}
}
protected void btnSubmit2_Click(object sender, EventArgs e)
{
List <Establishment> establishments = EstablishmentDB.getAllEstablishments();
Establishment es = new Establishment();
foreach (Establishment est in establishments)
{
if (tbxEmail2.Text.ToLower() == est.Email.ToLower() && (est.Type == "Blood Bank" || est.Type == "Hospital"))
{
estFound = true;
estFoundG = false;
estFoundN = false;
es = est;
break;
}
else if (tbxEmail2.Text.ToLower() == est.Email.ToLower() && est.Type == "Government")
{
estFoundG = true;
estFound = false;
estFoundN = false;
es = est;
break;
}
else if (tbxEmail2.Text.ToLower() == est.Email.ToLower() && est.Type == "NGO")
{
estFoundG = false;
estFound = false;
estFoundN = true;
es = est;
break;
}
}
if (estFound == true)
{
if (tbxPassword2.Text == es.Password)
{
if (es.Status == "active")
{
Session["establishment"] = es;
Server.Transfer("HospitalHomePage.aspx");
}
else
{
lbl2Output.Text = "You cannot access to this email anymore. Please contact admin for more details";
return;
}
}
else
{
lbl2Output.Text = "Incorrect password!";
return;
}
}
else if (estFoundG == true)
{
if (tbxPassword2.Text == es.Password)
{
if (es.Status == "active")
{
Session["establishment"] = es;
Server.Transfer("GMyAccount.aspx");
}
else
{
lbl2Output.Text = "You cannot access to this email anymore. Please contact admin for more details";
return;
}
}
else
{
lbl2Output.Text = "Incorrect password!";
return;
}
}
else if (estFoundN == true)
{
if (tbxPassword2.Text == es.Password)
{
if (es.Status == "active")
{
Session["establishment"] = es;
Server.Transfer("NHomePage.aspx");
}
else
{
lbl2Output.Text = "You cannot access to this email anymore. Please contact admin for more details";
return;
}
}
else
{
lbl2Output.Text = "Incorrect password!";
return;
}
}
else
{
lbl2Output.Text = "Account doesn't exist";
return;
}
}
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)));
}
//}
}
protected void btnsearch_Click(object sender, EventArgs e)
{
lblUpdateShow.Text = "";
Panel1.Visible = false;
bool temail = false;
if (tbxSearch.Text == "")
{
lblError.Visible = true;
lblError.Text = "Please enter the email address to search";
return;
}
else
{
if (DropDownList2.SelectedIndex == 0)
{
lblError.Visible = true;
lblError.Text = "Please select category to search the individual";
Panel1.Visible = false;
Panel2.Visible = false;
return;
}
else if (DropDownList2.SelectedIndex == 1)
{
List <AUser> userslist = AUserDB.getallUsers();
foreach (AUser u in userslist)
{
if (tbxSearch.Text.ToLower() == u.email.ToLower())
{
temail = true;
break;
}
else
{
temail = false;
}
}
if (temail == true)
{
PanelUserAll.Visible = true;
AUser suser = AUserDB.getUserbyEmail(tbxSearch.Text);
List <AUser> tempuserlist = new List <AUser>();
tempuserlist.Add(suser);
gvUser.DataSource = tempuserlist;
gvUser.DataBind();
Session["etemp"] = tbxSearch.Text;
Panel1.Visible = false;
Panel2.Visible = false;
lblError.Text = "";
}
else
{
PanelUserAll.Visible = false;
lblError.Visible = true;
lblError.Text = "The email address not found in the system for User";
Panel1.Visible = false;
Panel2.Visible = false;
Session["etemp"] = null;
}
}
else if (DropDownList2.SelectedIndex == 2)
{
List <Admins> adminslist = AdminDB.getallAdmins();
foreach (Admins m in adminslist)
{
if (tbxSearch.Text.ToLower() == m.email.ToLower())
{
temail = true;
break;
}
else
{
temail = false;
}
}
if (temail == true)
{
PanelAllAdmins.Visible = true;
Admins sadmin = AdminDB.getAdminbyEmail(tbxSearch.Text);
List <Admins> tempadminlist = new List <Admins>();
tempadminlist.Add(sadmin);
gvAdmin.DataSource = tempadminlist;
gvAdmin.DataBind();
Session["atemp"] = tbxSearch.Text;
pAdminDetail.Visible = false;
lblError.Text = "";
}
else
{
PanelAllAdmins.Visible = false;
pAdminDetail.Visible = false;
lblError.Visible = true;
lblError.Text = "The email address not found in the system for Admin";
Session["atemp"] = null;
}
}
else if (DropDownList2.SelectedIndex == 3)
{
List <Establishment> estlist = EstablishmentDB.getAllEstablishments();
foreach (Establishment es in estlist)
{
if (tbxSearch.Text.ToLower() == es.Email.ToLower())
{
temail = true;
break;
}
else
{
temail = false;
}
}
if (temail == true)
{
PanelAllEstablishment.Visible = true;
Establishment estab = EstablishmentDB.getEstablishmentByEmail(tbxSearch.Text);
List <Establishment> tempestlist = new List <Establishment>();
tempestlist.Add(estab);
gvEstablishment.DataSource = tempestlist;
gvEstablishment.DataBind();
Session["esttemp"] = tbxSearch.Text;
PanelEst.Visible = false;
lblError.Text = "";
}
else
{
PanelAllEstablishment.Visible = false;
PanelEst.Visible = false;
lblError.Visible = true;
lblError.Text = "The email address not found in the system for Establishment";
Session["esttemp"] = null;
}
}
}
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
lblUpdateShow.Text = "";
if (DropDownList2.SelectedIndex == 0)
{
PanelUserAll.Visible = false;
PanelAllAdmins.Visible = false;
Panel1.Visible = false;
pAdminDetail.Visible = false;
PanelAllEstablishment.Visible = false;
PanelEst.Visible = false;
lblError.Text = "";
lblAOutput.Text = "";
lblOutput.Text = "";
lblCError.Text = "";
}
else if (DropDownList2.SelectedIndex == 1)
{
List <AUser> allUsers = AUserDB.getallUsers();
if (allUsers.Count == 0)
{
lblCError.Text = "Sorry! There is no user found!";
return;
}
else
{
PanelUserAll.Visible = true;
Panel1.Visible = false;
PanelAllAdmins.Visible = false;
pAdminDetail.Visible = false;
PanelAllEstablishment.Visible = false;
PanelEst.Visible = false;
bindUser();
gvUser.SelectedIndex = -1;
lblCError.Text = "";
lblError.Text = "";
tbxSearch.Text = "";
Session["etemp"] = null;
Session["esttemp"] = null;
}
}
else if (DropDownList2.SelectedIndex == 2)
{
List <Admins> alladmins = AdminDB.getallAdmins();
if (alladmins.Count == 0)
{
lblCError.Text = "Sorry! There is no user found!";
return;
}
else
{
PanelUserAll.Visible = false;
Panel1.Visible = false;
pAdminDetail.Visible = false;
PanelAllEstablishment.Visible = false;
PanelEst.Visible = false;
PanelAllAdmins.Visible = true;
gvAdmin.SelectedIndex = -1;
bindAdmin();
lblCError.Text = "";
lblError.Text = "";
tbxSearch.Text = "";
Session["atemp"] = null;
Session["esttemp"] = null;
}
}
else if (DropDownList2.SelectedIndex == 3)
{
List <Establishment> allest = EstablishmentDB.getAllEstablishments();
if (allest.Count == 0)
{
lblCError.Text = "Sorry! There is no user found!";
return;
}
else
{
PanelUserAll.Visible = false;
Panel1.Visible = false;
pAdminDetail.Visible = false;
PanelAllAdmins.Visible = false;
PanelAllEstablishment.Visible = true;
PanelEst.Visible = false;
gvEstablishment.DataSource = allest;
gvEstablishment.DataBind();
lblCError.Text = "";
gvEstablishment.SelectedIndex = -1;
lblError.Text = "";
tbxSearch.Text = "";
Session["atemp"] = null;
Session["etemp"] = null;
}
}
}