private static List<Driver> LoadAllDriversLists(int cardId)
{
List<Driver> driversStructureList = new List<Driver>();
int number = 0;
string connectionString = ConfigurationManager.AppSettings["fleetnetbaseConnectionString"];
DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]);
Driver driversStructureTemp;
List<int> dataBlockIds = new List<int>();
try
{
dataBlock.OpenConnection();
dataBlockIds = dataBlock.cardsTable.GetAllDataBlockIds_byCardId(cardId);
int cardType;
List<DateTime> startEnd = new List<DateTime>();
foreach (int dataBlockId in dataBlockIds)
{
number++;
driversStructureTemp = new Driver();
driversStructureTemp.DataBlockId = dataBlockId;
driversStructureTemp.Number = number;
driversStructureTemp.Name = dataBlock.GetDataBlock_FileName(dataBlockId);
driversStructureTemp.RecordsCount = dataBlock.GetDataBlock_RecorsCount(dataBlockId);
driversStructureTemp.CreationTime = dataBlock.GetDataBlock_EDate(dataBlockId);
cardType = dataBlock.GetDataBlock_CardType(dataBlockId);
driversStructureTemp.CardTypeName = dataBlock.GetCardTypeName(dataBlockId);
if (cardType == 0)
{
startEnd = dataBlock.cardUnitInfo.Get_StartEndPeriod(dataBlockId);
driversStructureTemp.setFromDate(startEnd[0]);
driversStructureTemp.setToDate(startEnd[1]);
}
else
if (cardType == 2)
{
driversStructureTemp.setFromDate(dataBlock.plfUnitInfo.Get_START_PERIOD(dataBlockId));
driversStructureTemp.setToDate(dataBlock.plfUnitInfo.Get_END_PERIOD(dataBlockId));
}
else
{
driversStructureTemp.setFromDate(new DateTime());
driversStructureTemp.setToDate(new DateTime());
}
driversStructureList.Add(driversStructureTemp);
}
dataBlock.CloseConnection();
return driversStructureList;
}
catch (Exception ex)
{
dataBlock.CloseConnection();
return null;
}
}