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