private void Bind()
{
string addq = "";
//if (Request.QueryString["SL"] != null)
// addq = " AND SecLevel = '" + Request.QueryString["SL"] + "'";
string strSql = "SELECT "
+ " UserID"
+ ",Nama"
+ " FROM USERNAME"
+ " WHERE Status = 'A'"
+ addq
+ " ORDER BY Nama, UserID";
rs = Db.Rs(strSql);
Rpt.NoData(list, rs, "No username with ACTIVE status.");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
Label l;
CheckBox ch;
l = new Label();
l.Text = "<tr valign='top'>"
+ "<td style='border-bottom:1px dashed silver'>"
+ rs.Rows[i]["UserID"]
+ "</td>"
+ "<td style='border-bottom:1px dashed silver'>"
+ "<a href=\"javascript:popEditUser('" + rs.Rows[i]["UserID"] + "')\">"
+ rs.Rows[i]["Nama"]
+ "</a></td>";
list.Controls.Add(l);
for (int j = 2; j <= head.Cells.Count - 1; j++)
{
l = new Label();
l.Text = "<td style='border-bottom:1px dashed silver'>";
list.Controls.Add(l);
string s = head.Cells[j].ID;
ch = new CheckBox();
ch.ID = s + i;
ch.ToolTip = ch.ID;
if (Act.AksesPers(Act.NamaPT(s), rs.Rows[i]["UserID"].ToString())) // hanya menampilkan project yg sudah di matrikulasi pt nya untuk user tsb
{
list.Controls.Add(ch);
}
l = new Label();
l.Text = "</td>";
list.Controls.Add(l);
}
l = new Label();
l.Text = "</tr>";
list.Controls.Add(l);
}
}
protected void save_Click(object sender, System.EventArgs e)
{
Db.Execute("DELETE FROM PROJECTSEC");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
string UserID = rs.Rows[i]["UserID"].ToString();
for (int j = 2; j <= head.Cells.Count - 1; j++)
{
string Project = head.Cells[j].ID;
if (Act.AksesPers(Act.NamaPT(Project), rs.Rows[i]["UserID"].ToString()))
{
string Granted = "0";
string NamaProject = head.Cells[j].InnerHtml;
CheckBox r = (CheckBox)list.FindControl(Project + i);
if (r.Checked)
{
Granted = "1";
}
Db.Execute("EXEC spUserProject"
+ " '" + Project + "'"
+ ",'" + UserID + "'"
+ ",'" + Granted + "'"
+ ",'" + NamaProject + "'"
);
}
}
//DataTable rsDetail = Db.Rs("SELECT "
// + " UserID AS [Kode / Username]"
// + ",Nama AS [Nama Lengkap]"
// + " FROM USERNAME WHERE UserID = '" + UserID + "'");
//DataTable rsBef = Db.Rs("SELECT "
// + " SecLevel AS [Security Level]"
// + " FROM USERNAME WHERE UserID = '" + UserID + "'");
//DataTable rsAft = Db.Rs("SELECT "
// + " SecLevel AS [Security Level]"
// + " FROM USERNAME WHERE UserID = '" + UserID + "'");
//if (seclevel != rs.Rows[i]["SecLevel"].ToString())
//{
// string Ket = Cf.LogCapture(rsDetail)
// + Cf.LogCompare(rsBef, rsAft);
// Db.Execute("EXEC spLogUsername "
// + " 'MKA'"
// + ",'" + Act.UserID + "'"
// + ",'" + Act.IP + "'"
// + ",'" + Ket + "'"
// + ",'" + UserID + "'"
// );
//}
}
feed.Text = "<img src='/Media/db.gif' align=absmiddle> Berhasil...";
}