public static List<Area> getAllAreasList()
{
Logger.LogDebug(MethodBase.GetCurrentMethod().DeclaringType.ToString(), MethodBase.GetCurrentMethod().Name, "Entry Point", Logger.logLevel.Info);
Logger.LogDebug(MethodBase.GetCurrentMethod().DeclaringType.ToString(), MethodBase.GetCurrentMethod().Name, "", Logger.logLevel.Debug);
List<Area> lstArea = new List<Area>();
SqlConnection conn = null;
SqlDataReader reader = null;
try
{
// create and open a connection object
conn = ConnectionManager.getConnection();
conn.Open();
String query = "SELECT TOP 50 id,description,facility FROM area";
SqlCommand command = new SqlCommand(query, conn);
using (reader = command.ExecuteReader())
{
while (reader.Read())
{
String strArea = reader.GetSqlValue(1).ToString().Trim();
if (!(strArea.Equals("") || strArea.Equals("null") || strArea.Equals("NULL") || strArea.Equals("Null")))
{
Area areaObj = new Area();
areaObj.key = reader.GetSqlValue(0).ToString().Trim();
areaObj.value = reader.GetSqlValue(1).ToString().Trim();
lstArea.Add(areaObj);
}
}
}
}
catch (Exception ex)
{
var stackTrace = new StackTrace(ex, true);
var line = stackTrace.GetFrame(0).GetFileLineNumber();
Logger.LogExceptions(MethodBase.GetCurrentMethod().DeclaringType.ToString(), MethodBase.GetCurrentMethod().Name, ex.Message, line.ToString(), Logger.logLevel.Exception);
}
finally
{
if (conn != null)
{
conn.Close();
}
if (reader != null)
{
reader.Close();
}
}
lstArea = lstArea.OrderBy(x => x.Value).ToList();
Logger.LogDebug(MethodBase.GetCurrentMethod().DeclaringType.ToString(), MethodBase.GetCurrentMethod().Name, "Exit Point", Logger.logLevel.Debug);
return lstArea;
}
public static List<Area> getAreaByIDList(String[] facilityId, String keyStroke)
{
Logger.LogDebug(MethodBase.GetCurrentMethod().DeclaringType.ToString(), MethodBase.GetCurrentMethod().Name, "Entry Point", Logger.logLevel.Info);
Logger.LogDebug(MethodBase.GetCurrentMethod().DeclaringType.ToString(), MethodBase.GetCurrentMethod().Name, facilityId[0] + keyStroke, Logger.logLevel.Debug);
List<Area> lstArea = new List<Area>();
/*if (facilityId == null || facilityId[0].Equals("null"))
{
return getAllAreasList();
}*/
SqlConnection conn = null;
SqlDataReader reader = null;
try
{
// create and open a connection object
conn = ConnectionManager.getConnection();
conn.Open();
String query = "";
// if (facilityId[0].Equals("null"))
// {
query = "SELECT TOP 1000 id,description,facility FROM area WHERE description like '%" + keyStroke + "%'";
// }
// else
// {
// query = "SELECT TOP 1000 id,description,facility FROM area WHERE facility = " + facilityId[0].Trim() + " AND description like '%" + keyStroke + "%'";
// }
// for (int i = 1; i < facilityId.Length; i++)
// {
// query = query + " OR facility = " + facilityId[i].Trim();
// }
SqlCommand command = new SqlCommand(query, conn);
using (reader = command.ExecuteReader())
{
while (reader.Read())
{
String strArea = reader.GetSqlValue(1).ToString().Trim();
if (!(strArea.Equals("") || strArea.Equals("null") || strArea.Equals("NULL") || strArea.Equals("Null")))
{
Area areaObj = new Area();
areaObj.key = reader.GetSqlValue(0).ToString().Trim();
areaObj.value = reader.GetSqlValue(1).ToString().Trim();
lstArea.Add(areaObj);
}
}
}
}
catch (Exception ex)
{
var stackTrace = new StackTrace(ex, true);
var line = stackTrace.GetFrame(0).GetFileLineNumber();
Logger.LogExceptions(MethodBase.GetCurrentMethod().DeclaringType.ToString(), MethodBase.GetCurrentMethod().Name, ex.Message, line.ToString(), Logger.logLevel.Exception);
}
finally
{
if (conn != null)
{
conn.Close();
}
if (reader != null)
{
reader.Close();
}
}
lstArea = lstArea.OrderBy(x => x.Value).ToList();
Logger.LogDebug(MethodBase.GetCurrentMethod().DeclaringType.ToString(), MethodBase.GetCurrentMethod().Name, "Exit Point", Logger.logLevel.Debug);
return lstArea;
}