public void SaveData() { CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture; TextInfo textInfo = cultureInfo.TextInfo; PersonalData objper = new PersonalData(); string fname, mname, lname, company, employeetype, materialstatus, empstatus, phoneland, phoncell, phoneother, fax, email, webpage, facebook, twitter; string residstaddress, otherstaddress, homezip, otherzip; Nullable<Int32> residcityid = null, othercityid = null; Nullable<Int16> titleid = null; Nullable<DateTime> dateifhire = null, terminationdate = null, dob = null; othercityid = ucothercity.InsertCitydetails(); residcityid = ucresidcity.InsertCitydetails(); fname = textInfo.ToTitleCase(txtfirstname.Text.Trim()); mname = textInfo.ToTitleCase(txtmiddlename.Text.Trim()); lname = textInfo.ToTitleCase(txtlastname.Text.Trim()); company = textInfo.ToTitleCase(txtcompany.Text.Trim()); employeetype = ddlemployeetype.SelectedItem.Text.Trim(); materialstatus = txtmaterialstatus.Text.Trim(); empstatus = ddlemployeestatus.SelectedItem.Text;// txtemployeestatus.Text.Trim(); phoneland = txtphoneland.Text.Trim(); phoncell = txtphonecell.Text.Trim(); phoneother = txtphoneother.Text.Trim(); fax = txtfax.Text.Trim(); email = txtemail.Text.Trim(); webpage = txtwebpage.Text.Trim(); facebook = txtfacebook.Text.Trim(); twitter = txttwitter.Text.Trim(); titleid = (ddltitle.SelectedIndex == 0) ? titleid : Convert.ToInt16(ddltitle.SelectedItem.Value); dateifhire = (txtdateifhire.Text.Trim() == "") ? dateifhire : Convert.ToDateTime(txtdateifhire.Text); terminationdate = (txttermanitationdate.Text.Trim() == "") ? terminationdate : Convert.ToDateTime(txttermanitationdate.Text); dob = (txtdob.Text.Trim() == "") ? dob : Convert.ToDateTime(txtdob.Text); TextBox txtresidaddress = (TextBox)ucresidcity.FindControl("txtaddress"); TextBox txtotheraddress = (TextBox)ucothercity.FindControl("txtaddress"); residstaddress = textInfo.ToTitleCase(txtresidaddress.Text.Trim()); otherstaddress = textInfo.ToTitleCase(txtotheraddress.Text.Trim()); //homezip = (ucresidcity.FindControl("txtzipcode") as TextBox).Text; //otherzip = (ucothercity.FindControl("txtzipcode") as TextBox).Text; homezip = ucresidcity.Get_child_zipcode(); otherzip = ucothercity.Get_child_zipcode(); Int32 personalid = 0; //string msg = "", string type = "I"; if (string.IsNullOrEmpty(Request.QueryString["personalid"])) { personalid = objper.Personaldata_Insert(fname, mname, lname, company, employeetype, materialstatus, empstatus, phoneland, phoncell, phoneother, fax, email, webpage, facebook, twitter, residstaddress, residcityid, otherstaddress, othercityid, titleid, dateifhire, terminationdate, dob, homezip, otherzip); } else if (Request.QueryString["personalid"] != "" && Request.QueryString["personalid"] != null) { personalid = Convert.ToInt32(Request.QueryString["personalid"]); objper.Personaldata_Update(personalid, fname, mname, lname, company, employeetype, materialstatus, empstatus, phoneland, phoncell, phoneother, fax, email, webpage, facebook, twitter, residstaddress, residcityid, otherstaddress, othercityid, titleid, dateifhire, terminationdate, dob, homezip, otherzip); type = "U"; } if (personalid < 0) { lblerrmsg.Text = "Error: Data did not submit. Please contact system administrator!"; lblerrmsg.ForeColor = System.Drawing.Color.Red; } else if (personalid > 0) { ucshow.SavePersonalShow(personalid); ucdocx.SaveDocx(personalid, "PERSONAL"); ucshow.showhidefooter(false); if (string.IsNullOrEmpty(Request.QueryString["form"]) == true) { Response.Redirect("~/personal.aspx?personalid=" + personalid.ToString() + "&type=" + type + ""); } else { string prev_form = Request.QueryString["form"]; Int32 pre_or_ven_id = Convert.ToInt32(prev_form.Split('_').GetValue(1)); string pre_or_ven_flg = Convert.ToString(prev_form.Split('_').GetValue(0)); if (pre_or_ven_flg == "p") { objpre.PresenterContactperson_Insert(pre_or_ven_id, personalid); Response.Redirect("~/presenter.aspx?presenterid=" + pre_or_ven_id.ToString() + "&type=I"); } if (pre_or_ven_flg == "v") { VenueDataLayer.VenueData objven = new VenueDataLayer.VenueData(); objven.VenueContactperson_Insert(pre_or_ven_id, personalid); Response.Redirect("~/venue.aspx?venueid=" + pre_or_ven_id.ToString() + "&type=I"); } } } }
public void SaveVenueContactPerson(Int32 VenueID) { saveTempcontactperson(); DataTable dt = (DataTable)ViewState["temptable"]; Int32 personalid; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToInt32(dt.Rows[i]["contactpersonid"]) == 0) { personalid = Convert.ToInt32(dt.Rows[i]["personalid"]); VenueDataLayer.VenueData objven = new VenueDataLayer.VenueData(); objven.VenueContactperson_Insert(VenueID, personalid); } } } }