private void SaveData() { GeneralDAL _dal = null; Hashtable _ht = null; string sNextEmpCode = string.Empty; try { _dal = new GeneralDAL(); _ht = new Hashtable(); MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht); Shared.ApplyDefaultProp(_ht); _ht["branch_code"] = Request.Params["branch_code"]; if (Request.Params["action"].Equals("add")) { _dal.Insert(TABLE_NAME, _ht, ref sNextEmpCode); txtEmployeeCode.Text = sNextEmpCode; } else { _dal.Update(TABLE_NAME, _ht); } Shared.ShowSuccessGritter(this, string.Format("employeebranch.aspx?action=edit&emp_code={0}&branch_code={1} ", txtEmployeeCode.Text, txtBranchCode.Text)); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
private void SaveData() { GeneralDAL _dal = null; Hashtable _ht = null; try { _dal = new GeneralDAL(); _ht = new Hashtable(); MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht); Shared.ApplyDefaultProp(_ht); if (Request.Params["action"].Equals("add")) { _dal.Insert(TABLE_NAME, _ht); } else { _dal.Update(TABLE_NAME, _ht); } Shared.ShowSuccessGritter(this, string.Format("masterwidget.aspx?action=edit&code={0}", txtWidgetCode.Text)); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
private void SaveData() { GeneralDAL _dal = null; Hashtable _ht = null; int iNextID = 0; try { _dal = new GeneralDAL(); _ht = new Hashtable(); MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht); Shared.ApplyDefaultProp(_ht); _ht["p_id"] = txtId.Text; Shared.ApplyDefaultProp(_ht); if (Request.Params["action"].Equals("add")) { _dal.Insert(TABLE_NAME, _ht, ref iNextID); txtId.Text = iNextID.ToString() ; } else _dal.Update(TABLE_NAME, _ht); Shared.ShowSuccessGritter(this, string.Format("employeenotification.aspx?action=edit&id={0}", txtId.Text)); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
private void SaveData() { GeneralDAL _dal = null; Hashtable _ht = null; try { _dal = new GeneralDAL(); _ht = new Hashtable(); MPF23.Shared.Mapper.UIToDB.Map(upd.Controls, _ht); Shared.ApplyDefaultProp(_ht); _ht["p_application_no"] = txtApplicationNoCustomer.Text; Shared.ApplyDefaultProp(_ht); if (Request.Params["action"].Equals("add")) { _dal.Insert(TABLE_NAME, _ht); } else { _dal.Update(TABLE_NAME, _ht); } Shared.ShowSuccessGritter(this, string.Format("applicationcustomer.aspx?action=edit&app_no={0}", txtApplicationNoCustomer.Text)); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
private void SaveData() { GeneralDAL _dal = null; Hashtable _ht = null; int inextId = 0; try { _dal = new GeneralDAL(); _ht = new Hashtable(); MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht); Shared.ApplyDefaultProp(_ht); _ht["p_code_question"] = txtCode.Text; if (Request.Params["action"].Equals("add")) { _dal.Insert(TABLE_NAME, _ht, ref inextId); txtId.Text = inextId.ToString(); } else { _dal.Update(TABLE_NAME, _ht); } Shared.ShowSuccessGritter(this, string.Format("masterquestionchoice.aspx?action=edit&code={0}&id={1}", txtCode.Text, txtId.Text)); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
private void AddDataToSourceGVW(string Code) { GeneralDAL _dal = null; Hashtable _ht = null; try { _dal = new GeneralDAL(); _ht = new Hashtable(); _ht["p_emp_code"] = Request.Params["empcode"]; _ht[SP_PARAMETER_CODE] = Code; Shared.ApplyDefaultProp(_ht); _dal.Insert("", SP_TARGET_TO_SOURCE, _ht); string script = ""; if (Request.Params["gvw"] == null) { script += "javascript:parent.__doPostBack('ctl00$cpb$btnSearch','');"; } else { script += "javascript:parent.__doPostBack('" + Request.Params["gvw"] + "','');"; } ScriptManager.RegisterStartupScript(this, GetType(), "fn2", script, true); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
private void SaveDataCollection() { GeneralDAL _dal = null; Hashtable _ht = null; try { _dal = new GeneralDAL(); _ht = new Hashtable(); MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht); Shared.ApplyDefaultProp(_ht); _ht["p_trx_no"] = lblTrxNo.Text; Shared.ApplyDefaultProp(_ht); if (Request.Params["action"].Equals("add")) { _dal.Insert(TABLE_NAME_MAIN, _ht); } else { _dal.Update(TABLE_NAME_MAIN, _ht); } Shared.ShowSuccessGritter(this, string.Format("collectionmain.aspx?action=edit&trxNo={0}", lblTrxNo.Text)); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
private void SaveData() { GeneralDAL _dal = null; Hashtable _ht = null; int inextId = 0; try { _dal = new GeneralDAL(); _ht = new Hashtable(); MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht); Shared.ApplyDefaultProp(_ht); _ht["p_id"] = Request.Params["id"]; if (Request.Params["action"].Equals("add")) { _dal.Insert(TABLE_NAME_RESULTS, _ht, ref inextId); //txtID.Text = inextId.ToString(); } else { _dal.Update(TABLE_NAME_RESULTS, _ht); } Shared.ShowSuccessGritter(this, string.Format("collectionresults.aspx?action=edit&id={0}", int.Parse(Request.Params["id"]))); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
private void AddDataToTargetGVW(string Code) { GeneralDAL _dal = null; Hashtable _ht = null; try { _dal = new GeneralDAL(); _ht = new Hashtable(); for (int i = 0; i < Request.Params.Count; i++) { if (Request.Params.AllKeys[i] != null) { if (Request.Params.AllKeys[i].StartsWith("par_")) { string par = Request.Params.AllKeys[i].Substring(4); _ht["p_" + par] = Request.Params[i]; } else if (Request.Params.AllKeys[i].StartsWith("parc_")) { string par = Request.Params.AllKeys[i].Substring(5); _ht["p_" + par] = Request.Params[i]; } } } //System.Diagnostics.Debugger.Break(); _ht[SP_PARAMETER_CODE] = Code; Shared.ApplyDefaultProp(_ht); _dal.Insert("", SP_SOURCE_TO_TARGET, _ht); string script = ""; if (Request.Params["gvw"] == null) { script += "javascript:parent.__doPostBack('ctl00$cpb$btnSearch','');"; } else { script += "javascript:parent.__doPostBack('" + Request.Params["gvw"] + "','');"; } ScriptManager.RegisterStartupScript(this, GetType(), "fn2", script, true); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
//protected void btnSave_Click(object sender, EventArgs e) //{ // //commit data on gridview target // CommitSaveData(); // string script = Shared.GenerateLookUpReturnString(ClientQueryString, gvwListTarget); // ScriptManager.RegisterStartupScript(this, GetType(), "fn2", script, true); //} private void CommitSaveData() { GeneralDAL _dal = null; Hashtable _ht = null; try { _dal = new GeneralDAL(); _ht = new Hashtable(); _ht["p_emp_code"] = Request.Params["empcode"]; Shared.ApplyDefaultProp(_ht); _dal.ExecRawSP(SP_SAVE_NAME, _ht); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
protected void btnChangeStatus_Click(object sender, EventArgs e) { GeneralDAL _dal = null; Hashtable _ht = null; try { _dal = new GeneralDAL(); _ht = new Hashtable(); _ht["p_code"] = Request.Params["subcode"]; Shared.ApplyDefaultProp(_ht); _dal.ExecRawSP("xsp_master_general_subcode_update_status", _ht); Shared.ShowSuccessGritter(this, string.Format("mastergeneralsubcode.aspx?action=edit&general_code={0}&subcode={1}", txtGeneralCode.Text, txtCode.Text)); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
protected void btnChangeStatus_Click(object sender, EventArgs e) { GeneralDAL _dal = null; Hashtable _ht = null; try { _dal = new GeneralDAL(); _ht = new Hashtable(); _ht["p_code"] = Request.Params["code"]; Shared.ApplyDefaultProp(_ht); _dal.ExecRawSP("xsp_master_widget_update_status", _ht); // untuk megeksekusi sp selain dari 5 sp pokok Shared.ShowSuccessGritter(this, string.Format("masterwidget.aspx?action=edit&code={0}", txtWidgetCode.Text)); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
protected void btnResetPassword_Click(object sender, EventArgs e) { GeneralDAL _dal = null; Hashtable _ht = null; try { _dal = new GeneralDAL(); _ht = new Hashtable(); _ht["p_uid"] = Request.Params["id"]; Shared.ApplyDefaultProp(_ht); _dal.ExecRawSP("xsp_master_user_main_reset_password", _ht); // untuk megeksekusi sp selain dari 5 sp pokok Shared.ShowSuccessGritter(this, string.Format("masterusermain.aspx?action=edit&id={0}", lblId.Text)); } catch (Exception ex) { Shared.ShowErrorDialog(this, ex); } }
//protected void Page_Load(object sender, EventArgs e) //{ // dataBranch(); // //LoadInit(); // if (!Page.IsPostBack) // { // //if (Request.Params["action"].Equals("edit")) // // { // //LoadData(); // // btnCancel.Text = "<i class='icon-remove'></i>Back"; // //} // } //} //private void dataBranch() //{ // try // { // string constr = ConfigurationManager.ConnectionStrings["Test1"].ToString(); // connection string // SqlConnection con = new SqlConnection(constr); // con.Open(); // SqlCommand com = new SqlCommand("select * from Branch", con); // table name // SqlDataAdapter da = new SqlDataAdapter(com); // DataSet ds = new DataSet(); // da.Fill(ds); // fill dataset // txtBRANCH.DataTextField = ds.Tables[0].Columns["BranchFullName"].ToString(); // text field name of table dispalyed in dropdown // txtBRANCH.DataValueField = ds.Tables[0].Columns["BranchID"].ToString(); // to retrive specific textfield name // txtBRANCH.DataSource = ds.Tables[0]; //assigning datasource to the dropdownlist // txtBRANCH.DataBind(); //binding // con.Close(); // } // catch (Exception err) // { // } //} protected void btnSignIn_Click(object sender, EventArgs e) { //HttpCookie cookie = new HttpCookie("CurrentLanguage"); //cookie.Value = ddlLanguage.SelectedValue; //Response.SetCookie(cookie); /* * validate user * if row > 0, maka ambil role user tersebut * redirect ke main.aspx * jika tidak, show error */ GeneralDAL _dal = null; Hashtable _ht = null; bool IsValidUser = true; bool IsValidPassword = true; bool IsActiveUser = true; string UID = ""; try { _dal = new GeneralDAL(); _ht = new Hashtable(); _ht["p_uid"] = txtUID.Text; _ht["p_password"] = txtPassword.Text; DataRow dr = _dal.GetRow("", "xsp_master_user_main_validate", _ht); //dr null jika tidak ada record, langsung lari ke catch if (dr != null) { UID = dr["ID"].ToString(); if (dr["UPASS"].ToString().Equals(dr["UPASSMD5"].ToString())) { //Masukan Role disini //if (dr["p_uid"].ToString() == "ADM000") //{ // Response.Redirect("/module/finance/agunan.aspx"); //} if (((int)dr["LAST_FAIL_COUNT"]) >= 5) { IsValidPassword = false; } else { if (dr["IS_ACTIVE"].ToString().Equals("1")) //artinya user aktif { //reset fail count _ht["p_uid"] = UID; _dal.Update("", "xsp_master_user_main_reset_fail_count", _ht); //update last login _ht["p_uid"] = UID; _ht["p_login_date"] = DateTime.Now; _dal.Update("", "xsp_master_user_main_update_last_login", _ht); //save user profile ke session Session[SessionKey.CURRENT_USER_SESSION_KEY] = dr; //save user role ke session Session[SessionKey.CURRENT_USER_ROLE_SESSION_KEY] = _dal.GetRows("", "xsp_master_user_main_getroles", _ht); //save user ip address if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] == null) { Session[SessionKey.CURRENT_USER_IP_ADDRESS_SESSION_KEY] = Request.ServerVariables["REMOTE_ADDR"]; } else { Session[SessionKey.CURRENT_USER_IP_ADDRESS_SESSION_KEY] = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; } //insert master user login log _ht["p_uid"] = UID; _ht["p_ip_address"] = Shared.CurrentIPAddress; _ht["p_flag_code"] = "SUCCESS"; Shared.ApplyDefaultProp(_ht); _dal.Insert("", "xsp_master_user_login_log_insert", _ht); if (((DateTime)dr["NEXT_CHANGE_PASS"]) <= DateTime.Now) { ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowModalChangePassword();", true);; } else { //redirect ke halaman main //Response.Redirect("main.aspx"); //Masukan Role disini if (dr["ID"].ToString() == "ADM000") { Response.Redirect("branch/main_000.aspx"); } else if (dr["ID"].ToString() == "1000000003") { Response.Redirect("main.aspx"); } else if (dr["ID"].ToString() == "ADM001") { Response.Redirect("branch/main_001.aspx"); } else if (dr["ID"].ToString() == "ADM002") { Response.Redirect("branch/main_002.aspx"); } else if (dr["ID"].ToString() == "ADM004") { Response.Redirect("branch/main_004.aspx"); } else if (dr["ID"].ToString() == "ADM005") { Response.Redirect("branch/main_005.aspx"); } else if (dr["ID"].ToString() == "ADM006") { Response.Redirect("branch/main_006.aspx"); } else if (dr["ID"].ToString() == "ADM007") { Response.Redirect("branch/main_007.aspx"); } else if (dr["ID"].ToString() == "ADM008") { Response.Redirect("branch/main_008.aspx"); } else if (dr["ID"].ToString() == "ADM009") { Response.Redirect("branch/main_009.aspx"); } else if (dr["ID"].ToString() == "ADM010") { Response.Redirect("branch/main_010.aspx"); } else if (dr["ID"].ToString() == "ADM011") { Response.Redirect("branch/main_011.aspx"); } else if (dr["ID"].ToString() == "ADM012") { Response.Redirect("branch/main_012.aspx"); } else if (dr["ID"].ToString() == "ADM013") { Response.Redirect("branch/main_013.aspx"); } else if (dr["ID"].ToString() == "ADM014") { Response.Redirect("branch/main_014.aspx"); } else if (dr["ID"].ToString() == "ADM015") { Response.Redirect("branch/main_015.aspx"); } else if (dr["ID"].ToString() == "ADM016") { Response.Redirect("branch/main_016.aspx"); } else if (dr["ID"].ToString() == "ADM017") { Response.Redirect("branch/main_017.aspx"); } else if (dr["ID"].ToString() == "ADM018") { Response.Redirect("branch/main_018.aspx"); } else if (dr["ID"].ToString() == "ADM019") { Response.Redirect("branch/main_019.aspx"); } else if (dr["ID"].ToString() == "ADM020") { Response.Redirect("branch/main_020.aspx"); } else if (dr["ID"].ToString() == "ADM021") { Response.Redirect("branch/main_021.aspx"); } else if (dr["ID"].ToString() == "ADM022") { Response.Redirect("branch/main_022.aspx"); } else if (dr["ID"].ToString() == "ADM023") { Response.Redirect("branch/main_023.aspx"); } else if (dr["ID"].ToString() == "ADM024") { Response.Redirect("branch/main_024.aspx"); } else if (dr["ID"].ToString() == "ADM025") { Response.Redirect("branch/main_025.aspx"); } else if (dr["ID"].ToString() == "ADM026") { Response.Redirect("branch/main_026.aspx"); } else if (dr["ID"].ToString() == "ADM027") { Response.Redirect("branch/main_027.aspx"); } else if (dr["ID"].ToString() == "ADM028") { Response.Redirect("branch/main_028.aspx"); } else if (dr["ID"].ToString() == "ADM029") { Response.Redirect("branch/main_029.aspx"); } else if (dr["ID"].ToString() == "ADM030") { Response.Redirect("branch/main_030.aspx"); } else if (dr["ID"].ToString() == "ADM031") { Response.Redirect("branch/main_031.aspx"); } else if (dr["ID"].ToString() == "ADM032") { Response.Redirect("branch/main_032.aspx"); } else if (dr["ID"].ToString() == "ADM033") { Response.Redirect("branch/main_033.aspx"); } else if (dr["ID"].ToString() == "ADM034") { Response.Redirect("branch/main_034.aspx"); } else if (dr["ID"].ToString() == "ADM035") { Response.Redirect("branch/main_035.aspx"); } else if (dr["ID"].ToString() == "ADM036") { Response.Redirect("branch/main_036.aspx"); } else if (dr["ID"].ToString() == "ADM037") { Response.Redirect("branch/main_037.aspx"); } else if (dr["ID"].ToString() == "ADM038") { Response.Redirect("branch/main_038.aspx"); } else if (dr["ID"].ToString() == "ADM039") { Response.Redirect("branch/main_039.aspx"); } else if (dr["ID"].ToString() == "ADM040") { Response.Redirect("branch/main_040.aspx"); } else if (dr["ID"].ToString() == "ADM041") { Response.Redirect("branch/main_041.aspx"); } else if (dr["ID"].ToString() == "ADM042") { Response.Redirect("branch/main_042.aspx"); } else if (dr["ID"].ToString() == "ADM043") { Response.Redirect("branch/main_043.aspx"); } else if (dr["ID"].ToString() == "ADM044") { Response.Redirect("branch/main_044.aspx"); } else if (dr["ID"].ToString() == "ADM045") { Response.Redirect("branch/main_045.aspx"); } else if (dr["ID"].ToString() == "ADM046") { Response.Redirect("branch/main_046.aspx"); } else if (dr["ID"].ToString() == "ADM047") { Response.Redirect("branch/main_047.aspx"); } else if (dr["ID"].ToString() == "ADM048") { Response.Redirect("branch/main_048.aspx"); } else if (dr["ID"].ToString() == "ADM049") { Response.Redirect("branch/main_049.aspx"); } else if (dr["ID"].ToString() == "ADM050") { Response.Redirect("branch/main_050.aspx"); } else if (dr["ID"].ToString() == "ADM051") { Response.Redirect("branch/main_051.aspx"); } else if (dr["ID"].ToString() == "ADM052") { Response.Redirect("branch/main_052.aspx"); } else if (dr["ID"].ToString() == "ADM053") { Response.Redirect("branch/main_053.aspx"); } else if (dr["ID"].ToString() == "ADM054") { Response.Redirect("branch/main_054.aspx"); } else if (dr["ID"].ToString() == "ADM055") { Response.Redirect("branch/main_055.aspx"); } else if (dr["ID"].ToString() == "ADM056") { Response.Redirect("branch/main_056.aspx"); } else if (dr["ID"].ToString() == "ADM057") { Response.Redirect("branch/main_057.aspx"); } else if (dr["ID"].ToString() == "ADM058") { Response.Redirect("branch/main_058.aspx"); } else if (dr["ID"].ToString() == "ADM059") { Response.Redirect("branch/main_059.aspx"); } else if (dr["ID"].ToString() == "ADM060") { Response.Redirect("branch/main_060.aspx"); } else if (dr["ID"].ToString() == "ADM061") { Response.Redirect("branch/main_061.aspx"); } else if (dr["ID"].ToString() == "ADM062") { Response.Redirect("branch/main_062.aspx"); } else if (dr["ID"].ToString() == "ADM063") { Response.Redirect("branch/main_063.aspx"); } else if (dr["ID"].ToString() == "ADM064") { Response.Redirect("branch/main_064.aspx"); } else if (dr["ID"].ToString() == "ADM065") { Response.Redirect("branch/main_065.aspx"); } else if (dr["ID"].ToString() == "ADM066") { Response.Redirect("branch/main_066.aspx"); } else if (dr["ID"].ToString() == "ADM067") { Response.Redirect("branch/main_067.aspx"); } else if (dr["ID"].ToString() == "ADM068") { Response.Redirect("branch/main_068.aspx"); } else if (dr["ID"].ToString() == "ADM069") { Response.Redirect("branch/main_069.aspx"); } else if (dr["ID"].ToString() == "ADM070") { Response.Redirect("branch/main_070.aspx"); } else if (dr["ID"].ToString() == "ADM071") { Response.Redirect("branch/main_071.aspx"); } else if (dr["ID"].ToString() == "ADM072") { Response.Redirect("branch/main_072.aspx"); } else if (dr["ID"].ToString() == "ADM073") { Response.Redirect("branch/main_073.aspx"); } else if (dr["ID"].ToString() == "ADM0900") { Response.Redirect("branch/main_0900.aspx"); } } } else { IsActiveUser = false; } } } else { IsValidPassword = false; } } else { IsValidUser = false; } } catch { IsValidUser = false; } if (!IsActiveUser) { //show ke user message box, jika user dia tidak aktif ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowErrorNotif('User not active. Please contact your MIS/IT Department.', '');", true); } else if (!IsValidPassword) { //cek last fail count untuk uid yang login _dal = new GeneralDAL(); _ht = new Hashtable(); _ht["p_id"] = UID; DataRow dr = _dal.GetRow("", "xsp_master_user_main_getrow", _ht); _ht["p_login_date"] = DateTime.Now; _ht["p_cre_date"] = DateTime.Now; _ht["p_cre_by"] = txtUID.Text; _ht["p_cre_ip_address"] = "127.0.0.1"; if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] == null) { _ht["p_ip_address"] = Request.ServerVariables["REMOTE_ADDR"]; } else { _ht["p_ip_address"] = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; } if (((int)dr["LAST_FAIL_COUNT"]) >= 5) { _ht["p_flag_code"] = "FAIL MAX ATTEMPT"; _ht["p_uid"] = UID; //insert master user login log _dal.Insert("", "xsp_master_user_login_log_insert", _ht); //show warning max login attempt reached ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowErrorNotif('Maximum try login reached. Please contact your MIS/IT Department.', '');", true); } else // jika uid tersebut tidak ada berarti invalid user, langsung di catch { _ht["p_flag_code"] = "FAIL PASSWORD"; _ht["p_uid"] = UID; _ht["p_mod_date"] = DateTime.Now.ToString("yyyy-MM-dd"); _ht["p_mod_by"] = txtUID.Text; _ht["p_mod_ip_address"] = "127.0.0.1"; //insert master user login log try { _dal.Insert("", "xsp_master_user_login_log_insert", _ht); //update last fail count -> ditambahkan 1 _dal.Update("", "xsp_master_user_main_increment_fail_count", _ht); ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowErrorNotif('Invalid password', '');", true); } catch (Exception exp) { string error = exp.Message; } } } else if (!IsValidUser) { ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowErrorNotif('Invalid user', '');", true); } }