public static List <Review> GetList(ushort serviceId) { var list = new List <Review>(); db.ReaderRows(db.ReturnProcedure("sp_SelectCommentsService", serviceId), row => { list.Add(new Review((decimal)row[0], (string)row[1], CustomerDAO.GetById(Convert.ToUInt32(row[2])))); }); return(list); }
public static IEnumerable <Review> GetList(string service) { var list = new List <Review>(); Database.ReaderRows(Database.ReturnProcedure("sp_SelectCommentsService", service), row => { list.Add(new Review((decimal)row[0], (string)row[1], CustomerDAO.GetById(Convert.ToUInt32(row[2])))); }); return(list); }
public static List <Schedule> GetList() { var list = new List <Schedule>(); db.ReaderRows(db.ReturnCommand("select * from vw_SchedulesCustomer"), row => { list.Add(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] + "")); }); 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] + ""); return(schedule); }