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 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 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; } } } }