public void UserRepository_AddAndGetUser()
{
var userEntity = SetupUserEntity();
var expectedUserId = 1;
_sut.AddAsync(userEntity).Wait();
var result = _sut.GetAsync(expectedUserId).Result;
result.Id.ShouldBe(userEntity.Id);
result.Firstname.ShouldBe(userEntity.Firstname);
result.Lastname.ShouldBe(userEntity.Lastname);
result.Password.ShouldBe(userEntity.Password);
}
public async Task <ActionResult> Register(UserViewModel model)
{
if (ModelState.IsValid)
{
var repos = new ClientRepository();
var user = await repos.FindAsync(model.UserName);
if (user == null)
{
var newUser = new Client()
{
UserName = model.UserName,
FirstName = model.FirstName,
LastName = model.LastName,
Email = model.Email,
Phone = model.Phone,
Password = AppHelper.GetHash(model.Password),
Country = model.Country,
State = model.State,
City = model.City,
Street = model.Street,
Zip = model.Zip,
Active = false,
DateRegistered = DateTime.UtcNow
};
await repos.AddAsync(newUser);
return(View("RegisterSuccess"));
}
ModelState.AddModelError("UserName", "The user exist, please try another user name");
}
return(View(model));
}
public static async Task <string> InserirCliente(
string clientId,
Systore.Domain.Entities.Client client,
List <Tuple <int, string, string> > clientsInserted,
IMongoDatabase mongoDatabase)
{
try
{
SystoreContext context = _systoreContextFactory.CreateDbContext(new string[] { });
Console.WriteLine($"Inserindo cliente {client.Name}-{client.Cpf}");
var clientRepository = new ClientRepository(context, null);
clientRepository.IsConversion = true;
client.Cpf = Utils.OnlyNumbers(client.Cpf);
string ret = await clientRepository.AddAsync(client);
if (string.IsNullOrWhiteSpace(ret))
{
clientsInserted.Add(new Tuple <int, string, string>(client.Id, clientId, $"Client {client.Id}-{client.Name}-{client.Cpf} inserido com suceso"));
Console.WriteLine($"Client {client.Id}-{client.Name}-{client.Cpf} inserido com suceso.");
}
else
{
clientsInserted.Add(new Tuple <int, string, string>(-1, "", $"Erro ao inserir Client {client.Name}-{client.Cpf}: {ret}"));
Console.WriteLine($"Erro ao inserir Client {client.Name}-{client.Cpf}: {ret}");
return($"Erro ao inserir Client {client.Name}-{client.Cpf}: {ret}");
}
return("");
}
catch (Exception e)
{
clientsInserted.Add(new Tuple <int, string, string>(-1, clientId, $"Erro ao inserir Client {client.Name}-{client.Cpf}: {e.Message}"));
Console.WriteLine($"Erro ao inserir Client {client.Name}-{client.Cpf}: {e.Message}");
return($"Erro ao inserir Client {client.Name}-{client.Cpf}: {e.Message}");
}
}
private async Task InsertData()
{
int nombre = _context.Clients.CountAsync().Result;
if (nombre <= 20)
{
for (int i = 1; i <= 20; i++)
{
Client client = new Client("Nom" + i, "Prénom" + i, "adresse" + i, "téléphone" + i);
_ = await _ClientRepository.AddAsync(client);
}
_context.SaveChanges();
}
}
public async void ShouldAddAndSaveTheClientInTheContext()
{
var client = new Models.Client();
var context = A.Fake <IConfigurationDbContext>();
var clientRepository = new ClientRepository(context);
await clientRepository.AddAsync(client);
A.CallTo(() => context.SaveChangesAsync())
.MustHaveHappened();
A.CallTo(() => context.Clients.AddAsync(
A <Entities.Client> .Ignored,
A <CancellationToken> .Ignored))
.MustHaveHappened();
}
public async Task クライアントがClientIdで取得できること()
{
var ctx = new MockDocmsContext("MockDocmsContext");
var sut = new ClientRepository(ctx);
var d1 = new Client("ABC", "UPLOADER", "192.168.0.1");
d1.Request(ClientRequestType.Start);
await sut.AddAsync(d1);
await sut.UnitOfWork.SaveEntitiesAsync();
var d2 = await sut.GetAsync("ABC");
Assert.AreEqual("ABC", d2.ClientId);
Assert.AreEqual("UPLOADER", d2.Type);
Assert.AreEqual("192.168.0.1", d2.IpAddress);
Assert.AreEqual(ClientStatus.Stopped, d2.Status);
Assert.AreEqual(ClientRequestType.Start, d2.RequestType);
}
public async Task <IActionResult> Put([FromBody] Client editedClient)
{
var result = false;
try
{
_log.LogEntrance(nameof(Put), editedClient.ToString());
var repository = new ClientRepository(_log, false);
var exisingClient = await repository.GetById(editedClient.Id);
if (exisingClient == null)
{
await repository.AddAsync(editedClient);
}
else
{
await repository.UpdateAsync(editedClient);
}
result = true;
return(Ok(result));
}
catch (Exception ex)
{
_log.LogError($"my exception : [{ex.Message}] [{ex.StackTrace}]");
return(Ok(false));
}
finally
{
_log.LogExit(nameof(Add), result.ToString());
}
}
static async Task Convert()
{
List <Task <string> > tarefasCliente = new List <Task <string> >();
List <Task <string> > tarefasBillsReceive = new List <Task <string> >();
List <string> billsReceiveInserted = new List <string>();
var builder =
new ConfigurationBuilder().
SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json");
Configuration = builder.Build();
_settings = new SystoreDatabaseSettings();
Configuration.GetSection("SystoreDatabaseSettings").Bind(_settings);
Console.WriteLine();
var clientMongo = new MongoClient(_settings.ConnectionString);
var database = clientMongo.GetDatabase(_settings.DatabaseName);
string clientId = "";
var billReceives = database.GetCollection <BillReceive>(_settings.BillReceiveCollectionName);
var clients = database.GetCollection <Client>(_settings.ClientCollectionName);
// var users = database.GetCollection<Client>(settings.UserCollectionName);
foreach (var client in clients.Find(c => c.Id != "5d0ce3f2b796df5a27c4f76e").ToList())
//foreach (var client in clients.Find(c => c.code == 704).ToList())
{
var _client = new Systore.Domain.Entities.Client();
try
{
client.date_of_birth = addhour(client.date_of_birth); // client.date_of_birth.HasValue ? DateTime.SpecifyKind(client.date_of_birth.Value, DateTimeKind.Local) : client.date_of_birth;
client.admission_date = addhour(client.admission_date); //client.admission_date.HasValue ? DateTime.SpecifyKind(client.admission_date.Value, DateTimeKind.Local) : client.admission_date;
client.registry_date = addhour(client.registry_date); //client.registry_date.HasValue ? DateTime.SpecifyKind(client.registry_date.Value, DateTimeKind.Local) : client.registry_date;
_client.Id = client.code;
clientId = client.Id;
_client.Address = client.address ?? "";
_client.AddressNumber = client.address_number ?? "";
_client.City = client.city ?? "";
_client.CivilStatus = (Systore.Domain.Enums.CivilStatus)client.civil_status;
_client.Complement = client.complement ?? "";
_client.Cpf = Utils.OnlyNumbers(client.cpf);
_client.FatherName = client.father_name ?? "";
_client.JobName = client.job_name ?? "";
_client.DateOfBirth = client.date_of_birth; // client.date_of_birth.HasValue ? DateTime.SpecifyKind(client.date_of_birth.Value, DateTimeKind.Local) : client.date_of_birth;
_client.AdmissionDate = client.admission_date; //client.admission_date.HasValue ? DateTime.SpecifyKind(client.admission_date.Value, DateTimeKind.Local) : client.admission_date;
_client.MotherName = client.mother_name ?? "";
_client.Name = client.name ?? "";
_client.Neighborhood = client.neighborhood ?? "";
_client.Note = client.note ?? "";
_client.Occupation = client.occupation ?? "";
_client.Phone1 = client.phone1 ?? "";
_client.Phone2 = client.phone2 ?? "";
_client.PlaceOfBirth = client.place_of_birth ?? "";
_client.PostalCode = client.postal_code ?? "";
_client.Rg = client.rg ?? "";
_client.RegistryDate = client.registry_date; //client.registry_date.HasValue ? DateTime.SpecifyKind(client.registry_date.Value, DateTimeKind.Local) : client.registry_date;
_client.Seller = client.seller ?? "";
_client.Spouse = client.spouse ?? "";
_client.State = client.state ?? "";
}
catch (Exception e)
{
Console.WriteLine("Esse: ", e.Message);
}
await InserirCliente(client.Id, _client, clientsInserted, database);
}
Task.WaitAll(tarefasCliente.ToArray());
var arrayBillReceives = billReceives.Find(c => c.client != "5d0ce3f2b796df5a27c4f76e").ToList().ToArray();
//var arrayBillReceives = billReceives.Find(c => c.client == clientId).ToList().ToArray();
for (int i = 0; i < arrayBillReceives.Count(); i++)
{
billsReceiveInserted.Add($"Inserindo registro {i}");
await InserirBillReceive(arrayBillReceives[i], billsReceiveInserted);
}
Task.WaitAll(tarefasBillsReceive.ToArray());
var clientEx = clients.Find(c => c.Id == "5d0ce3f2b796df5a27c4f76e").ToList().FirstOrDefault();
var _clientEx = new Systore.Domain.Entities.Client();
try
{
clientEx.date_of_birth = addhour(clientEx.date_of_birth); // client.date_of_birth.HasValue ? DateTime.SpecifyKind(client.date_of_birth.Value, DateTimeKind.Local) : client.date_of_birth;
clientEx.admission_date = addhour(clientEx.admission_date); //client.admission_date.HasValue ? DateTime.SpecifyKind(client.admission_date.Value, DateTimeKind.Local) : client.admission_date;
clientEx.registry_date = addhour(clientEx.registry_date); //client.registry_date.HasValue ? DateTime.SpecifyKind(client.registry_date.Value, DateTimeKind.Local) : client.registry_date;
_clientEx.Address = clientEx.address ?? "";
_clientEx.AddressNumber = clientEx.address_number ?? "";
_clientEx.City = clientEx.city ?? "";
_clientEx.CivilStatus = (Systore.Domain.Enums.CivilStatus)clientEx.civil_status;
_clientEx.Complement = clientEx.complement ?? "";
_clientEx.Cpf = Utils.OnlyNumbers(clientEx.cpf);
_clientEx.FatherName = clientEx.father_name ?? "";
_clientEx.JobName = clientEx.job_name ?? "";
_clientEx.DateOfBirth = clientEx.date_of_birth; // clientEx.date_of_birth.HasValue ? DateTime.SpecifyKind(clientEx.date_of_birth.Value, DateTimeKind.Local) : clientEx.date_of_birth;
_clientEx.AdmissionDate = clientEx.admission_date; //clientEx.admission_date.HasValue ? DateTime.SpecifyKind(clientEx.admission_date.Value, DateTimeKind.Local) : clientEx.admission_date;
_clientEx.MotherName = clientEx.mother_name ?? "";
_clientEx.Name = clientEx.name ?? "";
_clientEx.Neighborhood = clientEx.neighborhood ?? "";
_clientEx.Note = clientEx.note ?? "";
_clientEx.Occupation = clientEx.occupation ?? "";
_clientEx.Phone1 = clientEx.phone1 ?? "";
_clientEx.Phone2 = clientEx.phone2 ?? "";
_clientEx.PlaceOfBirth = clientEx.place_of_birth ?? "";
_clientEx.PostalCode = clientEx.postal_code ?? "";
_clientEx.Rg = clientEx.rg ?? "";
_clientEx.RegistryDate = clientEx.registry_date;// clientEx.registry_date.HasValue ? DateTime.SpecifyKind(clientEx.registry_date.Value, DateTimeKind.Local) : clientEx.registry_date;
_clientEx.Seller = clientEx.seller ?? "";
_clientEx.Spouse = clientEx.spouse ?? "";
_clientEx.State = clientEx.state ?? "";
}
catch (Exception e)
{
Console.WriteLine("Esse: ", e.Message);
}
SystoreContext context = _systoreContextFactory.CreateDbContext(new string[] { });
Console.WriteLine($"Inserindo cliente {_clientEx.Name}-{_clientEx.Cpf}");
var clientRepository = new ClientRepository(context, null);
clientRepository.IsConversion = true;
string ret = await clientRepository.AddAsync(_clientEx);
if (string.IsNullOrWhiteSpace(ret))
{
clientsInserted.Add(new Tuple <int, string, string>(_clientEx.Id, clientEx.Id, $"Client {_clientEx.Id}-{_clientEx.Name}-{_clientEx.Cpf} inserido com suceso"));
Console.WriteLine($"Client {_clientEx.Id}-{_clientEx.Name}-{_clientEx.Cpf} inserido com suceso.");
}
else
{
clientsInserted.Add(new Tuple <int, string, string>(-1, "", $"Erro ao inserir Client {_clientEx.Name}-{_clientEx.Cpf}: {ret}"));
Console.WriteLine($"Erro ao inserir Client {_clientEx.Name}-{_clientEx.Cpf}: {ret}");
}
foreach (var billReceive in (await(await billReceives.FindAsync(c => c.client == "5d0ce3f2b796df5a27c4f76e")).ToListAsync()))
{
var _billReceive = new Systore.Domain.Entities.BillReceive()
{
ClientId = _clientEx.Id,
Code = billReceive.code,
DaysDelay = billReceive.days_delay,
DueDate = (addhour(billReceive.due_date) ?? DateTime.MinValue.ToUniversalTime()), //billReceive.due_date.HasValue ? DateTime.SpecifyKind(billReceive.due_date.Value, DateTimeKind.Local) : DateTime.MinValue.ToUniversalTime(),
FinalValue = billReceive.final_value,
Interest = billReceive.interest,
OriginalValue = billReceive.original_value,
PayDate = addhour(billReceive.pay_date), // billReceive.pay_date.HasValue ? DateTime.SpecifyKind(billReceive.pay_date.Value, DateTimeKind.Local) : billReceive.pay_date,
PurchaseDate = (addhour(billReceive.purchase_date) ?? DateTime.MinValue.ToUniversalTime()), //billReceive.purchase_date.HasValue ? DateTime.SpecifyKind(billReceive.purchase_date.Value, DateTimeKind.Local) : DateTime.MinValue.ToUniversalTime(),
Quota = billReceive.quota,
Situation = billReceive.situation == "O" ? Systore.Domain.Enums.BillReceiveSituation.Open : Systore.Domain.Enums.BillReceiveSituation.Closed,
Vendor = billReceive.vendor,
};
var billReceiveRepository = new BillReceiveRepository(context, null);
billReceiveRepository.IsConversion = true;
string retBill = await billReceiveRepository.AddAsync(_billReceive);
if (string.IsNullOrWhiteSpace(retBill))
{
Console.WriteLine($"BillReceive: ClientId: {_clientEx.Id} {_billReceive.Code}-{_billReceive.Quota} inserido com sucesso");
billsReceiveInserted.Add($"BillReceive: ClientId: {_clientEx.Id} {_billReceive.Code}-{_billReceive.Quota} inserido com sucesso");
}
else
{
Console.WriteLine($"Erro ao inserir BillReceive: ClientId: {_clientEx.Id} {_billReceive.Code}-{_billReceive.Quota} : {retBill}");
billsReceiveInserted.Add($"Erro ao inserir BillReceive: ClientId: {_clientEx.Id} {_billReceive.Code}-{_billReceive.Quota} : {retBill}");
}
}
List <string> arquivoSaida = new List <string>();
arquivoSaida.AddRange(clientsInserted.Select(c => c.Item3).ToList());
arquivoSaida.AddRange(billsReceiveInserted);
File.WriteAllLines(AppDomain.CurrentDomain.BaseDirectory + "\\log.txt", arquivoSaida);
Console.WriteLine("Fnalizou, verifique o log.txt");
Console.ReadKey();
}