private List <ContractorsAndContracts> GetContractorsAndContractsValues(DataTableCollection dataTableCollection, string tableName)
{
System.Data.DataTable table = dataTableCollection[tableName];
if (table == null)
{
table = dataTableCollection[0];
}
List <ContractorsAndContracts> contractorsAndContracts = new List <ContractorsAndContracts>();
foreach (DataRow row in table.Rows)
{
ContractorsAndContracts contractorsAndContractRow = new ContractorsAndContracts();
foreach (DataColumn column in table.Columns)
{
PutValueByTheCaptionContractsAndContracters(row, column, contractorsAndContractRow);
}
contractorsAndContracts.Add(contractorsAndContractRow);
}
return(contractorsAndContracts);
}
/// <summary>
/// переделать эту страшную штуку во что то приличное
/// </summary>
/// <param name="row"></param>
/// <param name="column"></param>
/// <param name="contractorsAndContract"></param>
private void PutValueByTheCaptionContractsAndContracters(DataRow row, DataColumn column, ContractorsAndContracts contractorsAndContractRow)
{
if (column.Caption.Contains("Contract #"))
{
contractorsAndContractRow.ContractId = row[column].ToString();
}
if (column.Caption.Contains("Name Eng"))
{
contractorsAndContractRow.NameEng = row[column].ToString();
}
if (column.Caption.Contains("Name Rus"))
{
contractorsAndContractRow.NameRus = row[column].ToString();
}
if (column.Caption.Contains("Contract Date Eng"))
{
contractorsAndContractRow.ContractStartDate = DateTime.Parse(row[column].ToString());
}
if (column.Caption.Contains("Contract Date Rus"))
{
contractorsAndContractRow.ContractStartDateRus = row[column].ToString();
}
if (column.Caption.Contains("INN"))
{
contractorsAndContractRow.INN = row[column].ToString();
}
if (column.Caption.Contains("Mailing Address"))
{
contractorsAndContractRow.MailingAddress = row[column].ToString();
}
if (column.Caption.Contains("Bank") && !column.Caption.Contains("BIC"))
{
contractorsAndContractRow.BankName = row[column].ToString();
}
if (column.Caption.Contains("Bank's BIC"))
{
contractorsAndContractRow.BanksBIC = row[column].ToString();
}
if (column.Caption.Contains("Correspondent Account"))
{
contractorsAndContractRow.CorrespondentAccount = row[column].ToString();
}
if (column.Caption.Contains("Account #"))
{
contractorsAndContractRow.AccountNumber = row[column].ToString();
}
if (column.Caption.Contains("Phone #"))
{
contractorsAndContractRow.Phone = row[column].ToString();
}
}
