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 } }