protected void btnOnlineConsult_Click(object sender, EventArgs e)
{
ConsultPatient cPatient = new ConsultPatient();
if (!string.IsNullOrEmpty(txtPatientName.Text) || !string.IsNullOrEmpty(txtEmailAddress.Text) || !string.IsNullOrEmpty(txtPhone.Text))
{
if (Session["PhoneEmail"] != null)
{
cPatient.DoctorEmail = Session["PhoneEmail"].ToString();
}
if (Session["TextEmail"] != null)
{
cPatient.DoctorEmail = Session["TextEmail"].ToString();
}
if (Session["VideoEmail"] != null)
{
cPatient.DoctorEmail = Session["VideoEmail"].ToString();
}
cPatient.PatientName = txtPatientName.Text;
cPatient.PhoneNo = txtPhone.Text;
cPatient.PatientEmail = txtEmailAddress.Text.Trim();
cPatient.ConsultType = lblConsultType.Text;
int rowCount = _cpManager.Save(cPatient);
if (rowCount > 0)
{
warningPanel.Visible = false;
successpanel.Visible = true;
successText.InnerHtml = "You are registered Successfully.";
}
}
else
{
successpanel.Visible = false;
warningPanel.Visible = true;
errorName.InnerHtml = "Field Cannot be Empty!";
}
}
internal int Insert(ConsultPatient cPatient)
{
try
{
connection.Open();
command = new SqlCommand("sp_ConsultPatient", connection);
command.Parameters.Clear();
command.Parameters.Add("@doctorEmail", SqlDbType.NVarChar).Value = cPatient.DoctorEmail;
command.Parameters.Add("@patientName", SqlDbType.NVarChar).Value = cPatient.PatientName;
command.Parameters.Add("@phoneNo", SqlDbType.NVarChar).Value = cPatient.PhoneNo;
command.Parameters.Add("@patientEmail", SqlDbType.NVarChar).Value = cPatient.PatientEmail;
command.Parameters.Add("@consultType", SqlDbType.NVarChar).Value = cPatient.ConsultType;
//command.Parameters.Add("@duration", SqlDbType.NVarChar).Value = cPatient.Duration;
command.CommandType = CommandType.StoredProcedure;
rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
catch (Exception)
{
throw;
}
}
internal int Save(ConsultPatient cPatient)
{
return(_cpGateway.Insert(cPatient));
}
