/// <summary>
/// method adds new user to local database
/// </summary>
/// <param name="name">name of new user</param>
/// <param name="token">token of new user</param>
public void saveUserToLocalDatabase(String name, String token)
{
List<User> users;
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
users = context.user.ToList();
User user = new User();
if (users.Count > 0)
{
user = users.First();
user.username = name;
user.token = token;
context.SaveChanges();
}
else
{
user.id = 1;
user.username = name;
user.token = token;
context.user.Add(user);
context.SaveChanges();
}
ChangeService.userToken = user.token;
}
}
}
public List <houseinfo> Get(string HouseArea)
{
using (var dbContext = new LocalDBContext())
{
return(dbContext.houseinfo.Where(i => i.HouseArea.Contains(HouseArea)).ToList());
}
}
public void saveReport(DefectReport report)
{
try
{
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
var oldReport = from r in context.defectReports
where r.ruleGUID == report.ruleGUID
select r;
DefectReport old = oldReport.FirstOrDefault();
if (old != null)
{
old.actionsBeforeCorrection = report.actionsBeforeCorrection;
context.SaveChanges();
}
else
{
context.defectReports.Add(report);
context.SaveChanges();
}
}
}
}
catch (Exception ex) { }
}
public Task <List <EventDb> > GetEvents(LocalDBContext context)
{
//LocalDBContext context = new LocalDBContext();
return(Task.FromResult(context.Events.Select(s => new EventDb {
Name = s.Name, Date = s.Date
}).ToList()));
}
public UserProfile Get(string Id)
{
using (var context = new LocalDBContext())
{
return(context.UserProfile.Where(i => i.Id == Id && i.SysStatus == UserProfile.EnumSysType.正常).FirstOrDefault());
}
}
public PermissionInfo Get(string Id)
{
using (var context = new LocalDBContext())
{
return(context.PermissionInfo.Where(i => i.Id == Id && i.Delflag == EnumType.DelflagType.正常).FirstOrDefault());
}
}
public List <PermissionInfo> GetAll()
{
using (var context = new LocalDBContext())
{
return(context.PermissionInfo.Where(x => x.Delflag == EnumType.DelflagType.正常).OrderBy(x => x.CDate).ToList());
}
}
public Statistics GetPV()
{
using (var Context = new LocalDBContext())
{
return(Context.Statistics.FirstOrDefault());
}
}
private void PreprocessCommandLine()
{
Log.Info("Enter PreprocessCommandLine()");
//check if it need finish updating.
if (CommandLine.ContainSwitchOption("update"))
{
ProgramUpdater.ApplyUpdate();
}
if (CommandLine.ContainSwitchOption("update_plugin"))
{
PluginUpdaterManager.ApplyPluginUpdate();
}
if (CommandLine.ContainSwitchOption("database_backup"))
{
if (CommandLine.TryGetOptionValue("to", out string to))
{
LocalDBContext.BackupDatabase(to);
Environment.Exit(0);
}
}
if (CommandLine.ContainSwitchOption("database_restore"))
{
if (CommandLine.TryGetOptionValue("to", out string to) && CommandLine.TryGetOptionValue("from", out string from))
{
LocalDBContext.RestoreDatabase(from, to);
Environment.Exit(0);
}
}
}
public bool Add(RedisMQLog _redisMQLog)
{
using (var context = new LocalDBContext()) {
context.RedisMQLog.Add(_redisMQLog);
context.SaveChanges();
return(true);
}
}
public bool Add(UserProfile _UserProfile)
{
using (var context = new LocalDBContext()) {
context.UserProfile.Add(_UserProfile);
context.SaveChanges();
return(true);
}
}
public bool AddPV(Statistics _Statistics)
{
using (var Context = new LocalDBContext()) {
Context.Statistics.Add(_Statistics);
Context.SaveChanges();
return(true);
}
}
public bool Add(PermissionInfo _PermissionInfo)
{
using (var context = new LocalDBContext())
{
context.PermissionInfo.Add(_PermissionInfo);
context.SaveChanges();
return(true);
}
}
public HomeController(ILogger <HomeController> logger, IOptions <AppSetting> option, IUserInfoRepository repository, IMapper mapper, LocalDBContext1 dbContext1, LocalDBContext dbContext2)
{
this._logger = logger;
this._option = option;
this._repository = repository;
this._mapper = mapper;
this._dbContext1 = dbContext1;
this._dbContext2 = dbContext2;
}
public bool Add(RolePermission _RolePermission)
{
using (var context = new LocalDBContext())
{
context.RolePermission.Add(_RolePermission);
context.SaveChanges();
return(true);
}
}
public bool Add(RoleInfo _RoleInfo)
{
using (var context = new LocalDBContext())
{
context.RoleInfo.Add(_RoleInfo);
context.SaveChanges();
return(true);
}
}
public bool Update(RedisMQLog _redisMQLog)
{
using (var context = new LocalDBContext())
{
context.RedisMQLog.Attach(_redisMQLog);
context.Entry(_redisMQLog).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return(true);
}
}
public bool Delete(UserProfile _UserProfile)
{
using (var context = new LocalDBContext())
{
context.UserProfile.Attach(_UserProfile);
context.Entry(_UserProfile).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return(true);
}
}
public bool Delete(PermissionInfo _PermissionInfo)
{
using (var context = new LocalDBContext())
{
context.PermissionInfo.Attach(_PermissionInfo);
context.Entry(_PermissionInfo).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return(true);
}
}
public bool Delete(RolePermission _RolePermission)
{
using (var context = new LocalDBContext())
{
context.RolePermission.Attach(_RolePermission);
context.Entry(_RolePermission).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return(true);
}
}
public bool UpdatePV(Statistics _Statistics)
{
using (var Context = new LocalDBContext())
{
Context.Statistics.Attach(_Statistics);
Context.Entry(_Statistics).State = System.Data.Entity.EntityState.Modified;
Context.SaveChanges();
return(true);
}
}
public bool Update(RoleInfo _RoleInfo)
{
using (var context = new LocalDBContext())
{
context.RoleInfo.Attach(_RoleInfo);
context.Entry(_RoleInfo).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return(true);
}
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.AddScoped(
typeof(IEntitiesRepository),
sp => new EntitiesRepository());
services.AddScoped(
typeof(DbContext),
sp =>
{
var context = new LocalDBContext(sp.GetService <IEntitiesRepository>());
Seed(context);
return(context);
});
services.AddScoped(
typeof(IBlobRepository),
sp => new BlobRepository());
services.AddScoped(
typeof(IQueryableRepository <Models.FileInfo>),
sp => new EntityFrameworkRepository <Models.FileInfo>(sp.GetService <DbContext>()));
// Register the Swagger generator, defining 1 or more Swagger documents
services.AddSwaggerGen(c =>
{
c.SwaggerDoc("v1", new Info
{
Version = "v1",
Title = "DataHub API",
Description = "A simple DataHub API",
TermsOfService = "None",
Contact = new Contact
{
Name = "HT/KM",
Email = string.Empty,
},
License = new License
{
Name = "",
Url = ""
}
});
var xmlFile = $"{Assembly.GetExecutingAssembly().GetName().Name}.xml";
var xmlPath = Path.Combine(AppContext.BaseDirectory, xmlFile);
c.IncludeXmlComments(xmlPath);
});
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1).AddJsonOptions(options =>
{
options.SerializerSettings.ContractResolver = new CamelCasePropertyNamesContractResolver();
options.SerializerSettings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;
options.SerializerSettings.NullValueHandling = NullValueHandling.Ignore;
});
}
public APIHandler(
LocalDBContext localDB,
MessageHandler messageHandler,
UserManager <IDUser> manager,
SignInManager <IDUser> signInManager)
{
_localDB = localDB;
_manager = manager;
_signInManager = signInManager;
_msgHandler = messageHandler;
}
public Word getWord(string[] wordString)
{
string wordS = wordString[0].ToLowerInvariant();
using (LocalDBContext context = new LocalDBContext())
{
var words = from w in context.dictionary
where w.word == wordS
select w;
return words.FirstOrDefault<Word>();
}
}
public string getBaseNoun(string wordToConvert)
{
string[] splitWord = wordToConvert.Split(' ');
string word = "";
if (splitWord.Length == 1)
{
word = splitWord[0];
}
else if (splitWord.Length > 1)
{
word = splitWord[1];
}
else
{
return "";
}
using (LocalDBContext context = new LocalDBContext())
{
var words = from w in context.dictionary
where w.word == word.ToLower()
select w.wordBase;
try
{
string wordBase = words.FirstOrDefault<String>();
if (String.IsNullOrEmpty(wordBase))
{
MessageBox.Show("Defect could not be corrected.");
return "";
}
if (splitWord.Length == 1)
{
splitWord[0] = wordBase;
}
else if (splitWord.Length > 1)
{
splitWord[1] = wordBase;
}
}
catch (NullReferenceException)
{
}
}
splitWord[0] = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(splitWord[0].ToLower());
return String.Join(" ", splitWord);
}
/// <summary>
/// method saves model change into local database
/// </summary>
/// <param name="change">instance of ModelChange carrying information about model change</param>
public void saveChange(ModelChange change)
{
try
{
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
context.modelChanges.Add(change);
context.SaveChanges();
}
}
}
catch (Exception ex) { }
}
public PictureDetailViewPage()
{
InitializeComponent();
DB = LocalDBContext.Instance;
MainGrid.DataContext = this;
layout_translate_storyboard = new Storyboard();
layout_translate_storyboard.Completed += (e, d) =>
{
ViewPage_SizeChanged(null, null);
ObjectPool <ThicknessAnimation> .Return(e as ThicknessAnimation);
};
}
public bool Add(TestClass _testClass)
{
try
{
using (var context = new LocalDBContext())
{
context.TestClass.Add(_testClass);
context.SaveChanges();
return(true);
}
}
catch (Exception ee)
{
throw ee;
}
}
/// <summary>
/// method starts activity of thread that uploads model changes in local database
/// </summary>
public void startActivityDispatcher()
{
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
List<User> users = context.user.ToList();
if (users.Count > 0)
{
User user = users.First();
if (user != null)
{
userToken = user.token;
}
else
{
userToken = "123456";
}
}
}
}
int sleepTime = 5 * 60 * 1000; // 5 min
try
{
using (WebClient webClient = new WebClient())
{
using (var stream = webClient.OpenRead(Utils.serviceAddress))
{
stream.Close();
this.uploadChanges();
}
}
}
catch (Exception ex)
{
newEvent.WaitOne(sleepTime);
startActivityDispatcher();
}
}
/// <summary>
/// method gets currently logged user
/// </summary>
/// <returns>instance of logged user</returns>
public User getLoggedUser()
{
List<User> users;
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
users = context.user.ToList();
User user = null;
if (users.Count > 0)
{
user = users.First();
return user;
}
else
{
return null;
}
}
}
}
/// <summary>
/// method finds token of currently logged user in local database
/// </summary>
/// <returns>token of user</returns>
public string findToken()
{
List<User> users;
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
users = context.user.ToList();
User user;
if (users.Count > 0)
{
user = users.First();
return user.token;
}
else
{
return "false";
}
}
}
}
public void uploadReports()
{
List<DefectReport> defectReports;
try
{
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
defectReports = context.defectReports.ToList();
}
}
if (defectReports.Count == 0)
{
Thread.Sleep(15 * 1000);
uploadReports();
}
using (WebClient webClient = new WebClient())
{
string result = "";
string data = "";
foreach (DefectReport defectReport in defectReports)
{
webClient.Headers[HttpRequestHeader.ContentType] = "application/json; charset=utf-8";
defectReport.userToken = userToken;
data = EncodeNonAsciiCharacters(defectReport.serialize());
result = webClient.UploadString(Utils.serviceAddress + "/defectReports", data);
if (result == "")
{
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
context.Remove(defectReport);
context.SaveChanges();
}
}
}
}
}
uploadReports();
}
catch (Exception ex) { }
}
public ClientTicketsController(LocalDBContext context, IHubContext <NewFeedbackHub> hubContext) : base(context)
{
_hubContext = hubContext;
}
public PoderesService(LocalDBContext local)
{
_local = local;
}
public ServerTicketsController(LocalDBContext context) : base(context)
{
}
/// <summary>
/// method updates structure of local database
/// </summary>
public void compareVersions()
{
string addInPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
string number;
try
{
number = File.ReadAllLines(addInPath + "\\version.txt").First();
double currentVersion = findVersion();
double newVersion = double.Parse(number, System.Globalization.CultureInfo.InvariantCulture);
if (newVersion > currentVersion)
{
if (currentVersion <= 1.0)
{
// update db schema
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
context.Database.ExecuteSqlCommand("DROP TABLE IF EXISTS `item_creations`");
context.Database.ExecuteSqlCommand("CREATE TABLE `item_creations` (`timestamp` varchar(255), `itemGUID` varchar(255), `modelGUID` varchar(255), `id` INTEGER PRIMARY KEY AUTOINCREMENT,"
+ "`elementType` int, `parentGUID` varchar(255), `author` varchar(255), `name` varchar(255), `packageGUID` varchar(255), `srcGUID` varchar(255),"
+ "`targetGUID` varchar(255), `diagramGUID` varchar(255), `coordinates` varchar(255), `elementDeleted` int);");
context.Database.ExecuteSqlCommand("DROP TABLE IF EXISTS `model_changes`");
context.Database.ExecuteSqlCommand("CREATE TABLE `model_changes` (`timestamp` varchar(255), `itemGUID` varchar(255), `modelGUID` varchar(255), `id` INTEGER PRIMARY KEY AUTOINCREMENT,"
+ "`elementType` int, `elementDeleted` int);");
context.Database.ExecuteSqlCommand("DROP TABLE IF EXISTS `property_changes`");
context.Database.ExecuteSqlCommand("CREATE TABLE `property_changes` (`timestamp` varchar(255), `itemGUID` varchar(255), `propertyBody` varchar(255), `propertyType` int,"
+ "`elementType` int, `modelGUID` varchar(255), `oldPropertyBody` varchar(255), `id` INTEGER PRIMARY KEY AUTOINCREMENT, `elementDeleted` int);");
context.Database.ExecuteSqlCommand("DROP TABLE IF EXISTS `scenario_changes`");
context.Database.ExecuteSqlCommand("CREATE TABLE `scenario_changes` (`timestamp` varchar(255), `itemGUID` varchar(255), `modelGUID` varchar(255),`id` INTEGER PRIMARY KEY AUTOINCREMENT,"
+ "`elementType` int, `name` varchar(255), `type` varchar(255), `status` int, `scenarioGUID` varchar(255), `elementDeleted` int);");
context.Database.ExecuteSqlCommand("DROP TABLE IF EXISTS `step_changes`");
context.Database.ExecuteSqlCommand("CREATE TABLE `step_changes` (`timestamp` varchar(255), `itemGUID` varchar(255), `modelGUID` varchar(255), `id` INTEGER PRIMARY KEY AUTOINCREMENT,"
+ "`elementType` int, `status` int, `scenarioGUID` varchar(255), `position` int, `stepType` varchar(255), `name` varchar(255), `uses` varchar(255), `results` varchar(255),"
+ "`state` varchar(255), `extensionGUID` varchar(255), `joiningStepGUID` varchar(255), `joiningStepPosition` varchar(255), `stepGUID` varchar(255), `elementDeleted` int);");
}
}
}
if (currentVersion <= 1.1)
{
// update db schema
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
context.Database.ExecuteSqlCommand("DROP TABLE IF EXISTS `defect_reports`");
context.Database.ExecuteSqlCommand("CREATE TABLE `defect_reports` (`timestamp` varchar(255), `ruleName` varchar(255), `modelGUID` varchar(255), `id` INTEGER PRIMARY KEY AUTOINCREMENT,"
+ "`ruleGUID` varchar(255), `actionsBeforeCorrection` int, `isHidden` int);");
}
}
}
this.editVersion(newVersion);
}
}
catch(Exception ex) { }
}
public ProjectsController(LocalDBContext context) : base(context)
{
}
private string getWordFlag(string wordString)
{
wordString = wordString.ToLowerInvariant();
using (LocalDBContext context = new LocalDBContext())
{
var words = from w in context.dictionary
where w.word == wordString
&& w.flags.Substring(4, 1) == "1"
select w.flags;
string flags = words.FirstOrDefault<String>();
return flags;
}
}
/// <summary>
/// method changes current version of EA extension in local database
/// </summary>
/// <param name="actualVersion">current version</param>
public void editVersion(double actualVersion)
{
List<Version> versions;
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
versions = context.version.ToList();
Version version = versions.First();
version.number = actualVersion;
context.SaveChanges();
}
}
}
/// <summary>
/// method finds current version of EA extension in local database
/// </summary>
/// <returns>double value of current version</returns>
public double findVersion()
{
List<Version> versions;
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
versions = context.version.ToList();
Version version = new Version();
if (versions.Count > 0)
{
version = versions.First();
return version.number;
}
else
{
version.id = 1;
version.number = 1.0;
context.version.Add(version);
context.SaveChanges();
return version.number;
}
}
}
}
/// <summary>
/// method uploads changes saved in local database
/// </summary>
public void uploadChanges()
{
List<ModelChange> modelChanges;
try {
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
modelChanges = context.modelChanges.ToList();
modelChanges.AddRange(context.Set<ItemCreation>().ToList());
modelChanges.AddRange(context.Set<PropertyChange>().ToList());
modelChanges.AddRange(context.Set<StepChange>().ToList());
modelChanges.AddRange(context.Set<ScenarioChange>().ToList());
}
}
if (modelChanges.Count == 0)
{
Thread.Sleep(10 * 1000);
uploadChanges();
}
using (WebClient webClient = new WebClient())
{
string result = "";
string data = "";
DTOWrapper dtoWrapper = new DTOWrapper();
dtoWrapper.userToken = userToken;
foreach (ModelChange change in modelChanges)
{
webClient.Headers[HttpRequestHeader.ContentType] = "application/json; charset=utf-8";
dtoWrapper.modelChange = change;
data = EncodeNonAsciiCharacters(dtoWrapper.serialize());
result = webClient.UploadString(Utils.serviceAddress + "/changes", data);
if (result == "")
{
lock (LocalDBContext.Lock)
{
using (LocalDBContext context = new LocalDBContext())
{
context.Remove(change);
context.SaveChanges();
}
}
}
}
}
uploadChanges();
}
catch (Exception ex)
{
throw new Exception();
}
}
public HealthCheckController(LocalDBContext context) : base(context)
{
}
public ClientAlternativesSelectionsController(LocalDBContext context, IHubContext <NewFeedbackHub> hubContext) : base(context)
{
_hubContext = hubContext;
}
public string testSelect()
{
string value = "";
using (LocalDBContext context = new LocalDBContext())
{
var words = (from w in context.dictionary
select w).Take(1);
foreach (Word word in words)
value = word.word;
}
return value;
}
