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