public Entity.SearchResult <List <Entity.HardwareKitResponse> > List(Entity.SearchRequest request, bool isAssigned, string companyId)
{
Entity.SearchResult <List <Entity.HardwareKitResponse> > result = new Entity.SearchResult <List <Entity.HardwareKitResponse> >();
try
{
logger.InfoLog(Constants.ACTION_ENTRY, "HardwareKitRepository.Get");
using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
{
List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, request.Version);
if (!string.IsNullOrEmpty(companyId))
{
parameters.Add(sqlDataAccess.CreateParameter("companyguid", Guid.Parse(companyId), DbType.Guid, ParameterDirection.Input));
}
parameters.Add(sqlDataAccess.CreateParameter("search", request.SearchText, DbType.String, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("isAssigned", isAssigned ? 1 : 0, DbType.Int32, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("pagesize", request.PageSize, DbType.Int32, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("pagenumber", request.PageNumber, DbType.Int32, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("orderby", request.OrderBy, DbType.String, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16));
System.Data.Common.DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[HardwareKit_List]", CommandType.StoredProcedure, null), parameters.ToArray());
result.Items = DataUtils.DataReaderToList <Entity.HardwareKitResponse>(dbDataReader, null);
result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString());
}
logger.InfoLog(Constants.ACTION_EXIT, "HardwareKitRepository.Get");
}
catch (Exception ex)
{
logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
}
return(result);
}
public Entity.SearchResult <List <Model.Crop> > List(Entity.SearchRequest request)
{
Entity.SearchResult <List <Model.Crop> > result = new Entity.SearchResult <List <Model.Crop> >();
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, request.Version);
parameters.Add(sqlDataAccess.CreateParameter("companyguid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("greenHouseGuid", request.GreenHouseId, DbType.String, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("search", request.SearchText, DbType.String, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("pagesize", request.PageSize, DbType.Int32, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("pagenumber", request.PageNumber, DbType.Int32, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("orderby", request.OrderBy, DbType.String, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16));
DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[Crop_List]", CommandType.StoredProcedure, null), parameters.ToArray());
result.Items = DataUtils.DataReaderToList <Model.Crop>(dbDataReader, null);
result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString());
}
_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 List <Entity.DeviceMaintenanceResponse> GetUpComingList(Entity.DeviceMaintenanceRequest request)
{
List <Entity.DeviceMaintenanceResponse> result = new List <Entity.DeviceMaintenanceResponse>();
try
{
logger.InfoLog(Constants.ACTION_ENTRY, "DeviceMaintenanceRepository.GetUpComingList");
using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
{
List <DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, "v1");
parameters.Add(sqlDataAccess.CreateParameter("companyguid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input));
if (request.EntityGuid.HasValue)
{
parameters.Add(sqlDataAccess.CreateParameter("entityGuid", request.EntityGuid.Value, DbType.Guid, ParameterDirection.Input));
}
if (request.DeviceGuid.HasValue)
{
parameters.Add(sqlDataAccess.CreateParameter("guid", request.DeviceGuid, DbType.Guid, ParameterDirection.Input));
}
parameters.Add(sqlDataAccess.CreateParameter("currentDate", request.currentDate, DbType.DateTime, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16));
DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[DeviceMaintenance_UpComingList]", CommandType.StoredProcedure, null), parameters.ToArray());
result = DataUtils.DataReaderToList <Entity.DeviceMaintenanceResponse>(dbDataReader, null);
}
logger.InfoLog(Constants.ACTION_EXIT, "DeviceMaintenanceRepository.GetUpComingList");
}
catch (Exception ex)
{
logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
}
return(result);
}
public bool ValidateSubscriptionAccessToken()
{
try
{
if (!string.IsNullOrWhiteSpace(_subcriptionAccessToken))
{
JwtSecurityTokenHandler jwthandler = new JwtSecurityTokenHandler();
Microsoft.IdentityModel.Tokens.SecurityToken jwttoken = jwthandler.ReadToken(_subcriptionAccessToken);
if (jwttoken.ValidTo < DateTime.UtcNow.AddMinutes(5))
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
return(false);
}
public Entity.BaseResponse <Entity.DashboardOverviewResponse> GetOverview(DateTime currentDate, string timeZone)
{
Entity.BaseResponse <List <Entity.DashboardOverviewResponse> > listResult = new Entity.BaseResponse <List <Entity.DashboardOverviewResponse> >();
Entity.BaseResponse <Entity.DashboardOverviewResponse> result = new Entity.BaseResponse <Entity.DashboardOverviewResponse>(true);
try
{
listResult = _dashboardrepository.GetStatistics(currentDate, timeZone);
if (listResult.Data.Count > 0)
{
result.IsSuccess = true;
result.Data = listResult.Data[0];
result.LastSyncDate = listResult.LastSyncDate;
var deviceResult = _deviceService.GetDeviceCounters();
if (deviceResult.IsSuccess && deviceResult.Data != null)
{
result.Data.TotalDisConnected = deviceResult.Data.disConnected;
result.Data.TotalConnected = deviceResult.Data.connected;
result.Data.TotalDevices = deviceResult.Data.total;
}
}
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
return(result);
}
protected void LogException(Exception ex)
{
object actionArguments = null, userId = null;
HttpContext.Items.TryGetValue("ActionRquestData", out actionArguments);
HttpContext.Items.TryGetValue("ControllerName", out object controllerName);
HttpContext.Items.TryGetValue("ActionName", out object actionName);
LogHandler.Logger _logger = HttpContext.RequestServices.GetService <LogHandler.Logger>();
if (ex is GenericCustomException || ex is NotFoundCustomException || ex is UnauthorizedCustomException)
{
_logger.WarningLog(ex.Message, actionArguments, errorCode: ErrorCode(ex), identity: Convert.ToString(userId), fileName: $"{controllerName}.cs", methodName: Convert.ToString(actionName));
}
else
{
if (ex.InnerException != null)
{
if (ex.InnerException.GetType() == typeof(GenericCustomException) || ex.InnerException.GetType() == typeof(NotFoundCustomException) || ex.InnerException.GetType() == typeof(UnauthorizedCustomException))
{
_logger.WarningLog(ex.Message, actionArguments, errorCode: ErrorCode(ex), identity: Convert.ToString(userId), fileName: $"{controllerName}.cs", methodName: Convert.ToString(actionName));
}
else
{
_logger.ErrorLog(ex.InnerException.Message, ex, actionArguments, errorCode: ErrorCode(ex), identity: Convert.ToString(userId), fileName: $"{controllerName}.cs", methodName: Convert.ToString(actionName));
}
}
else
{
_logger.ErrorLog(ex.Message, ex, actionArguments, errorCode: ErrorCode(ex), identity: Convert.ToString(userId), fileName: $"{controllerName}.cs", methodName: Convert.ToString(actionName));
}
}
}
public Entity.BaseResponse <List <Entity.DashboardOverviewResponse> > GetStatistics()
{
Entity.BaseResponse <List <Entity.DashboardOverviewResponse> > result = new Entity.BaseResponse <List <Entity.DashboardOverviewResponse> >();
try
{
_logger.InfoLog(Constants.ACTION_ENTRY, "GeneratorRepository.Get");
using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
{
List <DbParameter> parameters = sqlDataAccess.CreateParams(SolutionConfiguration.CurrentUserId, SolutionConfiguration.Version);
parameters.Add(sqlDataAccess.CreateParameter("guid", SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("syncDate", DateTime.UtcNow, DbType.DateTime, ParameterDirection.Output));
DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[CompanyStatistics_Get]", CommandType.StoredProcedure, null), parameters.ToArray());
result.Data = DataUtils.DataReaderToList <Entity.DashboardOverviewResponse>(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, "GeneratorRepository.Get");
}
catch (Exception ex)
{
_logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
}
return(result);
}
public List <Response.EnergyUsageResponse> GetEnergyUsage(Request.ChartRequest request)
{
List <Response.EnergyUsageResponse> result = new List <Response.EnergyUsageResponse>();
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_CurrentConsumption]", CommandType.StoredProcedure, null), parameters.ToArray());
result = DataUtils.DataReaderToList <Response.EnergyUsageResponse>(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 List <Entity.CompanyConfig> Get()
{
try
{
return(_companyConfigRepository.GetAll().Where(e => !e.IsDeleted).Select(p => Mapper.Configuration.Mapper.Map <Entity.CompanyConfig>(p)).ToList());
}
catch (Exception ex)
{
_logger.ErrorLog(ex, "CompanyConfig.Get " + ex);
return(null);
}
}
public List <Entity.CompanyConfig> Get()
{
try
{
return(_companyConfigRepository.GetAll().Where(e => !e.IsDeleted).Select(p => Mapper.Configuration.Mapper.Map <Entity.CompanyConfig>(p)).ToList());
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
return(null);
}
}
public Entity.SearchResult <List <Entity.AdminRule> > List(Entity.SearchRequest request)
{
try
{
return(_adminRuleRepository.List(request));
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
return(new Entity.SearchResult <List <Entity.AdminRule> >());
}
}
public Entity.SearchResult <List <Entity.AdminRule> > List(Entity.SearchRequest request)
{
try
{
return(_adminRuleRepository.List(request));
}
catch (Exception ex)
{
_logger.ErrorLog(ex, $"AdminRuleService.List, Error: {ex.Message}");
return(new Entity.SearchResult <List <Entity.AdminRule> >());
}
}
public Response.CountryResponse GetCountryLookUp()
{
Response.CountryResponse response = new Response.CountryResponse();
try
{
response = _subscriberHelper.GetCountryData();
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
return(response);
}
public void DailyProcess()
{
_logger.InfoLog(LogHandler.Constants.ACTION_ENTRY, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
try
{
var status = _chartService.TelemetrySummary_DayWise();
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
_logger.InfoLog(LogHandler.Constants.ACTION_EXIT, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
public Entity.SearchResult <List <Entity.HardwareKitResponse> > List(Entity.SearchRequest request, bool isAssigned)
{
try
{
var result = _hardwareKitRepository.List(request, isAssigned, null);
return(result);
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
return(new Entity.SearchResult <List <Entity.HardwareKitResponse> >());
}
}
public Entity.SearchResult <List <Entity.AllRuleResponse> > List(Entity.SearchRequest request)
{
Entity.SearchResult <List <Entity.AllRuleResponse> > result = new SearchResult <List <AllRuleResponse> >();
try
{
IOT.DataResponse <List <IOT.AllRuleResult> > rules = _iotConnectClient.Rule.All(new IoTConnect.Model.PagingModel()
{
PageNo = 1, PageSize = 1000
}).Result;
if (rules.status && rules.data != null)
{
result = new Entity.SearchResult <List <Entity.AllRuleResponse> >()
{
Items = rules.data.Select(p => Mapper.Configuration.Mapper.Map <Entity.AllRuleResponse>(p)).ToList(),
Count = rules.data.Count
};
}
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
return(new Entity.SearchResult <List <Entity.AllRuleResponse> >());
}
return(result);
}
public List <Entity.LookupItem> GetSensors(Guid deviceId)
{
List <Entity.LookupItem> result = new List <Entity.LookupItem>();
try
{
var template = _kitTypeRepository.FindBy(t => !t.IsDeleted).FirstOrDefault();//.Name == SolutionConfiguration.DefaultIoTTemplateName
if (template != null)
{
var childAttribute = (from child in _kitTypeAttributeRepository.FindBy(t => t.TemplateGuid == template.Guid && t.ParentTemplateAttributeGuid != null)
select child.ParentTemplateAttributeGuid).ToList();
result.AddRange(from device in _deviceRepository.FindBy(t => t.Guid == deviceId)
join attribute in _kitTypeAttributeRepository.FindBy(t => t.TemplateGuid == template.Guid) on 1 equals 1
where !childAttribute.Contains(attribute.Guid)
select new Entity.LookupItem()
{
Text = string.Format("{0}", attribute.LocalName),
Value = attribute.Guid.ToString()
});
}
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
return(result);
}
public Entity.SearchResult <List <Entity.AlertResponse> > AlertList(Entity.AlertRequest request)
{
Entity.SearchResult <List <Entity.AlertResponse> > result = new Entity.SearchResult <List <Entity.AlertResponse> >();
try
{
result = _notificationsRepository.GetAlertList(request);
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
return(result);
}
return(result);
}
public virtual void BeginTransaction()
{
_logger.InfoLog(LogHandler.Constants.ACTION_ENTRY, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
try
{
InTransaction = true;
_transaction = DbContext.Database.BeginTransaction();
_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);
throw;
}
}
public virtual void BeginTransaction()
{
_logger.InfoLog(Constants.ACTION_ENTRY, "UnitOfWork.BeginTransaction");
try
{
InTransaction = true;
_transaction = DbContext.Database.BeginTransaction();
_logger.InfoLog(Constants.ACTION_EXIT, "UnitOfWork.BeginTransaction");
}
catch (Exception ex)
{
_logger.ErrorLog(ex + ":UnitofWork.BeginTransaction", ex);
throw;
}
}
public Entity.BaseResponse <Entity.BuildingOverviewResponse> GetBuildingOverview(Guid buildingId, string frequency)
{
var result = new Entity.BaseResponse <Entity.BuildingOverviewResponse>(true);
try
{
result.Data = _entityService.GetBuildingOverview(buildingId, frequency);
}
catch (Exception ex)
{
_logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
return(new Entity.BaseResponse <Entity.BuildingOverviewResponse>(false, ex.Message));
}
return(result);
}
public Entity.SearchResult <List <Entity.AlertResponse> > GetAlertList(Entity.AlertRequest request)
{
Entity.SearchResult <List <Entity.AlertResponse> > result = new Entity.SearchResult <List <Entity.AlertResponse> >();
try
{
logger.InfoLog(Constants.ACTION_ENTRY, MethodBase.GetCurrentMethod().Name);
using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
{
List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, "v1");
parameters.Add(sqlDataAccess.CreateParameter("companyGuid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input));
if (!string.IsNullOrEmpty(request.EntityGuid))
{
parameters.Add(sqlDataAccess.CreateParameter("entityGuid", Guid.Parse(request.EntityGuid), DbType.Guid, ParameterDirection.Input));
}
if (!string.IsNullOrEmpty(request.DeviceGuid))
{
parameters.Add(sqlDataAccess.CreateParameter("deviceGuid", Guid.Parse(request.DeviceGuid), DbType.Guid, ParameterDirection.Input));
}
parameters.Add(sqlDataAccess.CreateParameter("pagesize", request.PageSize, DbType.Int32, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("pagenumber", request.PageNumber, DbType.Int32, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("orderby", request.OrderBy, DbType.String, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16));
System.Data.Common.DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[Alert_List]", CommandType.StoredProcedure, null), parameters.ToArray());
result.Items = DataUtils.DataReaderToList <Entity.AlertResponse>(dbDataReader, null);
result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString());
}
logger.InfoLog(Constants.ACTION_EXIT, MethodBase.GetCurrentMethod().Name);
}
catch (Exception ex)
{
logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
}
return(result);
}
public Model.User Get(string userName)
{
var result = new Model.User();
try
{
logger.InfoLog(Constants.ACTION_ENTRY, "UserRepository.Get");
_uow.DbContext.User.Where(u => u.Email.Equals(userName, StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault();
logger.InfoLog(Constants.ACTION_EXIT, "UserRepository.Get");
}
catch (Exception ex)
{
logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
}
return(result);
}
public Model.User Get(string userName)
{
var result = new Model.User();
try
{
_logger.InfoLog(LogHandler.Constants.ACTION_ENTRY, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
_uow.DbContext.User.Where(u => u.Email.Equals(userName, StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault();
_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 ActionStatus Manage(Entity.AddCompanyRequest request)
{
Entity.ActionStatus actionStatus = new Entity.ActionStatus(true);
try
{
if (request.Guid == null || request.Guid == Guid.Empty)
{
request.CreatedBy = component.helper.SolutionConfiguration.CurrentUserId;
request.CreatedDate = DateTime.Now;
actionStatus = _companyRepository.Manage(request);
actionStatus.Data = Mapper.Configuration.Mapper.Map <Model.Company, Entity.Company>(actionStatus.Data);
if (!actionStatus.Success)
{
_logger.ErrorLog(new Exception($"Company is not added in solution database, Error: {actionStatus.Message}")
, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
}
else
{
var olddbCompany = _companyRepository.GetByUniqueId(x => x.Guid == request.Guid);
if (olddbCompany == null)
{
throw new NotFoundCustomException($"{CommonException.Name.NoRecordsFound} : Company");
}
request.CreatedDate = olddbCompany.CreatedDate;
request.CreatedBy = olddbCompany.CreatedBy.Value;
request.UpdatedBy = component.helper.SolutionConfiguration.CurrentUserId;
request.UpdatedDate = DateTime.Now;
actionStatus = _companyRepository.Manage(request);
actionStatus.Data = Mapper.Configuration.Mapper.Map <Model.Company, Entity.Company>(actionStatus.Data);
if (!actionStatus.Success)
{
_logger.ErrorLog(new Exception($"Company is not added in solution database, Error: {actionStatus.Message}")
, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
}
}
catch (Exception ex)
{
_logger.InfoLog(Constants.ACTION_EXCEPTION, "Company.InsertCompany " + ex);
actionStatus.Success = false;
actionStatus.Message = ex.Message;
}
return(actionStatus);
}
public List <Entity.LookupItem> GetLookup(Guid companyId)
{
var result = new List <Entity.LookupItem>();
try
{
logger.InfoLog(Constants.ACTION_ENTRY, "EntityRepository.GetLookup");
result = _uow.DbContext.Entity.Where(u => u.CompanyGuid.Equals(companyId) && !u.Guid.Equals(component.helper.SolutionConfiguration.EntityGuid) && u.ParentEntityGuid.Equals(SolutionConfiguration.EntityGuid) && u.IsActive == true && !u.IsDeleted).Select(g => new Entity.LookupItem()
{
Text = g.Name, Value = g.Guid.ToString()
}).ToList();
logger.InfoLog(Constants.ACTION_EXIT, "EntityRepository.GetLookup");
}
catch (Exception ex)
{
logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
}
return(result);
}
public List <Entity.LookupItem> GetLookup(Guid companyId)
{
var result = new List <Entity.LookupItem>();
try
{
_logger.InfoLog(LogHandler.Constants.ACTION_ENTRY, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
result = _uow.DbContext.GreenHouse.Where(u => u.CompanyGuid.Equals(companyId) && !u.Guid.Equals(component.helper.SolutionConfiguration.EntityGuid) && u.IsActive == true && !u.IsDeleted).Select(g => new Entity.LookupItem()
{
Text = g.Name, Value = g.Guid.ToString()
}).ToList();
_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 List <Entity.LookupItem> GetFarmsLookup(Guid companyId)
{
List <Entity.LookupItem> lstResult = new List <Entity.LookupItem>();
try
{
lstResult = (from g in _dashboardrepository.FindBy(r => r.CompanyGuid == companyId)
select new Entity.LookupItem()
{
Text = g.Name,
Value = g.Guid.ToString().ToUpper()
}).ToList();
}
catch (Exception ex)
{
_logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
return(lstResult);
}
public void CompanyProcessMessage(MessageModel subscribeData)
{
try
{
var xmlCompanyData = Convert.ToString(JsonConvert.DeserializeXNode(JsonConvert.SerializeObject(subscribeData.Data), "items"));
var baseDataAccess = new BaseDataAccess(_connectionString);
var sqlParameters = new List <SqlParameter>()
{
baseDataAccess.AddInParameter("ComapnyXml", xmlCompanyData),
baseDataAccess.AddInParameter("action", subscribeData.Action),
baseDataAccess.AddInParameter("companyGuid", subscribeData.Company)
};
baseDataAccess.Execute("IotConnect_ManageCompany", sqlParameters);
}
catch (Exception ex)
{
_logger.ErrorLog(new Exception($"Error in sync iotconnect company data : {ex.Message}, StackTrace : {ex.StackTrace}, Data : {JsonConvert.SerializeObject(subscribeData)}"), this.GetType().Name, MethodBase.GetCurrentMethod().Name);
}
}
public Entity.ActionStatus TelemetrySummary_DayWise()
{
Entity.ActionStatus actionStatus = new Entity.ActionStatus(true);
try
{
_logger.InfoLog(LogHandler.Constants.ACTION_ENTRY, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
{
List <DbParameter> parameters = new List <DbParameter>();
sqlDataAccess.ExecuteNonQuery(sqlDataAccess.CreateCommand("[TelemetrySummary_DayWise_Add]", CommandType.StoredProcedure, null), parameters.ToArray());
}
_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);
actionStatus.Success = false;
actionStatus.Message = ex.Message;
}
return(actionStatus);
}
