public virtual void Add(TEntity obj)
{
try
{
_context.Set <TEntity>().Add(obj);
_context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取所有资源
/// </summary>
/// <param name="version"></param>
public string[] GetAllFile(string projName, string version, string platform)
{
var root = $"{this.fileRootPath}/{projName}";
//只保留10个版本
var ds = Directory.GetDirectories(root);
if (ds.Length > 10)
{
using (var db = new SqliteContext())
{
var ab = db.AssetBundleDatas.OrderBy((adb) => adb.Version). //排序
FirstOrDefault((abd) => abd.ProjName == projName && abd.Platform == platform); //取第一个
//删除最小版本
var del = $"{root}/{ab.Version}";
db.Remove(ab);
db.SaveChanges();
Directory.Delete(del, true);
}
}
//
var direct = $"{root}/{version}/{platform}";
if (Directory.Exists(direct))
{
var fs = Directory.GetFiles(direct, "*", SearchOption.AllDirectories);
return(fs.Select((d) => Path.GetFileName(d)).ToArray());
}
return(null);
}
public static void Edit(Cleaning cleaning)
{
using (var conn = new SqliteContext())
{
Cleaning cleaningToChange = conn.Cleanings.Where(p => p.Id == cleaning.Id).FirstOrDefault();
if (cleaningToChange != null)
{
cleaningToChange.IdRoom = cleaning.IdRoom;
cleaningToChange.IdWorker = cleaning.IdWorker;
TimeSpan startHour = new TimeSpan(10, 0, 0);
DateTime startTime = cleaning.CleanTime.Date + startHour; //dany dzień godz. 10:00
DateTime?dateToSet = CheckIfWorkerHaveTimeAndReturnFirstFreeDate(conn, cleaning.IdWorker, startTime);
if (dateToSet.HasValue)
{
cleaningToChange.CleanTime = dateToSet.Value;
}
else
{
throw new Exception("Pracownik o tym Id nie jest dostępny w wybranym dniu. Wybierze inny dzień lub innego pracownika.");
}
conn.SaveChanges();
}
else
{
throw new Exception("Nie znaleziono wpisu sprzątania do zmodyfikowania");
}
}
}
/// <summary>
/// 临时保存征询
/// </summary>
/// <param name="suggest"></param>
/// <returns></returns>
public bool saveSuggest(Suggest suggest)
{
using (SqliteContext context = new SqliteContext())
{
var old = context.Suggest.FirstOrDefault(s => s.Id == suggest.Id);
try
{
if (old == null)
{
context.Suggest.Add(suggest);
}
else
{
//old = suggest;
old.suggest_content = suggest.suggest_content;
old.remark = suggest.remark;
}
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool CreateGame(Game game)
{
_context.Games.Add(game);
var result = _context.SaveChanges();
return(result > 0);
}
private static void Archivos()
{
string ruta = @"/Users/bidkar/Documents/UDO/2019/Mayo-Agosto/Computacion9/PrimerParcial/Datos";
var archivos = Directory.GetFiles(ruta);
var claves = new List <ClaveDeLocalizacion>();
foreach (var a in archivos)
{
Console.WriteLine($"Archivo: {Path.GetFileName(a)}");
var contenido = File.ReadAllLines(a);
var contador = 1;
foreach (var linea in contenido)
{
if (contador > 1)
{
claves.Add(ClaveDeLocalizacion.Inicializar(linea.Replace("\"", "")));
}
contador++;
}
}
using (var db = new SqliteContext())
{
db.Database.EnsureCreated();
db.AddRange(claves);
db.SaveChanges();
Console.WriteLine("Claves guardadas!");
}
}
public void Add(Reservation rez)
{
using (var conn = new SqliteContext())
{
Customer cus = conn.Customers.FirstOrDefault(p => p.Id == rez.IdCustomer);
Room room = conn.Rooms.FirstOrDefault(p => p.Id == rez.IdRoom);
rez.Customer = cus ?? throw new Exception("Nie ma klienta o ID: " + rez.IdCustomer);
rez.Room = room ?? throw new Exception("Nie ma pokoju o ID: " + rez.IdRoom);
IList <Reservation> reservations = conn.Reservations.Where(p => p.IdRoom == rez.IdRoom).ToList();
if (reservations.Any(p => p.StartTime.Date == rez.StartTime.Date || p.StopTime.Date == rez.StopTime.Date ||
(p.StartTime.Date > rez.StartTime.Date && p.StartTime.Date < rez.StopTime.Date) ||
(p.StartTime.Date < rez.StartTime.Date && p.StopTime.Date > rez.StartTime.Date) ||
(p.StartTime.Date > rez.StartTime.Date && p.StopTime.Date < rez.StopTime.Date) ||
(p.StartTime.Date < rez.StartTime.Date && p.StopTime.Date > rez.StopTime.Date)))
{
throw new Exception("W tym terminie pokój jest już zarezerwowany");
}
rez.StartTime = rez.StartTime.AddHours(15);
rez.StopTime = rez.StopTime.AddHours(10);
conn.Reservations.Add(rez);
AddCleaning(rez, conn);
conn.SaveChanges();
}
}
private void Adicionar(LoginResponse loginResponse, Sentimento sentimento)
{
var urlAdicionar = "https://apiteams.goobee.com.br/api/Home/AdicionarHumor";
var paramAdicionar = new
{
idPessoa = loginResponse.IdPessoa,
idResponsavelCriacao = loginResponse.Id,
sentimento = (int)sentimento
};
using (var wb = new WebClient())
{
wb.Headers[HttpRequestHeader.Authorization] = "Bearer " + loginResponse.Token;
wb.Headers.Add(HttpRequestHeader.ContentType, "application/json");
wb.Headers[HttpRequestHeader.Accept] = "application/json";
var response = wb.UploadString(urlAdicionar, "POST", JsonConvert.SerializeObject(paramAdicionar));
using (var db = new SqliteContext())
{
var user = db.Usuarios.AsQueryable().Where(o => o.Login == loginResponse.Login).FirstOrDefault();
db.UsuarioSentimento.Add(new UsuarioSentimento()
{
IdUsuario = user.Id,
IdSentimentoPessoa = response.ToString().Replace("\"", ""),
LoginUsuario = loginResponse.Login,
DataCadastro = DateTime.Today
});
db.SaveChanges();
}
};
}
public void AddAdapters(List <IMqttAdapter> adapters)
{
using (var ctx = new SqliteContext())
{
foreach (var adapter in adapters)
{
var controller = _modelFactory.CreateController();
controller.Identifier = adapter.Identifier;
controller.Type = adapter.Type;
controller.InitializationArguments = _jsonSerializerService.Serialize(adapter.GetInitializationArguments());
foreach (var state in adapter.GetPossibleStates())
{
var stateModel = new ControllerStateInformation();
stateModel.State = state.State;
stateModel.PowerConsumption = state.PowerConsumption;
stateModel.Controller = controller;
ctx.Add(stateModel);
}
ctx.Add(controller);
}
ctx.SaveChanges();
}
}
protected override void ExecuteJsonCommand(ChatSession session, User commandInfo)
{
Console.WriteLine(@"{0:HH:mm:ss} 新用户注册 用户名:{1} 密码：{2}", DateTime.Now, commandInfo.Username, commandInfo.Password);
int result = 0;
using (var db = new SqliteContext())
{
db.Users.Add(commandInfo);
result = db.SaveChanges();
}
if (result > 0)
{
var status = new ServerStatus {
Status = true, Detail = "注册成功"
};
session.Send(JsonConvert.SerializeObject(status));
}
else
{
var status = new ServerStatus {
Status = false, Detail = "注册失败"
};
session.Send(JsonConvert.SerializeObject(status));
}
}
public static void Delete(InterestRateTableData interestRate)
{
using var context = new SqliteContext();
var entity = context.InterestRates.Remove(interestRate);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
public static void Edit(InterestRateTableData interestRate)
{
using var context = new SqliteContext();
var entity = context.InterestRates.Update(interestRate);
entity.State = EntityState.Modified;
context.SaveChanges();
}
public static void Edit(CreditCardTableData creditCard)
{
using var context = new SqliteContext();
var entity = context.CreditCards.Update(creditCard);
entity.State = EntityState.Modified;
context.SaveChanges();
}
public File Create(string name, string content, int groupId)
{
Console.WriteLine("groupId: " + groupId);
File file = new File()
{
Name = name,
Content = content,
GroupId = groupId
};
context.Files.Add(file);
context.SaveChanges();
NotifyClients(file.GroupId);
return(file);
}
public static void Add(Equipment equipment)
{
using (var conn = new SqliteContext())
{
conn.Equipments.Add(equipment);
conn.SaveChanges();
}
}
public static void Add(ParkingSlot parkingSlot)
{
using (var conn = new SqliteContext())
{
conn.ParkingSlots.Add(parkingSlot);
conn.SaveChanges();
}
}
public static void Delete(CreditCardTableData creditCard)
{
using var context = new SqliteContext();
var entity = context.CreditCards.Remove(creditCard);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
public static void Add(InterestRateTableData interestRate)
{
using var context = new SqliteContext();
var entity = context.InterestRates.Add(interestRate);
entity.State = EntityState.Added;
context.SaveChanges();
}
public async Task <IActionResult> Settings(string theme, string companyName, string db) // string logoPath, string version, int tax,, string language, string server, string port,
{
// if(sqliteContext..Settings)
Settings settings;
try
{
settings = await sqliteContext.Settings
.AsNoTracking()
.FirstOrDefaultAsync(i => i.Id == 1);
settings.Theme = theme;
settings.CompanyName = companyName;
//settings.Version = version;
settings.DB = db;
//Configuration[] // in die Configurationsdatei schreiben -> wie??
// settings.Language = language;
sqliteContext.Settings.Update(settings);
}
catch
{
settings = new Settings()
{
Theme = "Wooja", CompanyName = companyName, DB = db
};
sqliteContext.Settings.Add(settings);
sqliteContext.SaveChanges();
}
//} catch (Exception ex)
//{
// settings = new Settings() { Theme = "Wooja", CompanyName = companyName, DB = db};
// sqliteContext.Settings.Add(settings);
//}
// Settings settings = new Settings() { Theme = theme, CompanyName = companyName, Logo = logoPath, MwSt = tax, DB = db, Language = language, Server = server, Port = port, Version = version };
sqliteContext.SaveChanges();
return(View(settings));
}
public static int Add(CreditCardTableData creditCard)
{
using var context = new SqliteContext();
var entity = context.CreditCards.Add(creditCard);
entity.State = EntityState.Added;
context.SaveChanges();
return(creditCard.CreditCardId);
}
static void Main()
{
AutoMapperConfig.Config();
if (File.Exists("MyDateBase.db"))
{
File.Delete("MyDateBase.db");
}
using (var db = new SqliteContext("MyDateBase.db"))
{
var position = new Position()
{
Description = "Best Programmer"
};
db.Positions.Add(position);
db.SaveChanges();
var user = new User()
{
Name = "Kos",
Age = 23,
PositionId = position.Id
};
db.Users.Add(user);
db.SaveChanges();
}
using (var db = new SqliteContext("MyDateBase.db"))
{
var userUpdates = db.Users.ProjectTo <UserUpdate>().ToList();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine(string.Join(Environment.NewLine, userUpdates));
}
Console.ReadKey();
}
public void AddPwdInfo(SqliteContext context)
{
context.DBUser.Add(
new DBUser()
{
name = "tttt"
}
);
context.SaveChanges();
}
public static void Add(Customer customer)
{
using (var conn = new SqliteContext())
{
//if (conn.Customers.Any(w => w.Id == customer.Id))
// throw new Exception("Pracownik o tym ID już istnieje");
conn.Customers.Add(customer);
conn.SaveChanges();
}
}
public async Task <IActionResult> Post([FromBody] Product product)
{
if (product == null || product.Id != 0 || String.IsNullOrEmpty(product.ProductName))
{
return(StatusCode(StatusCodes.Status400BadRequest));
}
await _context.Products.AddAsync(product);
_context.SaveChanges();
return(Ok(product));
}
private async Task Cliente_MessageReceived(SocketMessage arg)
{
var mensagem = arg as SocketUserMessage;
if (mensagem == null || mensagem.Author.IsBot)
{
return;
}
var context = new SocketCommandContext(_cliente, mensagem);
int argPost = 0;
//Se for mensagem privada para o bot
if (mensagem.Channel is SocketDMChannel)
{
var array = mensagem.Content.Split(" ");
if (array.Length < 2)
{
await mensagem.Author.SendMessageAsync("Cara alguma coisa errada não ta certa, confere o que você digitou ai.");
}
var response = new GoobTeams().Login(array[0], array[1]);
if (response != null && response.Sucesso && !string.IsNullOrWhiteSpace(response.Token))
{
using (var db = new SqliteContext())
{
db.Usuarios.Add(new Usuario()
{
Login = array[0], Senha = array[1], IdDiscord = mensagem.Author.Id.ToString()
});
db.SaveChanges();
}
await mensagem.Author.SendMessageAsync("Boaaa, consegui autenticar você, volta no chat lá e manda o comando pra modificar o humor, valeu!");
}
else
{
await mensagem.Author.SendMessageAsync("Não consegui fazer o login com a info que você me passou, tem certeza que passou os dados certos?");
}
}
else if (mensagem.HasStringPrefix("?", ref argPost))
{
var result = await _commands.ExecuteAsync(context, argPost, _services);
if (!result.IsSuccess)
{
Console.WriteLine(result.ErrorReason);
}
}
}
static void Main(string[] args)
{
var context = new SqliteContext(new Uri("http://localhost.fiddler:59145/odata/"));
context.Format.UseJson();
// Call some basic Get
var eventDataItems = context.EventData.ToList();
var animalsItems = context.AnimalType.ToList();
var skillLevels = context.SkillLevels.Expand("Levels").GetValue();
var players = context.Player.Expand(c => c.PlayerStats).Where(u => u.PlayerStats.SkillLevel == 2).ToList();
// Create a new entity
var newObjectEventData = new EventData
{
AnimalTypeId = animalsItems.First().Key,
Factor = 55,
FixChange = 55.0,
StringTestId = "_ok_testdatafromodataclient",
AnimalType = animalsItems.First()
};
var secondNewObjectEventData = new EventData
{
AnimalTypeId = 200,
Factor = 44,
FixChange = 44.0,
StringTestId = "_nok_testdatafromodataclient",
};
// Update a new entity
var dataToUpdate = eventDataItems.FirstOrDefault();
dataToUpdate.Factor = -1;
dataToUpdate.FixChange = 97;
context.AddToEventData(newObjectEventData);
context.UpdateObject(dataToUpdate);
context.AddToEventData(secondNewObjectEventData);
context.AddAndUpdateResponsePreference = DataServiceResponsePreference.IncludeContent;
// Add the data to the server
DataServiceResponse response = context.SaveChanges(SaveChangesOptions.BatchWithSingleChangeset);
foreach (OperationResponse individualResponse in response)
{
Console.WriteLine(" status code = {0}", individualResponse.StatusCode);
}
Console.ReadLine();
}
public static void Add(Worker worker)
{
using (var conn = new SqliteContext(@"testDb"))
{
if (conn.Workers.Any(w => w.Id == worker.Id))
{
throw new Exception("Pracownik o tym ID już istnieje");
}
conn.Workers.Add(worker);
conn.SaveChanges();
}
}
public void Create(int userId, string ip)
{
ConnectedUser connectedUser = new ConnectedUser()
{
UserId = userId,
Ip = ip
};
var row = context.ConnectedUsers.SingleOrDefault(c => c.UserId == userId);
// If already connected, update IP
if (row != null)
{
row.Ip = ip;
}
else
{
context.ConnectedUsers.Add(connectedUser);
}
context.SaveChanges();
}
public static void Add(Room room)
{
using (var conn = new SqliteContext(@"testDb"))
{
if (conn.Rooms.Any(p => p.Id == room.Id))
throw new Exception("Pokój o tym ID już istnieje");
if (conn.Rooms.Any(p => p.RoomNumber == room.RoomNumber))
throw new Exception("Pokój o tym numerze już istnieje");
conn.Rooms.Add(room);
conn.SaveChanges();
}
}
public void Edit(Reservation rez)
{
using (var conn = new SqliteContext())
{
if (rez.StartTime > rez.StopTime)
{
throw new Exception("Data zakończenia pobytu nie może być mniejsza niż rozpoczęcie pobytu.");
}
Reservation rezToChange = conn.Reservations.Where(p => p.Id == rez.Id).FirstOrDefault();
Reservation rezBeforeChanges = new Reservation
{
StartTime = rezToChange.StartTime,
StopTime = rezToChange.StopTime
};
if (rezToChange != null)
{
rezToChange.IdCustomer = rez.IdCustomer;
rezToChange.IdRoom = rez.IdRoom;
rezToChange.StartTime = rez.StartTime;
rezToChange.StopTime = rez.StopTime;
IList <Reservation> reservations = conn.Reservations.Where(p => p.Id != rez.Id && p.IdRoom == rez.IdRoom).ToList();
if (reservations.Any(p => p.StartTime.Date == rez.StartTime.Date || p.StopTime.Date == rez.StopTime.Date ||
(p.StartTime.Date > rez.StartTime.Date && p.StartTime.Date < rez.StopTime.Date) ||
(p.StartTime.Date < rez.StartTime.Date && p.StopTime.Date > rez.StartTime.Date) ||
(p.StartTime.Date > rez.StartTime.Date && p.StopTime.Date < rez.StopTime.Date) ||
(p.StartTime.Date < rez.StartTime.Date && p.StopTime.Date > rez.StopTime.Date)))
{
throw new Exception("W tym terminie pokój jest już zarezerwowany, nie można zmienić terminu rezerwacji");
}
rezToChange.StartTime = rezToChange.StartTime.AddHours(15);
rezToChange.StopTime = rezToChange.StopTime.AddHours(10);
Customer cus = conn.Customers.FirstOrDefault(p => p.Id == rez.IdCustomer);
Room room = conn.Rooms.FirstOrDefault(p => p.Id == rez.IdRoom);
rez.Customer = cus ?? throw new Exception("Nie ma klienta o ID: " + rez.IdCustomer);
rez.Room = room ?? throw new Exception("Nie ma pokoju o ID: " + rez.IdRoom);
conn.SaveChanges();
EditClining(rezBeforeChanges, rezToChange, conn);
}
else
{
throw new Exception("Nie znaleziono rezerwacji do zmodyfikowania");
}
}
}
