protected void RBL_MODULE_SelectedIndexChanged(object sender, System.EventArgs e)
{
using (conn = new DbConnection(ConnString))
{
//InsertModuleUser(TXT_USERID.Text,RBL_MODULE.SelectedValue);
string cond = " where groupid = '" + DDL_GROUPID.SelectedValue +
"' and moduleid = '" + RBL_MODULE.SelectedValue + "' ";
conn.ExecReader(Q_MODULEGROUP + cond, null, dbtimeout);
IFR_MODULE.Attributes.Remove("src");
if (conn.hasRow() && conn.GetFieldValue("usermntpage").Trim() != "")
{
string src = conn.GetFieldValue("usermntpage");
if (src.IndexOf("?") > 0)
{
src += "&";
}
else
{
src += "?";
}
src += "moduleid=" + RBL_MODULE.SelectedValue + "&moddesc=" + RBL_MODULE.SelectedItem.Text + "&grpid=" + DDL_GROUPID.SelectedValue + "&uid=" + TXT_USERID.Text + "&spv=" + uREF_UPLINER.SelectedValue;
IFR_MODULE.Attributes.Add("src", src);
}
}
MyPage.SetFocus(this, BTN_SAVE);
}
private void Clear()
{
TXT_OLD.Text = "";
TXT_NEW.Text = "";
TXT_VERIFY.Text = "";
MyPage.SetFocus(this, TXT_OLD);
}
protected void RBL_MODULE_SelectedIndexChanged(object sender, EventArgs e)
{
using (conn = new DbConnection(Session["ConnStringLogin"].ToString()))
{
//InsertModuleUser(TXT_USERID.Text,RBL_MODULE.SelectedValue);
object[] par = new object[] { RBL_MODULE.SelectedValue };
conn.ExecReader(Q_MODULE, par, dbtimeout);
IFR_MODULE.Attributes.Remove("src");
if (conn.hasRow() && conn.GetFieldValue("grpmntpage").Trim() != "")
{
string src = conn.GetFieldValue("grpmntpage");
if (src.IndexOf("?") > 0)
{
src += "&";
}
else
{
src += "?";
}
src += "moduleid=" + RBL_MODULE.SelectedValue + "&moddesc=" + RBL_MODULE.SelectedItem.Text + "&gid=" + TXT_GROUPID.Text;
IFR_MODULE.Attributes.Add("src", src);
}
}
MyPage.SetFocus(this, BTN_SAVE);
}
protected void BTN_NEW_Click(object sender, EventArgs e)
{
BTN_SAVE.Visible = true;
BTN_CANCEL.Visible = true;
BTN_NEW.Visible = false;
EnableFields(true);
LBL_SAVEMODE.Text = "1";
MyPage.SetFocus(this, TXT_GROUPID);
}
private void LogonMessage(Login1.loginResult ret)
{
this.Label1.Text = Login1.getLogonMsg(ret, this.TXT_USERNAME.Text);
if (ret == Login1.loginResult.logPwdInvalid || ret == Login1.loginResult.logPwdEmpty || ret == Login1.loginResult.logJustLocked)
{
MyPage.SetFocus(this, this.TXT_PASSWORD);
}
else
{
MyPage.SetFocus(this, this.TXT_USERNAME);
}
}
private void LogonMessage(loginResult ret)
{
lblMessage.Text = getLogonMsg(ret);
if (ret == loginResult.logPwdInvalid || ret == loginResult.logPwdEmpty || ret == loginResult.logJustLocked)
{
MyPage.SetFocus(this, TXT_PASSWORD);
}
else
{
MyPage.SetFocus(this, TXT_USERNAME);
}
}
private void Clear()
{
TXT_OLD.Text = "";
TXT_NEW.Text = "";
TXT_VERIFY.Text = "";
if (TXT_OLD.Enabled)
{
MyPage.SetFocus(this, TXT_OLD);
}
else
{
MyPage.SetFocus(this, TXT_NEW);
}
}
private void Clear()
{
this.TXT_BARU.Text = "";
this.TXT_BARUVER.Text = "";
this.TXT_LAMA.Text = "";
if (this.TXT_LAMA.Enabled)
{
MyPage.SetFocus(this, TXT_LAMA);
}
else
{
MyPage.SetFocus(this, TXT_BARU);
}
}
protected void BTN_NEW_AD_Click(object sender, System.EventArgs e)
{
BTN_NEW.Visible = false;
BTN_NEW_AD.Visible = false;
BTN_SAVE.Visible = true;
BTN_CANCEL.Visible = true;
CHK_SU_ACTIVE.Checked = true;
SetEnable(true);
SetADMode(true);
TXT_USERID.ReadOnly = false;
using (conn = new DbConnection(ConnString))
{
FillUpliner(DDL_GROUPID.SelectedValue, uREF_BRANCHID.SelectedValue);
}
pwdmsg.Value = "Leave password blank to use default password!";
MyPage.SetFocus(this, BTN_CANCEL);
}
protected void CHK_MODULEID_SelectedIndexChanged(object sender, EventArgs e)
{
using (conn = new DbConnection(Session["ConnStringLogin"].ToString()))
{
string cond = " and moduleid in (''";
for (int i = 0; i < CHK_MODULEID.Items.Count; i++)
{
if (CHK_MODULEID.Items[i].Selected)
{
cond += ", '" + CHK_MODULEID.Items[i].Value + "'";
}
}
cond += ")";
MyPage.fillRefList(RBL_MODULE.Items, Q_RFMODULE + cond, conn);
RBL_MODULE.Items.RemoveAt(0);
try { RBL_MODULE.SelectedIndex = 0; RBL_MODULE_SelectedIndexChanged(null, null); }
catch { }
}
MyPage.SetFocus(this, BTN_SAVE);
}
protected void DDL_GROUPID_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (TXT_USERID.Text.Trim() == "")
{
MyPage.popMessage(this, "Please enter UserID First.");
DDL_GROUPID.SelectedIndex = 0;
return;
}
using (conn = new DbConnection(ConnString))
{
if (LBL_SAVEMODE.Text == "1") //insert new user
{
object[] par = new object[1] {
TXT_USERID.Text
};
conn.ExecReader(Q_CEKUSER, par, dbtimeout);
if (conn.hasRow())
{
if (conn.GetFieldValue(0) == "1")
{
MyPage.popMessage(this, "UserID exists in existing system.");
DDL_GROUPID.SelectedIndex = 0;
return;
}
else if (conn.GetFieldValue(1) == "2")
{
MyPage.popMessage(this, "UserID is in the pending list.");
DDL_GROUPID.SelectedIndex = 0;
return;
}
}
}
TXT_USERID.ReadOnly = true;
TXT_SU_FULLNAME.Text = hdn_nama.Value;
TXT_SU_EMAIL.Text = hdn_email.Value;
InitializeModule();
FillUpliner(DDL_GROUPID.SelectedValue, uREF_BRANCHID.SelectedValue);
MyPage.SetFocus(this, BTN_CANCEL);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (qryIdTx != "")
{
tdcode.InnerText = qryIdTx;
}
if (qryDeTx != "")
{
tddesc.InnerText = qryDeTx;
}
if (!IsPostBack)
{
if (qryInitVal != "")
{
TXT_CODE.Text = qryInitVal;
BTN_SEARCH_Click(null, null);
}
MyPage.SetFocus(this, TXT_DESC);
}
string args = "'" + qryCtrlId + "', '" + qryCtrlDesc + "'";
ok.Attributes.Add("onclick", "pilih(" + args + ");");
if (qryPreEndCallback != "")
{
args += ", opener." + qryPreEndCallback + "(document.form1.LST_RESULT.value)";
}
LST_RESULT.Attributes.Add("ondblclick", "pilih(" + args + ");");
if (qryPostEndCallback != "")
{
Response.Write(
"<script for=window event=onunload language='JavaScript'>" +
" if (picked) " +
" opener." + qryPostEndCallback +
"</script>");
}
}
protected void save_data()
{
try
{
if (base.Request.QueryString["ID"].ToString().Equals(""))
{
System.Data.DataTable dt = this.conn.GetDataTable("select * FROM [MRSDATA].[dbo].[LOGINPARAM]", null, this.dbtimeout, true, true);
if (dt.Rows.Count > 0)
{
PWDEXPDAY = int.Parse(dt.Rows[0]["PWDEXPDAY"].ToString());
}
object[] param = new object[]
{
NIK.Value.ToString().ToUpper()
};
System.Data.DataTable dataTableSms = this.conn.GetDataTable(Q_USER, param, this.dbtimeout, true, true);
if (dataTableSms.Rows.Count > 0)
{
if (dataTableSms.Rows[0]["USERID"].ToString().ToUpper().Equals(NIK.Value.ToString().ToUpper()))
{
var page1 = HttpContext.Current.CurrentHandler as Page;
ScriptManager.RegisterStartupScript(page1, page1.GetType(), "alert", "alert('User id atau NIK : " + NIK.Value.ToString() + " sudah terdaftar');", true);
MyPage.SetFocus(this, this.NIK);
}
else
{
hash_password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile("bankmantap1", "sha1");
NameValueCollection nameValueCollectionKey = new NameValueCollection();
NameValueCollection nameValueCollection = new NameValueCollection();
StaticFramework.SaveNvc(nameValueCollectionKey, "USERID", NIK);
StaticFramework.SaveNvc(nameValueCollection, "GROUPID", GROUP);
StaticFramework.SaveNvc(nameValueCollection, "SU_FULLNAME", FULLNAME);
StaticFramework.SaveNvc(nameValueCollection, "SU_EMAIL", email);
StaticFramework.SaveNvc(nameValueCollection, "SU_EMAIL_2", email2);
StaticFramework.SaveNvc(nameValueCollection, "SU_REGISTERBY", Session["UserID"].ToString());
StaticFramework.SaveNvc(nameValueCollection, "SU_HPNUM", NOUSER.Value.Replace("-", "").Replace(" ", ""));
StaticFramework.SaveNvc(nameValueCollection, "SU_PWD", hash_password);
StaticFramework.SaveNvc(nameValueCollection, "SU_REGISTERDATE", DateTime.Now);
StaticFramework.SaveNvc(nameValueCollection, "SU_PWDEXPDATE", DateTime.Now.AddDays(PWDEXPDAY));
StaticFramework.SaveNvc(nameValueCollection, "SU_ACTIVE", "1");
StaticFramework.SaveNvc(nameValueCollection, "UNIT", UNIT);
if (GROUP.SelectedValue.Equals("003HEAD"))
{
//StaticFramework.SaveNvc(nameValueCollection, "SU_EMAIL_KADIV", emailDivisi);
//StaticFramework.SaveNvc(nameValueCollection, "SU_EMAIL_DEPHEAD", emailDevHead);
StaticFramework.SaveNvc(nameValueCollection, "SU_UPLINER", SU_UPLINER);
//StaticFramework.SaveNvc(nameValueCollection, "SU_HPNUM_DEPHEAD", NODEVHEAD.Value.Replace("-", "").Replace(" ", ""));
//StaticFramework.SaveNvc(nameValueCollection, "SU_HPNUM_KADIV", NOKADIV.Value.Replace("-", ""));
}
else if (GROUP.SelectedValue.Equals("002PEN"))
{
StaticFramework.SaveNvc(nameValueCollection, "USER_DELEGATE", PIC2);
StaticFramework.SaveNvc(nameValueCollection, "SU_UPLINER", SU_UPLINER);
}
else if (GROUP.SelectedValue.Equals("004KADIV"))
{
StaticFramework.SaveNvc(nameValueCollection, "SU_EMAIL_DIREKTUR", emailDirektur);
StaticFramework.SaveNvc(nameValueCollection, "SU_HPNUM_DIREKTUR", NODIREKTUR.Value.Replace("-", "").Replace(" ", ""));
}
StaticFramework.Save(nameValueCollection, nameValueCollectionKey, "SCALLUSER", this.conn);
var page = HttpContext.Current.CurrentHandler as Page;
ScriptManager.RegisterStartupScript(page, page.GetType(), "alert", "alert('Save Data Success');", true);
NameValueCollection nameValueCollectionKeyflag = new NameValueCollection();
NameValueCollection nameValueCollectionflag = new NameValueCollection();
StaticFramework.SaveNvc(nameValueCollectionKeyflag, "USERID", NIK);
StaticFramework.SaveNvc(nameValueCollectionflag, "SU_LOGON", "0");
StaticFramework.SaveNvc(nameValueCollectionflag, "SU_REVOKE", "0");
StaticFramework.SaveNvc(nameValueCollectionflag, "SU_FALSEPWDCOUNT", "0");
StaticFramework.Save(nameValueCollectionflag, nameValueCollectionKeyflag, "scalluserflag", this.conn);
clear();
}
}
else
{
hash_password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile("bankmantap1", "sha1");
NameValueCollection nameValueCollectionKey = new NameValueCollection();
NameValueCollection nameValueCollection = new NameValueCollection();
StaticFramework.SaveNvc(nameValueCollectionKey, "USERID", NIK);
StaticFramework.SaveNvc(nameValueCollection, "GROUPID", GROUP);
StaticFramework.SaveNvc(nameValueCollection, "SU_FULLNAME", FULLNAME);
StaticFramework.SaveNvc(nameValueCollection, "SU_EMAIL", email);
StaticFramework.SaveNvc(nameValueCollection, "SU_EMAIL_2", email2);
StaticFramework.SaveNvc(nameValueCollection, "SU_REGISTERBY", Session["UserID"].ToString());
StaticFramework.SaveNvc(nameValueCollection, "SU_HPNUM", NOUSER.Value.Replace("-", "").Replace(" ", ""));
StaticFramework.SaveNvc(nameValueCollection, "SU_PWD", hash_password);
StaticFramework.SaveNvc(nameValueCollection, "SU_REGISTERDATE", DateTime.Now);
StaticFramework.SaveNvc(nameValueCollection, "SU_PWDEXPDATE", DateTime.Now.AddDays(PWDEXPDAY));
StaticFramework.SaveNvc(nameValueCollection, "SU_ACTIVE", "1");
StaticFramework.SaveNvc(nameValueCollection, "UNIT", UNIT);
if (GROUP.SelectedValue.Equals("003HEAD"))
{
//StaticFramework.SaveNvc(nameValueCollection, "SU_EMAIL_KADIV", emailDivisi);
//StaticFramework.SaveNvc(nameValueCollection, "SU_EMAIL_DEPHEAD", emailDevHead);
StaticFramework.SaveNvc(nameValueCollection, "SU_UPLINER", SU_UPLINER);
//StaticFramework.SaveNvc(nameValueCollection, "SU_HPNUM_DEPHEAD", NODEVHEAD.Value.Replace("-", "").Replace(" ", ""));
//StaticFramework.SaveNvc(nameValueCollection, "SU_HPNUM_KADIV", NOKADIV.Value.Replace("-", ""));
}
else if (GROUP.SelectedValue.Equals("002PEN"))
{
StaticFramework.SaveNvc(nameValueCollection, "USER_DELEGATE", PIC2);
StaticFramework.SaveNvc(nameValueCollection, "SU_UPLINER", SU_UPLINER);
}
else if (GROUP.SelectedValue.Equals("004KADIV"))
{
StaticFramework.SaveNvc(nameValueCollection, "SU_EMAIL_DIREKTUR", emailDirektur);
StaticFramework.SaveNvc(nameValueCollection, "SU_HPNUM_DIREKTUR", NODIREKTUR.Value.Replace("-", "").Replace(" ", ""));
}
StaticFramework.Save(nameValueCollection, nameValueCollectionKey, "SCALLUSER", this.conn);
var page = HttpContext.Current.CurrentHandler as Page;
ScriptManager.RegisterStartupScript(page, page.GetType(), "alert", "alert('Save Data Success');", true);
NameValueCollection nameValueCollectionKeyflag = new NameValueCollection();
NameValueCollection nameValueCollectionflag = new NameValueCollection();
StaticFramework.SaveNvc(nameValueCollectionKeyflag, "USERID", NIK);
StaticFramework.SaveNvc(nameValueCollectionflag, "SU_LOGON", "0");
StaticFramework.SaveNvc(nameValueCollectionflag, "SU_REVOKE", "0");
StaticFramework.SaveNvc(nameValueCollectionflag, "SU_FALSEPWDCOUNT", "0");
StaticFramework.Save(nameValueCollectionflag, nameValueCollectionKeyflag, "scalluserflag", this.conn);
clear();
}
}
}
catch (Exception e)
{
var page = HttpContext.Current.CurrentHandler as Page;
ScriptManager.RegisterStartupScript(page, page.GetType(), "alert", "alert('error save');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//dbtimeout = int.Parse(ConfigurationSettings.AppSettings["dbTimeOut"]);//1200;//
if (!IsPostBack)
{
FormsAuthentication.SignOut();
TXT_USERNAME.Text = (string)Session["UserID"];
hash_password = (string)Session["sha1"];
RemoveSession();
if (Request.QueryString.Count != 0 && Request.QueryString[0] == "logon")
{
if (hash_password != null)
{
logon = true;
BTN_SUBMIT_Click(null, null);
return;
}
}
if ((TXT_USERNAME.Text == null) || (TXT_USERNAME.Text == ""))
{
MyPage.SetFocus(this, TXT_USERNAME);
}
else
{
MyPage.SetFocus(this, TXT_PASSWORD);
}
}
if (Request.QueryString.Count > 0)
{
if (!String.IsNullOrEmpty(Request.QueryString["callback"]))
{
callback.Value = Request.QueryString["callback"];
}
if (Request.QueryString["msg"] != null && Request.QueryString["msg"] != "")
{
MyPage.popMessage(this, Request.QueryString["msg"]);
}
else if (Request.QueryString["menu"] == "0")
{
LogonMessage(loginResult.logNoMenuAccess);
}
else if (Request.QueryString[0] == "logon")
{
LogonMessage(loginResult.logReLogin);
}
else if (Request.QueryString[0] == "lost")
{
LogonMessage(loginResult.logSessionLost);
}
else if (Request.QueryString[0] == "new")
{
LogonMessage(loginResult.logNewLogin);
}
else if (Request.QueryString["tkn"] != null && Request.QueryString["tkn"] != "")
{
using (DbConnection conn = new DbConnection(getConnString()))
{
try
{
object[] token = new object[1] {
new Guid(Request.QueryString["tkn"])
};
conn.ExecuteNonQuery(SP_TOKENDELETE, token, dbtimeout);
LogonMessage(loginResult.logAuthFail);
}
catch (Exception ex)
{
Response.Write("<!-- ex msg: " + ex.Message.Replace("-->", "--)") + " -->\n");
LogonMessage(loginResult.logAuthFail);
}
}
}
else
{
LogonMessage(loginResult.logSessionLost);
}
}
//BTN_SUBMIT.Attributes.Add("onclick","return proceeding();");
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
MyPage.SetFocus(this, this.TXT_USERNAME);
}
protected void signin_Click(object sender, EventArgs e)
{
if (TXT_USERNAME.Text.ToString().Equals(""))
{
Response.Write("<script>alert('User Id Tidak Boleh Kosong')</script>");
MyPage.SetFocus(this, this.TXT_USERNAME);
return;
}
else if (TXT_PASSWORD.Text.ToString().Equals(""))
{
Response.Write("<script>alert('Password Tidak Boleh Kosong')</script>");
MyPage.SetFocus(this, this.TXT_PASSWORD);
return;
}
string nexturl = "";
if (!this.logon)
{
this.hash_password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(TXT_PASSWORD.Text, "sha1");
}
this.connectionString = Login1.decryptConnStr(ConfigurationSettings.AppSettings["MRSDATALOGIN"]);
using (DbConnection conn = new DbConnection(this.connectionString))
{
try
{
Login1.loginResult flag = Login1.ValidateLogin(this.TXT_USERNAME.Text, this.TXT_PASSWORD.Text, conn, this.dbtimeout, this.logon, base.Request.UserHostAddress);
Login1.loginResult loginResult = flag;
if (loginResult != Login1.loginResult.logSuccess)
{
if (loginResult != Login1.loginResult.logPwdExpired)
{
if (loginResult != Login1.loginResult.logPwdDefault)
{
this.LogonMessage(flag);
}
else
{
System.Web.Security.FormsAuthentication.SetAuthCookie(this.TXT_USERNAME.Text, false);
this.Session.Add("UserID", this.TXT_USERNAME.Text);
nexturl = "Change_Password.aspx?initial";
}
}
else
{
System.Web.Security.FormsAuthentication.SetAuthCookie(this.TXT_USERNAME.Text, false);
this.Session.Add("sha1", this.hash_password);
this.Session.Add("UserID", this.TXT_USERNAME.Text);
nexturl = "Change_Password.aspx?expired";
}
}
else
{
object[] lgparam = new object[]
{
this.TXT_USERNAME.Text,
base.Request.UserHostAddress
};
conn.ExecuteNonQuery(Login1.SP_LOGINSTARTED, lgparam, this.dbtimeout);
System.Web.Security.FormsAuthentication.SetAuthCookie(this.TXT_USERNAME.Text, false);
nexturl = this.AuthenticateUser(conn);
}
}
catch (Exception ex)
{
string errmsg = ex.Message;
if (errmsg.IndexOf("Last Query: exec SU_USERLOGINGIN") > 0)
{
errmsg = errmsg.Substring(0, errmsg.IndexOf("Last Query:"));
this.Label1.Text = errmsg;
}
else
{
Response.Write("<!-- ex msg: " + ex.Message.Replace("-->", "--)") + " -->\n");
this.LogonMessage(Login1.loginResult.logUnknown);
}
}
}
if (nexturl != "")
{
Session.Add("ConnString", _conn);
Session.Add("DbTimeOut", dbtimeout);
Response.Redirect(nexturl);
}
}
protected void CODE_TextChanged(object sender, System.EventArgs e)
{
if (CODE.Text.Trim() == "")
{
CODE.Text = "";
DESC.Text = "";
if (AutoPostBack && _oldvalue != CODE.Text)
{
_oldvalue = CODE.Text;
OnSelectedIndexChanged(e);
}
return;
}
dbtimeout = (int)Session["dbTimeOut"];
ConnString = (string)ConfigurationSettings.AppSettings["connString"].ToString();
//WebControl ctrl;
using (conn = new DbConnection(ConnString))
{
if (_query == null || _query.Trim() == "")
{
string qry = "select " + _fldid + ", " + _flddesc + " from " + _tblname;
if (_cond != null && _cond.Trim() != "")
{
qry += " where (" + _cond + ") and " + _fldid + " = '" + CODE.Text + "'";
}
else
{
qry += " where " + _fldid + " = '" + CODE.Text + "'";
}
conn.ExecReader(qry, null, dbtimeout);
if (conn.hasRow())
{
DESC.Text = conn.GetFieldValue(1);
//ctrl = CommonForm.ModuleSupport.NextCtrl(this.Parent.Page, CODE);
//if (ctrl != null)
// MyPage.SetFocus(this.Parent.Page, ctrl);
}
else
{
CODE.Text = "";
DESC.Text = "";
MyPage.popMessage(this.Parent.Page, "Kode tidak ditemukan");
MyPage.SetFocus(this.Parent.Page, CODE);
}
}
else
{
ListItemCollection items = new ListItemCollection();
MyPage.fillRefListINA(items, _query, null, dbtimeout, false, conn);
try
{
int i = 0;
for (i = 0; i < items.Count; i++)
{
if (items[i].Value.ToLower() == CODE.Text.ToLower()) //found
{
CODE.Text = items[i].Value;
DESC.Text = items[i].Text;
break;
}
}
//ctrl = CommonForm.ModuleSupport.NextCtrl(this.Parent.Page, CODE);
//if (ctrl != null)
// MyPage.SetFocus(this.Parent.Page, ctrl);
if (i == items.Count) // not found
{
CODE.Text = "";
DESC.Text = "";
MyPage.popMessage(this.Parent.Page, "Kode tidak ditemukan");
MyPage.SetFocus(this.Parent.Page, CODE);
}
}
catch
{
CODE.Text = "";
DESC.Text = "";
MyPage.popMessage(this.Parent.Page, "Kode tidak ditemukan");
MyPage.SetFocus(this.Parent.Page, CODE);
}
}
}
if (AutoPostBack && _oldvalue != CODE.Text)
{
_oldvalue = CODE.Text;
OnSelectedIndexChanged(e);
}
}
protected void CODE_TextChanged(object sender, EventArgs e)
{
if (CODE.Text.Trim() == "")
{
CODE.Text = "";
DESC.Text = "";
return;
}
dbtimeout = (int)Session["dbTimeOut"];
ConnString = (string)Session["ConnString"];
//WebControl ctrl;
using (conn = new DbConnection(ConnString))
{
if (_query == null || _query.Trim() == "")
{
string qry = "select " + _fldid + ", " + _flddesc + " from " + _tblname;
if (_cond != null && _cond.Trim() != "")
{
qry += " where (" + _cond + ") and " + _fldid + " = '" + CODE.Text + "'";
}
else
{
qry += " where " + _fldid + " = '" + CODE.Text + "'";
}
conn.ExecReader(qry, null, dbtimeout);
if (conn.hasRow())
{
DESC.Text = conn.GetFieldValue(1);
//ctrl = CommonForm.ModuleSupport.NextCtrl(this.Parent.Page, CODE);
//if (ctrl != null)
// MyPage.SetFocus(this, ctrl);
}
else
{
CODE.Text = "";
DESC.Text = "";
clientmsg = "Kode tidak ditemukan";
MyPage.SetFocus(this, CODE);
}
}
else
{
DropDownList DDL = new DropDownList();
MyPage.fillRefList(DDL.Items, _query, null, dbtimeout, false, conn);
try
{
DDL.SelectedValue = CODE.Text;
DESC.Text = DDL.SelectedItem.Text;
//ctrl = CommonForm.ModuleSupport.NextCtrl(this.Parent.Page, CODE);
//if (ctrl != null)
// MyPage.SetFocus(this, ctrl);
}
catch
{
CODE.Text = "";
DESC.Text = "";
clientmsg = "Kode tidak ditemukan";
MyPage.SetFocus(this, CODE);
}
}
}
}
protected void DatGrd_ItemCommand(object source, DataGridCommandEventArgs e)
{
conn = new DbConnection(Session["ConnStringLogin"].ToString());
ClearEntries();
switch (e.CommandName)
{
case "menuAccess":
Response.Write("<script language='javascript'>window.open('GroupMenuAccess.aspx?GroupID=" + e.Item.Cells[0].Text + "&ModuleID=61','MenuAccess','status=no,scrollbars=yes,width=500,height=400');</script>");
break;
case "edit":
EnableFields(true);
BTN_NEW.Visible = false;
BTN_CANCEL.Visible = true;
BTN_SAVE.Visible = true;
LBL_SAVEMODE.Text = "0";
TXT_GROUPID.ReadOnly = true;
TXT_GROUPID.Text = e.Item.Cells[0].Text;
TXT_SG_GRPNAME.Text = e.Item.Cells[1].Text;
CHK_SG_APPRSTA.Checked = false;
CHK_SG_CALCULATOR.Checked = false;
FLAG_SUPERVISOR.Checked = false;
if (e.Item.Cells[3].Text == "True")
{
CHK_SG_APPRSTA.Checked = true;
}
if (e.Item.Cells[4].Text == "True")
{
CHK_SG_CALCULATOR.Checked = true;
}
if (e.Item.Cells[5].Text == "True")
{
FLAG_SUPERVISOR.Checked = true;
}
conn.ExecReader("select moduleid from VW_GRPACCESSMODULE where groupid = '" + TXT_GROUPID.Text + "'", null, dbtimeout);
while (conn.hasRow())
{
try
{
CHK_MODULEID.Items.FindByValue(conn.GetFieldValue("moduleid")).Selected = true;
}
catch { }
}
//MEMBEROF_AD.Text = conn.GetFieldValue("memberof_ad").ToString();
SG_ROLEDESC.Text = e.Item.Cells[2].Text;
try { DDL_SG_GRPUPLINER.SelectedValue = e.Item.Cells[8].Text; } catch { }
try { CHK_MODULEID_SelectedIndexChanged(null, null); }
catch { }
MyPage.SetFocus(this, BTN_CANCEL);
break;
case "delete":
object[] pardel = new object[5] {
e.Item.Cells[0].Text, e.Item.Cells[1].Text, "2", "1", 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)
{
ClearEntries();
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;
}
conn.Dispose();
}
