public void DeleteData(string flag) { PresenterData objpres = new PresenterData(); Int32 presenterid = Convert.ToInt32(hdnpresenterid.Value); string msg = objpres.Presenter_Delete(presenterid, flag); if (msg == "") { divmsg.InnerHtml = (flag == "n") ? "Record deleted successfully!" : "Record undeleted successfully!"; (this.Master as Site1).show_control(flag, pnlpresenter); } else { lblerrmsg.Text = msg; } }
public static List<string> Getpresentername(string prefixText) { PresenterData objpres = new PresenterData(); List<string> Presentername = objpres.SearchPresentername(prefixText, "Y"); return Presentername; }
public void SaveData() { CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture; TextInfo textInfo = cultureInfo.TextInfo; string presentername = "", presenterstreet = "", notes = "", zip; Nullable<Int32> cityid = null; presentername = textInfo.ToTitleCase(txtpresentername.Text.Trim()); TextBox txtaddress = (TextBox)uccity.FindControl("txtaddress"); presenterstreet = textInfo.ToTitleCase(txtaddress.Text.Trim()); notes = txtnotes.Text.Trim(); cityid = uccity.InsertCitydetails(); PresenterData objpres = new PresenterData(); Int32 presenterid = 0; //zip = (uccity.FindControl("txtzipcode") as TextBox).Text; zip = uccity.Get_child_zipcode(); //string msg = ""; if (string.IsNullOrEmpty(Request.QueryString["presenterid"])) { if (hdnpresenterid.Value == "0") { presenterid = objpres.PresenterDetails_Insert(presentername, presenterstreet, cityid, notes, zip); if (presenterid == 0) { lblerrmsg.Text = "Presenter already exists!"; } else { hdnpresenterid.Value = presenterid.ToString(); uccontactperson.SavePresenterContactPerson(presenterid); ucdocx.SaveDocx(presenterid, "PRESENTER"); if (Convert.ToString(ViewState["status"]) == "") Response.Redirect("~/presenter.aspx?presenterid=" + presenterid.ToString() + "&type=I"); } } else { lblerrmsg.Text = "Presenter already exists!"; } } else if (!string.IsNullOrEmpty(Request.QueryString["presenterid"])) { presenterid = Convert.ToInt32(Request.QueryString["presenterid"]); hdnpresenterid.Value = presenterid.ToString(); int existid = 0; existid = objpres.PresenterDetails_Update(presenterid, presentername, presenterstreet, cityid, notes, zip); if (existid == 0) { uccontactperson.SavePresenterContactPerson(presenterid); ucdocx.SaveDocx(presenterid, "PRESENTER"); if (Convert.ToString(ViewState["status"]) == "") divmsg.InnerHtml = "Records updated successfully!"; uccontactperson.showhidefooter(false); } else { lblerrmsg.Text = "Presenter already exist!"; } } }
public static List<string> Getphone(string prefixText, string contextKey) { PresenterData objpres = new PresenterData(); List<string> personal = objpres.searchpersonal(contextKey, prefixText, "P", "Y"); return personal; }
public void LoadContactpersondetails(Int32 presenterid) { hdntype.Value = "PRESENTER"; hdnpresenterid.Value = presenterid.ToString(); hdnvenueid.Value = "0"; PresenterData objpres = new PresenterData(); DataTable dt = objpres.GetPresenterPersonalDetails(presenterid); 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; bindcontactperson(); showhidefooter(false); }
public void loadpresenterdetails() { try { Int32 presenterid = Convert.ToInt32(hdnpresenterid.Value); PresenterData objpres = new PresenterData(); DataTable dt = objpres.GetPresenterDetails(presenterid); if (dt.Rows.Count > 0) { lblHeader.Visible = true; lblHeader.Text= dt.Rows[0]["PRESENTER_NAME"].ToString(); txtpresentername.Text = dt.Rows[0]["PRESENTER_NAME"].ToString(); txtnotes.Text = dt.Rows[0]["PRESENTER_NOTES"].ToString(); (uccity.FindControl("txtzipcode") as TextBox).Text = dt.Rows[0]["zip"].ToString().Trim(); string City_Zip = dt.Rows[0]["zip"].ToString(); uccity.fillcitydetails(Convert.ToInt32(dt.Rows[0]["PRESENTER_CITY_ID"]), dt.Rows[0]["PRESENTER_STREET"].ToString(), City_Zip); string active_flag = dt.Rows[0]["PRESENTER_ACTIVE_FLAG"].ToString(); string beast_flag = dt.Rows[0]["presenter_beast_flag"].ToString(); (this.Master as Site1).show_control(active_flag, pnlpresenter, beast_flag); if (!string.IsNullOrEmpty(Request.QueryString["presenterid"])) { ucdocx.GetDocxDetails(presenterid, "PRESENTER"); uccontactperson.LoadContactpersondetails(presenterid); uccontactperson.showhidefooter(false); } } } catch (Exception ex) { lblerrmsg.Text = "Error: " + ex.Message.ToString(); lblerrmsg.ForeColor = System.Drawing.Color.Red; } }
//protected void ddltitle_SelectedIndexChanged(object sender, EventArgs e) //{ // DropDownList ddlfirstname = (DropDownList)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("ddlfirstname"); // DropDownList ddltitle = (DropDownList)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("ddltitle"); // 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"); // TextBox txtfirstname = (TextBox)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("txtfirstname"); // DropDownList ddllastname = (DropDownList)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("ddllastname"); // AjaxControlToolkit.AutoCompleteExtender acefirstname = (AjaxControlToolkit.AutoCompleteExtender)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("acefirstname"); // acefirstname.ContextKey = ddltitle.SelectedValue; // txtfirstname.Text = string.Empty; // ListItem li = ddllastname.Items[0]; // ddllastname.Items.Clear(); // ddllastname.Items.Add(li); // lblfax.Text = string.Empty; // lblemail.Text = string.Empty; // lblphone.Text = string.Empty; // loadPersonalFirstName(); //} protected void txtfirstname_TextChanged(object sender, EventArgs e) { DropDownList ddllastname = (DropDownList)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("ddllastname"); TextBox txtfirstname = (TextBox)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("txtfirstname"); ddllastname.Focus(); PresenterData objpres = new PresenterData(); DataTable dt = objpres.GetPersonalName(txtfirstname.Text, "", "L", "Y"); CommonFun objcf = new CommonFun(); objcf.FillDropDownList(ddllastname, dt, "PERSONAL_FNAME", "PERSONAL_ID"); if (dt.Rows.Count == 1) { ddllastname.SelectedIndex = 1; hdnfirstnameid.Value = ddllastname.SelectedItem.Value; loadphonedetails(); setneweditlink(); } setneweditlink(); }
public void SavePresenterContactPerson(Int32 presenterid) { 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"]); PresenterData objpres = new PresenterData(); objpres.PresenterContactperson_Insert(presenterid, personalid); } } } }
public void loadPersonalLastName() { DropDownList ddlfirstname = (DropDownList)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("ddlfirstname"); DropDownList ddllastname = (DropDownList)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("ddllastname"); PresenterData objpres = new PresenterData(); DataTable dt = objpres.GetPersonalName(ddlfirstname.SelectedItem.Text, "", "L", "Y"); CommonFun objcf = new CommonFun(); objcf.FillDropDownList(ddllastname, dt, "PERSONAL_FNAME", "PERSONAL_ID"); if (dt.Rows.Count == 1) { ddllastname.SelectedIndex = 1; hdnfirstnameid.Value = ddllastname.SelectedItem.Value; } loadphonedetails(); ddllastname.Focus(); }
public void loadPersonalFirstName() { //DropDownList ddltitle = (DropDownList)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("ddltitle"); DropDownList ddlfirstname = (DropDownList)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("ddlfirstname"); PresenterData objpres = new PresenterData(); dt = objpres.GetPersonalName(null, "", "F", "Y"); objcf.FillDropDownList(ddlfirstname, dt, "PERSONAL_FNAME", "PERSONAL_ID"); }
public static List<string> Getpersonalname(string prefixText) { PresenterData objpres = new PresenterData(); List<string> personal = objpres.searchpersonal("", prefixText, "F", "Y"); return personal; }