public void updateCompany(int id, Update company)
{
DBHelper._Company dbhelp = new DBHelper._Company();
Company existingCompany = dbhelp.GetByid(id);
if (existingCompany == null)
{
throw new CDSException(10301);
}
existingCompany.Name = company.Name;
existingCompany.ShortName = company.ShortName;
existingCompany.Address = company.Address;
existingCompany.CompanyWebSite = company.CompanyWebSite;
existingCompany.ContactName = company.ContactName;
existingCompany.ContactEmail = company.ContactEmail;
existingCompany.ContactPhone = company.ContactPhone;
existingCompany.Latitude = company.Latitude;
existingCompany.Longitude = company.Longitude;
existingCompany.CultureInfo = company.CultureInfoId;
existingCompany.AllowDomain = company.AllowDomain;
existingCompany.ExtAppAuthenticationKey = company.ExtAppAuthenticationKey;
if (company.DeletedFlag.HasValue)
{
existingCompany.DeletedFlag = (bool)company.DeletedFlag;
}
dbhelp.Update(existingCompany);
}
public Detail_readonly getCompanyByIdReadonly(int id)
{
DBHelper._Company dbhelp = new DBHelper._Company();
Company company = dbhelp.GetByid(id);
if (company == null)
{
throw new CDSException(10301);
}
return(new Detail_readonly()
{
Name = company.Name,
ShortName = company.ShortName,
Address = company.Address,
CompanyWebSite = company.CompanyWebSite,
ContactName = company.ContactName,
ContactPhone = company.ContactPhone,
ContactEmail = company.ContactEmail,
Latitude = (float)company.Latitude,
Longitude = (float)company.Longitude,
LogoURL = company.LogoURL,
CultureInfoName = (company.RefCultureInfo == null ? "" : company.RefCultureInfo.Name)
});
}
public List <Detail> getAllCompaniesBySuperAdmin()
{
DBHelper._Company dbhelp = new DBHelper._Company();
var companyList = dbhelp.GetAll();
if (companyList == null)
{
throw new CDSException(10301);
}
return(companyList.Select(s => new Detail()
{
Id = s.Id,
Name = s.Name,
ShortName = s.ShortName,
Address = s.Address,
CompanyWebSite = s.CompanyWebSite,
ContactName = s.ContactName,
ContactPhone = s.ContactPhone,
ContactEmail = s.ContactEmail,
Latitude = (float)s.Latitude,
Longitude = (float)s.Longitude,
LogoURL = s.LogoURL,
CultureInfoId = s.CultureInfo,
CultureInfoName = (s.RefCultureInfo == null ? "" : s.RefCultureInfo.Name),
AllowDomain = s.AllowDomain,
ExtAppAuthenticationKey = s.ExtAppAuthenticationKey,
DeletedFlag = s.DeletedFlag,
}).ToList <Detail>());
}
public Detail getCompanyById(int id)
{
DBHelper._Company dbhelp = new DBHelper._Company();
Company company = dbhelp.GetByid(id);
if (company == null)
{
throw new CDSException(10301);
}
return(new Detail()
{
Id = company.Id,
Name = company.Name,
ShortName = company.ShortName,
Address = company.Address,
CompanyWebSite = company.CompanyWebSite,
ContactName = company.ContactName,
ContactPhone = company.ContactPhone,
ContactEmail = company.ContactEmail,
Latitude = (float)company.Latitude,
Longitude = (float)company.Longitude,
LogoURL = company.LogoURL,
CultureInfoId = company.CultureInfo,
CultureInfoName = (company.RefCultureInfo == null ? "" : company.RefCultureInfo.Name),
AllowDomain = company.AllowDomain,
ExtAppAuthenticationKey = company.ExtAppAuthenticationKey,
DeletedFlag = company.DeletedFlag
});
}
public void deleteCompany(int id)
{
DBHelper._Company dbhelp = new DBHelper._Company();
Company existingCompany = dbhelp.GetByid(id);
dbhelp.Delete(existingCompany);
}
public List <Detail> getAllCompaniesBySuperAdmin()
{
DBHelper._Company dbhelp = new DBHelper._Company();
return(dbhelp.GetAllBySuperAdmin().Select(s => new Detail()
{
Id = s.Id,
Name = s.Name,
ShortName = s.ShortName,
Address = s.Address,
CompanyWebSite = s.CompanyWebSite,
ContactName = s.ContactName,
ContactPhone = s.ContactPhone,
ContactEmail = s.ContactEmail,
Latitude = (float)s.Latitude,
Longitude = (float)s.Longitude,
LogoURL = s.LogoURL,
CultureInfoId = s.CultureInfo,
CultureInfoName = (s.RefCultureInfo == null ? "" : s.RefCultureInfo.Name),
DocDBConnectionString = s.DocDBConnectionString,
AllowDomain = s.AllowDomain,
ExtAppAuthenticationKey = s.ExtAppAuthenticationKey,
DeletedFlag = s.DeletedFlag,
}).ToList <Detail>());
}
public List <Detail> GetAllOperationTaskByCompanyId(int companyId)
{
DBHelper._OperationTask dbhelp = new DBHelper._OperationTask();
DBHelper._Company dbhelp_company = new DBHelper._Company();
List <OperationTask> operationTaskList = new List <OperationTask>();
List <Detail> returnOperationtTaskDetail = new List <Detail>();
DateTime invaildDatetime = new DateTime(1, 1, 1);
operationTaskList = dbhelp.GetAllByCompanyId(companyId);
foreach (OperationTask operationTask in operationTaskList)
{
Company company = dbhelp_company.GetByid((int)operationTask.CompanyId);
returnOperationtTaskDetail.Add(new Detail()
{
Id = operationTask.Id,
Name = operationTask.Name,
TaskStatus = operationTask.TaskStatus,
CompanyId = (int)operationTask.CompanyId,
CompanyName = company == null ? "" : company.Name,
CompletedAt = operationTask.CompletedAt,
RetryCounter = (operationTask.RetryCounter == null) ? "" : operationTask.RetryCounter.ToString(),
Entity = operationTask.Entity,
EntityId = operationTask.EntityId,
TaskContent = (operationTask.TaskContent == null) ? null : JObject.Parse(operationTask.TaskContent),
TaskLog = operationTask.TaskLog
});
}
return(returnOperationtTaskDetail);
}
public void updateCompanyLogoURL(int id, string url)
{
DBHelper._Company dbhelp = new DBHelper._Company();
Company existingCompany = dbhelp.GetByid(id);
existingCompany.LogoURL = url;
dbhelp.Update(existingCompany);
}
public void deleteCompany(int id)
{
DBHelper._Company dbhelp = new DBHelper._Company();
Company existingCompany = dbhelp.GetByid(id);
if (existingCompany == null)
{
throw new CDSException(10301);
}
dbhelp.Delete(existingCompany);
}
public void updateCompanyLogoURL(int id, string url)
{
DBHelper._Company dbhelp = new DBHelper._Company();
Company existingCompany = dbhelp.GetByid(id);
if (existingCompany == null)
{
throw new CDSException(10301);
}
existingCompany.LogoURL = url;
dbhelp.Update(existingCompany);
}
public Detail getOperationTaskById(int id)
{
DBHelper._OperationTask dbhelp = new DBHelper._OperationTask();
DBHelper._Company dbhelp_company = new DBHelper._Company();
OperationTask operationTask = dbhelp.GetByid(id);
Company company = dbhelp_company.GetByid((int)operationTask.CompanyId);
return(new Detail()
{
Id = operationTask.Id,
Name = operationTask.Name,
TaskStatus = operationTask.TaskStatus,
CompanyId = (int)operationTask.CompanyId,
CompanyName = company == null ? "" : company.Name,
CompletedAt = operationTask.CompletedAt,
RetryCounter = (operationTask.RetryCounter == null) ? "" : operationTask.RetryCounter.ToString(),
Entity = operationTask.Entity,
EntityId = operationTask.EntityId,
TaskContent = (operationTask.TaskContent == null) ? null : JObject.Parse(operationTask.TaskContent),
TaskLog = operationTask.TaskLog
});
}
public int addCompany(Add company)
{
DBHelper._Company dbhelp = new DBHelper._Company();
var newCompany = new Company()
{
Name = company.Name,
ShortName = company.ShortName,
Address = company.Address,
CompanyWebSite = company.CompanyWebSite,
ContactName = company.ContactName,
ContactPhone = company.ContactPhone,
ContactEmail = company.ContactEmail,
Latitude = (float)company.Latitude,
Longitude = (float)company.Longitude,
CultureInfo = company.CultureInfoId,
CreatedAt = DateTime.Parse(DateTime.Now.ToString()),
DeletedFlag = false,
AllowDomain = company.AllowDomain,
ExtAppAuthenticationKey = company.ExtAppAuthenticationKey
};
return(dbhelp.Add(newCompany));
}
public override void Exec()
{
RecordStartLog();
DBHelper._Company dbhelp_Company = new DBHelper._Company();
DBHelper._Factory dbhelp_Facotry = new DBHelper._Factory();
DBHelper._Equipment dbhelp_Equipment = new DBHelper._Equipment();
DBHelper._UsageLog dbhelp_UsageLog = new DBHelper._UsageLog();
List <UsageLog> usageLogList = new List <UsageLog>();
foreach (var company in dbhelp_Company.GetAll())
{
int companyId = company.Id;
int factoryQty = 0;
int equipmentQty = 0;
long deviceMsgQty = 0;
long alarmMsgQty = 0;
int DocDbSizeInGB = 0;
int DocDBPercentage = 0;
try
{
foreach (var factory in dbhelp_Facotry.GetAllByCompanyId(companyId))
{
factoryQty++;
equipmentQty += dbhelp_Equipment.GetAllByFactoryId(factory.Id).Count;
}
DocumentDBHelper docDBHelpler = new DocumentDBHelper(companyId, company.DocDBConnectionString);
docDBHelpler.Init();
deviceMsgQty = docDBHelpler.GetCompanyDeviceMsgQty();
alarmMsgQty = docDBHelpler.GetCompanyAlarmMessageQty();
DocDbSizeInGB = Convert.ToInt32(docDBHelpler._SizeQuotaInKB / (1024 * 1024));
DocDBPercentage = Convert.ToInt32(docDBHelpler._SizeUsageInKB * 100 / docDBHelpler._SizeQuotaInKB);
}
catch (Exception ex)
{
StringBuilder logMessage = new StringBuilder();
logMessage.AppendLine("Routine TaskActor : " + _TaskName);
logMessage.AppendLine("\tCompayId " + companyId + " is failed");
logMessage.AppendLine("\tException: " + ex.Message);
if (ex.InnerException != null)
{
logMessage.AppendLine("\tInnerException: " + ex.InnerException.Message);
}
_sfAppLogger.Error(logMessage);
}
usageLogList.Add(new UsageLog()
{
CompanyId = companyId,
FactoryQty = factoryQty,
EquipmentQty = equipmentQty,
DeviceMessage = deviceMsgQty,
AlarmMessage = alarmMsgQty,
DocSizeInGB = DocDbSizeInGB,
DocDBPercentage = DocDBPercentage,
UpdatedAt = DateTime.Now
});
}
try
{
dbhelp_UsageLog.Add(usageLogList);
}
catch (Exception ex)
{
StringBuilder logMessage = new StringBuilder();
logMessage.AppendLine("Routine TaskActor : " + _TaskName);
logMessage.AppendLine("\tException: " + ex.Message);
logMessage.AppendLine("\tInnerException: " + ex.InnerException.Message);
_sfAppLogger.Error(logMessage);
}
RecordEndLog();
}
public List <Detail> searchInPastSevenDaysOperations(SearchCondition condition, int companyId = 0)
{
int hours;
string taskStatus;
if (condition == null)
{
hours = -168;
taskStatus = null;
}
else
{
hours = (condition.hours == 0 || condition.hours > 168) ? -168 : -(condition.hours);
taskStatus = condition.taskStatus;
}
DBHelper._OperationTask dbhelp = new DBHelper._OperationTask();
DBHelper._Company dbhelp_company = new DBHelper._Company();
List <OperationTask> operationTaskList = new List <OperationTask>();
List <Detail> returnOperationtTaskDetail = new List <Detail>();
if (companyId > 0)
{
operationTaskList = dbhelp.Search(taskStatus, hours, companyId);
Company company = dbhelp_company.GetByid(companyId);
foreach (OperationTask operationTask in operationTaskList)
{
try
{
returnOperationtTaskDetail.Add(new Detail()
{
Id = operationTask.Id,
Name = operationTask.Name,
TaskStatus = operationTask.TaskStatus,
CompanyId = (int)operationTask.CompanyId,
CompanyName = company == null ? "" : company.Name,
CompletedAt = operationTask.CompletedAt,
RetryCounter = (operationTask.RetryCounter == null) ? "" : operationTask.RetryCounter.ToString(),
Entity = operationTask.Entity,
EntityId = operationTask.EntityId,
TaskContent = (operationTask.TaskContent == null) ? null : JObject.Parse(operationTask.TaskContent),
TaskLog = operationTask.TaskLog
});
}
catch { }
}
}
else
{
operationTaskList = dbhelp.Search(taskStatus, hours);
List <int> companyIdList = operationTaskList.Select(s => (int)s.CompanyId).Distinct().ToList <int>();
CDStudioEntities dbEntity = new CDStudioEntities();
var L2Enty = from c in dbEntity.Company
where companyIdList.Contains(c.Id)
select new { Id = c.Id, Name = c.Name };
Dictionary <int, string> companyTable = new Dictionary <int, string>();
foreach (var company in L2Enty)
{
companyTable.Add(company.Id, company.Name);
}
foreach (OperationTask operationTask in operationTaskList)
{
try
{
returnOperationtTaskDetail.Add(new Detail()
{
Id = operationTask.Id,
Name = operationTask.Name,
TaskStatus = operationTask.TaskStatus,
CompanyId = (int)operationTask.CompanyId,
CompanyName = companyTable.ContainsKey((int)operationTask.CompanyId) ? companyTable[(int)operationTask.CompanyId] : "",
CompletedAt = operationTask.CompletedAt,
RetryCounter = (operationTask.RetryCounter == null) ? "" : operationTask.RetryCounter.ToString(),
Entity = operationTask.Entity,
EntityId = operationTask.EntityId,
TaskContent = (operationTask.TaskContent == null) ? null : JObject.Parse(operationTask.TaskContent),
TaskLog = operationTask.TaskLog
});
}
catch { }
}
}
return(returnOperationtTaskDetail);
}
