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