//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; 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 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(); }
//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(); } }
//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(); } }