protected void GrdReferrerAdditionalEmails_RowUpdating(object sender, GridViewUpdateEventArgs e) { Label lblId = (Label)GrdReferrerAdditionalEmails.Rows[e.RowIndex].FindControl("lblId"); TextBox txtName = (TextBox)GrdReferrerAdditionalEmails.Rows[e.RowIndex].FindControl("txtName"); TextBox txtEmail = (TextBox)GrdReferrerAdditionalEmails.Rows[e.RowIndex].FindControl("txtEmail"); txtName.Text = txtName.Text.Trim(); txtEmail.Text = txtEmail.Text.Trim(); if (txtName.Text.Length == 0) { SetErrorMessage("Referrer Additional Emails - Name is required"); return; } if (txtEmail.Text.Length == 0) { SetErrorMessage("Referrer Additional Emails - Email is required"); return; } if (!Utilities.IsValidEmailAddress(txtEmail.Text)) { SetErrorMessage("Referrer Additional Emails - Invalid email address"); return; } ReferrerAdditionalEmailDB.Update(Convert.ToInt32(lblId.Text), txtName.Text, txtEmail.Text); GrdReferrerAdditionalEmails.EditIndex = -1; FillGrdReferrerAdditionalEmails(); }
protected void GrdReferrerAdditionalEmails_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("Insert")) { TextBox txtName = (TextBox)GrdReferrerAdditionalEmails.FooterRow.FindControl("txtNewName"); TextBox txtEmail = (TextBox)GrdReferrerAdditionalEmails.FooterRow.FindControl("txtNewEmail"); txtName.Text = txtName.Text.Trim(); txtEmail.Text = txtEmail.Text.Trim(); if (txtName.Text.Length == 0) { SetErrorMessage("Referrer Additional Emails - Name is required"); return; } if (txtEmail.Text.Length == 0) { SetErrorMessage("Referrer Additional Emails - Email is required"); return; } if (!Utilities.IsValidEmailAddress(txtEmail.Text)) { SetErrorMessage("Referrer Additional Emails - Invalid email address"); return; } Patient patient = PatientDB.GetByID(GetFormPTID()); ReferrerAdditionalEmailDB.Insert(patient.PatientID, txtName.Text, txtEmail.Text); FillGrdReferrerAdditionalEmails(); } if (e.CommandName.Equals("_Delete") || e.CommandName.Equals("_UnDelete")) { int referrer_additional_email_id = Convert.ToInt32(e.CommandArgument); try { if (e.CommandName.Equals("_Delete")) { ReferrerAdditionalEmailDB.UpdateDeleted(referrer_additional_email_id, Convert.ToInt32(ViewState["StaffID"])); } else { ReferrerAdditionalEmailDB.UpdateNotDeleted(referrer_additional_email_id); } } catch (ForeignKeyConstraintException fkcEx) { SetErrorMessage("Can not delete because other records depend on this" + (Utilities.IsDev() ? " : " + fkcEx.Message : "")); } FillGrdReferrerAdditionalEmails(); } }
protected void FillGrdReferrerAdditionalEmails() { try { GrdReferrerAdditionalEmails.Visible = true; Patient patient = PatientDB.GetByID(GetFormPTID()); lblHeading.Text = "Referrer Additional Emails For " + patient.Person.FullnameWithoutMiddlename; DataTable dt = ReferrerAdditionalEmailDB.GetDataTable_ByPatient(patient.PatientID, false); dt.DefaultView.Sort = "rae_name ASC"; dt = dt.DefaultView.ToTable(); ViewState["referreradditionalemail_data"] = dt; if (dt.Rows.Count > 0) { if (IsPostBack && ViewState["referreradditionalemail_sortexpression"] != null && ViewState["referreradditionalemail_sortexpression"].ToString().Length > 0) { DataView dataView = new DataView(dt); dataView.Sort = ViewState["referreradditionalemail_sortexpression"].ToString(); GrdReferrerAdditionalEmails.DataSource = dataView; } else { GrdReferrerAdditionalEmails.DataSource = dt; } GrdReferrerAdditionalEmails.DataBind(); } else { dt.Rows.Add(dt.NewRow()); GrdReferrerAdditionalEmails.DataSource = dt; GrdReferrerAdditionalEmails.DataBind(); int TotalColumns = GrdReferrerAdditionalEmails.Rows[0].Cells.Count; GrdReferrerAdditionalEmails.Rows[0].Cells.Clear(); GrdReferrerAdditionalEmails.Rows[0].Cells.Add(new TableCell()); GrdReferrerAdditionalEmails.Rows[0].Cells[0].ColumnSpan = TotalColumns; GrdReferrerAdditionalEmails.Rows[0].Cells[0].Text = "No Additional Emails Added Yet"; } } catch (CustomMessageException ex) { SetErrorMessage(ex.ToString()); } catch (Exception ex) { SetErrorMessage("", Utilities.IsDev() ? ex.ToString() : ex.Message); } }