//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 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); } } }
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) { 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(); }
//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 classDBDonors = new Call_Database(); Repeater2.DataSource = classDBDonors.dbDonors; Repeater2.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); } } }
//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(); } }
//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 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(); } }
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 }
//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(); }