Beispiel #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        this.conn = (DBconnector.Connector)Session["connector"];

        DataTable dt = new DataTable();

        this.conn.GetAudit(dt);

        GridViewData.DataSource = dt;
        GridViewData.DataBind();
    }
 protected void Page_Load(object sender, EventArgs e)
 {
     this.conn = (DBconnector.Connector)Session["connector"];
 }
    protected void Page_Load(object sender, EventArgs e)
    {
        this.conn = (DBconnector.Connector)Session["connector"];
        bool update = false;
        DataTable dt = null;
        string type = "";
        string sin = "";

        if (Request.QueryString["type"] != null && Request.QueryString["sin"] != null)
        {
            update = true;

            type = Request.QueryString["type"];
            sin = Request.QueryString["sin"];

            if (type == "fulltime")
            {
                ddlEmployeeType.SelectedIndex = 2;
            }
            else if (type == "parttime")
            {
                ddlEmployeeType.SelectedIndex = 3;
            }
            else if (type == "seasonal")
            {
                ddlEmployeeType.SelectedIndex = 4;
            }

            dt = new DataTable();

            this.conn.GetEmployee(type, sin, dt);

            Session["modify"] = "y";
        }

        PanelDetails.Controls.Clear();

        if (ddlEmployeeType.SelectedIndex == 1)
        {
            Label labelHire = new Label();

            labelHire.Text = "Date Of Hire: ";

            TextBox textHire = new TextBox();
            textHire.ID = "hire";
            textHire.TextMode = TextBoxMode.Date;
            TextBox textTerm = new TextBox();

            PanelDetails.Controls.Add(labelHire);
            PanelDetails.Controls.Add(textHire);
            PanelDetails.Controls.Add(new LiteralControl("<br />"));
        }
        else if (ddlEmployeeType.SelectedIndex == 2)
        {
            Label labelHire = new Label();
            Label labelTerm = new Label();

            labelHire.Text = "Date Of Hire: ";

            TextBox textHire = new TextBox();
            textHire.ID = "hire";
            textHire.TextMode = TextBoxMode.Date;

            PanelDetails.Controls.Add(labelHire);
            PanelDetails.Controls.Add(textHire);
            PanelDetails.Controls.Add(new LiteralControl("<br />"));
        }
        else if (ddlEmployeeType.SelectedIndex == 3)
        {
            Label labelHire = new Label();
            Label labelReason = new Label();
            Label labelPayment = new Label();
            Label labelYear = new Label();

            labelHire.Text = "Season: ";
            labelYear.Text = "Season Year: ";

            TextBox textHire = new TextBox();
            textHire.ID = "hire";
            TextBox textYear = new TextBox();
            textYear.ID = "year";
            textYear.TextMode = TextBoxMode.Number;

            PanelDetails.Controls.Add(labelHire);
            PanelDetails.Controls.Add(textHire);
            PanelDetails.Controls.Add(new LiteralControl("<br />"));

            PanelDetails.Controls.Add(labelYear);
            PanelDetails.Controls.Add(textYear);
            PanelDetails.Controls.Add(new LiteralControl("<br />"));

        }

        if (update)
        {
            if (type == "fulltime")
            {
                txtCompany.Text = dt.Rows[0]["CompanyName"].ToString();
                object tmp = dt.Rows[0]["DateOfBirth"];
                if (tmp.ToString() != "")
                {
                    txtDateOfBirth.Text = ((DateTime)dt.Rows[0]["DateOfBirth"]).ToString("yyyy-MM-dd");
                }
                txtFirstName.Text = dt.Rows[0]["FirstName"].ToString();
                txtLastName.Text = dt.Rows[0]["LastName"].ToString();
                txtSIN.Text = sin;

                TextBox textHire = null;
                foreach (Control cont in PanelDetails.Controls)
                {
                    if (cont is TextBox)
                    {
                        if (cont.ID == "hire")
                        {
                            textHire = (TextBox)cont;
                            continue;
                        }
                    }
                }

                tmp = dt.Rows[0]["DateOfHire"];
                if (tmp.ToString() != "")
                {
                    textHire.Text = ((DateTime)dt.Rows[0]["DateOfHire"]).ToString("yyyy-MM-dd");
                }

            }
            else if (type == "parttime")
            {
                txtCompany.Text = dt.Rows[0]["CompanyName"].ToString();
                object tmp = dt.Rows[0]["DateOfBirth"];
                if (tmp.ToString() != "")
                {
                    txtDateOfBirth.Text = ((DateTime)dt.Rows[0]["DateOfBirth"]).ToString("yyyy-MM-dd");
                }
                txtFirstName.Text = dt.Rows[0]["FirstName"].ToString();
                txtLastName.Text = dt.Rows[0]["LastName"].ToString();
                txtSIN.Text = sin;

                TextBox textHire = null;
                foreach (Control cont in PanelDetails.Controls)
                {
                    if (cont is TextBox)
                    {
                        if (cont.ID == "hire")
                        {
                            textHire = (TextBox)cont;
                            continue;
                        }
                    }
                }

                tmp = dt.Rows[0]["DateOfHire"];
                if (tmp.ToString() != "")
                {
                    textHire.Text = ((DateTime)dt.Rows[0]["DateOfHire"]).ToString("yyyy-MM-dd");
                }

            }
            else if (type == "seasonal")
            {
                txtCompany.Text = dt.Rows[0]["CompanyName"].ToString();
                object tmp = dt.Rows[0]["DateOfBirth"];
                if (tmp.ToString() != "")
                {
                    txtDateOfBirth.Text = ((DateTime)dt.Rows[0]["DateOfBirth"]).ToString("yyyy-MM-dd");
                }
                txtFirstName.Text = dt.Rows[0]["FirstName"].ToString();
                txtLastName.Text = dt.Rows[0]["LastName"].ToString();
                txtSIN.Text = sin;

                TextBox textHire = null;
                TextBox textYear = null;
                foreach (Control cont in PanelDetails.Controls)
                {
                    if (cont is TextBox)
                    {
                        if (cont.ID == "hire")
                        {
                            textHire = (TextBox)cont;
                            continue;
                        }
                        else if (cont.ID == "year")
                        {
                            textYear = (TextBox)cont;
                            continue;
                        }
                    }
                }

                string season = dt.Rows[0]["Season"].ToString();
                if (season != "")
                {
                    textYear.Text = season.Substring(season.Length - 4);
                    textHire.Text = season.Substring(0, season.Length - 4);
                }
            }
        }
    }
 protected void Page_Load(object sender, EventArgs e)
 {
     this.conn = (DBconnector.Connector)Session["connector"];
     DataTable mondays = new DataTable();
     LabelComment.Text = conn.GetMondays("2012-01-01", mondays);
     DropDownListMondays.DataSource = mondays;
     DropDownListMondays.DataTextField = "MonDates";
     DropDownListMondays.DataValueField = "MonDates";
     DropDownListMondays.DataBind();
 }