private void locCB_SelectedIndexChanged(object sender, EventArgs e)
{
OracleCommand loc = new OracleCommand();
loc.Connection = OracleHelper.getConnection();
loc.CommandText = @"select date_, start_time, end_time
from locations_schedule
where status = 'Available'
and l_name =:loc";
loc.Parameters.Add("loc", locCB.SelectedItem.ToString());
loc.CommandType = CommandType.Text;
OracleDataReader locDR = loc.ExecuteReader();
dates = new ArrayList();
startTimes = new ArrayList();
endTimes = new ArrayList();
timeCB.Items.Clear();
timeCB.Text = "";
while (locDR.Read())
{
timeCB.Items.Add(locDR[0] + ": " + locDR[1] + " - " + locDR[2]);
dates.Add(locDR[0]);
startTimes.Add(locDR[1]);
endTimes.Add(locDR[2]);
}
locDR.Close();
}
private void button1_Click(object sender, EventArgs e)
{
OracleCommand reqaccept = new OracleCommand();
reqaccept.Connection = OracleHelper.getConnection();
reqaccept.CommandType = CommandType.Text;
reqaccept.CommandText = @"update EVENT set REQUEST_STATUS ='accepted'
where title=:event_title";
reqaccept.Parameters.Add("event_title", comboBox1.SelectedItem.ToString());
reqaccept.ExecuteNonQuery();
reqaccept = new OracleCommand();
reqaccept.Connection = OracleHelper.getConnection();
reqaccept.CommandType = CommandType.Text;
reqaccept.CommandText = @"update Locations_schedule set STATUS ='Busy'
where l_name=(select l_name from event where title=:event_title)";
reqaccept.Parameters.Add("event_title", comboBox1.SelectedItem.ToString());
int k;
k = reqaccept.ExecuteNonQuery();
if (k != -1)
{
MessageBox.Show("Event is accepted successfully");
comboBox1.Text = "";
textBox2.Clear();
textBox3.Clear();
textBox4.Clear();
textBox5.Clear();
comboBox1.Items.RemoveAt(comboBox1.SelectedIndex);
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
OracleCommand Event = new OracleCommand();
Event.Connection = OracleHelper.getConnection();
Event.CommandType = CommandType.Text;
Event.CommandText = @"select event.title,event.capacity,event.description,event.l_name,event.ls_start_time,event.ls_date, department.d_title, locations_schedule.end_time
from event , department, locations_schedule
where event.d_id = department.d_id
and event.ls_start_time= locations_schedule.start_time
and event.ls_date = locations_schedule.date_
and event.l_name = locations_schedule.l_name
and title=:combobox";
Event.Parameters.Add("combobox", comboBox1.SelectedItem.ToString());
OracleDataReader or = Event.ExecuteReader();
while (or.Read())
{
textBox2.Text = or[1].ToString();
textBox3.Text = or[2].ToString();
textBox4.Text = or[3].ToString();
textBox5.Text = or[4].ToString();
textBox6.Text = or[5].ToString();
}
or.Close();
}
private void loginBtn_Click(object sender, EventArgs e)
{
OracleCommand checkPass = new OracleCommand();
checkPass.Connection = OracleHelper.getConnection();
checkPass.CommandType = CommandType.StoredProcedure;
checkPass.CommandText = "Check_Password";
checkPass.Parameters.Add("usr", userNameText.Text);
checkPass.Parameters.Add("p", passwordTxt.Text);
checkPass.Parameters.Add("ret", OracleDbType.Int32, ParameterDirection.Output);
checkPass.ExecuteNonQuery();
int ret = int.Parse(checkPass.Parameters["ret"].Value.ToString());
if (ret == LoginForm.WRONG_PASS)
{
MessageBox.Show("Wrong Password!", "Warning");
passwordTxt.Clear();
}
else if (ret == LoginForm.WRONG_USERNAME)
{
MessageBox.Show("Username not found!", "Warning");
passwordTxt.Clear();
userNameText.Clear();
}
else if (ret == LoginForm.SUCCESS)
{
OracleHelper.LoggedIn.user_name = userNameText.Text;
this.Hide();
UserHome uh = new UserHome();
uh.Closed += (s, args) => this.Close();
uh.Show();
passwordTxt.Clear();
userNameText.Clear();
}
}
private void AdminHome_Load(object sender, EventArgs e)
{
cmd = new OracleCommand();
cmd.Connection = OracleHelper.getConnection();
//Combobox
cmd.CommandText = @"Select D_Title
from Department";
cmd.CommandType = CommandType.Text;
dr = cmd.ExecuteReader();
while (dr.Read())
{
Combo_Box_of_DEP.Items.Add(dr[0].ToString());
}
dr.Close();
//data_grid view
cmd.CommandText = @"select Title,Capacity,Description,
Request_status,L_Name,Ls_Start_time,Ls_date
from event";
cmd.CommandType = CommandType.Text;
dr = cmd.ExecuteReader();
row = dt.NewRow();
while (dr.Read())
{
row["Title"] = dr[0].ToString();
row["Description"] = dr[2].ToString();
row["Capacity"] = dr[1].ToString();
row["Request Stautue"] = dr[3].ToString();
row["Start Time"] = dr[5].ToString();
row["Date"] = dr[6].ToString();
row["Location Name"] = dr[4].ToString();
dt.Rows.Add(row);
row = dt.NewRow();
}
dr.Close();
int num;
int counter = 0;
foreach (DataRow drow in dt.Rows)
{
num = dataGridView1.Rows.Add();
dataGridView1.Rows[num].Cells[counter].Value = drow["Title"].ToString();
counter++;
dataGridView1.Rows[num].Cells[counter].Value = drow["Description"].ToString();
counter++;
dataGridView1.Rows[num].Cells[counter].Value = drow["Capacity"].ToString();
counter++;
dataGridView1.Rows[num].Cells[counter].Value = drow["Request Stautue"].ToString();
counter++;
dataGridView1.Rows[num].Cells[counter].Value = drow["start time"].ToString();
counter++;
dataGridView1.Rows[num].Cells[counter].Value = drow["Date"].ToString();
counter++;
dataGridView1.Rows[num].Cells[counter].Value = drow["Location Name"].ToString();
counter++;
counter = 0;
}
}
private void editBtn_Click(object sender, EventArgs e)
{
if (eventsCLB.CheckedItems.Count > 1)
{
MessageBox.Show("You cannot edit more than 1 event at a time!", "Warning");
return;
}
listPanel[1].BringToFront();
Event ev = (Event)events[eventsCLB.SelectedIndex];
#region location combo box
OracleCommand loc = new OracleCommand();
loc.Connection = OracleHelper.getConnection();
loc.CommandText = "select l_name from location";
loc.CommandType = CommandType.Text;
OracleDataReader locDR = loc.ExecuteReader();
evLocIndx = 0;
while (locDR.Read())
{
locCB.Items.Add(locDR[0].ToString());
if (ev.location.CompareTo(locDR[0].ToString()) == 0)
{
evLocIndx = locCB.Items.Count - 1;
}
}
locDR.Close();
#endregion
#region depCB
dids = new ArrayList();
OracleCommand dep = new OracleCommand();
dep.Connection = OracleHelper.getConnection();
dep.CommandText = "select * from department";
dep.CommandType = CommandType.Text;
OracleDataReader depDR = dep.ExecuteReader();
evDepIndx = 0;
while (depDR.Read())
{
depCB.Items.Add(depDR[1]);
dids.Add(depDR[0]);
if (ev.department.CompareTo(depDR[1].ToString()) == 0)
{
evDepIndx = depCB.Items.Count - 1;
}
}
depDR.Close();
#endregion
titleTxt.Text = ev.title.ToString();
descriptionTxt.Text = ev.description.ToString();
capTxt.Text = ev.capacity.ToString();
locCB.SelectedIndex = evLocIndx;
timeCB.Text = ev.date.ToString() + ": " + ev.start_time + " - " + ev.end_time;
depCB.SelectedIndex = evDepIndx;
}
private void locCB_SelectedIndexChanged(object sender, EventArgs e)
{
OracleCommand cap = new OracleCommand();
cap.Connection = OracleHelper.getConnection();
cap.CommandType = CommandType.StoredProcedure;
cap.CommandText = "Get_Capacity";
cap.Parameters.Add("loc", locCB.SelectedItem.ToString());
cap.Parameters.Add("cap", OracleDbType.Int32, ParameterDirection.Output);
cap.ExecuteNonQuery();
try
{
int capacity = int.Parse(cap.Parameters["cap"].Value.ToString());
int c = int.Parse(capTxt.Text);
if (c > capacity)
{
MessageBox.Show("Capacity of event must not exceed location capacity! ["
+ locCB.SelectedItem.ToString() + " " + capacity + "]", "Warning");
}
}catch (Exception ex)
{
MessageBox.Show("Please enter number in capacity...", "Warning");
}
OracleCommand loc = new OracleCommand();
loc.Connection = OracleHelper.getConnection();
loc.CommandText = @"select date_, start_time, end_time
from locations_schedule
where status = 'Available'
and l_name =:loc";
loc.Parameters.Add("loc", locCB.SelectedItem.ToString());
loc.CommandType = CommandType.Text;
OracleDataReader locDR = loc.ExecuteReader();
dates = new ArrayList();
startTimes = new ArrayList();
endTimes = new ArrayList();
timeCB.Items.Clear();
timeCB.Text = "";
while (locDR.Read())
{
timeCB.Items.Add(locDR[0] + ": " + locDR[1] + " - " + locDR[2]);
dates.Add(locDR[0]);
startTimes.Add(locDR[1]);
endTimes.Add(locDR[2]);
}
locDR.Close();
}
private void Combo_Box_of_DEP_SelectedIndexChanged(object sender, EventArgs e)
{
cmd = new OracleCommand();
cmd.Connection = OracleHelper.getConnection();
cmd.CommandText = @"select Title,Capacity,Description,
Request_status,L_Name,Ls_Start_time,Ls_date
from event
where D_id=
(select D_id from Department where D_title =:D_Name )";
cmd.Parameters.Add("D_Name", Combo_Box_of_DEP.SelectedItem.ToString());
cmd.CommandType = CommandType.Text;
dr = cmd.ExecuteReader();
dt.Rows.Clear();
row = dt.NewRow();
while (dr.Read())
{
row["Title"] = dr[0].ToString();
row["Description"] = dr[2].ToString();
row["Capacity"] = dr[1].ToString();
row["Request Stautue"] = dr[3].ToString();
row["Start Time"] = dr[5].ToString();
row["Date"] = dr[6].ToString();
row["Location Name"] = dr[4].ToString();
dt.Rows.Add(row);
row = dt.NewRow();
}
dr.Close();
int num;
int counter = 0;
dataGridView1.Rows.Clear();
foreach (DataRow drow in dt.Rows)
{
num = dataGridView1.Rows.Add();
dataGridView1.Rows[num].Cells[counter].Value = drow["Title"].ToString();
counter++;
dataGridView1.Rows[num].Cells[counter].Value = drow["Description"].ToString();
counter++;
dataGridView1.Rows[num].Cells[counter].Value = drow["Capacity"].ToString();
counter++;
dataGridView1.Rows[num].Cells[counter].Value = drow["Request Stautue"].ToString();
counter++;
dataGridView1.Rows[num].Cells[counter].Value = drow["Date"].ToString();
counter++;
dataGridView1.Rows[num].Cells[counter].Value = drow["Location Name"].ToString();
counter++;
counter = 0;
}
}
private void createEvent_Load(object sender, EventArgs e)
{
dids = new ArrayList();
usernames = new Dictionary <string, string>();
#region location combo box
OracleCommand loc = new OracleCommand();
loc.Connection = OracleHelper.getConnection();
loc.CommandText = "select l_name from location";
loc.CommandType = CommandType.Text;
OracleDataReader locDR = loc.ExecuteReader();
while (locDR.Read())
{
locCB.Items.Add(locDR[0].ToString());
}
locDR.Close();
#endregion
#region depCB
OracleCommand dep = new OracleCommand();
dep.Connection = OracleHelper.getConnection();
dep.CommandText = "select * from department";
dep.CommandType = CommandType.Text;
depDR = dep.ExecuteReader();
while (depDR.Read())
{
depCB.Items.Add(depDR[1]);
dids.Add(depDR[0]);
}
depDR.Close();
#endregion
#region userCB
OracleCommand user = new OracleCommand();
user.Connection = OracleHelper.getConnection();
user.CommandText = "select first_name, last_name, user_name from users";
user.CommandType = CommandType.Text;
userDR = user.ExecuteReader();
while (userDR.Read())
{
if (userDR[2].ToString().CompareTo(OracleHelper.LoggedIn.user_name) == 0)
{
continue;
}
hostCLB.Items.Add(userDR[0] + " " + userDR[1]);
usernames[userDR[0] + " " + userDR[1]] = userDR[2].ToString();
}
userDR.Close();
#endregion
}
private void View_Violations_Load(object sender, EventArgs e)
{
//data load
//users_load
cmd.Connection = OracleHelper.getConnection();
cmd.CommandText = @"Select DISTINCT h.user_name
from Host h, violations v
where h.e_title= v.e_title";
cmd.CommandType = CommandType.Text;
Dr1 = cmd.ExecuteReader();
while (Dr1.Read())
{
row["User"] = Dr1[0].ToString();
dt.Rows.Add(row);
row = dt.NewRow();
}
Dr1.Close();
//number of violations
for (int i = 0; i < dt.Rows.Count; i++)
{
cmd2 = new OracleCommand();
cmd2.Connection = OracleHelper.getConnection();
cmd2.CommandText = "get_count_of_violations";
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.Add("name_", dt.Rows[i]["User"].ToString());
cmd2.Parameters.Add("count_", OracleDbType.Int32, ParameterDirection.Output);
cmd2.ExecuteNonQuery();
dt.Rows[i]["Number Of Violations"] = cmd2.Parameters["count_"].Value.ToString();
}
//data_grid_view
int count = 0;
int num;
foreach (DataRow Drow in dt.Rows)
{
num = dataGridView1.Rows.Add();
dataGridView1.Rows[num].Cells[count].Value = Drow["User"].ToString();
count++;
dataGridView1.Rows[num].Cells[count].Value = Drow["Number Of Violations"].ToString();
count = 0;
num = 0;
}
}
private void cancelBtn_Click(object sender, EventArgs e)
{
events.Clear();
eventsCLB.Items.Clear();
titleTxt.Clear();
depCB.Items.Clear();
descriptionTxt.Clear();
capTxt.Clear();
listPanel[0].BringToFront();
OracleCommand getEvents = new OracleCommand();
getEvents.Connection = OracleHelper.getConnection();
getEvents.CommandType = CommandType.StoredProcedure;
getEvents.CommandText = "GetEvents";
getEvents.Parameters.Add("ref", OracleDbType.RefCursor, ParameterDirection.Output);
getEvents.Parameters.Add("hst", OracleHelper.LoggedIn.user_name);
OracleDataReader eventsDR = getEvents.ExecuteReader();
while (eventsDR.Read())
{
Event ev = new Event();
ev.title = eventsDR[0].ToString();
ev.capacity = int.Parse(eventsDR[2].ToString());
ev.description = eventsDR[3].ToString();
ev.location = eventsDR[4].ToString();
ev.start_time = eventsDR[5].ToString();
ev.date = eventsDR[6].ToString();
ev.department = eventsDR[7].ToString();
ev.end_time = eventsDR[8].ToString();
if (eventsDR[1].ToString().CompareTo("Rejected") == 0)
{
ev.rs = RequestStatus.REJECTED;
}
else if (eventsDR[1].ToString().CompareTo("accepted") == 0)
{
ev.rs = RequestStatus.ACCEPTED;
}
else if (eventsDR[1].ToString().CompareTo("pending") == 0)
{
ev.rs = RequestStatus.PENDING;
}
eventsCLB.Items.Add(ev.title + " " + ev.rs.ToString());
events.Add(ev);
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 2)
{
cmd3 = new OracleCommand();
cmd3.Connection = OracleHelper.getConnection();
cmd3.CommandText = "select E_title from Host where user_name=:name";
int index = e.RowIndex;
cmd3.Parameters.Add("name", dt.Rows[e.RowIndex]["User"].ToString());
Dr2 = cmd3.ExecuteReader();
while (Dr2.Read())
{
cmd3 = new OracleCommand();
cmd3.Connection = OracleHelper.getConnection();
cmd3.CommandText = "Delete from Host where e_title=:name";
cmd3.Parameters.Add("name", Dr2[0].ToString());
cmd3.ExecuteNonQuery();
cmd3 = new OracleCommand();
cmd3.Connection = OracleHelper.getConnection();
cmd3.CommandText = "Delete from violations where e_title=:name";
cmd3.Parameters.Add("name", Dr2[0].ToString());
cmd3.ExecuteNonQuery();
cmd3 = new OracleCommand();
cmd3.Connection = OracleHelper.getConnection();
cmd3.CommandText = "Delete from Event where title=:name";
cmd3.Parameters.Add("name", Dr2[0].ToString());
cmd3.ExecuteNonQuery();
}
Dr2.Close();
cmd3 = new OracleCommand();
cmd3.Connection = OracleHelper.getConnection();
cmd3.CommandText = "Delete from users where user_name=:name";
cmd3.Parameters.Add("name", dt.Rows[e.RowIndex]["User"].ToString());
int r = cmd3.ExecuteNonQuery();
if (r != -1)
{
MessageBox.Show("User deleted");
dataGridView1.Rows.RemoveAt(index);
}
}
}
private void Form2_Load(object sender, EventArgs e)
{
violation.Visible = false;
arr = new ArrayList();
OracleCommand Eventreq = new OracleCommand();
Eventreq.Connection = OracleHelper.getConnection();
Eventreq.CommandType = CommandType.Text;
Eventreq.CommandText = "select TITLE from EVENT where REQUEST_STATUS='pending'";
OracleDataReader or = Eventreq.ExecuteReader();
while (or.Read())
{
comboBox1.Items.Add(or[0].ToString());
arr.Add(or[0]);
}
or.Close();
}
private void button1_Click(object sender, EventArgs e)
{
OracleCommand insert_values = new OracleCommand();
insert_values.Connection = OracleHelper.getConnection();
insert_values.CommandType = CommandType.Text;
insert_values.CommandText = "insert into users values(: FName, :LName, :Username , :TemporaryPassword, :Department,:Job, :Email) ";
insert_values.Parameters.Add("FName", textBox1.Text);
insert_values.Parameters.Add("LName", textBox2.Text);
insert_values.Parameters.Add("Username", textBox3.Text);
insert_values.Parameters.Add("TemporaryPassword", textBox4.Text);
insert_values.Parameters.Add("Department", dids[comboBox2.SelectedIndex]);
insert_values.Parameters.Add("Job", jids[comboBox1.SelectedIndex]);
insert_values.Parameters.Add("Email", textBox5.Text);
int x;
x = insert_values.ExecuteNonQuery();
if (x != -1)
{
MessageBox.Show("Member is Added Successfully");
}
}
private void button4_Click(object sender, EventArgs e)
{
OracleCommand reqviolation = new OracleCommand();
reqviolation.Connection = OracleHelper.getConnection();
reqviolation.CommandType = CommandType.Text;
reqviolation.CommandText = "update EVENT set REQUEST_STATUS ='rejected' where title=:e_title";
reqviolation.Parameters.Add("e_title", comboBox1.SelectedItem.ToString());
reqviolation.ExecuteNonQuery();
reqviolation = new OracleCommand();
reqviolation.Connection = OracleHelper.getConnection();
reqviolation.CommandType = CommandType.Text;
reqviolation.CommandText = "update Locations_schedule set STATUS ='Available' where l_name=(select l_name from event where title=:event_title)";
reqviolation.Parameters.Add("event_title", comboBox1.SelectedItem.ToString());
reqviolation.ExecuteNonQuery();
reqviolation = new OracleCommand();
reqviolation.Connection = OracleHelper.getConnection();
reqviolation.CommandType = CommandType.Text;
reqviolation.CommandText = "insert into violations values(:r,:e)";
reqviolation.Parameters.Add("r", textBox1.Text);
reqviolation.Parameters.Add("e", comboBox1.SelectedItem.ToString());
int k = reqviolation.ExecuteNonQuery();
if (k != -1)
{
MessageBox.Show("Violation is recorded");
comboBox1.Text = "";
textBox2.Clear();
textBox3.Clear();
textBox4.Clear();
textBox5.Clear();
comboBox1.Items.RemoveAt(comboBox1.SelectedIndex);
}
textBox1.Clear();
violation.Visible = false;
}
private void addMember_Load(object sender, EventArgs e)
{
dids = new ArrayList();
jids = new ArrayList();
#region Job comboBox
OracleCommand Job = new OracleCommand();
Job.Connection = OracleHelper.getConnection();
Job.CommandText = "select * from JOB";
Job.CommandType = CommandType.Text;
OracleDataReader Job_reader = Job.ExecuteReader();
while (Job_reader.Read())
{
comboBox1.Items.Add(Job_reader[1].ToString());
jids.Add(Job_reader[0]);
}
Job_reader.Close();
#endregion
#region Department Combobox
OracleCommand Dept = new OracleCommand();
Dept.Connection = OracleHelper.getConnection();
Dept.CommandText = "select * from department";
Dept.CommandType = CommandType.Text;
OracleDataReader dep_reader = Dept.ExecuteReader();
while (dep_reader.Read())
{
comboBox2.Items.Add(dep_reader[1].ToString());
dids.Add(dep_reader[0]);
}
dep_reader.Close();
#endregion
}
private void delBtn_Click(object sender, EventArgs e)
{
if (eventsCLB.CheckedItems.Count <= 0)
{
MessageBox.Show("You must make a selection...", "Warning");
return;
}
for (int i = 0; i < eventsCLB.CheckedIndices.Count; i++)
{
OracleCommand del = new OracleCommand();
del.Connection = OracleHelper.getConnection();
del.CommandType = CommandType.StoredProcedure;
del.CommandText = "DeleteEvent";
Event ev = (Event)events[eventsCLB.CheckedIndices[i]];
del.Parameters.Add("t", ev.title);
del.ExecuteNonQuery();
events.RemoveAt(eventsCLB.CheckedIndices[i]);
}
eventsCLB.Items.Clear();
foreach (Event ev in events)
{
eventsCLB.Items.Add(ev.title + " " + ev.rs.ToString());
}
}
private void saveEditBtn_Click(object sender, EventArgs e)
{
//description is not empty
if (descriptionTxt.Text.Length == 0)
{
MessageBox.Show("Description is empty! Please enter a description...", "Warning");
return;
}
//capacity is not empty
if (capTxt.Text.Length == 0)
{
MessageBox.Show("Capacity is empty! Please enter a capacity...", "Warning");
return;
}
if (locCB.SelectedIndex < 0 || depCB.SelectedIndex < 0)
{
MessageBox.Show("Please do not leave empty fields..", "Warning");
return;
}
try
{
int x = int.Parse(capTxt.Text);
}
catch (Exception ex)
{
MessageBox.Show("Please enter number in capacity...", "Warning");
}
//update event
OracleCommand insEvent = new OracleCommand();
insEvent.Connection = OracleHelper.getConnection();
insEvent.CommandText = "Update_Event";
insEvent.CommandType = CommandType.StoredProcedure;
insEvent.Parameters.Add("t", titleTxt.Text);
insEvent.Parameters.Add("cap", capTxt.Text);
insEvent.Parameters.Add("des", descriptionTxt.Text);
insEvent.Parameters.Add("ln", locCB.SelectedItem.ToString());
if (timeCB.SelectedIndex >= 0)
{
int tIndx = timeCB.SelectedIndex;
insEvent.Parameters.Add("st", startTimes[tIndx].ToString());
insEvent.Parameters.Add("ld", dates[tIndx].ToString().ToUpper());
}
else
{
Event ev = (Event)events[eventsCLB.SelectedIndex];
insEvent.Parameters.Add("st", ev.start_time);
insEvent.Parameters.Add("ld", ev.date);
}
insEvent.Parameters.Add("did", dids[depCB.SelectedIndex]);
insEvent.ExecuteNonQuery();
MessageBox.Show("Event successfully updated!", "Success");
titleTxt.Clear();
descriptionTxt.Clear();
capTxt.Clear();
depCB.Items.Clear();
listPanel[0].BringToFront();
events.Clear();
eventsCLB.Items.Clear();
OracleCommand getEvents = new OracleCommand();
getEvents.Connection = OracleHelper.getConnection();
getEvents.CommandType = CommandType.StoredProcedure;
getEvents.CommandText = "GetEvents";
getEvents.Parameters.Add("ref", OracleDbType.RefCursor, ParameterDirection.Output);
getEvents.Parameters.Add("hst", OracleHelper.LoggedIn.user_name);
OracleDataReader eventsDR = getEvents.ExecuteReader();
while (eventsDR.Read())
{
Event ev = new Event();
ev.title = eventsDR[0].ToString();
ev.capacity = int.Parse(eventsDR[2].ToString());
ev.description = eventsDR[3].ToString();
ev.location = eventsDR[4].ToString();
ev.start_time = eventsDR[5].ToString();
ev.date = eventsDR[6].ToString();
ev.department = eventsDR[7].ToString();
ev.end_time = eventsDR[8].ToString();
if (eventsDR[1].ToString().CompareTo("Rejected") == 0)
{
ev.rs = RequestStatus.REJECTED;
}
else if (eventsDR[1].ToString().CompareTo("accepted") == 0)
{
ev.rs = RequestStatus.ACCEPTED;
}
else if (eventsDR[1].ToString().CompareTo("pending") == 0)
{
ev.rs = RequestStatus.PENDING;
}
eventsCLB.Items.Add(ev.title + " " + ev.rs.ToString());
events.Add(ev);
}
}
private void btn_Click(object sender, EventArgs e)
{
//event title is not empty
if (titleTxt.Text.Length == 0)
{
MessageBox.Show("Title is empty! Please enter a title...", "Warning");
return;
}
//event title is unique
OracleCommand title = new OracleCommand();
title.Connection = OracleHelper.getConnection();
title.CommandText = "IsTitleUnique";
title.CommandType = CommandType.StoredProcedure;
title.Parameters.Add("title", titleTxt.Text);
int ret;
title.Parameters.Add("ret", OracleDbType.Int32, ParameterDirection.Output);
title.ExecuteNonQuery();
//description is not empty
if (descriptionTxt.Text.Length == 0)
{
MessageBox.Show("Description is empty! Please enter a description...", "Warning");
return;
}
//capacity is not empty
if (capTxt.Text.Length == 0)
{
MessageBox.Show("Capacity is empty! Please enter a capacity...", "Warning");
return;
}
if (locCB.SelectedIndex < 0 || timeCB.SelectedIndex < 0 || depCB.SelectedIndex < 0)
{
MessageBox.Show("Please do not leave empty fields..", "Warning");
return;
}
try
{
ret = int.Parse(title.Parameters["ret"].Value.ToString());
if (ret == 0)
{
MessageBox.Show("Title is not unique!", "Warning");
return;
}
int x = int.Parse(capTxt.Text);
}catch (Exception ex)
{
MessageBox.Show("Please enter number in capacity...", "Warning");
}
//insert event
OracleCommand insEvent = new OracleCommand();
insEvent.Connection = OracleHelper.getConnection();
insEvent.CommandText = "Insert_Event";
insEvent.CommandType = CommandType.StoredProcedure;
insEvent.Parameters.Add("t", titleTxt.Text);
insEvent.Parameters.Add("cap", capTxt.Text);
insEvent.Parameters.Add("des", descriptionTxt.Text);
insEvent.Parameters.Add("ln", locCB.SelectedItem.ToString());
int tIndx = timeCB.SelectedIndex;
insEvent.Parameters.Add("st", startTimes[tIndx].ToString());
insEvent.Parameters.Add("et", endTimes[tIndx].ToString());
insEvent.Parameters.Add("ld", dates[tIndx].ToString().ToUpper());
insEvent.Parameters.Add("did", dids[depCB.SelectedIndex]);
insEvent.Parameters.Add("hst", OracleHelper.LoggedIn.user_name);
insEvent.ExecuteNonQuery();
//insert hosts
if (hostCLB.CheckedItems.Count > 0)
{
for (int i = 0; i < hostCLB.CheckedItems.Count; i++)
{
OracleCommand addHost = new OracleCommand();
addHost.Connection = OracleHelper.getConnection();
addHost.CommandText = "Add_Host";
addHost.CommandType = CommandType.StoredProcedure;
addHost.Parameters.Add("t", titleTxt.Text);
addHost.Parameters.Add("hst", usernames[hostCLB.CheckedItems[i].ToString()]);
addHost.ExecuteNonQuery();
}
}
MessageBox.Show("Event successfully created!", "Success");
titleTxt.Clear();
descriptionTxt.Clear();
capTxt.Clear();
hostCLB.ClearSelected();
this.Hide();
UserHome u = new UserHome();
u.Closed += (s, args) => this.Close();
u.Show();
}