private void KonvertoSinkronizoNeWebKerkesa()
{
string[] fusha = new string[4];
string[] llojet = new string[4];
fusha[0] = "ID_KERKESA";
fusha[1] = "DATA_KERKESA";
fusha[2] = "SASIA";
fusha[3] = "ALG";
llojet[0] = "char(255)";
llojet[1] = "char(255)";
llojet[2] = "char(255)";
llojet[3] = "char(255)";
KlaseExcel excel = new KlaseExcel("KERKESA.xls", fusha, llojet);
DataSet dsKerkesa = conObject.ExecuteQuery("SELECT * FROM KERKESA WHERE YEAR(DATA_KERKESA) = YEAR(GETDATE())");
excel.ShkruajTabele("KERKESA.xls", fusha, llojet, dsKerkesa);
}
private void KonvertoSinkronizoNeWebBlerje()
{
string[] fusha = new string[4];
string[] llojet = new string[4];
fusha[0] = "ID_BLERJE";
fusha[1] = "DATA_BLERJE";
fusha[2] = "SASIA";
fusha[3] = "KONSUMUAR";
llojet[0] = "char(255)";
llojet[1] = "char(255)";
llojet[2] = "char(255)";
llojet[3] = "char(255)";
KlaseExcel excel = new KlaseExcel("BLERJE.xls", fusha, llojet);
DataSet dsKerkesa = conObject.ExecuteQuery("SELECT * FROM BLERJE WHERE YEAR(DATA_BLERJE) = YEAR(GETDATE())");
excel.ShkruajTabele("BLERJE.xls", fusha, llojet, dsKerkesa);
}
private void KonvertoSinkronizoNeWebDergesa()
{
string[] fusha = new string[5];
string[] llojet = new string[5];
fusha[0] = "ID_DERGESA";
fusha[1] = "DATA_DERGESA";
fusha[2] = "DERGUAR";
fusha[3] = "PADERGUAR";
fusha[4] = "PROGRAMI";
llojet[0] = "char(255)";
llojet[1] = "char(255)";
llojet[2] = "char(255)";
llojet[3] = "char(255)";
llojet[4] = "char(255)";
KlaseExcel excel = new KlaseExcel("DERGESA.xls", fusha, llojet);
DataSet dsDergesa = conObject.ExecuteQuery("SELECT * FROM DERGESA WHERE YEAR(DATA_DERGESA) = YEAR(GETDATE())");
excel.ShkruajTabele("DERGESA.xls", fusha, llojet, dsDergesa);
}