public static List <Service> GetServices(uint id)
{
var list = new List <Service>();
string query = $"select * from tbservemployees where LoginId = '{id}'";
db.ReaderRows(db.ReturnCommand(query), row => list.Add(ServiceDAO.GetById((ushort)row[1])));
return(list);
}
public static List <Service> GetServicesFromPackage(ushort id)
{
var list = new List <Service>();
db.ReaderRows(db.ReturnCommand($"select * from tbpackitem where packid='{id}'"), row => {
list.Add(ServiceDAO.GetById((ushort)row[0]));
});
return(list);;
}
public static List <Schedule> GetList()
{
var list = new List <Schedule>();
db.ReaderRows(db.ReturnCommand("select * from vw_schedulescustomer order by scheddatetime desc"), row => {
uint id = Convert.ToUInt32(row[0]);
Employee employee = EmployeeDAO.GetById(Convert.ToUInt32(row[1]));
Customer customer = CustomerDAO.GetById(Convert.ToUInt32(row[2]));
Service service = ServiceDAO.GetById(Convert.ToUInt16(row[3]));
string date = row[4] + "";
bool boolean = Convert.ToBoolean(row[5]);
list.Add(new Schedule(id, employee, customer, service, date, boolean));
});
return(list);
}
public static Schedule GetById(uint id)
{
object[] row = db.ReaderRow(db.ReturnCommand($"select * from vw_SchedulesCustomer where SchedId = '{id}'"));
Schedule schedule = new Schedule(Convert.ToUInt32(row[0]), EmployeeDAO.GetById(Convert.ToUInt32(row[1])), CustomerDAO.GetById(Convert.ToUInt32(row[2])), ServiceDAO.GetById(Convert.ToUInt16(row[3])), row[4] + "", Convert.ToBoolean(row[5]));
return(schedule);
}