// GET: Patients
public ActionResult Index(DisplayAppointments da)
{
string mainconn = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(mainconn);
string s1 = "select * from [myDataBaseAuth].[dbo].[Appointment2]";
SqlCommand sqlcomm = new SqlCommand(s1);
sqlcomm.Connection = sqlconn;
sqlconn.Open();
SqlDataReader sdr = sqlcomm.ExecuteReader();
List <DisplayAppointments> objmodel = new List <DisplayAppointments>();
if (sdr.HasRows)
{
while (sdr.Read())
{
var details = new DisplayAppointments();
details.PatientName = sdr["PatientName"].ToString();
details.Gender = sdr["Gender"].ToString();
details.PhoneNumber = sdr["PatientPhoneNum"].ToString();
details.Email = sdr["Email"].ToString();
details.Symptoms = sdr["Symptoms"].ToString();
details.Doctor = sdr["Doctor"].ToString();
details.Date = sdr["Date"].ToString();
details.Time = sdr["Time"].ToString();
objmodel.Add(details);
}
da.patientInfo = objmodel;
sqlconn.Close();
}
return(View("Index", da));
}
public ActionResult DoctorsAppointments(DisplayAppointments da)
{
var currentUserID = User.Identity.GetUserId();
ViewBag.userid = currentUserID;
ViewBag.userEmail = User.Identity.GetUserName();
string mainconn = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(mainconn);
string s1 = "select * from [ProjectDB].[dbo].[Appointment4]";
SqlCommand sqlcomm = new SqlCommand(s1);
sqlcomm.Connection = sqlconn;
sqlconn.Open();
SqlDataReader sdr = sqlcomm.ExecuteReader();
List <DisplayAppointments> objmodel = new List <DisplayAppointments>();
if (sdr.HasRows)
{
while (sdr.Read())
{
var details = new DisplayAppointments();
details.PatientName = sdr["PatientName"].ToString();
details.Gender = sdr["Gender"].ToString();
details.PhoneNumber = sdr["PatientPhoneNum"].ToString();
details.Email = sdr["Email"].ToString();
details.Symptoms = sdr["Symptoms"].ToString();
details.Doctor = sdr["Doctor"].ToString();
details.Date = sdr["Date"].ToString();
details.UserId = sdr["UserId"].ToString();
objmodel.Add(details);
}
da.patientInfo = objmodel;
sqlconn.Close();
}
return(View("DoctorsAppointments", da));
}