public List <BMEData> RetriveBMEData()
{
List <BMEData> lstBMEData = null;
try
{
BMEData oBMEData = new BMEData();
lstBMEData = oBMEData.GetBMEData(FromDate, ToDate, Task);
}
catch (Exception)
{
}
return(lstBMEData);
}
public List <BMEData> GetBMEData(DateTime dtFromDate, DateTime dtToDate, string sTask)
{
DataTable _dt = null;
List <BMEData> lstBMEData = null;
DBParameters _DBParameters = new DBParameters();
DataAccess _DataAccess = new DataAccess();
try
{
_DataAccess.OpenConnection(false);
_DBParameters.clear();
_DBParameters.Add("@FROM_DATE_TIME", dtFromDate, ParameterDirection.Input, SqlDbType.DateTime);
_DBParameters.Add("@TO_DATE_TIME", dtToDate, ParameterDirection.Input, SqlDbType.DateTime);
_DBParameters.Add("@TASK", sTask, ParameterDirection.Input, SqlDbType.VarChar);
_DataAccess.Retrive("GET_BME_DATA", _DBParameters, out _dt);
_DataAccess.CloseConnection(false);
if (_dt != null && _dt.Rows.Count > 0)
{
lstBMEData = new List <BMEData>();
Int32 count = 0;
foreach (DataRow dr in _dt.Rows)
{
BMEData oBMEData = new BMEData();
oBMEData.SrNo = ++count;
oBMEData.ID = Convert.ToInt64(dr["ID"]);
oBMEData.BME_ID = Convert.ToString(dr["BME ID"]);
oBMEData.METER_TYPE = Convert.ToString("");
oBMEData.METER_SUB_TYPE = Convert.ToString(dr["METER TYPE"]);
oBMEData.METER_LOCATION = Convert.ToString(dr["LOCATION"]);
oBMEData.METER_NUMBER = Convert.ToString(dr["METER NO."]);
oBMEData.READING_DATE_TIME = Convert.ToDateTime(dr["READING TIME"]);
oBMEData.CURRENT_READING = Convert.ToString("");
oBMEData.PREVIOUS_READING = Convert.ToString("");
oBMEData.METER_START_TIME = Convert.ToDateTime(dr["START TIME"]);
oBMEData.METER_END_TIME = Convert.ToDateTime(dr["END TIME"]);
if (Convert.ToString(dr["IS ASSOCIATED"]).ToLower() == "yes")
{
oBMEData.PROCESSING_DONE = true;
}
else
{
oBMEData.PROCESSING_DONE = false;
}
oBMEData.PROCESSING_DATE_TIME = Convert.ToDateTime(DateTime.MinValue);
oBMEData.DATA_SOURCE_TYPE = Convert.ToString(dr["DATA SOURCE"]);
lstBMEData.Add(oBMEData);
oBMEData.Dispose();
oBMEData = null;
}
}
}
catch (Exception)
{
if (_DataAccess != null)
{
_DataAccess.RollBack(); _DataAccess.CloseConnection(false);
}
}
finally
{
if (_DBParameters != null)
{
_DBParameters.Dispose();
}
}
return(lstBMEData);
}
