//itt lép be a programba
private void ujAdatHozzaadasaAktivitasok(int refId, Esemeny esemeny)
{
int index = (ListOfAktivitas.Count == 0) ? 0 : ListOfAktivitas[ListOfAktivitas.Count - 1].ID + 1;
Aktivitas akt = new Aktivitas(
id: index,
felhasznaloId: (int)lbAktualUser.Tag,
refId: refId,
esemeny: esemeny,
datum: DateTime.Now);
ListOfAktivitas.Add(akt);
szinkronizalasAktivitasok();
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
string[] words = Aktivitas.Split('-');
bool x1 = true;
string nAktivitas = "";
foreach (string akt in words)
{
nAktivitas = akt.ToString();
}
Rpt.SubJudul(x
, "Tanggal Log : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai)
);
Rpt.SubJudul(x
, "Aktivitas : " + Aktivitas.Replace("-", ",")//Rpt.inSql(Aktivitas).Replace("'", "")
);
Rpt.SubJudul(x
, "User : "******"Security Level : " + SecLevel//seclevel.SelectedItem.Text
);
Rpt.SubJudul(x
, "IP Address : " + IP //ip.SelectedItem.Text
);
string legend = "";
//Rpt.Header(rpt, x);
Rpt.HeaderReport(headReport, legend, x);
}
private void Fill()
{
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
string UserID = "";
if (User != "SEMUA")
{
UserID = " AND UserID = '" + User + "'";
}
string nSecLevel = "";
if (SecLevel != "SEMUA")
{
nSecLevel = " AND SecLevel = '" + SecLevel + "'";
}
string nIP = "";
if (IP != "0" && IP != "SEMUA")
{
nIP = " AND IP = '" + IP + "'";
}
//change parameter
string akt = String.Empty;
akt = Aktivitas.Replace("-", ",").TrimEnd(',');
akt = akt.Replace(",", "','");
akt = "'" + akt + "'";
string strSql = "SELECT "
+ " LogID"
+ ",Tgl"
+ ",CASE Aktivitas "
+ " WHEN 'L' THEN 'Log-In Normal'"
+ " WHEN 'S' THEN 'Sign-Out Normal'"
+ " WHEN 'DL' THEN 'Double Login'"
+ " WHEN 'SP' THEN 'Salah Password'"
+ " WHEN 'B' THEN 'Blokir'"
+ " WHEN 'A' THEN 'Aktivasi'"
+ " WHEN 'GP' THEN 'Ganti Password'"
+ " END AS AktivitasDetil"
+ ",UserID"
+ ",Nama"
+ ",SecLevel"
+ ",IP"
+ " FROM SECURITY_LOG"
+ " WHERE 1=1 "
+ " AND CONVERT(varchar,Tgl,112) >= '" + Cf.Tgl112(Dari) + "'"
+ " AND CONVERT(varchar,Tgl,112) <= '" + Cf.Tgl112(Sampai) + "'"
+ " AND Aktivitas IN (" + akt + ")"//Rpt.inSql(Aktivitas.Replace("-",",")) + ")"
+ UserID
+ nSecLevel
+ nIP
+ " ORDER BY LogID";
DataTable rs = Db.Rs(strSql);
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
r.VerticalAlign = VerticalAlign.Top;
c = new TableCell();
c.Text = rs.Rows[i]["LogID"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["Tgl"]);
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Time(rs.Rows[i]["Tgl"]);
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["AktivitasDetil"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["UserID"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Nama"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["SecLevel"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["IP"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
rpt.Rows.Add(r);
}
}
