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