private void BindData()
{
DatGrd.DataSource = conn.GetDataTable(Q_GROUP + " " + SQLCondition(), null, dbtimeout);
try
{
DatGrd.DataBind();
}
catch
{
DatGrd.CurrentPageIndex = 0;
DatGrd.DataBind();
}
LinkButton lnk;
for (int i = 0; i < DatGrd.Items.Count; i++)
{
if (DatGrd.Items[i].Cells[6].Text == "0") //sg_active -- group deleted
{
lnk = (LinkButton)DatGrd.Items[i].Cells[7].FindControl("lnk_menu");
lnk.Visible = false;
lnk = (LinkButton)DatGrd.Items[i].Cells[7].FindControl("lnk_delete");
lnk.Visible = false;
lnk = (LinkButton)DatGrd.Items[i].Cells[7].FindControl("lnk_edit");
lnk.Visible = false;
DatGrd.Items[i].Cells[0].ForeColor = Color.Gray;
DatGrd.Items[i].Cells[1].ForeColor = Color.Gray;
DatGrd.Items[i].Cells[2].ForeColor = Color.Gray;
DatGrd.Items[i].Cells[3].ForeColor = Color.Gray;
DatGrd.Items[i].Cells[4].ForeColor = Color.Gray;
DatGrd.Items[i].Cells[5].ForeColor = Color.Gray;
}
}
}
private void BindData()
{
DatGrd.DataSource = conn.GetDataTable(Q_MODULEUSER + " " + SQLCondition(), null, dbtimeout);
try
{
DatGrd.DataBind();
}
catch
{
DatGrd.CurrentPageIndex = 0;
DatGrd.DataBind();
}
LinkButton lnk;
for (int i = 0; i < DatGrd.Items.Count; i++)
{
if (DatGrd.Items[i].Cells[10].Text == "0") //su_active -- user deleted
{
lnk = (LinkButton)DatGrd.Items[i].Cells[11].FindControl("lnkDelete");
lnk.Visible = false;
lnk = (LinkButton)DatGrd.Items[i].Cells[11].FindControl("lnkEdit");
lnk.Visible = false;
DatGrd.Items[i].Cells[2].ForeColor = Color.Gray; //userid
DatGrd.Items[i].Cells[3].ForeColor = Color.Gray; //fullname
}
else if (DatGrd.Items[i].Cells[12].Text == "1")
{
lnk = (LinkButton)DatGrd.Items[i].Cells[11].FindControl("lnkEdit");
lnk.Visible = false;
lnk = (LinkButton)DatGrd.Items[i].Cells[11].FindControl("lnkDelete");
lnk.Visible = false;
lnk = (LinkButton)DatGrd.Items[i].Cells[11].FindControl("lnkUndelete");
lnk.Visible = false;
DatGrd.Items[i].Cells[11].Text = "Waiting Approval!";
}
else
{
lnk = (LinkButton)DatGrd.Items[i].Cells[11].FindControl("lnkUndelete");
lnk.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
dbtimeout = int.Parse(ConfigurationSettings.AppSettings["dbTimeOut"]);
ConnString = Session["ConnStringLogin"].ToString();
if (!IsPostBack)
{
string user = (string)Session["UserID"];
conn = new DbConnection(ConnString);
uREF_BRANCH.fillRefList(Q_RFBRANCH, true);
uREF_BRANCHID.fillRefList(Q_RFBRANCH, true);
uREF_AREAID.fillRefList(Q_RFAREA, true);
MyPage.fillRefList(DDL_RFMODULE, Q_RFMODULE + " and moduleid in (" + MaintainedModuleIDs + ")", null, dbtimeout, false, conn);
ArrayList arrddl = new ArrayList();
arrddl.Add(DDL_RFGROUP);
arrddl.Add(DDL_GROUPID);
string cond = " where moduleid in (" + MaintainedModuleIDs + ") ";
MyPage.fillRefList(arrddl, Q_MODULEGROUPDDL + cond, null, dbtimeout, false, conn);
orderby = "";
ViewState["orderby"] = orderby;
// dummy query to show the grid
DatGrd.DataSource = conn.GetDataTable(Q_MODULEUSER + " WHERE 1 = 2 ", null, dbtimeout);
try
{
DatGrd.DataBind();
}
catch { }
ClearEntries();
conn.Dispose();
}
else
{
orderby = (string)ViewState["orderby"];
}
BTN_SAVE.Attributes.Add("onclick", "if(!cek_mandatory(document.form1)){return false;} else {simpan();};");
//BTN_SAVE.Attributes.Add("onclick", "simpan();");
}
