private void AddJobBtn_Click(object sender, EventArgs e)
{
if (DescriptionTxtbox.Text == "")
{
DesManLbl.Visible = true;
}
if (TitleTxtbox.Text == "")
{
TitManLbl.Visible = true;
}
if (CompanyTxtbox.Text == "")
{
ComManLbl.Visible = true;
}
if (CompanyTxtbox.Text == "")
{
LocManLbl.Visible = true;
}
else
{
string stream_id = (StreamComBox.SelectedIndex + 1).ToString();
string status_id = (StatusComBox.SelectedIndex + 1).ToString();
string description = DescriptionTxtbox.Text;
string title = TitleTxtbox.Text;
string deadline = DeadlinedatePicker1.Value.ToString();
string company = CompanyTxtbox.Text;
string location = LocTxtbox.Text;
DesManLbl.Visible = false;
TitManLbl.Visible = false;
ComManLbl.Visible = false;
LocManLbl.Visible = false;
string addJobQry = "INSERT INTO JobPost (Job_id, User_id, Stream_id, Status_id, Description, " +
"Title, DatePosted, Deadline, Company, Location) VALUES (job_id_seq.nextval, 6, " +
stream_id + ", " +
status_id + ", " +
description + ", " +
title +
", SYSDATE, " +
deadline +
", " + company + ", " +
location;
IWriteCommand cmd = new WriteCommand();
if (cmd.Execute(addJobQry))
{
DescriptionTxtbox.Text = "";
TitleTxtbox.Text = "";
CompanyTxtbox.Text = "";
CompanyTxtbox.Text = "";
}
else
{
JobMsgLbl.Text = "Adding Job Failed.";
JobMsgLbl.ForeColor = Color.Red;
}
JobMsgLbl.Visible = true;
}
}
public bool EndSession(Guid sessionId)
{
try
{
string qry = "DELETE FROM Sessions WHERE session_guid = '" + sessionId.ToString() + "'";
IWriteCommand cmd = new WriteCommand();
if (cmd.Execute(qry))
{
return true;
}
else
{
return false;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return false;
}
}
public Guid SessionStart(int userId, int typeID)
{
// Create the Guid for the session
Guid g = Guid.NewGuid();
// Insert session info into database
try
{
string qry = "INSERT INTO SESSIONS (session_id, session_guid, User_id, Type_id) VALUES ( session_id_seq.NEXTVAL, '" + g.ToString() + "', " + userId.ToString() + ", " + typeID.ToString() + ")";
IWriteCommand cmd = new WriteCommand();
if (cmd.Execute(qry))
{
return g;
}
else
{
return Guid.Empty;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return Guid.Empty;
}
}
