public ViewDoctors GetDoctor(int id, int medicalId)
{
Query = "SELECT * FROM ViewDoctors WHERE Id = @id AND MedicalId = @medicalId";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("id", id);
Command.Parameters.AddWithValue("medicalId", medicalId);
Connection.Open();
Reader = Command.ExecuteReader();
ViewDoctors doctors = null;
while (Reader.Read())
{
doctors = new ViewDoctors();
doctors.Id = Convert.ToInt32(Reader["Id"]);
doctors.ImagePath = Reader["ImagePath"].ToString();
doctors.Name = Reader["Name"].ToString();
doctors.Gender = Reader["Gender"].ToString();
doctors.Title = Reader["Title"].ToString();
doctors.Speciality = Reader["Speciality"].ToString();
doctors.Email = Reader["Email"].ToString();
doctors.MobileNo = Reader["MobileNo"].ToString();
doctors.PhoneNo = Reader["PhoneNo"].ToString();
doctors.BmdcReg = Reader["BmdcReg"].ToString();
doctors.OtherSpecification = Reader["OtherSpecification"].ToString();
doctors.MedicalId = Convert.ToInt32(Reader["MedicalId"]);
doctors.Fee = Convert.ToInt32(Reader["DoctorFee"]);
doctors.ReturningFee = Convert.ToInt32(Reader["DoctorReturningFee"]);
doctors.Sat = Convert.ToBoolean(Reader["Sat"]);
doctors.Sun = Convert.ToBoolean(Reader["Sun"]);
doctors.Mon = Convert.ToBoolean(Reader["Mon"]);
doctors.Tue = Convert.ToBoolean(Reader["Tue"]);
doctors.Wed = Convert.ToBoolean(Reader["Wed"]);
doctors.Thu = Convert.ToBoolean(Reader["Thu"]);
doctors.Fri = Convert.ToBoolean(Reader["Fri"]);
doctors.SatTime = Reader["SatTime"].ToString();
doctors.SunTime = Reader["SunTime"].ToString();
doctors.MonTime = Reader["MonTime"].ToString();
doctors.TueTime = Reader["TueTime"].ToString();
doctors.WedTime = Reader["WedTime"].ToString();
doctors.ThuTime = Reader["ThuTime"].ToString();
doctors.FriTime = Reader["FriTime"].ToString();
}
Reader.Close();
Connection.Close();
return(doctors);
}
private List <ViewDoctors> GetDoctorSearchDetails(int doctorId)
{
Connection.Close();
Query = "SELECT * FROM ViewDoctors WHERE Id = @id";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("id", doctorId);
Connection.Open();
Reader = Command.ExecuteReader();
List <ViewDoctors> viewDoctors = new List <ViewDoctors>();
while (Reader.Read())
{
ViewDoctors viewDoctor = new ViewDoctors();
viewDoctor.MedicalId = Convert.ToInt32(Reader["MedicalId"]);
viewDoctor.MedicalName = Reader["MedicalName"].ToString();
viewDoctor.MedicalAddress = Reader["Address"].ToString();
viewDoctor.MedicalArea = Reader["Area"].ToString();
viewDoctor.MedicalCity = Reader["City"].ToString();
viewDoctor.Fee = Convert.ToInt32(Reader["DoctorFee"]);
viewDoctor.ReturningFee = Convert.ToInt32(Reader["DoctorReturningFee"]);
viewDoctor.Sat = Convert.ToBoolean(Reader["Sat"]);
viewDoctor.Sun = Convert.ToBoolean(Reader["Sun"]);
viewDoctor.Mon = Convert.ToBoolean(Reader["Mon"]);
viewDoctor.Tue = Convert.ToBoolean(Reader["Tue"]);
viewDoctor.Wed = Convert.ToBoolean(Reader["Wed"]);
viewDoctor.Thu = Convert.ToBoolean(Reader["Thu"]);
viewDoctor.Fri = Convert.ToBoolean(Reader["Fri"]);
viewDoctor.SatTime = Reader["SatTime"].ToString();
viewDoctor.SunTime = Reader["SunTime"].ToString();
viewDoctor.MonTime = Reader["MonTime"].ToString();
viewDoctor.TueTime = Reader["TueTime"].ToString();
viewDoctor.WedTime = Reader["WedTime"].ToString();
viewDoctor.ThuTime = Reader["ThuTime"].ToString();
viewDoctor.FriTime = Reader["FriTime"].ToString();
viewDoctor.ManageAppointment = GetManageAppointmentInfo(doctorId, viewDoctor.MedicalId);
viewDoctors.Add(viewDoctor);
}
return(viewDoctors);
}
