Ejemplo n.º 1
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            //set culture to british
            //modify here in future if this needs to be set to us formats

            var      cinf      = new CultureInfo("en-GB");
            DateTime startdate = Convert.ToDateTime(TextBox3.Text, cinf);
            DateTime enddate   = Convert.ToDateTime(TextBox4.Text, cinf);

            string sdate = startdate.ToString("MM/dd/yyyy");
            string edate = enddate.ToString("MM/dd/yyyy");

            if (Request.QueryString["jobid"] != null)
            {
                #region updatejobs

                var mpage    = new DlMainpagepopulator();
                int recid    = mpage.RecName(Session["pusername"].ToString());
                int mxjobsid = Convert.ToInt16(Request.QueryString["jobid"]);

                //update job
                mpage.Updatejobs(mxjobsid, TextBox1.Text, TextBox2.Text, Editor1.Text, TextBox5.Text, 0, 0,
                                 TextBox6.Text, sdate, edate);

                mpage.Deletejobs(mxjobsid);

                //insert location
                foreach (ListItem listite1 in CheckBoxList2.Items.Cast <ListItem>().Where(listite1 => listite1.Selected))
                {
                    //insert

                    mpage.Insertjobmapping(mxjobsid, 1000, Convert.ToInt16(listite1.Value), recid);
                }

                //industry
                foreach (ListItem listitems3 in CheckBoxList1.Items.Cast <ListItem>().Where(listitems3 => listitems3.Selected))
                {
                    mpage.Insertjobmapping(mxjobsid, 1001, Convert.ToInt16(listitems3.Value), recid);
                }

                //insert contract
                foreach (ListItem listitems2 in CheckBoxList3.Items.Cast <ListItem>().Where(listitems2 => listitems2.Selected))
                {
                    //insert cats
                    mpage.Insertjobmapping(mxjobsid, 1002, Convert.ToInt16(listitems2.Value), recid);
                }

                //insert hours
                foreach (ListItem listitems4 in CheckBoxList7.Items.Cast <ListItem>().Where(listitems4 => listitems4.Selected))
                {
                    mpage.Insertjobmapping(mxjobsid, 1003, Convert.ToInt16(listitems4.Value), recid);
                }

                //employer direct of agency

                foreach (ListItem listitems5 in CheckBoxList8.Items.Cast <ListItem>().Where(listitems5 => listitems5.Selected))
                {
                    mpage.Insertjobmapping(mxjobsid, 1004, Convert.ToInt16(listitems5.Value), recid);
                }

                //insert salary
                foreach (ListItem listitems6 in CheckBoxList6.Items.Cast <ListItem>().Where(listitems6 => listitems6.Selected))
                {
                    mpage.Insertjobmapping(mxjobsid, 1005, Convert.ToInt16(listitems6.Value), recid);
                }

                //end update

                #endregion updatejobs
            }

            else
            {
                #region addjobs

                //add jobs
                var mpage    = new DlMainpagepopulator();
                int recid    = mpage.RecName(Session["pusername"].ToString());
                int mxjobsid = mpage.Getmaxjobid();

                //insert job

                mpage.Insertjobs(mxjobsid, TextBox1.Text, TextBox2.Text, Editor1.Text, TextBox5.Text, 0, 0,
                                 TextBox6.Text, sdate, edate);

                //insert default job
                mpage.Insertjobmapping(mxjobsid, 10000, 10000, recid);

                //insert location

                foreach (ListItem listite1 in CheckBoxList2.Items.Cast <ListItem>().Where(listite1 => listite1.Selected))
                {
                    //insert categories
                    mpage.Insertjobmapping(mxjobsid, 1000, Convert.ToInt16(listite1.Value), recid);
                }

                //industry
                foreach (ListItem listitems3 in CheckBoxList1.Items.Cast <ListItem>().Where(listitems3 => listitems3.Selected))
                {
                    mpage.Insertjobmapping(mxjobsid, 1001, Convert.ToInt16(listitems3.Value), recid);
                }

                //insert contract
                foreach (ListItem listitems2 in CheckBoxList3.Items.Cast <ListItem>().Where(listitems2 => listitems2.Selected))
                {
                    //insert cats
                    mpage.Insertjobmapping(mxjobsid, 1002, Convert.ToInt16(listitems2.Value), recid);
                }

                //insert hours
                foreach (ListItem listitems4 in CheckBoxList7.Items.Cast <ListItem>().Where(listitems4 => listitems4.Selected))
                {
                    mpage.Insertjobmapping(mxjobsid, 1003, Convert.ToInt16(listitems4.Value), recid);
                }

                //employer direct of agency

                foreach (ListItem listitems5 in CheckBoxList8.Items.Cast <ListItem>().Where(listitems5 => listitems5.Selected))
                {
                    mpage.Insertjobmapping(mxjobsid, 1004, Convert.ToInt16(listitems5.Value), recid);
                }

                //insert salary
                foreach (ListItem listitems6 in CheckBoxList6.Items.Cast <ListItem>().Where(listitems6 => listitems6.Selected))
                {
                    mpage.Insertjobmapping(mxjobsid, 1005, Convert.ToInt16(listitems6.Value), recid);
                }

                //end adding jobs

                #endregion addjobs
            }
        }