public bool AddListCustomers(ListCreateCustomersCommand customers)
{
try
{
var addCustomerResult = _repository.AddListCustomersInBulk(customers);
return(addCustomerResult == 0 ? false : true);
}
catch (Exception ex)
{
return(false);
}
}
public async Task <bool> TaskAddListCustomers(ListCreateCustomersCommand customers)
{
try
{
var getNameCustomer = NameCustomer(customers.Customers[0].FirstName);
var addCustomerResult = _repository.TaskAddListCustomersInBulk(customers);
return(addCustomerResult.Result == 0 ? false : true);
}
catch (Exception ex)
{
return(false);
}
}
public int AddListCustomersInBulk(ListCreateCustomersCommand customers)
{
var sqls = GetCustomerSqlsInBatches(customers.Customers);
var resultExecute = 0;
using (var connection = new SqlConnection(_config.Value.ConnectionString))
{
foreach (var sql in sqls)
{
resultExecute = connection.ExecuteAsync(sql).Result;
}
}
return(resultExecute);
}
public async Task <int> TaskAddListCustomersInBulk(ListCreateCustomersCommand customers)
{
var sqls = GetCustomerSqlsInBatches(customers.Customers);
int execute = 1;
using (var connection = new SqlConnection(_config.Value.ConnectionString))
{
foreach (var sql in sqls)
{
execute = connection.ExecuteAsync(sql).Result;
}
}
await Task.Delay(2000);
return(execute);
}
public async Task <bool> TaskAddListCustomers([FromBody] ListCreateCustomersCommand customers)
{
return(await _handler.TaskAddListCustomers(customers));
}
public bool AddListCustomers([FromBody] ListCreateCustomersCommand customers)
{
return(_handler.AddListCustomers(customers));
}
public Task <int> TaskAddListCustomersInBulk(ListCreateCustomersCommand customers)
{
throw new NotImplementedException();
}
