public void proccessData(DataModelStatsBibRecord tempData)
{
Models.StatsBib.DataSetStatsBibTableAdapters.OLPL_Apps_Stats_BibTableAdapter tbConnection = new Models.StatsBib.DataSetStatsBibTableAdapters.OLPL_Apps_Stats_BibTableAdapter();
if (tempData.id == 0)
{
tbConnection.Insert(tempData.dateReport, tempData.dateCreated, tempData.iType, tempData.iAudiance, tempData.statAdds, tempData.statDeletes, tempData.statTotal, tempData.statNet, tempData.statPTotal);
}
else
{
tbConnection.UpdateQuery(tempData.dateReport, tempData.dateCreated, tempData.iType, tempData.iAudiance, tempData.statAdds, tempData.statDeletes, tempData.statTotal, tempData.statNet, tempData.statPTotal, tempData.id);
}
}
public DataModelStatsBibRecord setTempData()
{
DataModelStatsBibRecord tempData = new DataModelStatsBibRecord(); ;
tempData.statPTotal = 0;
tempData.iType = "None";
tempData.iAudiance = "None";
tempData.dateReport = DateTime.Now;
tempData.dateCreated = DateTime.Now;
tempData.statAdds = 0;
tempData.statDeletes = 0;
tempData.statNet = 0;
tempData.id = 0;
tempData.statTotal = 0;
return tempData;
}
public DataModelStatsBibRecord getSQLData(DataModelStatsBibRecord tempData, DataModelStatsBib dd1)
{
Models.StatsBib.DataSetStatsBibTableAdapters.OLPL_Apps_Stats_BibTableAdapter tbConnection = new Models.StatsBib.DataSetStatsBibTableAdapters.OLPL_Apps_Stats_BibTableAdapter();
DataSetStatsBib.OLPL_Apps_Stats_BibDataTable tbResults = new DataSetStatsBib.OLPL_Apps_Stats_BibDataTable();
tbConnection.FillByFilter(tbResults, dd1.dateReport, dd1.iType, dd1.iAudiance);
if (tbResults.Count > 0)
{
DataSetStatsBib.OLPL_Apps_Stats_BibRow row1 = (DataSetStatsBib.OLPL_Apps_Stats_BibRow)tbResults.Rows[0];
tempData.iType = row1.iType;
tempData.id = row1.id;
tempData.iAudiance = row1.iAudiance;
tempData.statNet = row1.statNet;
tempData.statAdds = row1.statAdds;
tempData.statPTotal = row1.statPTotal;
tempData.dateCreated = row1.dateCreated;
tempData.dateReport = row1.dateReport;
tempData.statDeletes = row1.statDeletes;
tempData.statTotal = row1.statTotal;
}
else { tempData.id = 0; }
return tempData;
}
public int getPTotal(DataModelStatsBibRecord tempData, DataModelStatsBib dd1)
{
Models.StatsBib.DataSetStatsBibTableAdapters.OLPL_Apps_Stats_BibTableAdapter tbConnection = new Models.StatsBib.DataSetStatsBibTableAdapters.OLPL_Apps_Stats_BibTableAdapter();
DataSetStatsBib.OLPL_Apps_Stats_BibDataTable tbResults = new DataSetStatsBib.OLPL_Apps_Stats_BibDataTable();
DateTime datePTotal;
if (dd1.dateReport.Month == 1)
{
int year = dd1.dateReport.Year-1;
datePTotal = DateTime.Parse("12/1/" + year.ToString());
}
else
{
datePTotal = dd1.dateReport.AddMonths(-1);
}
tbConnection.FillByFilter(tbResults, datePTotal, dd1.iType, dd1.iAudiance);
if (tbResults.Count > 0)
{
DataSetStatsBib.OLPL_Apps_Stats_BibRow row1 = (DataSetStatsBib.OLPL_Apps_Stats_BibRow)tbResults.Rows[0];
return row1.statTotal;
}
else { return 0; }
}