public IEnumerable<LookUp> GetDistinctProductCodes() { DBFactory db; SqlDataReader rdr; List<LookUp> data = null; try { db = new DBFactory(); rdr = db.ExecuteReader("MSI_sp_GetDistinctProductCode"); data = new List<LookUp>(); LookUp record; while (rdr.Read()) { record = new LookUp(rdr["Product_Code"].ToString(), rdr["Product_Code"].ToString()); data.Add(record); } rdr.Close(); } catch (Exception ex) { throw new Exception("Exception in DataQueries.GetSearchResults:" + ex.Message); } return data.AsQueryable<LookUp>(); }
public IEnumerable<LookUp> GetDistinctResponsibility() { DBFactory db; SqlDataReader rdr; List<LookUp> data = null; try { db = new DBFactory(); rdr = db.ExecuteReader("MSI_sp_GetDistinctResponsibility"); data = new List<LookUp>(); LookUp record; while (rdr.Read()) { record = new LookUp(rdr["RESPONSIBILITY"].ToString(), rdr["RESPONSIBILITY"].ToString()); data.Add(record); } rdr.Close(); } catch (Exception ex) { throw new Exception("Exception in DataQueries.GetDistinctResponsibility:" + ex.Message); } return data.AsQueryable<LookUp>(); }
public IEnumerable<LookUp> GetDistinctResponsibility() { string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name); string logMessage = string.Format("{0}", thisMethod); LogHelper.Info(logMessage); DBFactory db; SqlDataReader rdr; List<LookUp> data = null; try { db = new DBFactory(); rdr = db.ExecuteReader("MSI_sp_GetDistinctResponsibility"); data = new List<LookUp>(); LookUp record; while (rdr.Read()) { record = new LookUp(rdr["RESPONSIBILITY"].ToString(), rdr["RESPONSIBILITY"].ToString()); data.Add(record); } rdr.Close(); } catch (Exception ex) { ErrorLogHelper.Error(logMessage, ex); } return data.AsQueryable<LookUp>(); }