protected void Page_Load(object sender, EventArgs e)
{
Session["pathdepth"] = 5;
try
{
odcbconn = new BLodbc();
odcbconn.conn.Open();
}
catch (Exception ex)
{
odcbconn.conn.Close();
debugmessage.InnerHtml = "<br/>ODCB Failed <br/>"/* + ex.ToString()*/;
return;
}
finally
{
odcbconn.conn.Close();
}
//only populate once
if (IsPostBack) return;
businessname.InnerHtml += Session["businessname"];
populateservices();
}
protected void Page_Load(object sender, EventArgs e)
{
Session["pathdepth"] = 5;
if (Session["serviceid"] == null || Session["packageid"] == null)
{
Response.Redirect("manageservices.aspx");
}
businessname.InnerHtml += Session["businessname"] + " " + Session["servicename"] + " " + Session["packagename"];
try
{
odcbconn = new BLodbc();
odcbconn.conn.Open();
}
catch (Exception ex)
{
odcbconn.conn.Close();
debugmessage.InnerHtml = "<br/>ODCB Failed <br/>"/* + ex.ToString()*/;
return;
}
finally
{
odcbconn.conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Session["pathdepth"] = 2;
if (Session["employeeid"] == null) {
//only for managers
//btnnew.Visible = false;
}
try
{
odcbconn = new BLodbc();
odcbconn.conn.Open();
}
catch (Exception ex)
{
odcbconn.conn.Close();
debugmessage.InnerHtml = "<br/>ODCB Failed <br/>"/* + ex.ToString()*/;
return;
}
finally
{
odcbconn.conn.Close();
}
//only populate once
if (IsPostBack) return;
try
{
//populate businesses
odcbconn.conn.Open();
OdbcCommand cmd = odcbconn.conn.CreateCommand();
cmd.CommandText = "SELECT BusinessId, BusinessName FROM business ORDER BY BusinessId";
OdbcDataReader rows = cmd.ExecuteReader();
ddlbusinesses.DataSource = rows;
ddlbusinesses.DataTextField = "BusinessName";
ddlbusinesses.DataValueField = "BusinessId";
ddlbusinesses.DataBind();
//no businesses
if (ddlbusinesses.Items.Count == 0)
{
odcbconn.conn.Close();
Response.Redirect("createbusiness.aspx");
}
}
catch (Exception ex)
{
odcbconn.conn.Close();
debugmessage.InnerHtml = "<br/>ODCB Failed <br/>"/* + ex.ToString()*/;
return;
}
finally
{
odcbconn.conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Session["pathdepth"] = 3;
try
{
odcbconn = new BLodbc();
odcbconn.conn.Open();
}
catch (Exception ex)
{
odcbconn.conn.Close();
debugmessage.InnerHtml = "<br/>ODCB Failed <br/>"/* + ex.ToString()*/;
return;
}
finally
{
odcbconn.conn.Close();
}
}
protected void btnlogin_Click(object sender, EventArgs e)
{
//validation error
if (!Page.IsValid)
{
debugmessage.InnerHtml = "Invalid input";
return;
}
try
{
odcbconn = new BLodbc();
odcbconn.conn.Open();
}
catch (Exception ex)
{
odcbconn.conn.Close();
debugmessage.InnerHtml = "<br/>ODCB Failed <br/>"/* + ex.ToString()*/;
return;
}
finally
{
odcbconn.conn.Close();
}
try
{
if (txtname.Text == "Admin")
{
Session["employeeid"] = 1;
Session["employeename"] = txtname.Text;
Response.Redirect("manage.aspx");
return;
}
//select employee
odcbconn.conn.Open();
OdbcCommand cmd = odcbconn.conn.CreateCommand();
cmd.CommandText = "SELECT EmployeeId, EmployeeName FROM employee INNER JOIN employeetype ON employee.EmployeeType_EmployeeTypeId WHERE employee.EmployeeName = ? AND employeetype.EmployeeTypeName = ? AND employee.Business_BusinessId = ?";
cmd.Parameters.Add("@employee.EmployeeName", OdbcType.VarChar, 100).Value = txtname.Text;
cmd.Parameters.Add("@employeetype.EmployeeTypeName", OdbcType.VarChar, 45).Value = "Manager";
cmd.Parameters.Add("@employeetype.EmployeeTypeName", OdbcType.Int).Value = Session["businessid"];
OdbcDataReader rows = cmd.ExecuteReader();
if (rows.Read())
{
Session["employeeid"] = rows.GetString(0);
Session["employeename"] = rows.GetString(1);
Response.Redirect("manage.aspx");
}
else
{
odcbconn.conn.Close();
Response.Redirect("createemployee.aspx");
}
}
catch (Exception ex)
{
odcbconn.conn.Close();
debugmessage.InnerHtml = "<br/>ODCB Failed <br/>"/* + ex.ToString()*/;
return;
}
finally
{
odcbconn.conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Session["pathdepth"] = 3;
try
{
odcbconn = new BLodbc();
odcbconn.conn.Open();
}
catch (Exception ex)
{
odcbconn.conn.Close();
debugmessage.InnerHtml = "<br/>ODCB Failed <br/>"/* + ex.ToString()*/;
return;
}
finally
{
odcbconn.conn.Close();
}
ddlmanager.Visible = false;
//only populate once
if (IsPostBack) return;
populateemployeetype();
populatemanager();
}
protected void Page_Load(object sender, EventArgs e)
{
Session["pathdepth"] = 2;
try
{
odbcconn = new BLodbc();
odbcconn.conn.Open();
}
catch (Exception ex)
{
odbcconn.conn.Close();
debugmessage.InnerHtml = "<br/>ODCB Failed <br/>"/* + ex.ToString()*/;
return;
}
finally
{
odbcconn.conn.Close();
}
//repopulate
if (IsPostBack)
{
if (Request.Params.Get("__EVENTTARGET").IndexOf("ddlservices") >= 0)
{
ddlservices.Items.Remove(ddlservices.Items.FindByValue("0"));
populatepackages();
}
else if (Request.Params.Get("__EVENTTARGET").IndexOf("ddlpackages") >= 0)
{
ddlpackages.Items.Remove(ddlpackages.Items.FindByValue("0"));
populateitems();
}
return;
}
businessname.InnerHtml += Session["businessname"]+"";
populateservices();
}
protected void Page_Load(object sender, EventArgs e)
{
Session["pathdepth"] = 5;
if (Session["serviceid"] == null)
{
Response.Redirect("manageservices.aspx");
}
if (Session["packageid"] == null)
{
Session["packageid"] = Request.QueryString["packageid"];
Session["packagename"] = HttpUtility.UrlDecode(Request.QueryString["packagename"]);
}
try
{
odcbconn = new BLodbc();
odcbconn.conn.Open();
}
catch (Exception ex)
{
odcbconn.conn.Close();
debugmessage.InnerHtml = "<br/>ODCB Failed <br/>"/* + ex.ToString()*/;
return;
}
finally
{
odcbconn.conn.Close();
}
//repopulate
if (IsPostBack)
{
if (Request.Params.Get("__EVENTTARGET").IndexOf("ddlservices") >= 0)
{
ddlservices.Items.Remove(ddlservices.Items.FindByValue("0"));
populatepackages();
}
else if (Request.Params.Get("__EVENTTARGET").IndexOf("ddlpackages") >= 0)
{
ddlpackages.Items.Remove(ddlpackages.Items.FindByValue("0"));
populateitems();
}
return;
}
//only populate once
populatetable();
businessname.InnerHtml += Session["businessname"] + " " + Session["servicename"] + " " + Session["packagename"];
populateservices();
}
