/// <summary> /// Gets triggered when the user clicks on delete button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdWebsites_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { //Get the list of websites List<Website> websites = (List<Website>)Session["Websites"]; Website websiteToDelete = null; DBUtility dbUtility = new DBUtility(); String dbName = Configurations.DatabaseName; String tableName = Configurations.Websites; //Get the website which has to be deleted websiteToDelete = websites[e.RowIndex]; if (!dbUtility.Delete(dbName, tableName, websiteToDelete)) throw new Exception("Error while deleting"); //Bind the data again BindData(); } catch (Exception ex) { DisplayMessage("Unable to delete the website"); Logger.Log("grdWebsites_RowDeleting: " + ex.Message); } }
/// <summary> /// Binds the data to UI /// </summary> private void BindData() { try { //Declarations DBUtility dbUtility = new DBUtility(); Person person; String[] phone; String tableName, dataBaseName; //Get the table name and datatbase name from the configuration file tableName = Configurations.TableName; dataBaseName = Configurations.DatabaseName; drpMonth.CssClass = "input-success"; //Bind the days drpDay.DataSource = Utility.GetTableData(1, 31); drpDay.DataBind(); drpDay.CssClass = "input-success"; //Bind the years drpYear.DataSource = Utility.GetTableData(1900, 1996); drpYear.DataBind(); drpYear.CssClass = "input-success"; //Get the person data person = dbUtility.getData(dataBaseName, tableName, lblName.Text); //Check if the person has a data or it has been configured not to display the PII if (person == null || !Configurations.DisplayPII) return; //Set the birth dates drpMonth.SelectedValue = person.MonthOfBirth; drpMonth.CssClass = "input-success"; drpDay.SelectedValue = person.DayOfBirth; drpDay.CssClass = "input-success"; drpYear.SelectedValue = person.YearOfBirth; drpYear.CssClass = "input-success"; //Bind the personal information txtName.Text = person.FullName; txtName.CssClass = "input-success"; txtCity.Text = person.City; txtCity.CssClass = "input-success"; txtEmail.Text = person.EmailAddress; txtEmail.CssClass = "input-success"; txtSpouse.Text = person.SpouseName; txtSpouse.CssClass = "input-success"; txtState.Text = person.State; txtState.CssClass = "input-success"; txtStreet.Text = person.StreetAddress; txtStreet.CssClass = "input-success"; txtZip.Text = person.Zip; txtZip.CssClass = "input-success"; txtCurrentEmployer.Text = Utility.AppendWithComma(person.CurrentEmployers); txtCurrentEmployer.CssClass = "input-success"; txtPastEmployer.Text = Utility.AppendWithComma(person.PastEmployers); txtPastEmployer.CssClass = "input-success"; txtChildren.Text = Utility.AppendWithComma(person.Children); txtChildren.CssClass = "input-success"; txtGrandChildren.Text = Utility.AppendWithComma(person.GrandChildren); txtGrandChildren.CssClass = "input-success"; //Populate the phone phone = person.PhoneNumber.Split(new Char[] { '-' }); txtPhone1.Text = phone[0]; txtPhone1.CssClass = "input-success"; txtPhone2.Text = phone[1]; txtPhone2.CssClass = "input-success"; txtPhone3.Text = phone[2]; txtPhone3.CssClass = "input-success"; lblUpdatedOn.Text = "Last updated on: " + person.LastUpdatedOn ; } catch (Exception ex) { Logger.Log("BindData: " + ex.Message); } }
/// <summary> /// Persists the user PII data to the database /// </summary> private void PersistData() { try { Person person; Char[] splitter = new Char[] { ',' }; String tableName, dataBaseName; //Get the table name and datatbase name from the configuration file tableName = Configurations.TableName; dataBaseName = Configurations.DatabaseName; //Check if the data is valid if (!ValidateData()) return; person = new Person { Volunteer = lblName.Text.Trim(), Children = txtChildren.Text.Trim().Split(splitter), GrandChildren = txtGrandChildren.Text.Trim().Split(splitter), City = txtCity.Text, CurrentEmployers = txtCurrentEmployer.Text.Trim().Split(splitter), MonthOfBirth = drpMonth.SelectedValue, DayOfBirth = drpDay.SelectedValue, YearOfBirth = drpYear.SelectedValue, EmailAddress = txtEmail.Text.Trim(), FullName = txtName.Text.Trim(), PastEmployers = txtPastEmployer.Text.Trim().Split(splitter), PhoneNumber = txtPhone1.Text.Trim() + "-" + txtPhone2.Text.Trim() + "-" + txtPhone3.Text.Trim(), SpouseName = txtSpouse.Text.Trim(), State = txtState.Text.Trim(), StreetAddress = txtStreet.Text.Trim(), Zip = txtZip.Text.Trim(), LastUpdatedOn = DateTime.Now.ToShortDateString() }; //Insert the data to database DBUtility dbUtility = new DBUtility(); dbUtility.UpdateData(dataBaseName, tableName, person); DisplayMessage("Successfully updated your data"); } catch (Exception ex) { DisplayMessage("Unable to update your data"); Logger.Log("PersistData: " + ex.Message); } }
/// <summary> /// Binds the data to the grid view /// </summary> private void BindData() { try { //Declarations DBUtility dbUtility = new DBUtility(); String dbName = Configurations.DatabaseName; String tableName = Configurations.Websites; List<Website> websites; //Bind the grid view grdWebsites.DataSource = dbUtility.getData(dbName, tableName, out websites); grdWebsites.DataBind(); //Add the list to session Session.Add("Websites", websites ?? new List<Website>()); } catch (Exception ex) { Logger.Log("BindData: " + ex.Message); } }
/// <summary> /// Persists the website data to the database /// </summary> private void PersistData() { //Declaratoins DBUtility dbUtility = new DBUtility(); String dbName = Configurations.DatabaseName; String tableName = Configurations.Websites; try { //Check if the data is valid if (!ValidateData()) return; Website website = new Website(); website.Name = txtName.Text; website.URL = txtURL.Text; website.IsActive = true; website.LastUpdatedOn = DateTime.Now.ToShortDateString(); //Update the data dbUtility.UpdateData(dbName, tableName, website); //Clear the textboxes txtName.Text = String.Empty; txtURL.Text = String.Empty; } catch (Exception ex) { DisplayMessage("Unable to update your data"); Logger.Log("PersistData: " + ex.Message); } }