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(); } }