public LocalController(LocalContext context)
{
_context = context;
if (_context.Local.Count() == 0)
{
_context.Local.Add(new LocalModel {
Id = 1, Ambiente = "PacotesVersao", Localizacao = @"C:\Users\Douglas\Desktop\Versionamento\PacoteVersao"
});
_context.SaveChanges();
_context.Local.Add(new LocalModel {
Id = 2, Ambiente = "Dev", Localizacao = @"C:\Users\Douglas\Desktop\Versionamento\Dev"
});
_context.SaveChanges();
_context.Local.Add(new LocalModel {
Id = 3, Ambiente = "QA", Localizacao = @"C:\Users\Douglas\Desktop\Versionamento\QA"
});
_context.SaveChanges();
_context.Local.Add(new LocalModel {
Id = 4, Ambiente = "PP", Localizacao = @"C:\Users\Douglas\Desktop\Versionamento\PP"
});
_context.SaveChanges();
_context.Local.Add(new LocalModel {
Id = 5, Ambiente = "Prod", Localizacao = @"C:\Users\Douglas\Desktop\Versionamento\Prod"
});
_context.SaveChanges();
}
}
public static void DBSetter(string strFirst, string strSecond)
{
using (LocalContext lcsContext = new LocalContext())
{
lcsContext.LcsStrings.Add(new Lcs(strFirst, strSecond));//Connection to DB for saving results
lcsContext.SaveChanges();
}
}
public async override Task OnConnectedAsync()
{
try{
var httpContext = Context.GetHttpContext();
var tokenValue = httpContext.Request.Query["access_token"].ToString();
var usuarionome = _help.retornaUsuario(tokenValue);
var usuario = _banco.usuario.Where(d => d.nome == usuarionome && d.ativo == true).FirstOrDefault();
if (usuario != null)
{
usuario.ativo = false;
_banco.SaveChanges();
}
await base.OnConnectedAsync();
UsuarioModel novousaurio = new UsuarioModel();
novousaurio.ativo = true;
novousaurio.nome = usuarionome;
novousaurio.datacriacao = DateTime.Now;
novousaurio.connectionId = Context.ConnectionId;
_banco.usuario.Add(novousaurio);
_banco.SaveChanges();
var listausuarios = _banco.usuario.Where(d => d.ativo == true).ToList();
await Clients.All.SendAsync("listausuarios", listausuarios);
}catch (Exception e) {
throw new System.InvalidOperationException("Erro");
}
}
public void AddToFavourites(cc310_reference_centre_file file)
{
using (LocalContext context = factory.CreateLocalContext())
{
if (!IsFileInFavorite(file.file_full_nm))
{
context.cc310_reference_centre_file.Add(file);
context.SaveChanges();
}
}
}
public void RemoveFromFavourites(string fileFullName)
{
using (LocalContext context = factory.CreateLocalContext())
{
var targetFile = context.cc310_reference_centre_file.FirstOrDefault(i => i.file_full_nm == fileFullName);
if (targetFile != null)
{
context.cc310_reference_centre_file.Remove(targetFile);
context.SaveChanges();
}
}
}
public void HookedDbContext_AfterConstruction_CanRegisterNewHooks()
{
var context = new LocalContext();
context.RegisterHook(new TimestampPreInsertHook());
var entity = new TimestampedSoftDeletedEntity();
context.Entities.Add(entity);
context.SaveChanges();
Assert.AreEqual(entity.CreatedAt.Date, DateTime.Today);
}
public void HookedDbContext_CanLateBindPostActionHooks()
{
var context = new LocalContext();
context.RegisterHook(new TimestampPostInsertHook());
var tsEntity = new TimestampedSoftDeletedEntity();
tsEntity.CreatedAt = DateTime.Now;
context.Entities.Add(tsEntity);
context.SaveChanges();
Assert.AreEqual(DateTime.Today, tsEntity.ModifiedAt.Value.Date);
}
public void HookedDbContext_ShouldNotHook_IfAnyChangedObjectsAreInvalid()
{
var context = new LocalContext();
context.RegisterHook(new TimestampPreInsertHook());
var tsEntity = new TimestampedSoftDeletedEntity();
var valEntity = new ValidatedEntity();
context.Entities.Add(tsEntity);
context.ValidatedEntities.Add(valEntity);
Assert.Throws <DbEntityValidationException>(() => context.SaveChanges());
Assert.AreNotEqual(tsEntity.CreatedAt.Date, DateTime.Today);
}
public void HookedDbContext_MustCallHooks_WhenRunningSaveChanges()
{
var hooks = new IHook[]
{
new TimestampPreInsertHook()
};
var context = new LocalContext(hooks);
var entity = new TimestampedSoftDeletedEntity();
context.Entities.Add(entity);
context.SaveChanges();
Assert.AreEqual(entity.CreatedAt.Date, DateTime.Today);
}
public RetornoModel CriarSala(string nomesala, string usuario)
{
RetornoModel retorno = new RetornoModel();
try{
var idsala = _help.RandomString(6);
SalaModel novasala = new SalaModel();
novasala.datacriacao = DateTime.Now;
novasala.donosala = usuario;
novasala.jogador1 = usuario;
novasala.nomesala = nomesala;
novasala.ativa = true;
novasala.idsala = idsala;
_local.sala.Add(novasala);
_local.SaveChanges();
retorno.status = "OK";
retorno.resultado = idsala;
return(retorno);
}catch (Exception e) {
return(retorno);
}
}
public void HookedDbContext_MustCallHooks_IfModelIsInvalidButUnchanged()
{
var context = new LocalContext();
context.RegisterHook(new TimestampPreInsertHook());
var tsEntity = new TimestampedSoftDeletedEntity();
var valEntity = new ValidatedEntity();
context.Entities.Add(tsEntity);
context.Entry(valEntity).State = EntityState.Unchanged;
Assert.DoesNotThrow(() => context.SaveChanges());
Assert.AreEqual(tsEntity.CreatedAt.Date, DateTime.Today);
}
public void HookedDbContext_MustOnlyHookWhenObjectIsInTheSameState()
{
var context = new LocalContext();
context.RegisterHook(new TimestampPreInsertHook());
context.RegisterHook(new TimestampPreUpdateHook());
var tsEntity = new TimestampedSoftDeletedEntity();
tsEntity.CreatedAt = DateTime.Now;
context.Entities.Add(tsEntity);
context.SaveChanges();
Assert.AreEqual(DateTime.Today, tsEntity.CreatedAt.Date);
Assert.IsFalse(tsEntity.ModifiedAt.HasValue);
}
public void HookedDbContext_PostActionHookMethod_MustHaveTheContextPassedInTheMetadata()
{
var context = new LocalContext();
var postAction = A.Fake <PostInsertHook <ITimeStamped> >();
A.CallTo(() => postAction.HookStates).Returns(EntityState.Added);
context.RegisterHook(postAction);
// We aren't testing the hook here
var entity = new TimestampedSoftDeletedEntity {
CreatedAt = DateTime.Now
};
context.Entities.Add(entity);
context.SaveChanges();
A.CallTo(() => postAction.Hook(entity, A <HookEntityMetadata> .That.Matches(m => m.CurrentContext == context))).MustHaveHappened();
}
public Return CriarUsuario(Usuario user)
{
UsuarioValidator validator = new UsuarioValidator(_context);
ValidationResult results = validator.Validate(user);
if (!results.IsValid)
{
return(new Return(results.Errors));
}
user.Senha = Hashing.HashMD5(user.Senha);
user.DataCriacao = DateTime.Now;
_context.Add(user);
_context.SaveChanges();
return(new Return(user));
}
public void HookedDbContext_MustNotCallHooks_IfModelIsInvalid()
{
var hooks = new IHook[]
{
new TimestampPreInsertHook()
};
var context = new LocalContext(hooks);
var validatedEntity = new ValidatedEntity();
context.ValidatedEntities.Add(validatedEntity);
try
{ context.SaveChanges(); }
catch { }
Assert.AreNotEqual(validatedEntity.CreatedAt.Date, DateTime.Today);
}
static void Main()
{
Console.WriteLine("Attempting to make connection with ' DESKTOP-K3B9EQ2\\SQLEXPRESS '");
Console.Clear();
while (true)
{
Console.Write("Program for solving LCS problem \n Please enter 2 string separated with ',' : ");
var input = Console.ReadLine();
string[] words = input.Split(',');
if (words.Length == 2 && input.All(c => Char.IsLetterOrDigit(c) || c == ','))
{
using (LocalContext lcsContext = new LocalContext())
{
Lcs lcs = new Lcs(words[0], words[1]);
lcsContext.LcsStrings.Add(new Lcs(words[0], words[1]));//saving results to DB
Console.WriteLine("\nLast answers\n" + new string('-', 25));
var answs = (from answers in lcsContext.LcsStrings select answers).ToList();
//writes last 5 or less elements from DB
lcsContext.LcsStrings.Skip(Math.Max(0, lcsContext.LcsStrings.Count() - 5)).ToList().ForEach(e =>
Console.WriteLine($"\nS1 : {e.FirstString}\nS2 : {e.SecondString}\nLCS: {e.AnswerString} \n"));
Console.WriteLine(new string('-', 25) + "\nYour answer\n" + new string('-', 25));
lcs.LcsOut();
Console.WriteLine("\n" + new string('-', 25));
Console.WriteLine("Press 'Enter' for saving changes or close Console for discard");
Console.ReadKey();
lcsContext.SaveChanges();
}
Environment.Exit(0);
}
else
{
Console.Clear();
Console.WriteLine("Wrong input, please try again \n");
}
}
}
public void HookedDbContext_ShouldHook_IfValidateBeforeSaveIsDisabled_AndChangedObjectsAreInvalid()
{
var context = new LocalContext();
context.Configuration.ValidateOnSaveEnabled = false;
context.RegisterHook(new TimestampPreInsertHook());
var tsEntity = new TimestampedSoftDeletedEntity();
var valEntity = new ValidatedEntity();
context.Entities.Add(tsEntity);
context.ValidatedEntities.Add(valEntity);
Assert.IsTrue(context.GetValidationErrors().Any(x => !x.IsValid));
Assert.Throws <DbUpdateException>(() => context.SaveChanges());
Assert.AreEqual(tsEntity.CreatedAt.Date, DateTime.Today);
Assert.AreEqual(valEntity.CreatedAt.Date, DateTime.Today);
}
public void HookedDbContext_ShouldPostHook_IfNoExceptionIsHit()
{
var runCheckingHook = new RunCheckedPreInsertHook();
var hooks = new IHook[]
{
runCheckingHook,
new TimestampPostInsertHook()
};
var context = new LocalContext(hooks);
var tsEntity = new TimestampedSoftDeletedEntity();
tsEntity.CreatedAt = DateTime.Now;
context.Entities.Add(tsEntity);
context.SaveChanges();
Assert.IsTrue(runCheckingHook.HasRun);
Assert.AreEqual(DateTime.Today, tsEntity.ModifiedAt.Value.Date);
}
public void HookedDbContext_ShouldNotPostHook_IfExceptionIsHit()
{
var runCheckingHook = new RunCheckedPreInsertHook();
var hooks = new IHook[]
{
runCheckingHook,
new TimestampPostInsertHook()
};
var context = new LocalContext(hooks);
var valEntity = new ValidatedEntity();
valEntity.CreatedAt = DateTime.Now;
context.ValidatedEntities.Add(valEntity);
Assert.Throws <DbEntityValidationException>(() => context.SaveChanges());
Assert.IsFalse(runCheckingHook.HasRun);
Assert.IsFalse(valEntity.ModifiedAt.HasValue);
}
public void Add(T entity)
{
var temp = _localContext.Set <T>().Add(entity);
_localContext.SaveChanges();
}
public virtual T Add(T t)
{
_context.Set <T>().Add(t);
_context.SaveChanges();
return(t);
}
public void Save()
{
context.SaveChanges();
}
public int SaveUser([FromBody] UserMaster user)
{
_context.Add(user);
return(_context.SaveChanges());
}
public void AddElement(Lcs lcs)
{
context.LcsStrings.Add(lcs);
context.SaveChanges();
}
public void Atualizar(Unidade local)
{
_context.Unidades.Update(local);
var status = _context.SaveChanges();
}
