private DataSet loadPerson(int id) { DataSet ds = new DataSet(); BusinessObjects.Person person = new BusinessObjects.Person(id); person.Fetch(id); lblFirstName.Text = person.FirstName.ToString(); lblLastName.Text = person.LastName.ToString(); return(ds); }
private DataSet loadPerson(int id) { DataSet ds = new DataSet(); BusinessObjects.Person person = new BusinessObjects.Person(id); person.Fetch(id); lblFirstName.Text = person.FirstName.ToString(); lblLastName.Text = person.LastName.ToString(); return ds; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["Mode"] == null) { Request.QueryString["Mode"] = "New"; //Response.Redirect("AddressForm.aspx?Mode=Edit"); } if (Request.QueryString["PersonID"] != null) { txtID.Text = Request.QueryString["PersonID"].ToString(); } if (Request.QueryString["emailAddressID"] != null) { txtEAID.Text = Request.QueryString["emailAddressID"].ToString(); } if (Request.QueryString != null) { string mode = Request.QueryString["Mode"]; switch (mode) { case "View": break; case "New": btnSave.Visible = true; txtID.Enabled = false; break; case "Edit": btnSave.Visible = true; txtID.Enabled = false; btnDelete.Visible = false; BusinessObjects.Person person = new BusinessObjects.Person(); //// DataPortal.PersonData pd = new DataPortal.PersonData(); DataSet pds = new DataSet(); int id = Convert.ToInt32(txtID.Text); person.Fetch(id); lblFirstName.Text = person.FirstName; lblLastName.Text = person.LastName; int PersonID = Convert.ToInt32(txtID.Text); //I need to do a fetch to select all from email addreaa where EmailAddressID = @EmailAddressID BusinessObjects.EmailAddress email = new BusinessObjects.EmailAddress(); int EmailAddressID = Convert.ToInt32(txtEAID.Text); DataSet ds = new DataSet(); ds = email.Load(EmailAddressID); // txtAddress.Text = email.Address.ToString(); txtAddress.Text = ds.Tables[0].Rows[0]["Address"].ToString(); //txtEAID.Text = email.EmailAddressID.ToString(); // email.EmailAddressID = Convert.ToInt32(txtEAID.Text); // txtAddress.Text = email.Address.ToString(); //// pds = pd.Fetch(PersonID); //object fn = pds.Tables[0].Rows[0]["FirstName"].ToString(); //object ln = pds.Tables[0].Rows[0]["LastName"].ToString(); //lblFirstName.Text = fn.ToString(); //lblLastName.Text = ln.ToString(); ////DataPortal.EmailAddressesData ead = new DataPortal.EmailAddressesData(); //// string Address = txtAddress.Text; //// object eaid = ds.Tables[0].Rows[0]["EmailAddressID"].ToString(); //// object a = ds.Tables[0].Rows[0]["Address"].ToString(); ////object pid = ds.Tables[0].Rows[0]["PersonID"].ToString(); // object id = ds.Tables[0].Rows[0]["IsDeleted"].ToString(); break; case "Delete": btnSave.Visible = false; txtID.Enabled = false; btnDelete.Visible = true; email = new BusinessObjects.EmailAddress(); EmailAddressID = Convert.ToInt32(txtEAID.Text); ds = email.Load(EmailAddressID); // txtAddress.Text = email.Address.ToString(); txtAddress.Text = ds.Tables[0].Rows[0]["Address"].ToString(); ////// PersonID = Convert.ToInt32(txtID.Text); ////// ead = new DataPortal.EmailAddressesData(); //////ds = ead.Fetch(PersonID); //////a = ds.Tables[0].Rows[0]["Address"].ToString(); // object id = ds.Tables[0].Rows[0]["IsDeleted"].ToString(); // txtIsDeleted.Text = id.ToString(); ////txtAddress.Text = a.ToString(); // btnSave.Visible = false; // txtID.Enabled = false; // btnDelete.Visible = true; // pd = new DataPortal.PersonData(); // pds = new DataSet(); // PersonID = Convert.ToInt32(txtID.Text); // pds = pd.Fetch(PersonID); // fn = pds.Tables[0].Rows[0]["FirstName"].ToString(); //ln = pds.Tables[0].Rows[0]["LastName"].ToString(); // lblFirstName.Text = fn.ToString(); // lblLastName.Text = ln.ToString(); //int EmailAddressID = Convert.ToInt32(txtEAID.Text); // Address = txtAddress.Text; // eaid = pds.Tables[0].Rows[0]["EmailAddressID"].ToString(); // a = pds.Tables[0].Rows[0]["Address"].ToString(); // pid = pds.Tables[0].Rows[0]["PersonID"].ToString(); // txtEAID.Text = eaid.ToString(); // txtAddress.Text = a.ToString(); break; } } if (txtID.Text != "") { if (txtEAID.Text == null) { BusinessObjects.Person person = new BusinessObjects.Person(); person.id = Convert.ToInt32(txtID.Text); lblFirstName.Text = person.FirstName.ToString(); lblLastName.Text = person.LastName.ToString(); //////int PersonID = Convert.ToInt32(txtID.Text); //////pds = pd.Fetch(PersonID); //////object fn = pds.Tables[0].Rows[0]["FirstName"].ToString(); //////object ln = pds.Tables[0].Rows[0]["LastName"].ToString(); //////lblFirstName.Text = fn.ToString(); //////lblLastName.Text = ln.ToString(); //// DataPortal.EmailAddressesData ead = new DataPortal.EmailAddressesData(); BusinessObjects.EmailAddress email = new BusinessObjects.EmailAddress(); email.EmailAddressID = Convert.ToInt32(txtEAID.Text); //////DataSet ds = new DataSet(); //////int EmailAddressID = Convert.ToInt32(txtEAID.Text); //////ds = ead.Fetch(PersonID); // int emailAddressID = Convert.ToInt32(txtEAID.Text); // String Address = txtAddress.Text; //////object eaid = ds.Tables[0].Rows[0]["EmailAddressID"].ToString(); //////object a = ds.Tables[0].Rows[0]["Address"].ToString(); //////object pid = ds.Tables[0].Rows[0]["PersonID"].ToString(); txtEAID.Text = email.EmailAddressID.ToString(); txtAddress.Text = email.Address.ToString(); } } } }
protected void btnSave_Click(object sender, EventArgs e) { ///// DataPortal.PersonPhoneData ppd = new DataPortal.PersonPhoneData(); BusinessObjects.PersonPhone pp = new BusinessObjects.PersonPhone(); BusinessObjects.Phone ph = new BusinessObjects.Phone(); BusinessObjects.Person person = new BusinessObjects.Person(); DataSet ds = new DataSet(); switch (Request.QueryString["Mode"]) { case "Edit": // pp = new BusinessObjects.PersonPhone(); pp.PhoneID = Convert.ToInt32(txtPHID.Text); pp.AreaCode = txtAreaCode.Text; pp.PhoneNumber = txtPhoneNumber.Text; pp.Extension = txtExtension.Text; if (ddlPhoneTypeID.SelectedIndex == 0) { ddlPhoneTypeID.SelectedIndex = 1; } pp.PhoneTypeID = Convert.ToInt32(ddlPhoneTypeID.Text); /// change this to ddlPHoneTypeID // object pid = ph.Save(); BusinessObjects.PersonPhone p = new BusinessObjects.PersonPhone(); pp.PersonID = Convert.ToInt32(lblID.Text); pp.Description = txtDescription.Text; pp.Notes = txtNotes.Text; pp.DoNotCall = cbDNC.Checked; pp.DoNotText = cbDNT.Checked; // PhoneID = Convert.ToInt32(pid.ToString()); int PhoneID = Convert.ToInt32(txtPHID.Text); pp.SavePhone(); // pp.PhoneTypeID = Convert.ToInt32(ddlPhoneTypeID.Text); txtPHTID.Enabled = false; // pp.PhoneID = Convert.ToInt32(txtPHID.Text); // pp.AreaCode = txtAreaCode.Text; // pp.PhoneNumber = txtPhoneNumber.Text; // pp.Extension = txtExtension.Text; // pp.PersonID = Convert.ToInt32(txtID.Text); // if (ddlPhoneTypeID.SelectedIndex == 0) // { // ddlPhoneTypeID.SelectedIndex = 1; // } // pp.PhoneTypeID = Convert.ToInt32(ddlPhoneTypeID.Text); // if (cbDNC.Checked == false) // { // cbDNC.Checked = false; // } // if (cbDNC.Checked == true) // { // cbDNC.Checked = true; // } // if (cbDNT.Checked == false) // { // cbDNT.Checked = false; // } // if (cbDNT.Checked == true) // { // cbDNT.Checked = true; // } // pp.Description = txtDescription.Text; // pp.Notes = txtNotes.Text; //pp.DoNotCall = cbDNC.Checked; //pp.DoNotText = cbDNT.Checked; //int id = Convert.ToInt32(lblID.Text); //int PhoneID = Convert.ToInt32(txtPHID.Text); //pp.Save(); /////// ppd.UpdatePhoneNumber(PhoneID, AreaCode, PhoneNumber, Extension, PhoneTypeID); //////// ppd.UpdatePersonPhones(PersonID, PhoneID, Description, Notes, DoNotCall, DoNotText); break; case "New": //first, try setting all of the values, and then calling the base //.save on the PersonPhone, that will save the base, and the PersonPhones table as well?? pp.AreaCode = txtAreaCode.Text; pp.PhoneNumber = txtPhoneNumber.Text; pp.Extension = txtExtension.Text; pp.PhoneTypeID = Convert.ToInt32(ddlPhoneTypeID.Text); /// change this to ddlPHoneTypeID // object pid = ph.Save(); // BusinessObjects.PersonPhone p = new BusinessObjects.PersonPhone(); // pp.PersonID = Convert.ToInt32(lblID.Text); // pp.PhoneID = Convert.ToInt32(pid); //pp.phoneID = pp.PersonID = Convert.ToInt32(lblID.Text); pp.Description = txtDescription.Text; pp.Notes = txtNotes.Text; pp.DoNotCall = cbDNC.Checked; pp.DoNotText = cbDNT.Checked; // PhoneID = Convert.ToInt32(pid.ToString()); pp.SavePhone(); pp.AreaCode = txtAreaCode.Text; pp.PhoneNumber = txtPhoneNumber.Text; pp.Extension = txtExtension.Text; ph.PhoneNumber = txtPhoneNumber.Text; if (ddlPhoneTypeID.SelectedIndex == 0) { ddlPhoneTypeID.SelectedIndex = 1; } // pp.PhoneTypeID = Convert.ToInt32(ddlPhoneTypeID.Text); txtPHTID.Enabled = false; break; } int x = Convert.ToInt32(txtID.Text); Response.Redirect("WebForm1.aspx?PersonID=" + x + ""); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataManager.DataAccess da = new DataManager.DataAccess(); DataSet dsPhoneTypes = da.FetchPhoneTypes(); ddlPhoneTypeID.DataSource = dsPhoneTypes.Tables[0]; // ddlPhoneTypeID.Items.Add(New ListItem("", "")); ddlPhoneTypeID.DataTextField = "Name"; ddlPhoneTypeID.DataValueField = "PhoneTypeID"; ddlPhoneTypeID.DataBind(); // ddlPhoneTypeID.Items.Add(new ListItem("Please Select Phone Type", "")); ddlPhoneTypeID.Items.Insert(0, new ListItem("PLEASE SELECT PHONE TYPE", string.Empty)); // DataPortal.PersonPhoneData ppd = new DataPortal.PersonPhoneData(); BusinessObjects.PersonPhone pp = new BusinessObjects.PersonPhone(); DataSet ds2 = new DataSet(); if (Request.QueryString["Mode"] == null) { Request.QueryString["Mode"] = "New"; } if (Request.QueryString["PersonID"] != null) { txtID.Text = Request.QueryString["PersonID"].ToString(); lblID.Text = Request.QueryString["PersonID"].ToString(); } if (Request.QueryString["phoneID"] != null) { txtPHID.Text = Request.QueryString["phoneID"].ToString(); } if (Request.QueryString != null) { string mode = Request.QueryString["Mode"]; switch (mode) { case "View": break; case "New": btnSave.Visible = true; txtID.Enabled = false; txtPHTID.Visible = false; btnDelete.Visible = false; break; case "Edit": btnSave.Visible = true; txtID.Enabled = false; int id = Convert.ToInt32(txtID.Text); BusinessObjects.Person person = new BusinessObjects.Person(id); DataSet ds = new DataSet(); // id = Convert.ToInt32(txtID.ToString()); person.Fetch(id); person.id = id; object t = person.Title.ToString(); object fn = person.FirstName.ToString(); object ln = person.LastName.ToString(); lblFirstName.Text = fn.ToString(); lblLastName.Text = ln.ToString(); int PhoneID = Convert.ToInt32(txtPHID.Text); BusinessObjects.PersonPhone personPhone = new BusinessObjects.PersonPhone(id, PhoneID); id = Convert.ToInt32(lblID.Text); int PersonID = id; ds = personPhone.Fetch(PersonID, PhoneID); // object pid = personPhone.PhoneID.ToString(); // object ac = personPhone.AreaCode.ToString(); object ac = ds.Tables[0].Rows[0]["AreaCode"].ToString(); object pn = ds.Tables[0].Rows[0]["PhoneNumber"].ToString(); object ex = ds.Tables[0].Rows[0]["Extension"].ToString(); object d = ds.Tables[0].Rows[0]["Description"].ToString(); object n = ds.Tables[0].Rows[0]["Notes"].ToString(); object ptid = ds.Tables[0].Rows[0]["PhoneTypeID"].ToString(); txtAreaCode.Text = ac.ToString(); txtPhoneNumber.Text = pn.ToString(); txtExtension.Text = ex.ToString(); txtDescription.Text = d.ToString(); txtNotes.Text = n.ToString(); txtPHTID.Text = ptid.ToString(); ddlPhoneTypeID.Text = ptid.ToString(); object dc = ds.Tables[0].Rows[0]["DoNotCall"].ToString(); object dt = ds.Tables[0].Rows[0]["DoNotText"].ToString(); cbDNT.Checked = Convert.ToBoolean(dt.ToString()); cbDNC.Checked = Convert.ToBoolean(dc.ToString()); btnDelete.Visible = false; // txtDescription.Text = d.ToString(); // txtNotes.Text = n.ToString(); // cbDNT.Checked = Convert.ToBoolean(dt.ToString()); // cbDNC.Checked = Convert.ToBoolean(dc.ToString()); // // ddlPhoneTypeID.SelectedIndex = 0; // btnDelete.Visible = false; //First create a DataSet that returns, equals person.Fetch(PersonID) as /////////////////////////////////OLD CODE Start // DataPortal.PersonData pd = new DataPortal.PersonData(); // DataSet pds = new DataSet(); // O int PersonID = Convert.ToInt32(txtID.Text); /// // L pds = pd.Fetch(PersonID); // D object fn = pds.Tables[0].Rows[0]["FirstName"].ToString(); // object ln = pds.Tables[0].Rows[0]["LastName"].ToString(); // C lblFirstName.Text = fn.ToString(); /// // O lblLastName.Text = ln.ToString(); /// //D // E ppd = new DataPortal.PersonPhoneData(); // DataSet ds = new DataSet(); // int PhoneID = Convert.ToInt32(txtPHID.Text); /// // ds = ppd.Fetch(PersonID, PhoneID); // object pid = ds.Tables[0].Rows[0]["PhoneID"].ToString(); // object ac = ds.Tables[0].Rows[0]["AreaCode"].ToString(); // object pn = ds.Tables[0].Rows[0]["PhoneNumber"].ToString(); // object ex = ds.Tables[0].Rows[0]["Extension"].ToString(); // object ptid = ds.Tables[0].Rows[0]["PhoneTypeID"].ToString(); // txtPHID.Text = pid.ToString(); // txtAreaCode.Text = ac.ToString(); // txtPhoneNumber.Text = pn.ToString(); // txtExtension.Text = ex.ToString(); // txtPHTID.Text = ptid.ToString(); // txtPHTID.Visible = false; // ddlPhoneTypeID.Text = ptid.ToString(); // object d = ds.Tables[0].Rows[0]["Description"].ToString(); // object n = ds.Tables[0].Rows[0]["Notes"].ToString(); // object dc = ds.Tables[0].Rows[0]["DoNotCall"].ToString(); // object dt = ds.Tables[0].Rows[0]["DoNotText"].ToString(); // txtDescription.Text = d.ToString(); // txtNotes.Text = n.ToString(); // cbDNT.Checked = Convert.ToBoolean(dt.ToString()); // cbDNC.Checked = Convert.ToBoolean(dc.ToString()); // // ddlPhoneTypeID.SelectedIndex = 0; // btnDelete.Visible = false; /////////////////////////////////////////OLD CODE Stop break; case "Delete": btnSave.Visible = false; txtID.Enabled = true; btnSave.Visible = true; txtID.Enabled = false; id = Convert.ToInt32(txtID.Text); person = new BusinessObjects.Person(id); ds = new DataSet(); // id = Convert.ToInt32(txtID.ToString()); person.Fetch(id); person.id = id; t = person.Title.ToString(); fn = person.FirstName.ToString(); ln = person.LastName.ToString(); lblFirstName.Text = fn.ToString(); lblLastName.Text = ln.ToString(); PhoneID = Convert.ToInt32(txtPHID.Text); personPhone = new BusinessObjects.PersonPhone(id, PhoneID); id = Convert.ToInt32(lblID.Text); PersonID = id; ds = personPhone.Fetch(PersonID, PhoneID); // object pid = personPhone.PhoneID.ToString(); // object ac = personPhone.AreaCode.ToString(); ac = ds.Tables[0].Rows[0]["AreaCode"].ToString(); pn = ds.Tables[0].Rows[0]["PhoneNumber"].ToString(); ex = ds.Tables[0].Rows[0]["Extension"].ToString(); d = ds.Tables[0].Rows[0]["Description"].ToString(); n = ds.Tables[0].Rows[0]["Notes"].ToString(); ptid = ds.Tables[0].Rows[0]["PhoneTypeID"].ToString(); txtAreaCode.Text = ac.ToString(); txtPhoneNumber.Text = pn.ToString(); txtExtension.Text = ex.ToString(); txtDescription.Text = d.ToString(); txtNotes.Text = n.ToString(); txtPHTID.Text = ptid.ToString(); ddlPhoneTypeID.Text = ptid.ToString(); dc = ds.Tables[0].Rows[0]["DoNotCall"].ToString(); dt = ds.Tables[0].Rows[0]["DoNotText"].ToString(); cbDNT.Checked = Convert.ToBoolean(dt.ToString()); cbDNC.Checked = Convert.ToBoolean(dc.ToString()); btnDelete.Visible = true; btnSave.Visible = false; disableForm(); ////// pd = new DataPortal.PersonData(); //////pds = new DataSet(); //////PersonID = Convert.ToInt32(txtID.Text); //Fix later //////pds = pd.Fetch(PersonID); ////// fn = pds.Tables[0].Rows[0]["FirstName"].ToString(); //////ln = pds.Tables[0].Rows[0]["LastName"].ToString(); //////lblFirstName.Text = fn.ToString(); //////lblLastName.Text = ln.ToString(); //////ds = new DataSet(); ////// PhoneID = Convert.ToInt32(txtPHID.Text); //////ds = ppd.Fetch(PersonID, PhoneID); ////// pid = ds.Tables[0].Rows[0]["PhoneID"].ToString(); ////// ac = ds.Tables[0].Rows[0]["AreaCode"].ToString(); ////// pn = ds.Tables[0].Rows[0]["PhoneNumber"].ToString(); ////// ex = ds.Tables[0].Rows[0]["Extension"].ToString(); ////// ptid = ds.Tables[0].Rows[0]["PhoneTypeID"].ToString(); //txtPHID.Text = pid.ToString(); //txtAreaCode.Text = ac.ToString(); //txtPhoneNumber.Text = pn.ToString(); //txtExtension.Text = ex.ToString(); //txtPHTID.Text = ptid.ToString(); //txtPHTID.Visible = false; //ddlPhoneTypeID.Text = ptid.ToString(); //txtAreaCode.Enabled = false; //txtPhoneNumber.Enabled = false; //txtExtension.Enabled = false; //txtPHTID.Enabled = false; //ddlPhoneTypeID.Enabled = false; //cbDNC.Enabled = false; //cbDNT.Enabled = false; //txtDescription.Enabled = false; //txtNotes.Enabled = false; // d = ds.Tables[0].Rows[0]["Description"].ToString(); // n = ds.Tables[0].Rows[0]["Notes"].ToString(); // dc = ds.Tables[0].Rows[0]["DoNotCall"].ToString(); //dt = ds.Tables[0].Rows[0]["DoNotText"].ToString(); //txtDescription.Text = d.ToString(); //txtNotes.Text = n.ToString(); //cbDNT.Checked = Convert.ToBoolean(dt.ToString()); //cbDNC.Checked = Convert.ToBoolean(dc.ToString()); break; } } } }