public List <AppointmentShow> GetLichHenHomeNayCuaBacSy(int employeeID)
{
const string proc = "SP_XemLichHenHomNayCuaBacSy";
List <SqlParameter> para = new List <SqlParameter>()
{
new SqlParameter("EMPLOYEEID", employeeID)
};
IDataReader reader = DataProvider.ExecuteReader(proc, para);
List <AppointmentShow> result = new List <AppointmentShow>();
AppointmentShow lichhen;
while (reader.Read())
{
lichhen = new AppointmentShow();
lichhen.AppointmentID = Convert.ToInt32(reader["AppointmentID"]);
lichhen.Date = Convert.ToDateTime(reader["Date"]);
lichhen.EmployeeID = Convert.ToInt32(reader["EmployeeID"]);
lichhen.EmployeeName = Convert.ToString(reader["EmployeeName"]);
lichhen.PatientName = Convert.ToString(reader["Name"]);
lichhen.PhoneNumber = Convert.ToString(reader["PhoneNumber"]);
result.Add(lichhen);
}
return(result);
}
public List <AppointmentShow> GetLichHenHomeNay()
{
const string proc = "SP_XemLichHenHomNay";
List <SqlParameter> para = new List <SqlParameter>()
{
// new SqlParameter("employeeID - 1",employeeID - 2)// 1 là ten prameter trong Proc , 2 là tên parameter của hàm
};
IDataReader reader = DataProvider.ExecuteReader(proc, para);
List <AppointmentShow> result = new List <AppointmentShow>();
AppointmentShow lichhen;
while (reader.Read())
{
lichhen = new AppointmentShow();
lichhen.AppointmentID = Convert.ToInt32(reader["AppointmentID"]);
lichhen.Date = Convert.ToDateTime(reader["Date"]);
lichhen.EmployeeID = Convert.ToInt32(reader["EmployeeID"]);
lichhen.EmployeeName = Convert.ToString(reader["EmployeeName"]);
lichhen.PatientName = Convert.ToString(reader["Name"]);
lichhen.PhoneNumber = Convert.ToString(reader["PhoneNumber"]);
result.Add(lichhen);
}
return(result);
}
public List <AppointmentShow> SearchLichHenTheoIDBacSy(int employeeID) // Timf kieems lichj henj theo ma .
{
const string proc = "SP_TimKiemLichHenTheoMaBacSy";
List <SqlParameter> para = new List <SqlParameter>()
{
new SqlParameter("EMPLOYEEID", employeeID)
};
IDataReader reader = DataProvider.ExecuteReader(proc, para);
List <AppointmentShow> res = new List <AppointmentShow>();
AppointmentShow lichhen;
while (reader.Read())
{
lichhen = new AppointmentShow();
lichhen.AppointmentID = Convert.ToInt32(reader["AppointmentID"]);
lichhen.Date = Convert.ToDateTime(reader["Date"]);
lichhen.EmployeeID = Convert.ToInt32(reader["EmployeeID"]);
lichhen.EmployeeName = Convert.ToString(reader["EmployeeName"]);
lichhen.PatientName = Convert.ToString(reader["PatientName"]);
lichhen.PhoneNumber = Convert.ToString(reader["PhoneNumber"]);
res.Add(lichhen);
}
return(res);
}
