public ReturnStructure <T> Delete <T>(T obj) where T : class
{
sysplanAgrimaldoDatabase.Database.BeginTransaction();
try
{
sysplanAgrimaldoDatabase.Set <T>().Remove(obj);
}
catch (Exception ex)
{
sysplanAgrimaldoDatabase.Database.RollbackTransaction();
return(ReturnStructure <T> .Return(false, ex.Message));
}
sysplanAgrimaldoDatabase.Database.CommitTransaction();
sysplanAgrimaldoDatabase.SaveChanges();
return(ReturnStructure <T> .Return(obj));
}
public ReturnStructure <Client> Delete(Guid Id)
{
var _client = repository.GetOne <Client>(false, a => a.Id.Equals(Id));
if (_client == null)
{
return(ReturnStructure <Client> .Return(false, "Cliente não encontrado"));
}
var _result = repository.Delete <Client>(_client);
if (_result.Success)
{
return(ReturnStructure <Client> .Return(true, "Cliente excluído com sucesso"));
}
else
{
return(ReturnStructure <Client> .Return(false, "Ocorreu um erro no processo de remoção"));
}
}
public static async Task Main()
{
List <Account> list_accounts = new List <Account>();
//Acesso às APIs
var clients = new List <ClientAccount>();
var client1 = new ClientAccount(ConfigurationManager.AppSettings["client1Auth"], ConfigurationManager.AppSettings["client1Token"], ConfigurationManager.AppSettings["client1endpoint"]);
var client2 = new ClientAccount(ConfigurationManager.AppSettings["client2Auth"], ConfigurationManager.AppSettings["client2Token"], ConfigurationManager.AppSettings["client2endpoint"]);
var client3 = new ClientAccount(ConfigurationManager.AppSettings["client3Auth"], ConfigurationManager.AppSettings["client3Token"], ConfigurationManager.AppSettings["client3endpoint"]);
clients.Add(client1);
clients.Add(client2);
clients.Add(client3);
foreach (var client in clients)
{
SafraAPIsComm restApi = new SafraAPIsComm();
string oAuth = restApi.OAuthRq(client.TokenAccount);
var json = restApi.TransactionRq(oAuth, client.AccountEndpoint);
string accountId = String.Empty;
string transactionId = String.Empty;
string transactionAmount = String.Empty;
string creditDebitInfo = String.Empty;
string balanceAmount = String.Empty;
string balanceCreditDebitInfo = String.Empty;
string insertCreditQuery = String.Empty;
string insertDebitQuery = String.Empty;
double client_in = 0;
double client_out = 0;
foreach (var item in json.Data.Transaction)
{
//info da transação
accountId = item.AccountId;
transactionId = item.TransactionId;
transactionAmount = item.Amount._Amount;
creditDebitInfo = item.CreditDebitIndicator;
if (creditDebitInfo.Equals("Credit", StringComparison.OrdinalIgnoreCase))
{
client_in += Double.Parse(transactionAmount, System.Globalization.CultureInfo.InvariantCulture);
}
else if (creditDebitInfo.Equals("Debit", StringComparison.OrdinalIgnoreCase))
{
client_out += Double.Parse(transactionAmount, System.Globalization.CultureInfo.InvariantCulture);
}
}
Account account = new Account();
account.Balance_in = client_in;
account.Balance_out = client_out;
account.Description = accountId;
list_accounts.Add(account);
}
Database db = new Database();
ReturnStructure returnstructure = new ReturnStructure();
await Task.Run(() => returnstructure = db.Set_Accounts(list_accounts));
//Run no algoritmo de "clusterização"
//-----------------------------------
var pyScript = new Cluster();
pyScript.RunClusterAlgorithm();
String exe_location = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location);
await Task.Run(() => returnstructure = db.Get_Accounts());
if (returnstructure.Status)
{
List <Account> list_of_accounts = (List <Account>)returnstructure.Data;
Excel excel = new Excel();
await Task.Run(() => excel.Create_Report(list_of_accounts, Path.Combine(exe_location, @"relatorio saude financeira.xlsx")));
GC.Collect();
GC.WaitForPendingFinalizers();
}
//Envio do e-mail
var email = new Email();
email.SendEmail(Path.Combine(exe_location, @"relatorio saude financeira.xlsx"));
}
public ReturnStructure <List <Client> > Get()
{
var _result = repository.List <Client>();
return(ReturnStructure <List <Client> > .Return(_result));
}
