private void button2_Click(object sender, EventArgs e)
{
using (var db = new LiteDB.LiteDatabase(@"Pokes.db"))
{
Microsoft.Office.Interop.Excel.Application obj;
Microsoft.Office.Interop.Excel.Workbook hoja;
Microsoft.Office.Interop.Excel.Worksheet Sheet;
obj = new Microsoft.Office.Interop.Excel.Application();
hoja = obj.Workbooks.Open(textBox1.Text);
Sheet = (Microsoft.Office.Interop.Excel.Worksheet)hoja.ActiveSheet;
var todo = db.GetCollection <pokemon>("pokemons");
for (int index = 2; index < 89; index++)
{
var pok = new pokemon
{
ID = Convert.ToString(Sheet.Cells[index, 2].Value),
NombrePok = Convert.ToString(Sheet.Cells[index, 1].Value),
HPpok = Convert.ToString(Sheet.Cells[index, 3].Value),
ATKpok = Convert.ToString(Sheet.Cells[index, 4].Value),
DEFpof = Convert.ToString(Sheet.Cells[index, 5].Value),
SATKpok = Convert.ToString(Sheet.Cells[index, 6].Value),
SDEFpok = Convert.ToString(Sheet.Cells[index, 7].Value),
VELpok = Convert.ToString(Sheet.Cells[index, 8].Value)
};
todo.Insert(pok);
}
}
MessageBox.Show("Fin");
}
private void button9_Click(object sender, EventArgs e)
{
using (var db = new LiteDB.LiteDatabase(@"Tipos.db"))
{
Microsoft.Office.Interop.Excel.Application obj;
Microsoft.Office.Interop.Excel.Workbook hoja;
Microsoft.Office.Interop.Excel.Worksheet Sheet;
obj = new Microsoft.Office.Interop.Excel.Application();
hoja = obj.Workbooks.Open(textBox2.Text);
Sheet = (Microsoft.Office.Interop.Excel.Worksheet)hoja.ActiveSheet;
var todo = db.GetCollection <tipos>("Tipos");
for (int index = 2; index < 89; index++)
{
var mov = new tipos
{
id = Convert.ToString(Sheet.Cells[index, 1].Value),
name = Convert.ToString(Sheet.Cells[index, 2].Value),
efectividades = Convert.ToString(Sheet.Cells[index, 3].Value),
neutro = Convert.ToString(Sheet.Cells[index, 4].Value),
inmune = Convert.ToString(Sheet.Cells[index, 5].Value),
poco = Convert.ToString(Sheet.Cells[index, 6].Value)
};
todo.Insert(mov);
}
}
MessageBox.Show("Fin");
}
private void button15_Click(object sender, EventArgs e)
{
using (var db = new LiteDB.LiteDatabase(@"Naturalezas.db"))
{
Microsoft.Office.Interop.Excel.Application obj;
Microsoft.Office.Interop.Excel.Workbook hoja;
Microsoft.Office.Interop.Excel.Worksheet Sheet;
obj = new Microsoft.Office.Interop.Excel.Application();
hoja = obj.Workbooks.Open(textBox5.Text);
Sheet = (Microsoft.Office.Interop.Excel.Worksheet)hoja.ActiveSheet;
var todo = db.GetCollection <naturaleza>("naturaleza");
for (int index = 2; index < 26; index++)
{
var mov = new naturaleza
{
id = Convert.ToString(Sheet.Cells[index, 1].Value),
nombre = Convert.ToString(Sheet.Cells[index, 2].Value),
Ataque = Convert.ToDouble(Sheet.Cells[index, 3].Value),
Defensa = Convert.ToDouble(Sheet.Cells[index, 4].Value),
SAataque = Convert.ToDouble(Sheet.Cells[index, 5].Value),
SDefensa = Convert.ToDouble(Sheet.Cells[index, 6].Value),
Velocidad = Convert.ToDouble(Sheet.Cells[index, 7].Value)
};
todo.Insert(mov);
}
}
MessageBox.Show("Fin");
}
static void Main(string[] args)
{
Logger = new Logger(GetStringSha256Hash(DateTime.UtcNow.ToString()));
if (File.Exists("version.txt"))
{
Logger.LogGenericMessage($"Build {File.ReadAllText("version.txt").Trim()}");
BuildNumber = File.ReadAllText("version.txt").Trim();
}
GlobalConfiguration = new GlobalConfiguration().Load();
GlobalDatabase = new LiteDB.LiteDatabase(@"Filename=files/guildDatabase.db; Mode=Shared; Async=true; Password=" + GlobalConfiguration.DatabasePassword);
GuildConfigs = new Dictionary <ulong, GuildConfig>();
#region Timers
Updater.AutoReset = true;
Updater.Interval = 5 * 1000;
Updater.Elapsed += CheckMuteRemoval;
if (!string.IsNullOrEmpty(GlobalConfiguration.StatusAuthKey))
{
StatusPollingTimer.AutoReset = true;
StatusPollingTimer.Interval = 1 * 1000;
StatusPollingTimer.Elapsed += StatusPollingTimerOnElapsed;
StatusPollingTimer.Start();
}
#endregion Timers
while (true)
{
new GenericBot().Start().GetAwaiter().GetResult();
}
}
public static void Save(string name, string comment, int mark)
{
//nasty haxor
var s = new SurveyResult()
{
Name = name,
Comment = comment,
Date = DateTime.UtcNow.AddHours(2),
Mark = mark
};
Console.WriteLine("-------------");
Console.WriteLine("SURVEY RESULT");
Console.WriteLine($"Name: {s.Name}");
Console.WriteLine($"Comment: {s.Comment}");
Console.WriteLine($"Date: {s.Date}");
Console.WriteLine($"Mark: {s.Mark}");
Console.WriteLine("-------------");
using (var db = new LiteDB.LiteDatabase("db.litedb"))
{
var col = db.GetCollection <SurveyResult>("surveyresults");
col.Insert(s);
}
}
/// <summary>
/// Método que carrega os produtos, pois na consulta de pedidos da API Rest, os itens não carregam os dados mercadológicos
/// </summary>
private static void CarregarProdutos()
{
// Paginação
int page = 1;
logger.Info("Carregar lista de Produtos...");
// Gravando os produtos em uma solução NoSQL local, para evitar realizar muitas consultas na API Rest.
using (var db = new LiteDB.LiteDatabase(@"app.db"))
{
IRestResponse response;
// A cada importação, a lista de produtos é destruida para sempre pegar uma listagem nova
db.DropCollection("produtos");
var produtosDB = db.GetCollection <Produto>("produtos");
do
{
logger.Info($"Carregando produtos página {page}...");
var client = new RestClient((URL_BASE + URL_PRODUTO).Replace("[page]", page.ToString()).Replace("[apikey]", apiKey));
var request = new RestRequest(Method.GET);
response = client.Execute(request);
// Contando os requests para logar. Isso vai ajudar a mensurar quantas requisições estão sendo feitas por execução
qtdeRequest++;
if (response.StatusCode == System.Net.HttpStatusCode.OK && JsonValue.Parse(response.Content)["retorno"].ContainsKey("produtos"))
{
var listProdutosJson = (JsonArray)JsonValue.Parse(response.Content)["retorno"]["produtos"];
foreach (var linha in listProdutosJson)
{
var produtoAux = linha["produto"];
var produto = new Produto
{
codigo = produtoAux["codigo"],
descricao = (string)produtoAux["descricao"],
unidade = produtoAux["unidade"],
grupoProduto = produtoAux["grupoProduto"],
situacao = produtoAux["situacao"],
nomeFornecedor = produtoAux["nomeFornecedor"],
marca = produtoAux["marca"],
preco = produtoAux["preco"],
precoCusto = produtoAux["precoCusto"],
pesoLiq = produtoAux["pesoLiq"],
dataInclusao = produtoAux["dataInclusao"],
dataAlteracao = produtoAux["dataAlteracao"]
};
produtosDB.Insert(produto);
}
}
logger.Info($"Produtos da página {page} carregados");
page++;
} while (response.StatusCode == System.Net.HttpStatusCode.OK && JsonValue.Parse(response.Content)["retorno"].ContainsKey("produtos")); // Continua enquanto houver produto
}
logger.Info("Lista de produtos carregada");
}
private void CountDown(int serialNumber)
{
DeviceDto device;
using (var db = new LiteDatabase(_databaseName))
{
var collection = db.GetCollection <DeviceDto>(_deviceTable);
device = collection.FindOne(d => d.SerialNumber == serialNumber);
device.IsWorking = true;
device.IsInterrupted = false;
collection.Update(device.Id, device);
}
while (device.Credit > 0 && !device.IsInterrupted)
{
using (var db = new LiteDatabase(_databaseName))
{
var collection = db.GetCollection <DeviceDto>(_deviceTable);
var deviceTemp = device;
device = collection.FindOne(d => d.Id == deviceTemp.Id);
device.WorkCount = device.Credit > 10 ? device.WorkCount + 10 : device.WorkCount + device.Credit;
device.Credit = device.Credit > 10 ? device.Credit - 10 : 0;
if (device.Credit == 0)
{
device.IsWorking = false;
device.IsInterrupted = true;
}
collection.Update(device.Id, device);
}
Thread.Sleep(100);
if (device.WorkCount % 100 <= 9)
{
Console.WriteLine($"device {device.SerialNumber} is working, total work done {device.WorkCount} credit left {device.Credit}");
}
}
}
public void SaveRankModel(Dictionary <string, RankModel> dict)
{
System.Diagnostics.Stopwatch stopwatch = new System.Diagnostics.Stopwatch();
stopwatch.Start();
LiteDB.LiteDatabase liteDatabase = new LiteDB.LiteDatabase(this.DbLite);
LiteDB.LiteCollection <RankModel> liteCollection = liteDatabase.GetCollection <RankModel>("博客园排行");
int count = 0;
foreach (KeyValuePair <string, RankModel> itemRank in dict)
{
count++;
LiteDB.BsonValue bsonValue = new LiteDB.BsonValue(itemRank.Value.Url);
RankModel model = liteCollection.FindById(bsonValue);
if (model == null)
{
bsonValue = liteCollection.Insert(itemRank.Value);
}
else
{
}
}
liteDatabase.Dispose();
stopwatch.Stop();
Console.WriteLine(stopwatch.Elapsed);
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
textBox1.Text = comboBox1.Text;
using (var db = new LiteDB.LiteDatabase(@"C:\DBS\Pokes.db"))
{
var collection = db.GetCollection <pokemon>("pokemons");
var pokemons = collection.Find(LiteDB.Query.EQ("NombrePok", textBox1.Text));//collection.FindById(textBox1.Text);
foreach (var algo in pokemons)
{
textBox3.Text = algo.HPpok;
textBox4.Text = algo.ATKpok;
textBox5.Text = algo.DEFpof;
textBox6.Text = algo.SATKpok;
textBox7.Text = algo.SDEFpok;
textBox8.Text = algo.VELpok;
if (checkBox1.Checked)
{
pictureBox1.Image = Image.FromFile(@"C:\Users\oxikr\source\repos\pokeapi\data\v2\sprites\pokemon\shiny\" + algo.ID + ".png");
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
}
else
{
pictureBox1.Image = Image.FromFile(@"C:\Users\oxikr\source\repos\pokeapi\data\v2\sprites\pokemon\" + algo.ID + ".png");
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
}
ID.Text = algo.ID;
}
}
}
public static void Connect(string collectionName)
{
if (Collection != null)
{
throw new TraceStateException("Connection already established.");
}
client = new LiteDB.LiteDatabase(@"MyData.db");
//just to update the description state
var databases = client.GetCollectionNames();
if (client == null)
{
throw new TraceStateException("Local db is unreachable.");
}
Collection = client.GetCollection <Log>(collectionName);
Buffers = new LogBuffer[NumberOfBuffers];
for (int i = 0; i < NumberOfBuffers; i++)
{
Buffers[i] = new LogBuffer();
}
Arbiter = new Arbiter2(Buffers);
//I create a new delegate in order to call a method with a Conditional Attribute
Arbiter.OnAllBuffersFilled += delegate { Flush(); };
timer = new Timer(2000);
timer.AutoReset = true;
timer.Elapsed += delegate { Timer_Elapsed(null, null); };
timer.Start();
}
public void OnGet(int id)
{
using var db = new LiteDB.LiteDatabase("movies.db");
var movies = db.GetCollection <Movie>();
Movie = movies.FindById(id);
}
public async Task <bool> Insert(QueryHashResponse item)
{
return(await Task.Run(() =>
{
try
{
if (item == null)
{
throw new ArgumentNullException(nameof(item));
}
if (string.IsNullOrEmpty(item.MD5Hash))
{
throw new ArgumentNullException(nameof(item.MD5Hash));
}
using (var db = new LiteDB.LiteDatabase(DB_FILE_NAME))
{
var collection = db.GetCollection <QueryHashResponse>();
return collection.Insert(item) > 0;
}
}
catch (Exception ex)
{
Log.Error(ex, $"Attempting to insert {item} into {Name}");
return false;
}
}));
}
public override async Task <string> InsertURLAsync(string url)
{
using (var db = new LiteDB.LiteDatabase(DB_FileName))
{
var collection = db.GetCollection <URLObject>();
url = url.ToLower();
var existingResult = collection.FindOne(a => a.URL == url);
if (existingResult != null)
{
return(existingResult.Key);
}
var urlObject = new URLObject
{
URL = url,
Key = KeyGenerator.Generate()
};
collection.Insert(urlObject);
return(urlObject.Key);
}
}
public void SaveCard(Card card)
{
DeleteCard(card);
_cardGameData.Cards.Add(new JsonCard
{
Id = card.Id,
CardTypeId = card.CardType.Id,
Name = card.Name,
ImageData = card.ImageData
});
_cardGameData.CardAttributeValues.AddRange(card.AttributeValues.Select(av => new JsonCardAttributeValue
{
CardId = card.Id,
CardAttributeId = av.CardAttribute.Id,
Value = av.Value
}));
using (var database = new LiteDB.LiteDatabase("c:\\utilities\\test.cogs"))
{
using (var stream = new MemoryStream(Convert.FromBase64String(card.ImageData)))
{
database.FileStorage.Upload("testcard", "test.png", stream);
}
}
SaveChanges();
}
static void Main(string[] args)
{
Logger = new Logger(GetStringSha256Hash(DateTime.UtcNow.ToString()));
if (File.Exists("version.txt"))
{
Logger.LogGenericMessage($"Build {File.ReadAllText("version.txt").Trim()}");
BuildNumber = File.ReadAllText("version.txt").Trim();
}
GlobalConfiguration = new GlobalConfiguration().Load();
DBPassword = GlobalConfiguration.DatabasePassword;
GlobalDatabase = new LiteDB.LiteDatabase(@"Filename=files\guildDatabase.db; Password="******"files/tweetStore.json"));
Twitter.AuthenticateWith("924464831813398529-pi51h6UB3iitJB2UQwGrHukYjD1Pz7F", "3R0vFFQLCGe9vuGvn00Avduq1K8NHjmRBUFJVuo9nRYXJ");
#region Timers
TweetSender.AutoReset = true;
TweetSender.Interval = 60 * 1000;
TweetSender.Elapsed += TweetSenderOnElapsed;
TweetSender.Start();
Updater.AutoReset = true;
Updater.Interval = 5 * 1000;
Updater.Elapsed += CheckMuteRemoval;
#endregion Timers
while (true)
{
new GenericBot().Start().GetAwaiter().GetResult();
}
}
public ReturnSet <bool> Update <T>(T obj) where T : BaseTable
{
using (var db = new LiteDB.LiteDatabase(_dbFileName))
{
return(new ReturnSet <bool>(db.GetCollection <T>().Update(obj)));
}
}
public bool UpdateItem <T>(Expression <Func <T, bool> > expression, T item) where T : BaseObject
{
using (var db = new LiteDB.LiteDatabase(CoreManager.GetService <Config>().DBFileName))
{
return(db.GetCollection <T>().Update(item));
}
}
public List <T> GetAll <T>() where T : BaseObject
{
using (var db = new LiteDB.LiteDatabase(CoreManager.GetService <Config>().DBFileName))
{
return(new List <T>(db.GetCollection <T>().FindAll()));
}
}
public bool DeleteAll <T>() where T : BaseObject
{
using (var db = new LiteDB.LiteDatabase(CoreManager.GetService <Config>().DBFileName))
{
return(db.DropCollection(typeof(T).Name));
}
}
public bool Contains <T>(Expression <Func <T, bool> > expression) where T : BaseObject
{
using (var db = new LiteDB.LiteDatabase(CoreManager.GetService <Config>().DBFileName))
{
return(db.GetCollection <T>().FindOne(expression) != null);
}
}
public async void SaveBlogModel(List <BlogModel> blogModels, string collectionName)
{
System.Diagnostics.Stopwatch stopwatch = new System.Diagnostics.Stopwatch();
stopwatch.Start();
LiteDB.LiteDatabase liteDatabase = new LiteDB.LiteDatabase(this.DbLite);
LiteDB.LiteCollection <BlogModel> liteCollection = liteDatabase.GetCollection <BlogModel>(collectionName.RepleaceBrackets());
int count = 0;
foreach (BlogModel blogModel in blogModels)
{
count++;
LiteDB.BsonValue bsonValue = new LiteDB.BsonValue(blogModel.PostUrl);
BlogModel model = liteCollection.FindById(bsonValue);
if (model == null)
{
blogModel.HtmlContent = await this.Get(blogModel.PostUrl);
blogModel.HtmlContent = blogModel.HtmlContent?.RepleaceBrackets()?.Sub();
bsonValue = liteCollection.Insert(blogModel);
}
else
{
}
}
liteDatabase.Dispose();
stopwatch.Stop();
Console.WriteLine(stopwatch.Elapsed);
}
public List <EntradaDTO> Listar()
{
using (var db = new LiteDB.LiteDatabase("BancoDeDados.db"))
{
var entradaCollection = db.GetCollection <EntradaDTO>("entradas");
return(entradaCollection.FindAll().ToList());
}
}
public EntradaDTO BuscaPorId(Guid id)
{
using (var db = new LiteDB.LiteDatabase("BancoDeDados.db"))
{
var entradaCollection = db.GetCollection <EntradaDTO>("entradas");
return(entradaCollection.FindOne(x => x.Id == id));
}
}
public bool Excluir(Guid id)
{
using (var db = new LiteDB.LiteDatabase("BancoDeDados.db"))
{
var entradaCollection = db.GetCollection <EntradaDTO>("entradas");
return(entradaCollection.Delete(id));
}
}
/// <summary>
/// Inicia la BD
/// </summary>
public static void Init()
{
if (db == null)
{
db = new LiteDB.LiteDatabase(System.AppDomain.CurrentDomain.BaseDirectory + "datos.db");
Logger.Log("Base de datos iniciada");
}
}
List <DomainModel.TodoObject> UseCase.ITodoRepositry.ListAll()
{
using (var db = new LiteDB.LiteDatabase(this.connectionString))
{
var collection = db.GetCollection <DomainModel.TodoObject>();
return(collection.FindAll().ToList());
}
}
public void AddTodo(DomainModel.TodoObject todo)
{
using (var db = new LiteDB.LiteDatabase(this.connectionString))
{
var collection = db.GetCollection <DomainModel.TodoObject>();
collection.Insert(todo);
}
}
public Usuario BuscaPorId(Guid id)
{
using (var db = new LiteDB.LiteDatabase("bancoDeDados.db"))
{
var usersCollection = db.GetCollection <Usuario>("usuarios");
return(usersCollection.FindOne(x => x.Id == id));
}
}
public bool Excluir(Guid id)
{
using (var db = new LiteDB.LiteDatabase("bancoDeDados.db"))
{
var usersCollection = db.GetCollection <Usuario>("usuarios");
return(usersCollection.Delete(id));
}
}
public List <Usuario> Listar()
{
using (var db = new LiteDB.LiteDatabase("bancoDeDados.db"))
{
var usersCollection = db.GetCollection <Usuario>("usuarios");
return(usersCollection.FindAll().ToList());
}
}
private void AddConnection()
{
DataConnectionDialog dlg = new DataConnectionDialog();
DataSource.AddStandardDataSources(dlg);
var dr = DataConnectionDialog.Show(dlg);
if (dr == DialogResult.Cancel)
{
return;
}
var cs = dlg.ConnectionString;
SqlConnectionStringBuilder b = new SqlConnectionStringBuilder(cs);
ConnString s = new ConnString(b.DataSource, b.ConnectionString);
var dbfn = new FileInfo(Sets.LiteDBFN);
dbfn.Directory.Create();
using (var ldb = new LiteDB.LiteDatabase(Sets.LiteDBFN))
{
var coll = ldb.GetCollection<ConnString>(nameof(ConnString));
coll.Insert(s);
}
Connections.Add(s);
Selected = s;
}
private ObservableCollection<ConnString> InitConnections()
{
var res = new ObservableCollection<ConnString>();
if (File.Exists(Sets.LiteDBFN))
{
using (var ldb = new LiteDB.LiteDatabase(Sets.LiteDBFN))
{
var coll = ldb.GetCollection<ConnString>(nameof(ConnString));
res.AddRange(coll.FindAll());
}
}
return res;
}
