public string readExcelPackageToStringBulk(ExcelPackage package, ExcelWorksheet worksheet)
{
try
{
var rowCount = worksheet.Dimension?.Rows;
var colCount = worksheet.Dimension?.Columns;
if (!rowCount.HasValue || !colCount.HasValue)
{
return(string.Empty);
}
List <BulkPayment> AgentsList = new List <BulkPayment>();
var sb = new StringBuilder();
for (int row = 3; row <= rowCount.Value; row++)
{
string fullNames = worksheet.Cells[row, 2].Value.ToString();
BulkPayment Person = (new BulkPayment
{
FirstName = worksheet.Cells[row, 3].Value.ToString(),
MiddleName = worksheet.Cells[row, 4].Value.ToString(),
LastName = worksheet.Cells[row, 5].Value.ToString(),
IdentificationNo = worksheet.Cells[row, 6].Value.ToString(),
PhoneNumber = worksheet.Cells[row, 6].Value.ToString(),
});
AgentsList.Add(Person);
}
Context.BulkPayments.AddRangeAsync(AgentsList);
Context.SaveChanges();
return(sb.ToString());
}
catch (Exception e)
{
return(e.ToString());
}
}
private IBulkPayment CreateBulkPayment()
{
IBulkPayment bulkPayment = new BulkPayment(LedgerType.PayerAccountsReceivable, "987654321", 10000, new DateTime(2009, 5, 1), _userMock, _batchMock);
return bulkPayment;
}
private IBulkPayment CreateBulkPaymentPersisted()
{
IBulkPayment bulkPayment = new BulkPayment(LedgerType.PayerAccountsReceivable, 9650, _batchMock);
return bulkPayment;
}
public BulkPaymentResponseData bulkPayment(BulkPaymentPayload bulkPaymentPayload)
{
BulkPayment bulkPayment = new BulkPayment();
return(bulkPayment.makeBulkPayment(bulkPaymentPayload, NewCredentials));
}
