protected void Button1_Click(object sender, EventArgs e) { int seq; for (int x = 0; x < i; x++) { CheckBox c = Page.FindControl("CK_" + x.ToString()) as CheckBox; HtmlInputHidden hd = Page.FindControl("HD_" + x.ToString()) as HtmlInputHidden; if (c != null) { seq = x + 1; string selection = "1"; string chkSeq = ""; if (c.Checked) { selection = "1"; } else { selection = "0"; } chkSeq = hd.Value; string SP = "exec SLIK_UPDATE_SELECTION @1,@2,@3"; object[] prmtr = new object[] { appid.Value, chkSeq, selection }; conn.ExecuteNonQuery(SP, prmtr, dbtimeout); } } runcreditpolicy(appid.Value); MyPage.popMessage(this, "Data Saved & Recalculated."); }
protected void Button1_Click(object sender, EventArgs e) { FormsAuthentication.SignOut(); int dbtimeout = int.Parse(ConfigurationManager.AppSettings["dbTimeOut"]); string connString = EncryptDecrypt.decryptConnStr(ConfigurationManager.AppSettings["AuthConnString"]); string nexturl = ""; using (DbConnection conn = new DbConnection(connString)) { conn.ExecReader(Q_LOGINSCR, parmodule, dbtimeout); if (conn.hasRow()) { string uid = TextBox1.Text, dbip = connESecurity.GetFieldValue(1), dbname = connESecurity.GetFieldValue(2), dbuid = connESecurity.GetFieldValue(3), dbpwd = authenticate.decryptMyStr(connESecurity.GetFieldValue(4)); if (AddSession(uid, "Data Source=" + dbip + ";Initial Catalog=" + dbname + ";uid=" + dbuid + ";pwd=" + dbpwd + ";Pooling=true", dbtimeout)) { FormsAuthentication.SetAuthCookie(uid, false); nexturl = TextBox2.Text; } } conn.Dispose(); if (nexturl != "") Response.Redirect(nexturl, true); else MyPage.popMessage(this, "User not found"); } }
protected void cb_logon_CheckedChanged(object sender, System.EventArgs e) { object[] paruser = new object[1] { TXT_USERID.Text }; using (conn = new DbConnection(ConnString)) { conn.ExecuteNonQuery(U_RESETLOGON, paruser, dbtimeout); BindData(); } MyPage.popMessage(this, "Logon flag resetted!"); }
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 lb_Click(object sender, System.EventArgs e) { LinkButton lbl = (LinkButton)sender; object[] modname = new object[1] { lbl.Text }; string moduleid = null, url = ""; connESecurity.ExecReader(Q_GETMODULE, modname, dbtimeout); if (connESecurity.hasRow()) { moduleid = connESecurity.GetFieldValue(0); } Guid token = System.Guid.NewGuid(); object[] objtkn = new object[3] { token, Session["UserID"], moduleid }; connESecurity.ExecReader(SP_SAVETOKEN, objtkn, dbtimeout); if (connESecurity.hasRow()) { string tempurl = connESecurity.GetFieldValue(0); if (tempurl.IndexOf("?") >= 0) { url = tempurl + "&tkn=" + token.ToString() + "&sessionid=" + Session["sessionid"]; } else { url = tempurl + "?tkn=" + token.ToString() + "&sessionid=" + Session["sessionid"]; } } connESecurity.Dispose(); if (url != "") { RemoveSession(); Response.Redirect(url, true); } else { MyPage.popMessage(this, "Invalid Server State!"); } }
protected void btnExport_Click(object sender, EventArgs e) { try { string strFileName = Session["userid"] + "_" + DateTime.Now.ToString("yyMMddhhmmss"); string strFilePath = Server.MapPath(svrpathurl) + "\\" + strFileName + ".xls"; System.IO.FileStream fs = new System.IO.FileStream(strFilePath, System.IO.FileMode.Create, System.IO.FileAccess.Write); gridExport.WriteXls(fs); fs.Dispose(); Response.Write("<script for=window event=onload language='JavaScript'>"); Response.Write("window.open('" + svrpathurl + "/" + strFileName + ".xls" + "');"); Response.Write("</script>"); } catch (Exception ex) { MyPage.popMessage(Page, ex.Message); } }
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) { int dbtimeout = int.Parse(ConfigurationSettings.AppSettings["dbTimeOut"]); DbConnection conn = new DbConnection(Session["ConnStringLogin"].ToString()); conn.ExecReader("select jenisuser from scalluser where userid=@1", new object[] { Session["USERID"] }, dbtimeout); if (conn.hasRow()) { if (conn.GetFieldValue(0) != null) { if (conn.GetFieldValue(0).ToString() == "1") { MyPage.popMessage(this, "User Active Directory cannot changes password here. Please contact IT Admin.."); TXT_OLD.Enabled = false; TXT_NEW.Enabled = false; TXT_VERIFY.Enabled = false; BTN_CHANGE.Enabled = false; } } } }
protected void Button1_Click(object sender, EventArgs e) { FormsAuthentication.SignOut(); int dbtimeout = int.Parse(ConfigurationSettings.AppSettings["dbTimeOut"]); DbConnection connESecurity = new DbConnection(getConnStringLogin()); string nexturl = ""; object[] parmodule = new object[1] { ConfigurationSettings.AppSettings["ModuleID"] }; connESecurity.ExecReader(Q_LOGINSCR, parmodule, dbtimeout); if (connESecurity.hasRow()) { string uid = TextBox1.Text, dbip = connESecurity.GetFieldValue(1), dbname = connESecurity.GetFieldValue(2), dbuid = connESecurity.GetFieldValue(3), dbpwd = connESecurity.GetFieldValue(4); if (AddSession(uid, "Data Source=" + dbip + ";Initial Catalog=" + dbname + ";uid=" + dbuid + ";pwd=" + dbpwd + ";Pooling=true", dbtimeout)) { FormsAuthentication.SetAuthCookie(uid, false); nexturl = "main.html"; } } connESecurity.Dispose(); if (nexturl != "") { Response.Redirect(nexturl, true); } else { MyPage.popMessage(this, "User not found"); } }
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(); }
private void ViewData(string key) { string src = ""; try { DataTable dt = conn.GetDataTable("select * from slik_resultmatch where appid = @1", new object[] { key }, dbtimeout); listvaluestring.Value = ""; for (i = 0; i <= dt.Rows.Count - 1; i++) { string nik = dt.Rows[i]["nik"].ToString(); string detailid = dt.Rows[i]["trn_ideb_detail_id"].ToString(); string idebid = dt.Rows[i]["trn_ideb_id"].ToString(); //string pdfviewsite = ConfigurationSettings.AppSettings["pdfviewsite"]; string pdfviewsite = "ViewPDF.aspx?"; TB_SIDLIST.Rows.Add(new TableRow()); TB_SIDLIST.Rows[i].Cells.Add(new TableCell()); //checkbox System.Web.UI.WebControls.CheckBox ck = new CheckBox(); ck.ID = "CK_" + i.ToString(); ck.Attributes.Add("onclick", "ceknik('" + dt.Rows[i]["nik"].ToString() + "',this);"); if ((bool)dt.Rows[i]["selected"]) { ck.Checked = true; listvaluestring.Value += dt.Rows[i]["nik"].ToString() + ":1,"; } else { ck.Checked = false; listvaluestring.Value += dt.Rows[i]["nik"].ToString() + ":0,"; } TB_SIDLIST.Rows[i].Cells[0].Controls.Add(ck); System.Web.UI.WebControls.HyperLink h = new HyperLink(); h.ID = "HL_" + i.ToString(); h.Target = "IFR_TEXT"; h.Text = dt.Rows[i]["linkname"].ToString(); h.Attributes.Add("style", "cursor:hand"); string urlnavigate = "notyetuploaded.html"; if (!String.IsNullOrEmpty(idebid) && !String.IsNullOrEmpty(detailid)) { urlnavigate = pdfviewsite + "idebid=" + idebid + "&detailid=" + detailid; } h.Attributes.Add("onclick", "javascript:kliklink('HL_" + i.ToString() + "','" + urlnavigate + "')"); if (dt.Rows[i]["POLRES"].ToString() != "1") { h.ForeColor = System.Drawing.Color.Red; } h.ToolTip = dt.Rows[i]["result_name"].ToString(); TB_SIDLIST.Rows[i].Cells[0].Controls.Add(h); if (i == 0) { src = urlnavigate; urlframe.Value = urlnavigate; } //hyperlink matching score System.Web.UI.WebControls.HyperLink h2 = new HyperLink(); h2.ID = "HLmatch_" + i.ToString(); h2.Text = " (" + dt.Rows[i]["match_level"].ToString() + ")"; //h2.Font.Underline = true; h2.Attributes.Add("style", "cursor:hand"); h2.Attributes.Add("onclick", "javascript:PopupPage('DetailValidation.aspx?id=" + dt.Rows[i]["resultid"].ToString() + "',800,600)"); TB_SIDLIST.Rows[i].Cells[0].Controls.Add(h2); } } catch (Exception ex) { MyPage.popMessage(this, ex.Message); } nikcount.Value = i.ToString(); if (i == 0) { dv_found.Attributes.Add("style", "display:none"); } else { TR_MSG.Visible = false; TR_FRAME.Visible = true; IFR_TEXT.Attributes.Add("src", src); btnpdf.Style.Add("display", "none"); dv_found.Attributes.Remove("style"); } }
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 btnSubmit_Click(object sender, EventArgs e) { bool flag_sameuser = false; string[] keyREJCT = hREJCT.Value.Split(','); string[] keyAPPRV = hAPPRV.Value.Split(','); for (int i = 0; i < keyREJCT.Length; i++) { if (keyREJCT[i] != "") { conn.ExecNonQuery(U_DELPARAMTMP, new object[] { keyREJCT[i] }, dbtimeout); } } for (int i = 0; i < keyAPPRV.Length; i++) { if (keyAPPRV[i] != "") { conn.ExecReader(Q_PARAMTMP, new object[] { keyAPPRV[i] }, dbtimeout); if (conn.hasRow()) { switch (conn.GetFieldValue("Status")) { case "Insert": case "Update": if (conn.GetFieldValue("CreatedBy") == Session["USERID"].ToString()) { flag_sameuser = true; } else { save(keyAPPRV[i]); } break; case "Delete": if (conn.GetFieldValue("CreatedBy") == Session["USERID"].ToString()) { flag_sameuser = true; } else { delete(keyAPPRV[i]); } break; } } } } dtbindpending(gridpending); if (gridpending.GroupCount > 0) { funcpendCss = ""; } hAPPRV.Value = ""; hREJCT.Value = ""; hCANCL.Value = ""; if (flag_sameuser) { MyPage.popMessage(this, "Update failed, Checker maker must be done by different ID ..."); } }
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 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(); }