public static Service GetByName(string name) { object[] row = Database.ReaderRow(Database.ReturnCommand($"select * from tbservices where ServName = '{name}'")); Service service = new Service((ushort)row[0], (string)row[1], (decimal)row[2], (string)row[3], (string)row[4], CategoryDAO.GetById((byte)row[5]), TimeSpan.Parse(row[6].ToString()), (byte[])row[7], (string)row[8]); return(service); }
public static List <Service> GetList() { var list = new List <Service>(); Database.ReaderRows(Database.ReturnCommand("select * from tbservices"), row => { list.Add(new Service((ushort)row[0], (string)row[1], (decimal)row[2], (string)row[3], (string)row[4], CategoryDAO.GetById((byte)row[5]), TimeSpan.Parse(row[6].ToString()), (byte[])row[7], (string)row[8])); }); return(list); }
public static List <Service> GetList(int orderIndex, string category, int?sp, int?ep) { var list = new List <Service>(); string query = GetQuery(orderIndex, category, sp, ep); Database.ReaderRows(Database.ReturnCommand(query), row => { list.Add(new Service((ushort)row[0], (string)row[1], (decimal)row[2], (string)row[3], (string)row[4], CategoryDAO.GetById((byte)row[5]), TimeSpan.Parse(row[6].ToString()), (byte[])row[7], (string)row[8])); }); return(list); }
public static List <Service> GetListByCategory(ushort id) { var list = new List <Service>(); db.ReaderRows(db.ReturnCommand($"select * from vw_services where CategoryId = {id}"), row => { decimal?starRating = row[9] != DBNull.Value ? Convert.ToDecimal(row[9] + "") : (decimal?)null; list.Add(new Service((ushort)row[0], (string)row[1], (decimal)row[2], (string)row[3], (string)row[4], CategoryDAO.GetById((byte)row[5]), TimeSpan.Parse(row[6].ToString()), (byte[])row[7], (string)row[8], starRating)); }); return(list); }
public static Service GetByName(string name) { object[] row = db.ReaderRow(db.ReturnCommand($"select * from vw_services where ServName = '{name}'")); decimal? starRating = row[9] != DBNull.Value ? Convert.ToDecimal(row[9] + "") : (decimal?)null; Service service = new Service((ushort)row[0], (string)row[1], (decimal)row[2], (string)row[3], (string)row[4], CategoryDAO.GetById((byte)row[5]), TimeSpan.Parse(row[6].ToString()), (byte[])row[7], (string)row[8], starRating); return(service); }
public static List <Service> GetList(int orderIndex, string category, int?sp, int?ep) { var list = new List <Service>(); string query = GetQuery(orderIndex, category, sp, ep); db.ReaderRows(db.ReturnCommand(query), row => { decimal?starRating = row[9] != DBNull.Value ? Convert.ToDecimal(row[9] + "") : (decimal?)null; list.Add(new Service((ushort)row[0], (string)row[1], (decimal)row[2], (string)row[3], (string)row[4], CategoryDAO.GetById((byte)row[5]), TimeSpan.Parse(row[6].ToString()), (byte[])row[7], (string)row[8], starRating)); }); return(list); }