public void loadpersonaldetails() { try { DataTable dt = new DataTable(); PersonalData objper = new PersonalData(); dt = objper.GetPersonalDetails(hdnpersonalid.Value); if (dt.Rows.Count > 0) { if (Request.QueryString["personalid"] != "" && Request.QueryString["personalid"] != null) { txtfirstname.Text = dt.Rows[0]["PERSONAL_FNAME"].ToString(); } lblHeader.Visible = true; lblHeader1.Visible = true; lblHeader.Text = dt.Rows[0]["PERSONAL_FNAME"].ToString() +" " + dt.Rows[0]["PERSONAL_LNAME"].ToString(); lblHeader1.Text = dt.Rows[0]["PERSONAL_TITLE_ID"].ToString(); txtfirstname.Text = dt.Rows[0]["PERSONAL_FNAME"].ToString(); txtlastname.Text = dt.Rows[0]["PERSONAL_LNAME"].ToString(); txtmiddlename.Text = dt.Rows[0]["PERSONAL_MNAME"].ToString(); txtphoneland.Text = dt.Rows[0]["PERSONAL_PHONE_LAND"].ToString(); txtphonecell.Text = dt.Rows[0]["PERSONAL_PHONE_CELL"].ToString(); txtphoneother.Text = dt.Rows[0]["PERSONAL_PHONE_OTHER"].ToString(); ddltitle.SelectedIndex = ddltitle.Items.IndexOf(ddltitle.Items.FindByValue(dt.Rows[0]["PERSONAL_TITLE_ID"].ToString())); txtfax.Text = dt.Rows[0]["PERSONAL_FAX"].ToString(); txtemail.Text = dt.Rows[0]["PERSONAL_EMAIL"].ToString(); txtcompany.Text = dt.Rows[0]["PERSONAL_COMPANY"].ToString(); ddlemployeetype.SelectedIndex = ddlemployeetype.Items.IndexOf(ddlemployeetype.Items.FindByText(dt.Rows[0]["PERSONAL_EMP_TYPE"].ToString())); txtdateifhire.Text = dt.Rows[0]["PERSONAL_HIRE_DATE"].ToString(); txttermanitationdate.Text = dt.Rows[0]["PERSONAL_TERM_DATE"].ToString(); ddlemployeestatus.SelectedIndex = ddlemployeestatus.Items.IndexOf(ddlemployeestatus.Items.FindByText(dt.Rows[0]["PERSONAL_EMP_STATUS"].ToString())); txtdob.Text = dt.Rows[0]["PERSONAL_DOB"].ToString(); txtmaterialstatus.Text = dt.Rows[0]["PERSONAL_MARRIED_STATUS"].ToString(); txtwebpage.Text = dt.Rows[0]["PERSONAL_WEBPAGE"].ToString(); txtfacebook.Text = dt.Rows[0]["PERSONAL_FACEBOOK"].ToString(); txttwitter.Text = dt.Rows[0]["PERSONAL_TWITTER"].ToString(); (ucresidcity.FindControl("txtzipcode") as TextBox).Text = dt.Rows[0]["HOMEZIP"].ToString(); (ucothercity.FindControl("txtzipcode") as TextBox).Text = dt.Rows[0]["OTHERZIP"].ToString(); string City_Zip_H = dt.Rows[0]["HOMEZIP"].ToString(); string City_Zip_O = dt.Rows[0]["OTHERZIP"].ToString(); ucresidcity.fillcitydetails(Convert.ToInt32(dt.Rows[0]["PERSONAL_HOME_CITY_ID"]), dt.Rows[0]["PERSONAL_HOME_STREET"].ToString(), City_Zip_H); ucothercity.fillcitydetails(Convert.ToInt32(dt.Rows[0]["PERSONAL_OTHER_CITY_ID"]), dt.Rows[0]["PERSONAL_OTHER_STREET"].ToString(), City_Zip_O); string active_flag = dt.Rows[0]["PERSONAL_ACTIVE_FLAG"].ToString(); string beast_flag = dt.Rows[0]["personal_beast_flag"].ToString(); (this.Master as Site1).show_control(active_flag, pnlpersonal, beast_flag); if (Request.QueryString["personalid"] != "" && Request.QueryString["personalid"] != null) { ucshow.GetPersonalShow(Convert.ToInt32(hdnpersonalid.Value)); ucdocx.GetDocxDetails(Convert.ToInt32(hdnpersonalid.Value), "PERSONAL"); } } } catch (Exception ex) { lblerrmsg.Text = "Error: " + ex.Message.ToString(); lblerrmsg.ForeColor = System.Drawing.Color.Red; } }
public void DeleteData(string flag) { PersonalData objper = new PersonalData(); Int32 personalid = Convert.ToInt32(hdnpersonalid.Value); string msg = objper.Personal_Delete(personalid, flag); if (msg == "") { divmsg.InnerHtml = (flag == "n") ? "Record deleted successfully!" : "Record undeleted successfully!"; (this.Master as Site1).show_control(flag, pnlpersonal); } else { lblerrmsg.Text = msg; } }
public void GetPersonalShow(Int32 personalid) { hdnucpersonalid.Value = personalid.ToString(); PersonalData objper = new PersonalData(); DataTable dt = new DataTable(); dt = objper.GetPersonalShowAssignDetails(personalid); DataColumn dc = new DataColumn(); dc.ColumnName = "tempid"; dc.DataType = typeof(int); dc.AutoIncrement = true; dc.AutoIncrementSeed = 1; dt.Columns.Add(dc); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["tempid"] = i + 1; } ViewState["temptable"] = dt; BindShow(); showhidefooter(false); }
public void SavePersonalShow(Int32 personalid) { SaveTempShowDetails(); DataTable dt; dt = (DataTable)ViewState["temptable"]; PersonalData objper = new PersonalData(); Int32 personalassignshowid; DateTime assigndate; Nullable<DateTime> enddate = null; string assingflag; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["per_assign_id"].ToString() == "0") { personalassignshowid = Convert.ToInt32(dt.Rows[i]["showid"]); assigndate = Convert.ToDateTime(dt.Rows[i]["assigndate"]); enddate = (dt.Rows[i]["enddate"].ToString() != "") ? Convert.ToDateTime(dt.Rows[i]["enddate"]) : enddate; assingflag = Convert.ToString(dt.Rows[i]["assignflag"]); objper.PersonalShowAssign_Insert(personalid, personalassignshowid, assigndate, enddate, assingflag); } } GetPersonalShow(personalid); }
public static List<string> Getpersonalname(string prefixText) { PersonalData objper = new PersonalData(); List<string> personal = objper.searchpersonal(prefixText, "Y"); return personal; }
public static List<string> Getcompanyname(string prefixText) { PersonalData objper = new PersonalData(); List<string> company = objper.GetCompanyName(prefixText); return company; }
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 loadphonedetails() { Label lblfax = (Label)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("lblfax"); Label lblemail = (Label)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("lblemail"); Label lblphone = (Label)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("lblphone"); Label lblTitle = (Label)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("lblTitle"); PersonalData objper = new PersonalData(); string phone = ""; DataTable dt = objper.GetPersonalDetails(hdnfirstnameid.Value); if (dt.Rows.Count > 0) { lblfax.Text = dt.Rows[0]["personal_fax"].ToString(); lblemail.Text = dt.Rows[0]["personal_email"].ToString(); phone = dt.Rows[0]["personal_phone_land"].ToString(); lblTitle.Text = dt.Rows[0]["title_name"].ToString(); } else { lblfax.Text = string.Empty; lblemail.Text = string.Empty; } lblphone.Text = phone; lblphone.Focus(); }
protected void lnkbtnDelete_Click(object sender, EventArgs e) { try { DataTable dt = new DataTable(); dt = (DataTable)ViewState["temptable"]; foreach (RepeaterItem gr in RepDetails.Items) { CheckBox chkdelete = (CheckBox)gr.FindControl("chkdelete"); HiddenField hdntempid = (HiddenField)gr.FindControl("hdntempid"); HiddenField hdnpersonalshowid = (HiddenField)gr.FindControl("hdnpersonalshowid"); if (chkdelete.Checked == true) { DataRow[] dr; dr = dt.Select("tempid='" + hdntempid.Value + "'", ""); dt.Rows.Remove(dr[0]); if (hdnpersonalshowid.Value != "0") { PersonalData objper = new PersonalData(); objper.PersonalShowAssign_Delete(Convert.ToInt32(hdnpersonalshowid.Value)); } } } ViewState["temptable"] = dt; BindShow(); trfooter.Visible = false; } catch (Exception ex) { lblerrmsg.Text = "Error: " + ex.Message; } }
public void UpdateShowDetails(RepeaterItem ri) { TextBox txtassignmentdateE = (TextBox)ri.FindControl("txtassignmentdateE"); TextBox txtenddateE = (TextBox)ri.FindControl("txtenddateE"); DropDownList ddlshownameE = (DropDownList)ri.FindControl("ddlshownameE"); DropDownList ddlcurrentshowE = (DropDownList)ri.FindControl("ddlcurrentshowE"); HiddenField hdnPersonalAssignid = (HiddenField)ri.FindControl("hdnpersonalshowid"); HiddenField hdntempid = (HiddenField)ri.FindControl("hdntempid"); if (ddlshownameE.SelectedIndex > 0) { DataTable dt = new DataTable(); dt = (DataTable)ViewState["temptable"]; dt.Columns["assigndate"].ReadOnly = false; dt.Columns["enddate"].ReadOnly = false; dt.Columns["assignflagtext"].ReadOnly = false; dt.Columns["assignflag"].ReadOnly = false; IEnumerable<DataRow> rows = dt.Rows.Cast<DataRow>().Where(r => r["tempid"].ToString() == hdntempid.Value); rows.ToList().ForEach(r => r.SetField("showname", ddlshownameE.SelectedItem.Text)); rows.ToList().ForEach(r => r.SetField("assigndate", txtassignmentdateE.Text)); rows.ToList().ForEach(r => r.SetField("enddate", Convert.ToString(txtenddateE.Text))); rows.ToList().ForEach(r => r.SetField("assignflagtext", ddlcurrentshowE.SelectedItem.Text)); rows.ToList().ForEach(r => r.SetField("assignflag", ddlcurrentshowE.SelectedItem.Value)); ViewState["temptable"] = dt; if (hdnPersonalAssignid.Value != "0") { PersonalData objper = new PersonalData(); Int32 personalassignshowid; DateTime assigndate; Nullable<DateTime> enddate = null; string assingflag; personalassignshowid = Convert.ToInt32(ddlshownameE.SelectedItem.Value); assigndate = Convert.ToDateTime(txtassignmentdateE.Text); enddate = (txtenddateE.Text.ToString() != "") ? Convert.ToDateTime(txtenddateE.Text) : enddate; assingflag = Convert.ToString(ddlcurrentshowE.SelectedItem.Value); objper.PersonalShowAssign_Update(Convert.ToInt32(hdnPersonalAssignid.Value), Convert.ToInt32(hdnucpersonalid.Value), personalassignshowid, assigndate, enddate, assingflag); } BindShow(); } }