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;
}
}
public void LoadAllDriversDateStatistics(List<int> dataBlockIds)
{
string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"];
DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]);
try
{
DateTime mindate = DateTime.Now;
DateTime maxdate = new DateTime();
List<DateTime> startEndPeriod = new List<DateTime>();
List<int> selectedIds = new List<int>();
bool isDDD = IsDDDFile();
dataBlock.OpenConnection();
Session["AllDataBlockIds"] = dataBlockIds;
int fileType = 0;
foreach (int id in dataBlockIds)
{
fileType = dataBlock.GetDataBlock_CardType(id);
if (isDDD == true)//DDD
if (fileType == 2 || fileType == 1)//2-PLF, 1-vehicle
continue;
else
{
selectedIds.Add(id);
startEndPeriod = dataBlock.cardUnitInfo.Get_StartEndPeriod(id);
}
else//PLF
if (fileType == 0 || fileType == 1)//0 - drivers DDD; 1 for vehicle
continue;
else
{
selectedIds.Add(id);
startEndPeriod = new List<DateTime>();
startEndPeriod.Add(dataBlock.plfUnitInfo.Get_START_PERIOD(id));
startEndPeriod.Add(dataBlock.plfUnitInfo.Get_END_PERIOD(id));
}
if (mindate > startEndPeriod[0])
mindate = startEndPeriod[0];
if (maxdate < startEndPeriod[1])
maxdate = startEndPeriod[1];
}
Session["StatisticsDataBlockIds"] = selectedIds;
List<int> yearsList = GetYearList(mindate, maxdate);
if (isDDD)
{
LoadAllForDDDDriver(dataBlock, selectedIds, yearsList);
}
else
{
LoadAllForPLFFile(dataBlock, selectedIds, yearsList);
}
Status.Text = "";
YearsGrid.SelectedIndex = 0;
MonthGrid.SelectedIndex = 0;
}
catch (Exception ex)
{
Status.Text = ex.Message;
}
finally
{
dataBlock.CloseConnection();
DateUpdate.Update();
}
}
public static List<PLFFilesTreeItem> GetPLFFilesTree(String OrgID)
{
string connectionString = ConfigurationManager.AppSettings["fleetnetbaseConnectionString"];
DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]);
int orgId = Convert.ToInt32(OrgID);
List<string> names = new List<string>();
List<string> numbers = new List<string>();
List<int> IDs = new List<int>();
List<int> PLFs = new List<int>();
dataBlock.OpenConnection();
IDs = dataBlock.cardsTable.GetAllCardIds(orgId, dataBlock.cardsTable.driversCardTypeId);
names = dataBlock.cardsTable.GetCardNames(IDs);
numbers = dataBlock.cardsTable.GetCardNumbers(IDs);
List<PLFFilesTreeItem> PLFFilesTreeItems = new List<PLFFilesTreeItem>();
const int CARD_TYPE_DRIVER=0;
const int CARD_TYPE_PLF=2;
for (int i = 0; i < names.Count;i++)
{
PLFFilesTreeItem treeItem=new PLFFilesTreeItem ();
treeItem.ID=IDs[i];
treeItem.Name=names[i];
treeItem.Number=numbers[i];
PLFFilesTreeItems.Add(treeItem);
PLFs= dataBlock.cardsTable.GetAllDataBlockIds_byCardId(IDs[i]);
if (PLFs != null)
{
foreach (int plf in PLFs)
{
int cardType; //0 - driver, 2 - plf
cardType = dataBlock.GetDataBlock_CardType(plf);
if (cardType == CARD_TYPE_PLF)
{
string vehicle = dataBlock.plfUnitInfo.Get_VEHICLE(plf);
string deviceID = dataBlock.plfUnitInfo.Get_ID_DEVICE(plf);
string period = "(" + dataBlock.plfUnitInfo.Get_START_PERIOD(plf).ToShortDateString() +
" - " +
dataBlock.plfUnitInfo.Get_END_PERIOD(plf).ToShortDateString() + ")";
bool exist=false;
foreach(PLFFilesTreeItem item in PLFFilesTreeItems)
{
foreach(PLFItem PLFItem in item.PLFItems)
{
if(PLFItem.DeviceID.Equals(vehicle)&&PLFItem.Equals(deviceID)){
PLFItem.PLFs.Add(new MapItem(plf.ToString(), period));
exist=true;
break;
}
}
}
if(!exist)
{
PLFItem PLFItem = new PLFItem();
PLFItem.Vehicle = vehicle;
PLFItem.DeviceID = deviceID;
PLFItem.PLFs.Add(new MapItem(plf.ToString(), period));
treeItem.PLFItems.Add(PLFItem);
}
}
}
}
}
dataBlock.CloseConnection();
return PLFFilesTreeItems;
}
protected void ReloadStats_Click(object s, EventArgs e)
{
string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"];
DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]);
try
{
bool isDDD = IsDDDFile();
List<int> selectedIds = new List<int>();
selectedIds = (List<int>)Session["StatisticsDataBlockIds"];
int yearVal = Convert.ToInt32(YearsGrid.SelectedRow.Cells[0].Text);
int monthNumber = MonthGrid.SelectedIndex+1;
dataBlock.OpenConnection();
if (isDDD)
{
if (dataBlock.GetDataBlock_CardType(selectedIds[0]) == 0)//dddDriverCard
{
MonthGrid_Values.DataSource = GetDDDMonthValuesDataTable(dataBlock, selectedIds, yearVal);
DaysGrid.DataSource = GetDDDDayValuesDataTable(dataBlock, selectedIds, yearVal, monthNumber);
}
else//DDDVehicleCard
{
MonthGrid_Values.DataSource = GetVehicleMonthValuesDataTable(dataBlock, selectedIds, yearVal);
DaysGrid.DataSource = GetVehicleDayValuesDataTable(dataBlock, selectedIds, yearVal, monthNumber);
}
}
else
{
MonthGrid_Values.DataSource = GetPLFMonthValuesDataTable(dataBlock, selectedIds, yearVal);
DaysGrid.DataSource = GetPLFDayValuesDataTable(dataBlock, selectedIds, yearVal, monthNumber);
}
MonthGrid_Values.DataBind();
DaysGrid.DataBind();
dataBlock.CloseConnection();
DateUpdate.Update();
}
catch (Exception ex)
{
Status.Text = ex.Message;
DateUpdate.Update();
}
finally
{
dataBlock.CloseConnection();
}
}