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