private void InitializeModule(bool init)
{
try
{
RBL_MODULE.Items.Clear();
string cond = " where groupid = '" + DDL_GROUPID.SelectedValue +
"' and moduleid in (" + MaintainedModuleIDs + ") ";
conn.ExecReader(Q_MODULEGROUP + cond, null, dbtimeout);
int i = 0;
while (conn.hasRow())
{
string moduleid = conn.GetFieldValue("moduleid").Trim();
string src = conn.GetFieldValue("usermntpage").Trim();
RBL_MODULE.Items.Add(new ListItem(conn.GetFieldValue("modulename"), moduleid));
if (i == 0 && src != "")
{
if (src.IndexOf("?") > 0)
{
src += "&";
}
else
{
src += "?";
}
src += "moduleid=" + moduleid + "&moddesc=" + RBL_MODULE.Items[0].Text + "&grpid=" + DDL_GROUPID.SelectedValue + "&uid=" + TXT_USERID.Text + "&spv=" + uREF_UPLINER.SelectedValue;
IFR_MODULE.Attributes.Remove("src");
IFR_MODULE.Attributes.Add("src", src);
RBL_MODULE.SelectedIndex = 0;
i++;
}
if (init)
{
try
{
using (DbConnection modconn = new DbConnection(MNTTools.GetConnString(moduleid)))
{
object[] pardata = new object[2] {
TXT_USERID.Text, moduleid
};
modconn.ExecuteNonQuery(SP_INITPENDINGMODULEUSER, pardata, dbtimeout);
}
}
catch (Exception ex1)
{
Response.Write("<!-- " + ex1.Message.Replace("-->", "--)") + " -->\n");
MNTTools.LogError(this, (string)Session["UserID"], ex1);
}
}
}
}
catch (Exception ex)
{
Response.Write("<!-- " + ex.Message.Replace("-->", "--)") + " -->\n");
MNTTools.LogError(this, (string)Session["UserID"], ex);
}
}
protected void BTN_SAVE_Click(object sender, EventArgs e)
{
try
{
UpdateMenuAccess();
ViewData();
MyPage.popMessage(this, "Group Menu Access Updated!");
}
catch (Exception ex)
{
Response.Write("<!-- " + ex.Message + " -->\n");
MNTTools.LogError(this, (string)Session["UserID"], ex);
MyPage.popMessage(this, "Update Failed...");
}
}
protected void BTN_SAVE_Click(object sender, EventArgs e)
{
try
{
UpdateMenuAccess();
ViewData("pending");
MyPage.popMessage(this, "Menu Access submitted! Awaiting approval..\nPlease click save again on group level...");
}
catch (Exception ex)
{
Response.Write("<!-- " + ex.Message + " -->\n");
MNTTools.LogError(this, (string)Session["UserID"], ex);
MyPage.popMessage(this, "Failed...");
}
}
private void DeletePendingUser(string userid)
{
try
{
object[] pardata = new object[2] {
userid, ""
};
conn.ExecuteNonQuery(SP_USP_DELETE_PENDING, pardata, dbtimeout);
}
catch (Exception ex)
{
Response.Write("<!-- " + ex.Message.Replace("-->", "--)") + " -->\n");
MNTTools.LogError(this, (string)Session["UserID"], ex);
}
}
private void SaveData()
{
try
{
for (int i = 0; i <= CBL_SEGMEN.Items.Count - 1; i++)
{
object[] p = new object[] { Request.QueryString["uid"], CBL_SEGMEN.Items[i].Value, CBL_SEGMEN.Items[i].Selected };
modconn.ExecuteNonQuery(SP_SAVEUSER, p, dbtimeout);
}
//MNTTools.InsertModuleUser(Request.QueryString["uid"], moduleid);
}
catch (Exception ex)
{
Response.Write("<!-- " + ex.Message.Replace("-->", "--)") + " -->\n");
MNTTools.LogError(this, (string)Session["UserID"], ex);
}
}
protected void BTN_SUBMIT_Click(object sender, EventArgs e)
{
conn = new DbConnection(Session["ConnStringLogin"].ToString());
try
{
bool result = ProcessPending();
if (result == true)
{
MyPage.popMessage(this, "Update Complete...");
}
else
{
MyPage.popMessage(this, "Update failed, Checker maker must be done by different ID ...");
}
}
catch (Exception ex)
{
Response.Write("<!-- " + ex.Message + " -->\n");
MNTTools.LogError(this, (string)Session["UserID"], ex);
MyPage.popMessage(this, "Update Failed...");
}
BindData();
conn.Dispose();
}
protected void DatGrd_ItemCommand(object source, DataGridCommandEventArgs e)
{
ClearEntries();
conn = new DbConnection(ConnString);
switch (e.CommandName)
{
case "edit":
BTN_NEW.Visible = false;
BTN_NEW_AD.Visible = false;
BTN_SAVE.Visible = true;
BTN_CANCEL.Visible = true;
LBL_SAVEMODE.Text = "0";
SetEnable(true);
TXT_USERID.ReadOnly = true;
object[] paruser = new object[1] {
e.Item.Cells[2].Text
};
conn.ExecReader(Q_USERDATA, paruser, dbtimeout);
if (conn.hasRow())
{
if (conn.GetFieldValue("SU_REVOKE") == "1")
{
cb_revoke.Checked = true;
cb_revoke.Text = "(clear to reset)";
}
else
{
cb_revoke.Checked = false;
}
if (conn.GetFieldValue("SU_LOGON") == "1")
{
cb_logon.Checked = true;
}
else
{
cb_logon.Checked = false;
}
if (conn.GetFieldValue("SU_ACTIVE") == "1")
{
CHK_SU_ACTIVE.Checked = true;
}
else
{
CHK_SU_ACTIVE.Checked = false;
}
TXT_USERID.Text = conn.GetFieldValue("USERID");
TXT_SU_FULLNAME.Text = conn.GetFieldValue("SU_FULLNAME");
TXT_SU_HPNUM.Text = conn.GetFieldValue("SU_HPNUM");
TXT_SU_EMAIL.Text = conn.GetFieldValue("SU_EMAIL");
uREF_BRANCHID.SelectedValue = conn.GetFieldValue("BRANCHID");
uREF_AREAID.SelectedValue = conn.GetFieldValue("AREAID");
ddl_JenisUser.SelectedValue = conn.GetFieldValue("JenisUser");
if (conn.GetFieldValue("JenisUser") == "1")
{
//userAD tidak bisa reset password
SetADMode(true);
btn_cekAD.Visible = false;
}
else
{
SetADMode(false);
}
try
{
DDL_GROUPID.SelectedValue = conn.GetFieldValue("GROUPID");
string spv = conn.GetFieldValue("SU_UPLINER");
string spv2 = conn.GetFieldValue("SU_UPLINER2");
string spv3 = conn.GetFieldValue("SU_UPLINER3");
string spv4 = conn.GetFieldValue("SU_UPLINER4");
string spv5 = conn.GetFieldValue("SU_UPLINER5");
FillUpliner(DDL_GROUPID.SelectedValue, uREF_BRANCHID.SelectedValue);
try { uREF_UPLINER.SelectedValue = spv; } catch { }
try { uREF_UPLINER2.SelectedValue = spv2; } catch { }
try { uREF_UPLINER3.SelectedValue = spv3; } catch { }
try { uREF_UPLINER4.SelectedValue = spv4; } catch { }
try { uREF_UPLINER5.SelectedValue = spv5; } catch { }
InitializeModule(true);
}
catch (Exception ex)
{
MyPage.popMessage(this, "Error initializing group/module screen");
Response.Write("<!-- " + ex.Message.Replace("-->", "--)") + " -->\n");
MNTTools.LogError(this, (string)Session["UserID"], ex);
}
}
pwdmsg.Value = "Leave password blank to use old password!";
MyPage.SetFocus(this, BTN_CANCEL);
break;
case "delete":
object[] pardel = new object[5] {
e.Item.Cells[2].Text, e.Item.Cells[4].Text,
"1", e.Item.Cells[3].Text, Session["USerID"]
};
try
{
conn.ExecuteNonQuery(SP_DELETE, pardel, dbtimeout);
LBL_RESULT.Text = "Request Submitted! Awaiting Approval ... ";
LBL_RESULT.ForeColor = System.Drawing.Color.Green;
}
catch (Exception ex)
{
if (ex.Message.IndexOf("Last Query:") > 0)
{
LBL_RESULT.Text = ex.Message.Substring(0, ex.Message.IndexOf("Last Query:"));
}
else
{
LBL_RESULT.Text = ex.Message;
}
LBL_RESULT.ForeColor = System.Drawing.Color.Red;
}
break;
case "undelete":
object[] parundel = new object[5] {
e.Item.Cells[2].Text, e.Item.Cells[4].Text,
"1", e.Item.Cells[3].Text, Session["UserID"]
};
try
{
conn.ExecuteNonQuery(SP_UNDELETE, parundel, dbtimeout);
LBL_RESULT.Text = "Request Submitted! Awaiting Approval ... ";
LBL_RESULT.ForeColor = System.Drawing.Color.Green;
}
catch (Exception ex)
{
if (ex.Message.IndexOf("Last Query:") > 0)
{
LBL_RESULT.Text = ex.Message.Substring(0, ex.Message.IndexOf("Last Query:"));
}
else
{
LBL_RESULT.Text = ex.Message;
}
LBL_RESULT.ForeColor = System.Drawing.Color.Red;
}
break;
}
BindData();
conn.Dispose();
}