public List<Patient_Contact> GetDashBoardContacts(long PatientID) { dl = new DataLayer(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Portal_GetDashBoardContacts"; cmd.Parameters.AddWithValue("PatientID", PatientID); List<Patient_Contact> contacts = new List<Patient_Contact>(); DataTable dt = dl.Execute(cmd); foreach (DataRow dr in dt.Rows) { Patient_Contact contact = new Patient_Contact { ID = Int64.Parse(dr["ID"].ToString()), ContactName = dr["ContactName"].ToString(), ContactType = dr["ContactType"].ToString(), ContactPhoneNumber = dr["PhoneNumber"].ToString(), Emergency = bool.Parse(dr["Emergency"].ToString()) }; contacts.Add(contact); } return contacts; }
protected void Submitlogin_Click(object sender, EventArgs e) { var id = Request.QueryString["id"]; if (!string.IsNullOrEmpty(id)) { Patient_Contact contact = new Patient_Contact { PatientID = long.Parse(id.ToString()), ContactName = txtContactName.Text, EmailAddress = txtContactEmailAddress.Text, Emergency = chkEmergency.Checked, ContactPhoneNumber = txtPhone.Text, ContactPhoneType = drpContactPhoneType.SelectedValue, Street = txtContactStreet.Text, Suite = txtContactSuiteApt.Text, City = txtContactCity.Text, State = drpContactState.SelectedValue, ZipCode = txtContactZipCode.Text, Country = drpCoontactCountry.SelectedValue, Password = txtPassword.Text, ContactType = drpContactType.SelectedValue }; int status = controller.Portal_SavePatientContact(contact, HttpContext.Current.Session["email"].ToString()); if (status == 1) { //email exists Helper.DisplayAlert(this, "patient contact with the entered email already exists!, record was not saved."); } if (status == 0) { //success Helper.DisplayAlert(this, "patient contact saved successfully."); Response.Redirect("AddContacts.aspx?id=" + id.ToString()); } } }
public int Portal_SavePatientContact(Patient_Contact contact, string LoggedInUserEmail) { dl = new DataLayer(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Portal_SavePatientContact"; cmd.Parameters.AddWithValue("@PatientID", contact.PatientID); cmd.Parameters.AddWithValue("@ContactName", contact.ContactName); cmd.Parameters.AddWithValue("@EmailAddress", contact.EmailAddress); cmd.Parameters.AddWithValue("@Emergency", contact.Emergency); cmd.Parameters.AddWithValue("@ContactPhoneNumber", contact.ContactPhoneNumber); cmd.Parameters.AddWithValue("@ContactPhoneType", contact.ContactPhoneType); cmd.Parameters.AddWithValue("@Street", contact.Street); cmd.Parameters.AddWithValue("@Suite", contact.Suite); cmd.Parameters.AddWithValue("@City", contact.City); cmd.Parameters.AddWithValue("@State", contact.State); cmd.Parameters.AddWithValue("@ZipCode", contact.ZipCode); cmd.Parameters.AddWithValue("@Country", contact.Country); cmd.Parameters.AddWithValue("@Password", contact.Password); cmd.Parameters.AddWithValue("@ContactType", contact.ContactType); cmd.Parameters.AddWithValue("@SavedBy", LoggedInUserEmail); DataTable dt = dl.Execute(cmd); DataRow dr = dt.Rows[0]; return Int32.Parse(dr["RET"].ToString()); }