public DataTable GetDbsStats(enumOmrade omrade)
{
DataTable dtDbsStats = InitDataNew();
DataTable dtDatabases = GetDatabases();
foreach (DataRow dr in dtDatabases.Rows)
{
AddStatistics(dtDbsStats, dr["NAME"].ToString(), omrade);
}
dtDbsStats.AcceptChanges();
return dtDbsStats;
}
public DataTable GetDbsStats(enumOmrade omrade)
{
DataTable dtDbsStats = InitDataNew();
DataTable dtDatabases = GetDatabases();
foreach (DataRow dr in dtDatabases.Rows)
{
AddStatistics(dtDbsStats, dr["NAME"].ToString(), omrade);
}
dtDbsStats.AcceptChanges();
return(dtDbsStats);
}
private void AddStatistics(DataTable dtDbsStats, string DatabaseName, enumOmrade omrade)
{
DataRow dr = dtDbsStats.NewRow();
try
{
//Databasens namn
dr["NAMN"] = DatabaseName;
//Antal användare
AddStatisticFromDbs(dr, DatabaseName, "BA_ANV", "ANTAL_ANVANDARE");
//Antal anställda
AddStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_GRUND", "ANTAL_ANSTALLDA");
if (omrade == enumOmrade.omrGemensamt)
{
//Antal företag
AddStatisticFromDbs(dr, DatabaseName, "BA_FTG", "ANTAL_FORETAG");
//Antal användarprofiler
AddStatisticFromDbs(dr, DatabaseName, "BA_ANVGRP", "ANTAL_ANVANDARPROFILER");
//Antal personprofiler
AddStatisticFromDbs(dr, DatabaseName, "BA_PERSONPROFIL", "ANTAL_PERSONPROFILER");
//Antal programprofiler
AddStatisticFromDbs(dr, DatabaseName, "BA_PROGRAMPROFIL", "ANTAL_PROGRAMPROFILER");
//Antal rapporter
AddStatisticFromDbs(dr, DatabaseName, "UD_FORMAT", "ANTAL_RAPPORTER");
//Antal distributioner
AddStatisticFromDbs(dr, DatabaseName, "UD_DISTRIBUTION", "ANTAL_DISTRIBUTIONER");
//Antal noteringar
AddStatisticFromDbs(dr, DatabaseName, "BA_ANTECKNING", "ANTAL_NOTERINGAR");
//Antal bevakningar
AddStatisticFromDbs(dr, DatabaseName, "BA_BEVAKNING", "ANTAL_BEVAKNINGAR");
}
if (omrade == enumOmrade.omrLon)
{
//Antal löner
AddStatisticFromDbs(dr, DatabaseName, "BA_LONPER_PERS", "ANTAL_LONER");
//Antal projekt
AddStatisticFromDbs(dr, DatabaseName, "PR_PROJEKT", "ANTAL_PROJEKT");
//Antal lärlingar
AddStatisticFromDbs(dr, DatabaseName, "PR_AKTIVT_FTAL", "ANTAL_LARLINGAR");
//Antal konteringsbegrepp
AddStatisticFromDbs(dr, DatabaseName, "BA_KONTBGR", "ANTAL_KONTBGR");
//Antal revisionstillfällen
AddStatisticFromDbs(dr, DatabaseName, "LR_REVTILLF", "ANTAL_REVISIONSTILLFALLEN");
//Antal avvikelser
AddStatisticFromDbs(dr, DatabaseName, "BA_AVVIK_PERS", "ANTAL_AVVIKELSER");
}
if (omrade == enumOmrade.omrTid)
{
//Antal stämplingar tidreg
AddStamplingStatisticFromDbs(dr, DatabaseName, "TI_STAMPLINGAR", "ANTAL_STAMPLINGAR_TIDREG", true);
//Antal stämplingar förtroende
AddStamplingStatisticFromDbs(dr, DatabaseName, "TI_STAMPLINGAR", "ANTAL_STAMPLINGAR_FORTROENDE", false);
//Antal Offline-stämplingar
AddStatisticFromDbs(dr, DatabaseName, "TI_OFFLINESTAMPLINGAR", "ANTAL_OFFLINESTAMPLINGAR");
//Antal tidterminaler
AddStatisticFromDbs(dr, DatabaseName, "TI_TIDTERMINALER", "ANTAL_TIDTERMINALER");
}
if (omrade == enumOmrade.omrResor)
{
//Antal resor
AddStatisticFromDbs(dr, DatabaseName, "RE_RESOR", "ANTAL_RESOR");
AddStatisticFromDbs(dr, DatabaseName, "RE_PERS_KREDITK", "ANTAL_KREDITKORT");
}
if (omrade == enumOmrade.omrHRM)
{
//Antal medarbetarsamtal
AddStatisticFromDbs(dr, DatabaseName, "PA_MEDARB_SAMT", "ANTAL_MEDARB_SAMT");
//Antal rekryteringsärenden
AddStatisticFromDbs(dr, DatabaseName, "PA_JOBB", "ANTAL_REKRYT");
//Antal kompetenser
AddStatisticFromDbs(dr, DatabaseName, "PA_KOMP", "ANTAL_KOMPETENSER");
//Antal utbildningar
AddStatisticFromDbs(dr, DatabaseName, "PA_KURS", "ANTAL_UTBILDNINGAR");
}
if (omrade == enumOmrade.omrHist)
{
//Antal arbetstid
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_ARBTID", "ANTAL_HIST_ARBTID");
//Antal fack
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_FACK", "ANTAL_HIST_FACK");
//Antal kontering
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_KONTERING", "ANTAL_HIST_KONTERING");
//Antal lön
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_LON", "ANTAL_HIST_LON");
//Antal organisation
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_ORGANISATION", "ANTAL_HIST_ORGANISATION");
//Antal semester
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_SEMESTER", "ANTAL_HIST_SEMESTER");
//Antal skatt
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_SKATT", "ANTAL_HIST_SKATT");
//Antal statistik
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_STATISTIK", "ANTAL_HIST_STATISTIK");
}
if (omrade == enumOmrade.omrVersion)
{
//Versionsinfo
AddVersionsinfoFromDbs(dr, DatabaseName, "BA_DB_VERSION", "VERSION_TXT", "SCRIPT_NR");
}
if (omrade == enumOmrade.omrACL)
{
//Antal ACL
AddStatisticFromDbs(dr, DatabaseName, "ACL", "ANTAL_ACL");
//Antal ACL beskrivning
AddStatisticFromDbs(dr, DatabaseName, "ACL_BESTALLNING", "ANTAL_ACL_BESTALLNING");
//Antal ACL historik
AddStatisticFromDbs(dr, DatabaseName, "ACL_HISTORIK", "ANTAL_ACL_HISTORIK");
//Antal ACL historik detaljer
AddStatisticFromDbs(dr, DatabaseName, "ACL_HISTORIK_DETALJER", "ANTAL_ACL_HISTORIK_DETALJER");
//Detta är bara en testrad
AddStatisticFromDbs(dr, DatabaseName, "ACL_HISTORIK_DETALJER", "ANTAL_ACL_HISTORIK_DETALJER");
}
dtDbsStats.Rows.Add(dr);
dr.AcceptChanges();
}
catch
{
dr.RejectChanges();
}
}
private void AddStatistics(DataTable dtDbsStats, string DatabaseName, enumOmrade omrade)
{
DataRow dr = dtDbsStats.NewRow();
try
{
//Databasens namn
dr["NAMN"] = DatabaseName;
//Antal användare
AddStatisticFromDbs(dr, DatabaseName, "BA_ANV", "ANTAL_ANVANDARE");
//Antal anställda
AddStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_GRUND", "ANTAL_ANSTALLDA");
if (omrade == enumOmrade.omrGemensamt)
{
//Antal företag
AddStatisticFromDbs(dr, DatabaseName, "BA_FTG", "ANTAL_FORETAG");
//Antal användarprofiler
AddStatisticFromDbs(dr, DatabaseName, "BA_ANVGRP", "ANTAL_ANVANDARPROFILER");
//Antal personprofiler
AddStatisticFromDbs(dr, DatabaseName, "BA_PERSONPROFIL", "ANTAL_PERSONPROFILER");
//Antal programprofiler
AddStatisticFromDbs(dr, DatabaseName, "BA_PROGRAMPROFIL", "ANTAL_PROGRAMPROFILER");
//Antal rapporter
AddStatisticFromDbs(dr, DatabaseName, "UD_FORMAT", "ANTAL_RAPPORTER");
//Antal distributioner
AddStatisticFromDbs(dr, DatabaseName, "UD_DISTRIBUTION", "ANTAL_DISTRIBUTIONER");
//Antal noteringar
AddStatisticFromDbs(dr, DatabaseName, "BA_ANTECKNING", "ANTAL_NOTERINGAR");
//Antal bevakningar
AddStatisticFromDbs(dr, DatabaseName, "BA_BEVAKNING", "ANTAL_BEVAKNINGAR");
}
if (omrade == enumOmrade.omrLon)
{
//Antal löner
AddStatisticFromDbs(dr, DatabaseName, "BA_LONPER_PERS", "ANTAL_LONER");
//Antal projekt
AddStatisticFromDbs(dr, DatabaseName, "PR_PROJEKT", "ANTAL_PROJEKT");
//Antal lärlingar
AddStatisticFromDbs(dr, DatabaseName, "PR_AKTIVT_FTAL", "ANTAL_LARLINGAR");
//Antal konteringsbegrepp
AddStatisticFromDbs(dr, DatabaseName, "BA_KONTBGR", "ANTAL_KONTBGR");
//Antal revisionstillfällen
AddStatisticFromDbs(dr, DatabaseName, "LR_REVTILLF", "ANTAL_REVISIONSTILLFALLEN");
//Antal avvikelser
AddStatisticFromDbs(dr, DatabaseName, "BA_AVVIK_PERS", "ANTAL_AVVIKELSER");
}
if (omrade == enumOmrade.omrTid)
{
//Antal stämplingar tidreg
AddStamplingStatisticFromDbs(dr, DatabaseName, "TI_STAMPLINGAR", "ANTAL_STAMPLINGAR_TIDREG", true);
//Antal stämplingar förtroende
AddStamplingStatisticFromDbs(dr, DatabaseName, "TI_STAMPLINGAR", "ANTAL_STAMPLINGAR_FORTROENDE", false);
//Antal Offline-stämplingar
AddStatisticFromDbs(dr, DatabaseName, "TI_OFFLINESTAMPLINGAR", "ANTAL_OFFLINESTAMPLINGAR");
//Antal tidterminaler
AddStatisticFromDbs(dr, DatabaseName, "TI_TIDTERMINALER", "ANTAL_TIDTERMINALER");
}
if (omrade == enumOmrade.omrResor)
{
//Antal resor
AddStatisticFromDbs(dr, DatabaseName, "RE_RESOR", "ANTAL_RESOR");
AddStatisticFromDbs(dr, DatabaseName, "RE_PERS_KREDITK", "ANTAL_KREDITKORT");
}
if (omrade == enumOmrade.omrHRM)
{
//Antal medarbetarsamtal
AddStatisticFromDbs(dr, DatabaseName, "PA_MEDARB_SAMT", "ANTAL_MEDARB_SAMT");
//Antal rekryteringsärenden
AddStatisticFromDbs(dr, DatabaseName, "PA_JOBB", "ANTAL_REKRYT");
//Antal kompetenser
AddStatisticFromDbs(dr, DatabaseName, "PA_KOMP", "ANTAL_KOMPETENSER");
//Antal utbildningar
AddStatisticFromDbs(dr, DatabaseName, "PA_KURS", "ANTAL_UTBILDNINGAR");
}
if (omrade == enumOmrade.omrHist)
{
//Antal arbetstid
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_ARBTID", "ANTAL_HIST_ARBTID");
//Antal fack
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_FACK", "ANTAL_HIST_FACK");
//Antal kontering
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_KONTERING", "ANTAL_HIST_KONTERING");
//Antal lön
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_LON", "ANTAL_HIST_LON");
//Antal organisation
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_ORGANISATION", "ANTAL_HIST_ORGANISATION");
//Antal semester
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_SEMESTER", "ANTAL_HIST_SEMESTER");
//Antal skatt
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_SKATT", "ANTAL_HIST_SKATT");
//Antal statistik
AddPersHistStatisticFromDbs(dr, DatabaseName, "BA_ANSTALLD_STATISTIK", "ANTAL_HIST_STATISTIK");
}
if (omrade == enumOmrade.omrVersion)
{
//Versionsinfo
AddVersionsinfoFromDbs(dr, DatabaseName, "BA_DB_VERSION", "VERSION_TXT", "SCRIPT_NR");
}
if (omrade == enumOmrade.omrACL)
{
//Antal ACL
AddStatisticFromDbs(dr, DatabaseName, "ACL", "ANTAL_ACL");
//Antal ACL beskrivning
AddStatisticFromDbs(dr, DatabaseName, "ACL_BESTALLNING", "ANTAL_ACL_BESTALLNING");
//Antal ACL historik
AddStatisticFromDbs(dr, DatabaseName, "ACL_HISTORIK", "ANTAL_ACL_HISTORIK");
//Antal ACL historik detaljer
AddStatisticFromDbs(dr, DatabaseName, "ACL_HISTORIK_DETALJER", "ANTAL_ACL_HISTORIK_DETALJER");
//Detta är bara en testrad
AddStatisticFromDbs(dr, DatabaseName, "ACL_HISTORIK_DETALJER", "ANTAL_ACL_HISTORIK_DETALJER");
}
dtDbsStats.Rows.Add(dr);
dr.AcceptChanges();
}
catch
{
dr.RejectChanges();
}
}
