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");
}
//insert 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();
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 Form1_FormClosed(object sender, FormClosedEventArgs e)
{
OracleHelper.closeConnection();
}
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();
}