protected void Submit2_Click(object sender, EventArgs e)
{
if (EmpID.Text == "" || QuarterID.Text == "")
{
Response.Write("<script>alert('Please enter all of the details.');</script>");
ClearForm();
}
else if (CheckIfExists())
{
Response.Write("<script>alert('The employee is allocated to a quarter already or the quarter is already taken.');</script>");
ClearForm();
}
else
{
AddNew();
QuarterInfo.DataBind();
ClearForm();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//This is to redirect the page if the user is not logged in
if (string.IsNullOrEmpty((string)Session["role"]))
{
Response.Redirect("~/");
}
if (!IsPostBack)
{
SqlConnection connection = new SqlConnection(Strcon);
connection.Open();
SqlCommand Command = new SqlCommand("SELECT employee.emp_id from employee LEFT JOIN allocatedquarter ON allocatedquarter.emp_id=employee.emp_id WHERE allocatedquarter.emp_id IS NULL;", connection);
SqlCommand Command2 = new SqlCommand("SELECT quarterlist.quarter_id from quarterlist LEFT JOIN allocatedquarter ON allocatedquarter.quarter_id=quarterlist.quarter_id WHERE allocatedquarter.quarter_id IS NULL;", connection);
EmpID.DataSource = Command.ExecuteReader();
QuarterID.DataSource = Command2.ExecuteReader();
EmpID.DataBind();
QuarterID.DataBind();
QuarterID.Items.Insert(0, new ListItem("Select a quarter ID", ""));
EmpID.Items.Insert(0, new ListItem("Select a employee ID", ""));
QuarterInfo.DataBind();
connection.Close();
}
}