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..."; }