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);
}
/// <summary>
/// kthen nje dataset me notat e nxenesve per klasat e zgjedhura
/// ne varesi te kritereve te kerkimit
/// </summary>
/// <returns></returns>
private DataSet KerkoNotat()
{
string strKushti = " AND NT_VITI_SHKOLLOR = '" + vitiShkollor + "' AND NT_RIPROVIM = 0 ";
int semestri = semestriAktual();
if (rbNotaMomentale.Checked)
{
string fillRev, mbarRev;
fillRev = dtpFillimi.Value.ToString("yyyy/MM/dd");
mbarRev = dtpMbarimi.Value.ToString("yyyy/MM/dd");
strKushti += " AND NT_MOMENTALES" + semestri + " = 1 AND NT_SEMESTRI1= 0 AND" +
" NT_SEMESTRI2 = 0 AND NT_VJETORE = 0 AND NT_DATA BETWEEN '" + fillRev + "' AND '" + mbarRev + "' AND NT_MUNGESE_ME = 0 AND NT_MUNGESE_PA = 0 ";
}
else if (rbMungesa.Checked)
{
DateTime dtSot = DateTime.Now;
string sotRev = dtSot.ToString("yyyy/MM/dd");
strKushti += " AND lower(NT_VLERESIMI) = 'm' AND NT_MOMENTALES" + semestri + " = 1 AND NT_DATA = '" + sotRev + "' ";
}
else if (rbSemestri1.Checked)
{
strKushti += " AND NT_SEMESTRI1 = 1 AND NT_MUNGESE_ME = 0 AND NT_MUNGESE_PA = 0 ";
}
else if (rbSemestri2.Checked)
{
strKushti += " AND NT_SEMESTRI2 = 1 AND NT_MUNGESE_ME = 0 AND NT_MUNGESE_PA = 0 ";
}
else if (rbVjetore.Checked)
{
strKushti += " AND NT_VJETORE = 1 AND NT_MUNGESE_ME = 0 AND NT_MUNGESE_PA = 0 ";
}
string strKushtiKlasat = " AND (";
int count = 0;
foreach (Control c in panelExKlasat.Controls)
{
CheckBox cb = c as CheckBox;
if (cb.Checked)
{
if (cb.Name == "cbAll")
{
break;
}
else
{
count++;
if (count == 1)
{
strKushtiKlasat += "NT_KLASA = " + cb.Tag;
}
else
{
strKushtiKlasat += " OR NT_KLASA = " + cb.Tag;
}
}
}
}
strKushtiKlasat += ")";
if (count > 0)
{
strKushti = strKushti + strKushtiKlasat + " ORDER BY CONVERT(INT, NT_KLASA), " +
"NT_INDEKSI, NT_NR_AMZA, NT_CIKLI, NT_EMRI_LENDA, NT_DATA";
}
string strSql = "SELECT TBL_NOTA.*, AMZA_EMRI, AMZA_MBIEMRI FROM TBL_NOTA, TBL_AMZA WHERE NT_NR_AMZA = AMZA_NR_AMZA AND NT_CIKLI = AMZA_CIKLI " +
strKushti;
return(conObject.ExecuteQuery(strSql));
}