public static void generisiRezultat()
{
Console.WriteLine(DateTime.Now + ": Pocinje generisanje rezultata...");
DBBasicFunctions.openConnection();
DBBasicFunctions.generisiRezultat();
DBBasicFunctions.closeConnection();
Console.WriteLine(DateTime.Now + ": Zavrseno generisanje rezultata.");
}
public static ArrayList getRezultat(int IDMonitoring)
{
ArrayList rib;
Console.WriteLine(DateTime.Now + ": Pocinje hvatanje rezultata...");
DBBasicFunctions.openConnection();
rib = DBBasicFunctions.getRezultat(IDMonitoring);
DBBasicFunctions.closeConnection();
Console.WriteLine(DateTime.Now + ": Zavrseno hvatanje rezultata.");
return(rib);
}
public static void uploadSource(String filePath)
{
Console.WriteLine(DateTime.Now + ": Pocinje upload novog source-a...");
RacunIzCSV rcsv;
StreamReader sr;
CsvReader csvread;
int lineCount;
int i;
// inicijalizacija
rcsv = null;
sr = new StreamReader(filePath);
csvread = new CsvReader(sr);
lineCount = File.ReadLines(filePath).Count();
i = 1;
DBBasicFunctions.openConnection();
DBBasicFunctions.shiftOld();
csvread.Configuration.HasHeaderRecord = false;
while (csvread.Read())
{
rcsv = new RacunIzCSV(csvread);
while (rcsv.maticniBroj == null) //ako maticni broj ne postoji
{
rcsv = new RacunIzCSV(csvread);
}
DBBasicFunctions.writeRacuniIzCSV(rcsv);
if (i % 1000 == 0)
{
Console.WriteLine("Upisao " + i + "/" + lineCount);
}
i++;
}
DBBasicFunctions.closeConnection();
Console.WriteLine(DateTime.Now + ": Zavrsen upload source-a.");
}
public static List <MonitoringIzBaze> getMonitoringIzBaze()
{
List <MonitoringIzBaze> monitoringIzBaze = new List <MonitoringIzBaze>();
MonitoringIzBaze mib;
DBBasicFunctions.openConnection();
List <int> monitoringPoVrsti = DBBasicFunctions.getMonitoringIDPoVrsti(8);
foreach (int monitoringID in monitoringPoVrsti)
{
mib = new MonitoringIzBaze();
mib.idMonitoring = monitoringID;
mib.naziv = DBBasicFunctions.getNazivPoIDMonitoring(monitoringID);
mib.mailoviZaSlanje = DBBasicFunctions.getMailPoIDMonitoring(monitoringID);
monitoringIzBaze.Add(mib);
mib = null;
}
DBBasicFunctions.closeConnection();
return(monitoringIzBaze);
}
static void Main(string[] args)
{
if (DBBasicFunctions.checkDatabaseStatus())
{
ArrayList rib;
SadistaImplementation.doYourThing();
UcitavanjeGenerisanje.uploadSource(Params.PUTANJA_ZA_SKINUTO + "\\" + Params.FILE_PREFIX + DateTime.Now.ToString(Params.FILE_NAME_FORMAT) + Params.FILE_EXTENSION);
UcitavanjeGenerisanje.generisiRezultat();
List <MonitoringIzBaze> monitoringIzBaze = UcitavanjeGenerisanje.getMonitoringIzBaze();
foreach (MonitoringIzBaze mib in monitoringIzBaze)
{
rib = UcitavanjeGenerisanje.getRezultat(mib.idMonitoring);
UcitavanjeGenerisanje.email_send(mib.naziv,
ExcelCommunication.upisiUFajl(rib, mib.naziv, mib.naziv),
mib.mailoviZaSlanje);
}
}
Console.ReadKey();
}
