//DELETE data from Table
protected void DeleteLink_Click(object sender, EventArgs e)
{
Call_Database deleteEntry = new Call_Database();
if (LeadershipDisplay.Items.FindByValue("AdvBoard").Selected == true)
{
string Action = "AdvBoardDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.AdvBoard;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ElecBoard").Selected == true)
{
string Action = "ElecBoardDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.ElecBoard;
RepeaterNum2.DataBind();
}
}
//INSERTS datafields into Database Table
protected void SubButton_Click(object sender, EventArgs e)
{
Call_Database callDB = new Call_Database();
if (ImageUpload.HasFile)
{
if (CheckFileType(ImageUpload.FileName))
{
string strPath = "../Images/dbImages/" + ImageUpload.FileName;
ImageUpload.SaveAs(MapPath(strPath));
}
}
if (NameBox.Text != "" && txtProfile.Text != "")
{
string Action = "DonorsINSERT";
callDB.FormINSERT(Action, NameBox.Text, ImageUpload.FileName, txtProfile.Text, null, null, 0, 0, 0, 0);
NameBox.Text = String.Empty;
txtProfile.Text = String.Empty;
Call_Database update = new Call_Database();
RepeaterNum.DataSource = update.dbDonors;
RepeaterNum.DataBind();
}
}
//UPDATE datafields from Repeater Table
protected void OnUpdate_Click(object sender, EventArgs e)
{
Call_Database updateEntry = new Call_Database();
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
if (LeadershipDisplay.Items.FindByValue("AdvBoard").Selected == true)
{
string Action = "AdvBoardUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditStatus = (item.FindControl("EditStatus") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, EditStatus, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.AdvBoard;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ElecBoard").Selected == true)
{
string Action = "ElecBoardUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditYear = (item.FindControl("EditYear") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, EditYear, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.ElecBoard;
RepeaterNum2.DataBind();
}
}
//UPDATE datafields from Repeater Table
protected void OnUpdate_Click(object sender, EventArgs e)
{
Call_Database updateEntry = new Call_Database();
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
if (LeadershipDisplay.Items.FindByValue("AdvBoard").Selected == true)
{
string Action = "AdvBoardUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditStatus = (item.FindControl("EditStatus") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, EditStatus, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.AdvBoard;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ElecBoard").Selected == true)
{
string Action = "ElecBoardUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditYear = (item.FindControl("EditYear") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, EditYear, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.ElecBoard;
RepeaterNum2.DataBind();
}
}
//Update Video
protected void VidChange_Click(object sender, EventArgs e)
{
Call_Database vidDB = new Call_Database();
vidDB.VideoUPDATE(VidBox.Text);
VidBox.Text = String.Empty;
}
protected void Page_Load(object sender, EventArgs e)
{
Call_Database callDb = new Call_Database();
dtDonors = callDb.dbDonors;
HtmlGenericControl div, img;
foreach (DataRow row in dtDonors.Rows)
{
string DenyPhoto = "Images/dbImages/";
string Deny = (string)row["photo"];
if (Deny != DenyPhoto)
{
div = new HtmlGenericControl("div");
div.Attributes["data-p"] = "112.50";
div.Attributes["style"] = "display: none;";
SlideShowDiv.Controls.Add(div);
img = new HtmlGenericControl("img");
img.Attributes["data-u"] = "image";
img.Attributes["src"] = row["photo"].ToString();
div.Controls.Add(img);
img = new HtmlGenericControl("img");
img.Attributes["data-u"] = "thumb";
img.Attributes["src"] = row["photo"].ToString();
div.Controls.Add(img);
}
}
}
//DELETE data from Table
protected void DeleteLink_Click(object sender, EventArgs e)
{
Call_Database deleteEntry = new Call_Database();
if (LeadershipDisplay.Items.FindByValue("AdvBoard").Selected == true)
{
string Action = "AdvBoardDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.AdvBoard;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ElecBoard").Selected == true)
{
string Action = "ElecBoardDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.ElecBoard;
RepeaterNum2.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Call_Database callDb = new Call_Database();
dtDonors = callDb.dbDonors;
HtmlGenericControl div, h, p, img;
foreach (DataRow row in dtDonors.Rows)
{
//Response.Write(row["name"]);
h = new HtmlGenericControl("h3");
h.ID = "dynDivCode";
h.InnerHtml = row["name"].ToString();
accordion.Controls.Add(h);
div = new HtmlGenericControl("div");
img = new HtmlGenericControl("img");
img.Attributes["src"] = row["photo"].ToString();
img.Attributes["class"] = "photos";
div.Controls.Add(img);
p = new HtmlGenericControl("p");
p.InnerHtml = row["profile"].ToString();
div.Controls.Add(p);
accordion.Controls.Add(div);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Call_Database callDb = new Call_Database();
dtDonors = callDb.dbDonors;
HtmlGenericControl div, img;
foreach (DataRow row in dtDonors.Rows)
{
string DenyPhoto = "Images/dbImages/";
string Deny = (string)row["photo"];
if (Deny != DenyPhoto)
{
div = new HtmlGenericControl("div");
div.Attributes["class"] = "swiper-slide";
SlideShowDiv.Controls.Add(div);
img = new HtmlGenericControl("img");
img.Attributes["src"] = row["photo"].ToString();
div.Controls.Add(img);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["Id"] != null)
{
strQuery = Request.QueryString["Id"].ToString();
}
Call_Database ChapelDB = new Call_Database();
Repeater1.DataSource = ChapelDB.dbChapelBuilding;
Repeater1.DataBind();
Repeater2.DataSource = ChapelDB.dbHarmonyWall;
Repeater2.DataBind();
Repeater3.DataSource = ChapelDB.dbHopeWall;
Repeater3.DataBind();
Repeater4.DataSource = ChapelDB.dbFaithWall;
Repeater4.DataBind();
Repeater5.DataSource = ChapelDB.dbGraceWall;
Repeater5.DataBind();
Repeater6.DataSource = ChapelDB.dbPeaceWall;
Repeater6.DataBind();
Repeater7.DataSource = ChapelDB.dbChairsBenches;
Repeater7.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["Id"] != null)
{
strQuery = Request.QueryString["Id"].ToString();
}
Call_Database ChapelDB = new Call_Database();
Repeater1.DataSource = ChapelDB.dbChapelBuilding;
Repeater1.DataBind();
Repeater2.DataSource = ChapelDB.dbHarmonyWall;
Repeater2.DataBind();
Repeater3.DataSource = ChapelDB.dbHopeWall;
Repeater3.DataBind();
Repeater4.DataSource = ChapelDB.dbFaithWall;
Repeater4.DataBind();
Repeater5.DataSource = ChapelDB.dbGraceWall;
Repeater5.DataBind();
Repeater6.DataSource = ChapelDB.dbPeaceWall;
Repeater6.DataBind();
Repeater7.DataSource = ChapelDB.dbChairsBenches;
Repeater7.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Call_Database callDb = new Call_Database();
dtDonors = callDb.dbDonors;
HtmlGenericControl div, h, p, img;
foreach (DataRow row in dtDonors.Rows)
{
//Response.Write(row["name"]);
h = new HtmlGenericControl("h3");
h.ID = "dynDivCode2";
h.InnerHtml = row["name"].ToString();
accordion.Controls.Add(h);
div = new HtmlGenericControl("div");
img = new HtmlGenericControl("img");
img.Attributes["src"] = row["photo"].ToString();
img.Attributes["class"] = "photos";
div.Controls.Add(img);
p = new HtmlGenericControl("p");
p.InnerHtml = row["profile"].ToString();
div.Controls.Add(p);
accordion.Controls.Add(div);
h.ID = null;
break;
}
Call_Database ListDB = new Call_Database();
Repeater1.DataSource = ListDB.dbDonors;
Repeater1.DataBind();
}
protected void Delete_Click(object sender, EventArgs e)
{
Call_Database deleteEntry = new Call_Database();
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId);
Response.Redirect(Request.RawUrl);
}
//DELETE datafields from Database Table
protected void DeleteLink_Click(object sender, EventArgs e)
{
Call_Database deleteEntry = new Call_Database();
string Action = "DonorsDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum.DataSource = update.dbDonors;
RepeaterNum.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Call_Database callDatabase = new Call_Database();
dtDataTable = callDatabase.dbFitnessCenter;
HtmlGenericControl div, h, p;
foreach (DataRow row in dtDataTable.Rows)
{
//Response.Write(row["name"]);
h = new HtmlGenericControl("h3");
h.ID = "dynDivCode2";
h.InnerHtml = row["RoomName"].ToString();
accordion.Controls.Add(h);
div = new HtmlGenericControl("div");
p = new HtmlGenericControl("p");
p.InnerHtml = "<b>Room Plaque</b>";
div.Controls.Add(p);
p = new HtmlGenericControl("p");
p.InnerHtml = row["RoomPlaque"].ToString();
div.Controls.Add(p);
p = new HtmlGenericControl("p");
p.InnerHtml = "</br>";
div.Controls.Add(p);
p = new HtmlGenericControl("p");
p.InnerHtml = row["Date"].ToString();
if (p.InnerHtml != "")
{
p = new HtmlGenericControl("p");
p.InnerHtml = "<b>Date</b>";
div.Controls.Add(p);
p = new HtmlGenericControl("p");
p.InnerHtml = row["Date"].ToString();
div.Controls.Add(p);
}
accordion.Controls.Add(div);
h.ID = null;
}
Call_Database SearchCommonsDB = new Call_Database();
Repeater1.DataSource = SearchCommonsDB.dbFitnessCenter;
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["Id"] != null)
{
strQuery = Request.QueryString["Id"].ToString();
}
Call_Database OutdoorsDB = new Call_Database();
Repeater1.DataSource = OutdoorsDB.dbOutdoors;
Repeater1.DataBind();
}
//DELETE datafields from Database Table
protected void DeleteLink_Click(object sender, EventArgs e)
{
Call_Database deleteEntry = new Call_Database();
string Action = "DonorsDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum.DataSource = update.dbDonors;
RepeaterNum.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Call_Database callDatabase = new Call_Database();
dtDataTable = callDatabase.dbFitnessCenter;
HtmlGenericControl div, h, p;
foreach (DataRow row in dtDataTable.Rows)
{
//Response.Write(row["name"]);
h = new HtmlGenericControl("h3");
h.ID = "dynDivCode2";
h.InnerHtml = row["RoomName"].ToString();
accordion.Controls.Add(h);
div = new HtmlGenericControl("div");
p = new HtmlGenericControl("p");
p.InnerHtml = "<b>Room Plaque</b>";
div.Controls.Add(p);
p = new HtmlGenericControl("p");
p.InnerHtml = row["RoomPlaque"].ToString();
div.Controls.Add(p);
p = new HtmlGenericControl("p");
p.InnerHtml = "</br>";
div.Controls.Add(p);
p = new HtmlGenericControl("p");
p.InnerHtml = row["Date"].ToString();
if (p.InnerHtml != "")
{
p = new HtmlGenericControl("p");
p.InnerHtml = "<b>Date</b>";
div.Controls.Add(p);
p = new HtmlGenericControl("p");
p.InnerHtml = row["Date"].ToString();
div.Controls.Add(p);
}
accordion.Controls.Add(div);
h.ID = null;
}
Call_Database SearchCommonsDB = new Call_Database();
Repeater1.DataSource = SearchCommonsDB.dbFitnessCenter;
Repeater1.DataBind();
}
//UPDATE datafields from Repeater Table
protected void OnUpdate_Click(object sender, EventArgs e)
{
Call_Database updateEntry = new Call_Database();
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
string Action = "DonorsUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPhoto = (item.FindControl("EditPhoto") as TextBox).Text;
string EditProfile = (item.FindControl("EditProfile") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, EditPhoto, EditProfile, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum.DataSource = update.dbDonors;
RepeaterNum.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["Id"] != null)
{
strQuery = Request.QueryString["Id"].ToString();
}
Call_Database OutdoorsDB = new Call_Database();
Repeater1.DataSource = OutdoorsDB.dbOutdoors;
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["id"] != null)
{
strQuery = Request.QueryString["id"].ToString();
}
Call_Database classDBDonors = new Call_Database();
Repeater2.DataSource = classDBDonors.dbDonors;
Repeater2.DataBind();
}
//UPDATE datafields from Repeater Table
protected void OnUpdate_Click(object sender, EventArgs e)
{
Call_Database updateEntry = new Call_Database();
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
string Action = "DonorsUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPhoto = (item.FindControl("EditPhoto") as TextBox).Text;
string EditProfile = (item.FindControl("EditProfile") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, EditPhoto, EditProfile, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum.DataSource = update.dbDonors;
RepeaterNum.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["Id"] != null)
{
strQuery = Request.QueryString["Id"].ToString();
}
Call_Database classDBRep1 = new Call_Database();
Repeater1.DataSource = classDBRep1.AdvBoard;
Repeater1.DataBind();
Call_Database classDBRep2 = new Call_Database();
Repeater2.DataSource = classDBRep2.ElecBoard;
Repeater2.DataBind();
}
protected void OnAlumniUpdate_Click(object sender, EventArgs e)
{
Call_Database updateEntry = new Call_Database();
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
string Action = "AlumniMapUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditAlumniName") as TextBox).Text;
string EditAlumni = ((item.FindControl("EditAlumni") as TextBox).Text);
int EditAlumniNum = Convert.ToInt32(EditAlumni);
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, EditAlumniNum, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbAlumniMap;
RepeaterNum2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["Id"] != null)
{
strQuery = Request.QueryString["Id"].ToString();
}
Call_Database FoundersDB = new Call_Database();
Repeater1.DataSource = FoundersDB.dbFounders;
Repeater1.DataBind();
Call_Database CornerstoneDB = new Call_Database();
Repeater2.DataSource = CornerstoneDB.dbCornerstone;
Repeater2.DataBind();
Call_Database ScholarshipsDB = new Call_Database();
Repeater3.DataSource = ScholarshipsDB.dbScholarships;
Repeater3.DataBind();
Call_Database RoundtableDB = new Call_Database();
Repeater4.DataSource = RoundtableDB.dbRoundtable;
Repeater4.DataBind();
Call_Database PresidentsTabDB = new Call_Database();
Repeater5.DataSource = PresidentsTabDB.dbPresidentsTab;
Repeater5.DataBind();
Call_Database QuadrangleTabDB = new Call_Database();
Repeater6.DataSource = QuadrangleTabDB.dbQuadrangleTab;
Repeater6.DataBind();
Call_Database BlueGoldTabDB = new Call_Database();
Repeater7.DataSource = BlueGoldTabDB.dbBlueGoldTab;
Repeater7.DataBind();
Call_Database CenturyTabDB = new Call_Database();
Repeater8.DataSource = CenturyTabDB.dbCenturyTab;
Repeater8.DataBind();
Call_Database OtherDonorsTabDB = new Call_Database();
Repeater9.DataSource = OtherDonorsTabDB.dbOtherDonorsTab;
Repeater9.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["id"] != null)
{
strQuery = Request.QueryString["id"].ToString();
}
if (!IsPostBack)
{
Call_Database PageDB = new Call_Database();
Call_Database AlumniDB = new Call_Database();
RepeaterNum.DataSource = PageDB.dbDonors;
RepeaterNum.DataBind();
RepeaterNum2.DataSource = AlumniDB.dbAlumniMap;
RepeaterNum2.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["id"] != null)
{
strQuery = Request.QueryString["id"].ToString();
}
if (!IsPostBack)
{
Call_Database PageDB = new Call_Database();
//Loads AdvBoard Table
RepeaterNum1.DataSource = PageDB.AdvBoard;
RepeaterNum1.DataBind();
//Loads ElecBoard Table
RepeaterNum2.DataSource = PageDB.ElecBoard;
RepeaterNum2.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Call_Database callDb = new Call_Database();
dtDonors = callDb.dbDonors;
HtmlGenericControl div, cap, img1, img2, bold;
foreach (DataRow row in dtDonors.Rows)
{
string DenyPhoto = "Images/dbImages/";
string Deny = (string)row["photo"];
string Content = (string)row["profile"];
if (Deny != DenyPhoto)
{
div = new HtmlGenericControl("div");
div.Attributes["data-p"] = "112.50";
div.Attributes["style"] = "display: none;";
SlideShowDiv.Controls.Add(div);
img1 = new HtmlGenericControl("img");
img1.Attributes["data-u"] = "image";
img1.Attributes["src"] = row["photo"].ToString();
div.Controls.Add(img1);
cap = new HtmlGenericControl("span");
cap.Attributes["style"] = "position: inherit; top: 500px; left: 450px; width: 350px; height: 80px; display: block; font - size: 20px; line - height: 30px; text - align: center; background: rgba(255,255,255, 0.8); border-radius: 10px; padding: 20px; ";
img1.Controls.Add(cap);
bold = new HtmlGenericControl("b");
bold.InnerHtml = row["profile"].ToString();
cap.Controls.Add(bold);
img2 = new HtmlGenericControl("img");
img2.Attributes["data-u"] = "thumb";
img2.Attributes["src"] = row["photo"].ToString();
div.Controls.Add(img2);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["Id"] != null)
{
strQuery = Request.QueryString["Id"].ToString();
}
Call_Database classDBRep1 = new Call_Database();
Repeater1.DataSource = classDBRep1.AdvBoard;
Repeater1.DataBind();
Call_Database classDBRep2 = new Call_Database();
Repeater2.DataSource = classDBRep2.ElecBoard;
Repeater2.DataBind();
}
//INSERT data into Leadership Tables
protected void SubButton_Click(object sender, EventArgs e)
{
Call_Database callDB = new Call_Database();
if (LeadershipDisplay.Items.FindByValue("AdvBoard").Selected == true)
{
string Action = "AdvBoardINSERT";
callDB.FormINSERT(Action, txtName.Text, txtStatus.Text, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.AdvBoard;
RepeaterNum1.DataBind();
}
if (LeadershipDisplay.Items.FindByValue("ElecBoard").Selected == true)
{
string Action = "ElecBoardINSERT";
callDB.FormINSERT(Action, txtName.Text, txtYear.Text, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.ElecBoard;
RepeaterNum2.DataBind();
}
}
protected void SubButton_Click(object sender, EventArgs e)
{
Call_Database callDb = new Call_Database();
if (ImageUpload.HasFile)
{
if (CheckFileType(ImageUpload.FileName))
{
string strPath = "~/Images/" + ImageUpload.FileName;
ImageUpload.SaveAs(MapPath(strPath));
}
}
if (NameBox.Text != "" && txtProfile.Text != "")
{
callDb.Add(NameBox.Text, ImageUpload.FileName, txtProfile.Text);
NameBox.Text = String.Empty;
txtProfile.Text = String.Empty;
Response.Redirect(Request.RawUrl);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["id"] != null)
{
strQuery = Request.QueryString["id"].ToString();
}
if (!IsPostBack)
{
Call_Database PageDB = new Call_Database();
//Loads Scholarships Table
RepeaterNum1.DataSource = PageDB.dbOutdoors;
RepeaterNum1.DataBind();
//Loads Founders Table
RepeaterNum2.DataSource = PageDB.dbChapel;
RepeaterNum2.DataBind();
//Loads Society Tables
RepeaterNum3.DataSource = PageDB.dbFisherHall;
RepeaterNum3.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["id"] != null)
{
strQuery = Request.QueryString["id"].ToString();
}
if (!IsPostBack)
{
Call_Database PageDB = new Call_Database();
//Loads AdvBoard Table
RepeaterNum1.DataSource = PageDB.AdvBoard;
RepeaterNum1.DataBind();
//Loads ElecBoard Table
RepeaterNum2.DataSource = PageDB.ElecBoard;
RepeaterNum2.DataBind();
}
}
//PICK Data to GOTO
protected void GOTO_Click(object sender, EventArgs e)
{
if (LeadershipDisplay.Items.FindByValue("Scholarships").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum1.DataSource = set.dbScholarships;
RepeaterNum1.DataBind();
ScholarshipsTableShow.Visible = true;
FoundersTableShow.Visible = false;
SocietyTableShow.Visible = false;
SubmitDiv.Visible = true;
SortShow.Visible = true;
EstablishedShow.Visible = true;
StatusShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbScholarships;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("Founders").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum2.DataSource = set.dbFounders;
RepeaterNum2.DataBind();
ScholarshipsTableShow.Visible = false;
FoundersTableShow.Visible = true;
SocietyTableShow.Visible = false;
SubmitDiv.Visible = true;
SortShow.Visible = false;
EstablishedShow.Visible = false;
StatusShow.Visible = true;
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbFounders;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CornerstoneTab").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbCornerstone;
RepeaterNum3.DataBind();
ScholarshipsTableShow.Visible = false;
FoundersTableShow.Visible = false;
SocietyTableShow.Visible = true;
SubmitDiv.Visible = true;
SortShow.Visible = false;
EstablishedShow.Visible = false;
StatusShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = set.dbCornerstone;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("RoundtableTab").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbRoundtable;
RepeaterNum3.DataBind();
ScholarshipsTableShow.Visible = false;
FoundersTableShow.Visible = false;
SocietyTableShow.Visible = true;
SubmitDiv.Visible = true;
SortShow.Visible = false;
EstablishedShow.Visible = false;
StatusShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = set.dbRoundtable;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("PresidentsTab").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbPresidentsTab;
RepeaterNum3.DataBind();
ScholarshipsTableShow.Visible = false;
FoundersTableShow.Visible = false;
SocietyTableShow.Visible = true;
SubmitDiv.Visible = true;
SortShow.Visible = false;
EstablishedShow.Visible = false;
StatusShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = set.dbPresidentsTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("QuadrangleTab").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbQuadrangleTab;
RepeaterNum3.DataBind();
ScholarshipsTableShow.Visible = false;
FoundersTableShow.Visible = false;
SocietyTableShow.Visible = true;
SubmitDiv.Visible = true;
SortShow.Visible = false;
EstablishedShow.Visible = false;
StatusShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = set.dbQuadrangleTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlueGoldTab").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbBlueGoldTab;
RepeaterNum3.DataBind();
ScholarshipsTableShow.Visible = false;
FoundersTableShow.Visible = false;
SocietyTableShow.Visible = true;
SubmitDiv.Visible = true;
SortShow.Visible = false;
EstablishedShow.Visible = false;
StatusShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = set.dbBlueGoldTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CenturyTab").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbCenturyTab;
RepeaterNum3.DataBind();
ScholarshipsTableShow.Visible = false;
FoundersTableShow.Visible = false;
SocietyTableShow.Visible = true;
SubmitDiv.Visible = true;
SortShow.Visible = false;
EstablishedShow.Visible = false;
StatusShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = set.dbCenturyTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("OtherDonorsTab").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbOtherDonorsTab;
RepeaterNum3.DataBind();
ScholarshipsTableShow.Visible = false;
FoundersTableShow.Visible = false;
SocietyTableShow.Visible = true;
SubmitDiv.Visible = true;
SortShow.Visible = false;
EstablishedShow.Visible = false;
StatusShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = set.dbOtherDonorsTab;
RepeaterNum3.DataBind();
}
}
//INSERT data into Leadership Tables
protected void SubButton_Click(object sender, EventArgs e)
{
Call_Database callDB = new Call_Database();
if (LeadershipDisplay.Items.FindByValue("AdvBoard").Selected == true)
{
string Action = "AdvBoardINSERT";
callDB.FormINSERT(Action, txtName.Text, txtStatus.Text, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.AdvBoard;
RepeaterNum1.DataBind();
}
if (LeadershipDisplay.Items.FindByValue("ElecBoard").Selected == true)
{
string Action = "ElecBoardINSERT";
callDB.FormINSERT(Action, txtName.Text, txtYear.Text, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.ElecBoard;
RepeaterNum2.DataBind();
}
}
//INSERT DATA into MAP Tables
protected void SubButton_Click(object sender, EventArgs e)
{
Call_Database callDB = new Call_Database();
if (LeadershipDisplay.Items.FindByValue("OutdoorsInfo").Selected == true)
{
string Action = "OutdoorsInfoINSERT";
callDB.FormINSERT(Action, txtLocation.Text, txtName.Text, txtArea.Text, txtPlaque.Text, txtDedication.Text, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbOutdoors;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ChapelInfo").Selected == true)
{
string Action = "ChapelInfoINSERT";
float ChapelFloat = float.Parse((OrderShow.FindControl("txtOrder") as TextBox).Text);
callDB.FormINSERT(Action, txtLevel.Text, txtPlaque.Text, txtSort.Text, null, null, 0, 0, 0, ChapelFloat);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbChapel;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CommonsInfo").Selected == true)
{
string Action = "CommonsInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCommons;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FisherHallInfo").Selected == true)
{
string Action = "FisherHallInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFisherHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FitnessCenterInfo").Selected == true)
{
string Action = "FitnessCenterInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFitnessCenter;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("LibraryInfo").Selected == true)
{
string Action = "LibraryInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbLibrary;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ResHallInfo").Selected == true)
{
string Action = "ResHallInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbResidence;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("SwartsHallInfo").Selected == true)
{
string Action = "SwartsHallInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbSwartsHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlaisdellHallInfo").Selected == true)
{
string Action = "BlaisdellHallInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlaisdellHall;
RepeaterNum3.DataBind();
}
}
//UPDATE DATA from TABLES
protected void OnUpdate_Click(object sender, EventArgs e)
{
Call_Database updateEntry = new Call_Database();
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
if (LeadershipDisplay.Items.FindByValue("OutdoorsInfo").Selected == true)
{
string Action = "OutdoorsInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditLocation = (item.FindControl("EditLocation") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditArea = (item.FindControl("EditArea") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDedication = (item.FindControl("EditDedication") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditLocation, EditName, EditArea, EditPlaque, EditDedication, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbOutdoors;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ChapelInfo").Selected == true)
{
string Action = "ChapelInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
float EditOrder = float.Parse((OrderShow.FindControl("EditOrder") as TextBox).Text);
string EditLevel = (item.FindControl("EditLevel") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditSort = (item.FindControl("EditSort") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditLevel, EditPlaque, EditSort, null, null, updateId, 0, 0, EditOrder);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbChapel;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CommonsInfo").Selected == true)
{
string Action = "CommonsInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCommons;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FisherHallInfo").Selected == true)
{
string Action = "FisherHallInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFisherHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FitnessCenterInfo").Selected == true)
{
string Action = "FitnessCenterInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFitnessCenter;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("LibraryInfo").Selected == true)
{
string Action = "LibraryInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbLibrary;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ResHallInfo").Selected == true)
{
string Action = "ResHallInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbResidence;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("SwartsHallInfo").Selected == true)
{
string Action = "SwartsHallInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbSwartsHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlaisdellHallInfo").Selected == true)
{
string Action = "BlaisdellHallInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlaisdellHall;
RepeaterNum3.DataBind();
}
}
//DELETE Data from Recognition Tables
protected void DeleteLink_Click(object sender, EventArgs e)
{
Call_Database deleteEntry = new Call_Database();
if (LeadershipDisplay.Items.FindByValue("Scholarships").Selected == true)
{
string Action = "ScholarshipsDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbScholarships;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("Founders").Selected == true)
{
string Action = "FoundersDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbFounders;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CornerstoneTab").Selected == true)
{
string Action = "CornerstoneTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCornerstone;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("RoundtableTab").Selected == true)
{
string Action = "RoundtableTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbRoundtable;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("PresidentsTab").Selected == true)
{
string Action = "PresidentsTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbPresidentsTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("QuadrangleTab").Selected == true)
{
string Action = "QuadrangleTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbQuadrangleTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlueGoldTab").Selected == true)
{
string Action = "BlueGoldTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlueGoldTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CenturyTab").Selected == true)
{
string Action = "CenturyTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCenturyTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("OtherDonorsTab").Selected == true)
{
string Action = "OtherDonorsTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbOtherDonorsTab;
RepeaterNum3.DataBind();
}
}
//PICK Data with GOTO
protected void GOTO_Click(object sender, EventArgs e)
{
if (LeadershipDisplay.Items.FindByValue("OutdoorsInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum1.DataSource = set.dbOutdoors;
RepeaterNum1.DataBind();
OutdoorsTableShow.Visible = true;
ChapelTableShow.Visible = false;
MapTableShow.Visible = false;
SubmitDiv.Visible = true;
PlaqueShow.Visible = true;
LocationShow.Visible = true;
NameShow.Visible = true;
AreaShow.Visible = true;
DedicationShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbOutdoors;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ChapelInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum2.DataSource = set.dbChapel;
RepeaterNum2.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = true;
MapTableShow.Visible = false;
SubmitDiv.Visible = true;
LevelShow.Visible = true;
PlaqueShow.Visible = true;
SortShow.Visible = true;
OrderShow.Visible = true;
LocationShow.Visible = false;
NameShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbChapel;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CommonsInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbCommons;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCommons;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FisherHallInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbFisherHall;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFisherHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FitnessCenterInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbFitnessCenter;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFitnessCenter;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("LibraryInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbLibrary;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbLibrary;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ResHallInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbResidence;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbResidence;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("SwartsHallInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbSwartsHall;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbSwartsHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlaisdellHallInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbBlaisdellHall;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlaisdellHall;
RepeaterNum3.DataBind();
}
}
//UPDATE DATA from TABLES
protected void OnUpdate_Click(object sender, EventArgs e)
{
Call_Database updateEntry = new Call_Database();
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
if (LeadershipDisplay.Items.FindByValue("OutdoorsInfo").Selected == true)
{
string Action = "OutdoorsInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditLocation = (item.FindControl("EditLocation") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditArea = (item.FindControl("EditArea") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDedication = (item.FindControl("EditDedication") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditLocation, EditName, EditArea, EditPlaque, EditDedication, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbOutdoors;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ChapelInfo").Selected == true)
{
string Action = "ChapelInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
float EditOrder = float.Parse((OrderShow.FindControl("EditOrder") as TextBox).Text);
string EditLevel = (item.FindControl("EditLevel") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditSort = (item.FindControl("EditSort") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditLevel, EditPlaque, EditSort, null, null, updateId, 0, 0, EditOrder);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbChapel;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CommonsInfo").Selected == true)
{
string Action = "CommonsInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCommons;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FisherHallInfo").Selected == true)
{
string Action = "FisherHallInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFisherHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FitnessCenterInfo").Selected == true)
{
string Action = "FitnessCenterInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFitnessCenter;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("LibraryInfo").Selected == true)
{
string Action = "LibraryInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbLibrary;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ResHallInfo").Selected == true)
{
string Action = "ResHallInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbResidence;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("SwartsHallInfo").Selected == true)
{
string Action = "SwartsHallInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbSwartsHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlaisdellHallInfo").Selected == true)
{
string Action = "BlaisdellHallInfoUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditRoomId = (item.FindControl("EditRoomId") as TextBox).Text;
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditPlaque = (item.FindControl("EditPlaque") as TextBox).Text;
string EditDate = (item.FindControl("EditDate") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditRoomId, EditName, EditPlaque, EditDate, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlaisdellHall;
RepeaterNum3.DataBind();
}
}
//INSERT DATA into MAP Tables
protected void SubButton_Click(object sender, EventArgs e)
{
Call_Database callDB = new Call_Database();
if (LeadershipDisplay.Items.FindByValue("OutdoorsInfo").Selected == true)
{
string Action = "OutdoorsInfoINSERT";
callDB.FormINSERT(Action, txtLocation.Text, txtName.Text, txtArea.Text, txtPlaque.Text, txtDedication.Text, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbOutdoors;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ChapelInfo").Selected == true)
{
string Action = "ChapelInfoINSERT";
float ChapelFloat = float.Parse((OrderShow.FindControl("txtOrder") as TextBox).Text);
callDB.FormINSERT(Action, txtLevel.Text, txtPlaque.Text, txtSort.Text, null, null, 0, 0, 0, ChapelFloat);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbChapel;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CommonsInfo").Selected == true)
{
string Action = "CommonsInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCommons;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FisherHallInfo").Selected == true)
{
string Action = "FisherHallInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFisherHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FitnessCenterInfo").Selected == true)
{
string Action = "FitnessCenterInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFitnessCenter;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("LibraryInfo").Selected == true)
{
string Action = "LibraryInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbLibrary;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ResHallInfo").Selected == true)
{
string Action = "ResHallInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbResidence;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("SwartsHallInfo").Selected == true)
{
string Action = "SwartsHallInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbSwartsHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlaisdellHallInfo").Selected == true)
{
string Action = "BlaisdellHallInfoINSERT";
callDB.FormINSERT(Action, txtRoomId.Text, txtName.Text, txtPlaque.Text, txtDate.Text, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlaisdellHall;
RepeaterNum3.DataBind();
}
}
//DELETE Data from Recognition Tables
protected void DeleteLink_Click(object sender, EventArgs e)
{
Call_Database deleteEntry = new Call_Database();
if (LeadershipDisplay.Items.FindByValue("Scholarships").Selected == true)
{
string Action = "ScholarshipsDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbScholarships;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("Founders").Selected == true)
{
string Action = "FoundersDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbFounders;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CornerstoneTab").Selected == true)
{
string Action = "CornerstoneTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCornerstone;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("RoundtableTab").Selected == true)
{
string Action = "RoundtableTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbRoundtable;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("PresidentsTab").Selected == true)
{
string Action = "PresidentsTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbPresidentsTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("QuadrangleTab").Selected == true)
{
string Action = "QuadrangleTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbQuadrangleTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlueGoldTab").Selected == true)
{
string Action = "BlueGoldTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlueGoldTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CenturyTab").Selected == true)
{
string Action = "CenturyTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCenturyTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("OtherDonorsTab").Selected == true)
{
string Action = "OtherDonorsTabDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbOtherDonorsTab;
RepeaterNum3.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["id"] != null)
{
strQuery = Request.QueryString["id"].ToString();
}
if (!IsPostBack)
{
Call_Database PageDB = new Call_Database();
//Loads Scholarships Table
RepeaterNum1.DataSource = PageDB.dbScholarships;
RepeaterNum1.DataBind();
//Loads Founders Table
RepeaterNum2.DataSource = PageDB.dbFounders;
RepeaterNum2.DataBind();
//Loads Society Tables
RepeaterNum3.DataSource = PageDB.dbCornerstone;
RepeaterNum3.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["id"] != null)
{
strQuery = Request.QueryString["id"].ToString();
}
if (!IsPostBack)
{
Call_Database PageDB = new Call_Database();
RepeaterNum.DataSource = PageDB.dbDonors;
RepeaterNum.DataBind();
}
}
protected void UPLOADData_Click(object sender, EventArgs e)
{
//Recognition Upload
if (RecognitionUpload.Visible == true)
{
if (RecognitionUpload.Items.FindByValue("Scholarships").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "Scholarships");
}
else if (RecognitionUpload.Items.FindByValue("Founders").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "Founders");
}
else if (RecognitionUpload.Items.FindByValue("CornerstoneTab").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "CornerstoneTab");
}
else if (RecognitionUpload.Items.FindByValue("RoundtableTab").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "RoundtableTab");
}
else if (RecognitionUpload.Items.FindByValue("PresidentsTab").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "PresidentsTab");
}
else if (RecognitionUpload.Items.FindByValue("QuadrangleTab").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "QuadrangleTab");
}
else if (RecognitionUpload.Items.FindByValue("BlueGoldTab").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "BlueGoldTab");
}
else if (RecognitionUpload.Items.FindByValue("CenturyTab").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "CenturyTab");
}
else if (RecognitionUpload.Items.FindByValue("OtherDonorsTab").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "OtherDonorsTab");
}
//Recognition End
}
//Leadership Here
else if (LeadershipUpload.Visible == true)
{
if (LeadershipUpload.Items.FindByValue("AdvBoard").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "AdvBoard");
}
else if (LeadershipUpload.Items.FindByValue("ElecBoard").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "ElecBoard");
}
}
//Leadership END
//MAP START
else if (MapDataUpload.Visible == true)
{
if (MapDataUpload.Items.FindByValue("OutdoorsInfo").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "OutdoorsInfo");
}
else if (MapDataUpload.Items.FindByValue("ChapelInfo").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "ChapelInfo");
}
else if (MapDataUpload.Items.FindByValue("CommonsInfo").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "CommonsInfo");
}
else if (MapDataUpload.Items.FindByValue("FisherHallInfo").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "FisherHallInfo");
}
else if (MapDataUpload.Items.FindByValue("FitnessCenterInfo").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "FitnessCenterInfo");
}
else if (MapDataUpload.Items.FindByValue("LibraryInfo").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "LibraryInfo");
}
else if (MapDataUpload.Items.FindByValue("ResHallInfo").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "ResHallInfo");
}
else if (MapDataUpload.Items.FindByValue("SwartsHallInfo").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "SwartsHallInfo");
}
else if (MapDataUpload.Items.FindByValue("BlaisdellHallInfo").Selected == true)
{
Call_Database conn = new Call_Database();
conn.Connect(FileUploadID, "BlaisdellHallInfo");
}
}
//MAP END
}
//INSERTS datafields into Database Table
protected void SubButton_Click(object sender, EventArgs e)
{
Call_Database callDB = new Call_Database();
if (ImageUpload.HasFile)
{
if (CheckFileType(ImageUpload.FileName))
{
string strPath = "../Images/dbImages/" + ImageUpload.FileName;
ImageUpload.SaveAs(MapPath(strPath));
}
}
if (NameBox.Text != "" && txtProfile.Text != "")
{
string Action = "DonorsINSERT";
callDB.FormINSERT(Action, NameBox.Text, ImageUpload.FileName, txtProfile.Text, null, null, 0, 0, 0, 0);
NameBox.Text = String.Empty;
txtProfile.Text = String.Empty;
Call_Database update = new Call_Database();
RepeaterNum.DataSource = update.dbDonors;
RepeaterNum.DataBind();
}
}
//DELETE Data from Tables
protected void DeleteLink_Click(object sender, EventArgs e)
{
Call_Database deleteEntry = new Call_Database();
if (LeadershipDisplay.Items.FindByValue("OutdoorsInfo").Selected == true)
{
string Action = "OutdoorsInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbOutdoors;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ChapelInfo").Selected == true)
{
string Action = "ChapelInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbChapel;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CommonsInfo").Selected == true)
{
string Action = "CommonsInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCommons;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FisherHallInfo").Selected == true)
{
string Action = "FisherHallInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFisherHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FitnessCenterInfo").Selected == true)
{
string Action = "FitnessCenterInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFitnessCenter;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("LibraryInfo").Selected == true)
{
string Action = "LibraryInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbLibrary;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ResHallInfo").Selected == true)
{
string Action = "ResHallInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbResidence;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("SwartsHallInfo").Selected == true)
{
string Action = "SwartsHallInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbSwartsHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlaisdellHallInfo").Selected == true)
{
string Action = "BlaisdellHallInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlaisdellHall;
RepeaterNum3.DataBind();
}
}
//DELETE Data from Tables
protected void DeleteLink_Click(object sender, EventArgs e)
{
Call_Database deleteEntry = new Call_Database();
if (LeadershipDisplay.Items.FindByValue("OutdoorsInfo").Selected == true)
{
string Action = "OutdoorsInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbOutdoors;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ChapelInfo").Selected == true)
{
string Action = "ChapelInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbChapel;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CommonsInfo").Selected == true)
{
string Action = "CommonsInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCommons;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FisherHallInfo").Selected == true)
{
string Action = "FisherHallInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFisherHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FitnessCenterInfo").Selected == true)
{
string Action = "FitnessCenterInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFitnessCenter;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("LibraryInfo").Selected == true)
{
string Action = "LibraryInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbLibrary;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ResHallInfo").Selected == true)
{
string Action = "ResHallInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbResidence;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("SwartsHallInfo").Selected == true)
{
string Action = "SwartsHallInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbSwartsHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlaisdellHallInfo").Selected == true)
{
string Action = "BlaisdellHallInfoDELETE";
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int deleteId = int.Parse((item.FindControl("idLabel") as Label).Text);
deleteEntry.Delete(deleteId, Action);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlaisdellHall;
RepeaterNum3.DataBind();
}
}
//INSERT Data into RECOGNITION TABLES
protected void SubButton_Click(object sender, EventArgs e)
{
Call_Database callDB = new Call_Database();
if (LeadershipDisplay.Items.FindByValue("Scholarships").Selected == true)
{
string Action = "ScholarshipsINSERT";
callDB.FormINSERT(Action, txtSort.Text, txtName.Text, txtEstablished.Text, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbScholarships;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("Founders").Selected == true)
{
string Action = "FoundersINSERT";
callDB.FormINSERT(Action, txtName.Text, txtStatus.Text, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbFounders;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CornerstoneTab").Selected == true)
{
string Action = "CornerstoneTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCornerstone;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("RoundtableTab").Selected == true)
{
string Action = "RoundtableTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbRoundtable;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("PresidentsTab").Selected == true)
{
string Action = "PresidentsTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbPresidentsTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("QuadrangleTab").Selected == true)
{
string Action = "QuadrangleTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbQuadrangleTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlueGoldTab").Selected == true)
{
string Action = "BlueGoldTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlueGoldTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CenturyTab").Selected == true)
{
string Action = "CenturyTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCenturyTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("OtherDonorsTab").Selected == true)
{
string Action = "OtherDonorsTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbOtherDonorsTab;
RepeaterNum3.DataBind();
}
}
//UPDATE Data to Recognition Tables
protected void OnUpdate_Click(object sender, EventArgs e)
{
Call_Database updateEntry = new Call_Database();
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
if (LeadershipDisplay.Items.FindByValue("Scholarships").Selected == true)
{
string Action = "ScholarshipsUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditSort = (item.FindControl("EditSort") as TextBox).Text;
string EditEstablished = (item.FindControl("EditEstablished") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditSort, EditName, EditEstablished, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbScholarships;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("Founders").Selected == true)
{
string Action = "FoundersUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditStatus = (item.FindControl("EditStatus") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, EditStatus, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbFounders;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CornerstoneTab").Selected == true)
{
string Action = "CornerstoneTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCornerstone;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("RoundtableTab").Selected == true)
{
string Action = "RoundtableTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbRoundtable;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("PresidentsTab").Selected == true)
{
string Action = "PresidentsTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbPresidentsTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("QuadrangleTab").Selected == true)
{
string Action = "QuadrangleTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbQuadrangleTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlueGoldTab").Selected == true)
{
string Action = "BlueGoldTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlueGoldTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CenturyTab").Selected == true)
{
string Action = "CenturyTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCenturyTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("OtherDonorsTab").Selected == true)
{
string Action = "OtherDonorsTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbOtherDonorsTab;
RepeaterNum3.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
string strVideo = "";
if (Request.QueryString["Id"] != null)
{
strQuery = Request.QueryString["Id"].ToString();
}
Call_Database FoundersDB = new Call_Database();
Repeater1.DataSource = FoundersDB.dbFounders;
Repeater1.DataBind();
Call_Database VideoDB = new Call_Database();
strVideo = VideoDB.VideoLOAD();
urIframe.Attributes.Add("src", strVideo.ToString());
Call_Database CornerstoneDB = new Call_Database();
Repeater2.DataSource = CornerstoneDB.dbCornerstone;
Repeater2.DataBind();
Call_Database ScholarshipsDB = new Call_Database();
Repeater3.DataSource = ScholarshipsDB.dbScholarships;
Repeater3.DataBind();
Call_Database RoundtableDB = new Call_Database();
Repeater4.DataSource = RoundtableDB.dbRoundtable;
Repeater4.DataBind();
Call_Database PresidentsTabDB = new Call_Database();
Repeater5.DataSource = PresidentsTabDB.dbPresidentsTab;
Repeater5.DataBind();
Call_Database QuadrangleTabDB = new Call_Database();
Repeater6.DataSource = QuadrangleTabDB.dbQuadrangleTab;
Repeater6.DataBind();
Call_Database BlueGoldTabDB = new Call_Database();
Repeater7.DataSource = BlueGoldTabDB.dbBlueGoldTab;
Repeater7.DataBind();
Call_Database CenturyTabDB = new Call_Database();
Repeater8.DataSource = CenturyTabDB.dbCenturyTab;
Repeater8.DataBind();
Call_Database OtherDonorsTabDB = new Call_Database();
Repeater9.DataSource = OtherDonorsTabDB.dbOtherDonorsTab;
Repeater9.DataBind();
}
//UPDATE Data to Recognition Tables
protected void OnUpdate_Click(object sender, EventArgs e)
{
Call_Database updateEntry = new Call_Database();
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
if (LeadershipDisplay.Items.FindByValue("Scholarships").Selected == true)
{
string Action = "ScholarshipsUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditSort = (item.FindControl("EditSort") as TextBox).Text;
string EditEstablished = (item.FindControl("EditEstablished") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditSort, EditName, EditEstablished, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbScholarships;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("Founders").Selected == true)
{
string Action = "FoundersUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
string EditStatus = (item.FindControl("EditStatus") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, EditStatus, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbFounders;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CornerstoneTab").Selected == true)
{
string Action = "CornerstoneTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCornerstone;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("RoundtableTab").Selected == true)
{
string Action = "RoundtableTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbRoundtable;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("PresidentsTab").Selected == true)
{
string Action = "PresidentsTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbPresidentsTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("QuadrangleTab").Selected == true)
{
string Action = "QuadrangleTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbQuadrangleTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlueGoldTab").Selected == true)
{
string Action = "BlueGoldTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlueGoldTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CenturyTab").Selected == true)
{
string Action = "CenturyTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCenturyTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("OtherDonorsTab").Selected == true)
{
string Action = "OtherDonorsTabUPDATE";
int updateId = int.Parse((item.FindControl("idLabel") as Label).Text);
string EditName = (item.FindControl("EditName") as TextBox).Text;
updateEntry.FormUPDATE(Action, EditName, null, null, null, null, updateId, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbOtherDonorsTab;
RepeaterNum3.DataBind();
}
}
//PICK Data with GOTO
protected void GOTO_Click(object sender, EventArgs e)
{
if (LeadershipDisplay.Items.FindByValue("OutdoorsInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum1.DataSource = set.dbOutdoors;
RepeaterNum1.DataBind();
OutdoorsTableShow.Visible = true;
ChapelTableShow.Visible = false;
MapTableShow.Visible = false;
SubmitDiv.Visible = true;
PlaqueShow.Visible = true;
LocationShow.Visible = true;
NameShow.Visible = true;
AreaShow.Visible = true;
DedicationShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbOutdoors;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ChapelInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum2.DataSource = set.dbChapel;
RepeaterNum2.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = true;
MapTableShow.Visible = false;
SubmitDiv.Visible = true;
LevelShow.Visible = true;
PlaqueShow.Visible = true;
SortShow.Visible = true;
OrderShow.Visible = true;
LocationShow.Visible = false;
NameShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbChapel;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CommonsInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbCommons;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCommons;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FisherHallInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbFisherHall;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFisherHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("FitnessCenterInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbFitnessCenter;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbFitnessCenter;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("LibraryInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbLibrary;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbLibrary;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("ResHallInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbResidence;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbResidence;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("SwartsHallInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbSwartsHall;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbSwartsHall;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlaisdellHallInfo").Selected == true)
{
Call_Database set = new Call_Database();
RepeaterNum3.DataSource = set.dbBlaisdellHall;
RepeaterNum3.DataBind();
OutdoorsTableShow.Visible = false;
ChapelTableShow.Visible = false;
MapTableShow.Visible = true;
SubmitDiv.Visible = true;
RoomIdShow.Visible = true;
NameShow.Visible = true;
PlaqueShow.Visible = true;
DateShow.Visible = true;
LevelShow.Visible = false;
SortShow.Visible = false;
OrderShow.Visible = false;
LocationShow.Visible = false;
AreaShow.Visible = false;
DedicationShow.Visible = false;
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlaisdellHall;
RepeaterNum3.DataBind();
}
}
//INSERT Data into RECOGNITION TABLES
protected void SubButton_Click(object sender, EventArgs e)
{
Call_Database callDB = new Call_Database();
if (LeadershipDisplay.Items.FindByValue("Scholarships").Selected == true)
{
string Action = "ScholarshipsINSERT";
callDB.FormINSERT(Action, txtSort.Text, txtName.Text, txtEstablished.Text, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum1.DataSource = update.dbScholarships;
RepeaterNum1.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("Founders").Selected == true)
{
string Action = "FoundersINSERT";
callDB.FormINSERT(Action, txtName.Text, txtStatus.Text, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum2.DataSource = update.dbFounders;
RepeaterNum2.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CornerstoneTab").Selected == true)
{
string Action = "CornerstoneTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCornerstone;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("RoundtableTab").Selected == true)
{
string Action = "RoundtableTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbRoundtable;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("PresidentsTab").Selected == true)
{
string Action = "PresidentsTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbPresidentsTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("QuadrangleTab").Selected == true)
{
string Action = "QuadrangleTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbQuadrangleTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("BlueGoldTab").Selected == true)
{
string Action = "BlueGoldTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbBlueGoldTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("CenturyTab").Selected == true)
{
string Action = "CenturyTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbCenturyTab;
RepeaterNum3.DataBind();
}
else if (LeadershipDisplay.Items.FindByValue("OtherDonorsTab").Selected == true)
{
string Action = "OtherDonorsTabINSERT";
callDB.FormINSERT(Action, txtName.Text, null, null, null, null, 0, 0, 0, 0);
Call_Database update = new Call_Database();
RepeaterNum3.DataSource = update.dbOtherDonorsTab;
RepeaterNum3.DataBind();
}
}
