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>();
}
