public List <Response.DeviceTypeUsageResponse> GetDeviceTypeUsage(Request.ChartRequest request)
{
List <Response.DeviceTypeUsageResponse> result = new List <Response.DeviceTypeUsageResponse>();
try
{
_logger.InfoLog(Constants.ACTION_ENTRY, "Chart_UtilizationByDeviceType.Get");
using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
{
List <DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, component.helper.SolutionConfiguration.Version);
parameters.Add(sqlDataAccess.CreateParameter("companyGuid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input));
if (request.EntityGuid != null && request.EntityGuid != Guid.Empty)
{
parameters.Add(sqlDataAccess.CreateParameter("parentEntityGuid", request.EntityGuid, DbType.Guid, ParameterDirection.Input));
}
parameters.Add(sqlDataAccess.CreateParameter("frequency", request.Frequency, DbType.String, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("syncDate", DateTime.UtcNow, DbType.DateTime, ParameterDirection.Output));
parameters.Add(sqlDataAccess.CreateParameter("enableDebugInfo", component.helper.SolutionConfiguration.EnableDebugInfo, DbType.String, ParameterDirection.Input));
DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[Chart_UtilizationByDeviceType]", CommandType.StoredProcedure, null), parameters.ToArray());
result = DataUtils.DataReaderToList <Response.DeviceTypeUsageResponse>(dbDataReader, null);
}
_logger.InfoLog(Constants.ACTION_EXIT, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
return(result);
}
public List <Response.WaterUsageResponse> GetWaterUsage(Request.ChartRequest request)
{
List <Response.WaterUsageResponse> result = new List <Response.WaterUsageResponse>();
try
{
_logger.InfoLog(LogHandler.Constants.ACTION_ENTRY, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
{
List <DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, component.helper.SolutionConfiguration.Version);
parameters.Add(sqlDataAccess.CreateParameter("companyguid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("entityguid", request.GreenHouseGuid, DbType.Guid, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("guid", request.HardwareKitGuid, DbType.Guid, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("enableDebugInfo", component.helper.SolutionConfiguration.EnableDebugInfo, DbType.String, ParameterDirection.Input));
DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[Chart_WaterConsumption]", CommandType.StoredProcedure, null), parameters.ToArray());
result = DataUtils.DataReaderToList <Response.WaterUsageResponse>(dbDataReader, null);
}
_logger.InfoLog(LogHandler.Constants.ACTION_EXIT, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
return(result);
}
public Entity.BaseResponse <List <Response.FuelUsageResponse> > GetFuelUsage(Request.ChartRequest request)
{
Entity.BaseResponse <List <Response.FuelUsageResponse> > result = new Entity.BaseResponse <List <Response.FuelUsageResponse> >();
try
{
_logger.InfoLog(Constants.ACTION_ENTRY, "Chart_FuelUsed.Get");
using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
{
List <DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, component.helper.SolutionConfiguration.Version);
parameters.Add(sqlDataAccess.CreateParameter("entityguid", request.EntityGuid, DbType.Guid, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("guid", request.DeviceGuid, DbType.Guid, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("enableDebugInfo", component.helper.SolutionConfiguration.EnableDebugInfo, DbType.String, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("syncDate", DateTime.UtcNow, DbType.DateTime, ParameterDirection.Output));
DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[Chart_FuelUsed]", CommandType.StoredProcedure, null), parameters.ToArray());
result.Data = DataUtils.DataReaderToList <Response.FuelUsageResponse>(dbDataReader, null);
if (parameters.Where(p => p.ParameterName.Equals("syncDate")).FirstOrDefault() != null)
{
result.LastSyncDate = Convert.ToString(parameters.Where(p => p.ParameterName.Equals("syncDate")).FirstOrDefault().Value);
}
}
_logger.InfoLog(Constants.ACTION_EXIT, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
return(result);
}
public List <Response.FuelUsageResponse> GetFuelUsage(Request.ChartRequest request)
{
Dictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("companyguid", request.CompanyGuid.ToString());
parameters.Add("entityguid", request.EntityGuid.ToString());
parameters.Add("hardwarekitguid", request.HardwareKitGuid.ToString());
return(_entityRepository.ExecuteStoredProcedure <Response.FuelUsageResponse>("[ChartDate]", parameters));
}
public List <Response.DeviceBatteryStatusResponse> GetDeviceBatteryStatus(Request.ChartRequest request)
{
Dictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("companyguid", request.CompanyGuid.ToString());
parameters.Add("entityguid", request.EntityGuid.ToString());
parameters.Add("hardwarekitguid", request.HardwareKitGuid.ToString());
return(_entityRepository.ExecuteStoredProcedure <Response.DeviceBatteryStatusResponse>("[GensetUsage_Get]", parameters));
}
public List <Response.EnergyUsageResponse> GetEnergyUsage(Request.ChartRequest request)
{
Dictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("companyguid", request.CompanyGuid.ToString());
parameters.Add("greenhouseguid", request.EntityGuid.ToString());
parameters.Add("hardwarekitguid", request.DeviceGuid.ToString());
return(_locationRepository.ExecuteStoredProcedure <Response.EnergyUsageResponse>("[ChartDate]", parameters));
}
public Entity.BaseResponse <List <Response.FuelUsageResponse> > FuelUsage(Request.ChartRequest request)
{
Entity.BaseResponse <List <Response.FuelUsageResponse> > response = new Entity.BaseResponse <List <Response.FuelUsageResponse> >(true);
try
{
response.Data = _chartService.GetFuelUsage(request);
}
catch (Exception ex) {
base.LogException(ex);
}
return(response);
}
public Entity.BaseResponse <List <Response.WaterUsageResponse> > WaterUsage(Request.ChartRequest request)
{
Entity.BaseResponse <List <Response.WaterUsageResponse> > response = new Entity.BaseResponse <List <Response.WaterUsageResponse> >(true);
try
{
response.Data = _chartService.GetWaterUsage(request);
}
catch (Exception ex)
{
base.LogException(ex);
return(new Entity.BaseResponse <List <Response.WaterUsageResponse> >(false, ex.Message));
}
return(response);
}
public Entity.BaseResponse <List <Response.FuelUsageResponse> > GetFuelUsage(Request.ChartRequest request)
{
Entity.BaseResponse <List <Response.FuelUsageResponse> > response = new Entity.BaseResponse <List <Response.FuelUsageResponse> >(true);
try
{
response = _chartService.GetFuelUsage(request);
response.IsSuccess = true;
}
catch (Exception ex)
{
base.LogException(ex);
return(new Entity.BaseResponse <List <Response.FuelUsageResponse> >(false, ex.Message));
}
return(response);
}
public Entity.BaseResponse <List <Response.EnergyConsumption> > GetEnergyUsage(Request.ChartRequest request)
{
Entity.BaseResponse <List <Response.EnergyConsumption> > result = new Entity.BaseResponse <List <Response.EnergyConsumption> >();
List <Response.EnergyConsumption> energylst = new List <Response.EnergyConsumption>();
try
{
_logger.InfoLog(Constants.ACTION_ENTRY, "Chart_EnergyConsumption.Get");
using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
{
List <Response.EnergyConsumptionResponse> data = new List <Response.EnergyConsumptionResponse>();
List <DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, component.helper.SolutionConfiguration.Version);
if (!request.CompanyGuid.Equals(Guid.Empty))
{
parameters.Add(sqlDataAccess.CreateParameter("companyguid", request.CompanyGuid, DbType.Guid, ParameterDirection.Input));
}
if (!request.EntityGuid.Equals(Guid.Empty))
{
parameters.Add(sqlDataAccess.CreateParameter("entityguid", request.EntityGuid, DbType.Guid, ParameterDirection.Input));
}
if (!request.DeviceGuid.Equals(Guid.Empty))
{
parameters.Add(sqlDataAccess.CreateParameter("guid", request.DeviceGuid, DbType.Guid, ParameterDirection.Input));
}
parameters.Add(sqlDataAccess.CreateParameter("syncDate", DateTime.UtcNow, DbType.DateTime, ParameterDirection.Output));
parameters.Add(sqlDataAccess.CreateParameter("enableDebugInfo", component.helper.SolutionConfiguration.EnableDebugInfo, DbType.String, ParameterDirection.Input));
DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[Chart_CurrentConsumption]", CommandType.StoredProcedure, null), parameters.ToArray());
data = DataUtils.DataReaderToList <Response.EnergyConsumptionResponse>(dbDataReader, null);
if (parameters.Where(p => p.ParameterName.Equals("syncDate")).FirstOrDefault() != null)
{
result.LastSyncDate = Convert.ToString(parameters.Where(p => p.ParameterName.Equals("syncDate")).FirstOrDefault().Value);
}
var resultGrp = from item in data
group item by item.Month
into egroup
select egroup;
foreach (var group in resultGrp)
{
List <Response.EnergyConsumptionByMonth> lookupItems = new List <Response.EnergyConsumptionByMonth>();
foreach (var items in group)
{
lookupItems.Add(new Response.EnergyConsumptionByMonth {
Year = items.Year, Value = items.Value
});
}
energylst.Add(new Response.EnergyConsumption {
Month = group.Key, EnergyValue = lookupItems
});
}
result.Data = energylst;
result.IsSuccess = true;
}
_logger.InfoLog(Constants.ACTION_EXIT, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
return(result);
}
public Entity.BaseResponse <List <Response.DeviceBatteryStatusResponse> > DeviceBatteryStatus(Request.ChartRequest request)
{
Entity.BaseResponse <List <Response.DeviceBatteryStatusResponse> > response = new Entity.BaseResponse <List <Response.DeviceBatteryStatusResponse> >(true);
try
{
response.Data = _chartService.GetDeviceBatteryStatus(request);
}
catch (Exception ex)
{
base.LogException(ex);
}
return(response);
}
public Entity.BaseResponse <List <Response.EnergyConsumption> > EnergyConsumption(Request.ChartRequest request)
{
Entity.BaseResponse <List <Response.EnergyConsumption> > response = new Entity.BaseResponse <List <Response.EnergyConsumption> >(true);
try
{
response = _chartService.GetEnergyUsage(request);
response.Message = "Data Loaded Successfully !!";
response.IsSuccess = true;
}
catch (Exception ex) {
base.LogException(ex);
}
return(response);
}
public Entity.BaseResponse <List <Response.CompanyUsageResponse> > CompanyUsage(Request.ChartRequest request)
{
Entity.BaseResponse <List <Response.CompanyUsageResponse> > response = new Entity.BaseResponse <List <Response.CompanyUsageResponse> >(true);
try
{
response.Data = _chartService.GetCompanyUsage(request);
if (response.Data.Count == 0)
{
response.IsSuccess = false;
response.Message = "No usage found";
}
else if (response.Data.Count > 0 && int.Parse(response.Data[0].UtilizationPer) <= 0)
{
response.IsSuccess = false;
response.Message = "No usage found";
}
}
catch (Exception ex)
{
base.LogException(ex);
}
return(response);
}
public Entity.BaseResponse <List <Response.DeviceTypeUsageResponse> > DeviceTypeUsage(Request.ChartRequest request)
{
Entity.BaseResponse <List <Response.DeviceTypeUsageResponse> > response = new Entity.BaseResponse <List <Response.DeviceTypeUsageResponse> >(true);
try
{
response.Data = _chartService.GetDeviceTypeUsage(request);
if (response.Data.Count == 0)
{
response.IsSuccess = false;
response.Message = "No usage found";
}
}
catch (Exception ex) {
base.LogException(ex);
}
return(response);
}