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());
}
