public static Technician GetTechnician(int techID) { DBManager DB = TechSupportDB.GetDBManager(); SortedList slParams = new SortedList(); SqlDataReader dr; Technician technician = null; string strSelect = "SELECT " + FldTechID + ", " + FldName + ", " + FldEmail + ", " + FldPhone + " FROM " + TblTechnicians + " WHERE " + FldTechID + "=@" + FldTechID; slParams.Add(FldTechID, techID); dr = DB.SelectDirect(strSelect, CommandType.Text, slParams); if (dr.Read()) { technician = new Technician(); technician.TechID = (int)dr[FldTechID]; technician.Name = dr[FldName].ToString(); technician.Email = dr[FldEmail].ToString(); technician.Phone = dr[FldPhone].ToString(); } dr.Close(); return technician; }
public static List<Technician> GetTechnicianList() { DBManager DB = TechSupportDB.GetDBManager(); List<Technician> technicianList = new List<Technician>(); SqlDataReader dr; string strSelect = "SELECT " + FldTechID + ", " + FldName + " FROM " + TblTechnicians + " ORDER BY " + FldName; dr = DB.SelectDirect(strSelect, CommandType.Text); while (dr.Read()) { Technician technician = new Technician(); technician.TechID = (int)dr[FldTechID]; technician.Name = dr[FldName].ToString(); technicianList.Add(technician); } dr.Close(); return technicianList; }