public string graphic() { String output = ""; var param1 = Request.Params["param1"].ToString(); var param2 = Request.Params["param2"].ToString(); //var param3 = Request.Params["param3"].ToString(); //var param4 = Request.Params["param4"].ToString(); //var param5 = Request.Params["param5"].ToString(); //var param6 = Request.Params["param6"].ToString(); try { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List2("ALMIS.D_REPORT", param1, param2); DataTable dt = new DataTable(); dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { output += (dt.Rows[i]["t_xmlxx"].ToString()); } } catch (Exception e) { output = e.Message; } return output; }
private bool ServiceSelect(string sm) { switch (sm) { case "L": var param1L = Request.Params["param1"].ToString(); var param2L = Request.Params["param2"].ToString(); var param4L = Request.Params["param4"].ToString(); var param5L = Request.Params["param5"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List14("P_CLAUSR", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "", ""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrNmrClm"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrLokKab"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrLokKec"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrLokDes"].ToString()) + "</cell>"); if (dt.Rows[i]["ClausrNmrClm"].ToString() != "") { Response.Write("<cell>" + RemoveWhiteSpace("View^KlaimUserForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["ClausrNmrClm"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Edit^KlaimUserForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["ClausrNmrClm"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^KlaimUserForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["ClausrNmrClm"].ToString() + "") + "</cell>"); } Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
public void HakAkses() { if (Session["userid"] is object) { userid = Session["userid"].ToString(); if (Session["groups"] is object) { groups = Session["groups"].ToString(); } } if (!(Session["userid"] is object)) { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Session sudah habis. Silakan login kembali.');"); Response.Write("location.href = '../login.aspx';"); Response.Write("</script>"); } ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List8("P_MENU", "CHA", "", groups, "Pra Registrasi", "", "", "", ""); dt = ds.Tables[0]; PraRegistrasiView = dt.Rows[0]["VIEWXXX"].ToString(); //0 PraRegistrasiEdit = dt.Rows[0]["EDITXXX"].ToString(); //1 PraRegistrasiDelete = dt.Rows[0]["DELETEX"].ToString(); //2 PraRegistrasiAssign = dt.Rows[0]["ASSIGNX"].ToString(); //3 dt.Dispose(); if (PraRegistrasiView.ToString() != "1" ) { if (groups.ToString() != "1") { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); //Response.Write("window.location.reload()"); Response.Write("alert('Anda Tidak Memiliki Akses Untuk Melihat Modul Ini');"); Response.Write("location.href = '../Pages/home.aspx';"); Response.Write("</script>"); } } }
private String SaveDetail() { String param1 = ""; if (Request.Params["param1"] is object) param1 = Request.Params["param1"].ToString(); String param2 = ""; if (Request.Params["param2"] is object) param2 = Request.Params["param2"].ToString(); String param3 = ""; if (Request.Params["param3"] is object) param3 = Request.Params["param3"].ToString(); String param4 = ""; if (Request.Params["param4"] is object) param4 = Request.Params["param4"].ToString(); String param5 = ""; if (Request.Params["param5"] is object) param5 = Request.Params["param5"].ToString(); String param6 = ""; if (Request.Params["param6"] is object) param6 = Request.Params["param6"].ToString(); String param7 = ""; if (Request.Params["param7"] is object) param7 = Request.Params["param7"].ToString(); String param8 = ""; if (Request.Params["param8"] is object) param8 = Request.Params["param8"].ToString(); String param9 = ""; if (Request.Params["param9"] is object) param9 = Request.Params["param9"].ToString(); try { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save9("P_PENGTO_D", param1, param2, param3, param4, param5, param6, param7, param8, param9); } catch (Exception ex) { Response.Write(ex.Message); Response.End(); return ex.Message; } return param1; }
private bool ServiceSelect(string sm) { switch (sm) { case "E": Response.ContentType = "text/plain"; var param1 = Request.Params["param1"].ToString(); var param2 = Request.Params["param2"].ToString(); var param4 = Request.Params["param4"].ToString(); var param5 = Request.Params["param5"].ToString(); var param6 = Request.Params["param6"].ToString(); var param7 = Request.Params["param7"].ToString(); var param8 = Request.Params["param8"].ToString(); var param21 = Request.Params["param21"].ToString(); var param22 = Session["userid"].ToString(); var param24 = Request.Params["param24"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save25("P_PMBYRN", param1, param2, "", param4, param5, param6, param7, param8, "", "", "", "", "", "", "", "", "", "", "", "", param21, param22, "", param24, ""); Response.End(); return false; case "L": var param1L = Request.Params["param1"].ToString(); var param2L = Request.Params["param2"].ToString(); var param4L = Request.Params["param4"].ToString(); var param5L = Request.Params["param5"].ToString(); var param24L = Request.Params["param24"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List25("P_PMBYRN", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userid, "", param24L, ""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnNmrByr"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks1NmrReg"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnAssign"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnLnjuts"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Assign"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks1NmrNeg"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsNovism"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks1NmrBr1"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; case "UA": Response.ContentType = "text/plain"; Response.Write(UA()); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "L": HakAkses(); var param1L = Request.Params["param1"].ToString(); var param2L = Request.Params["param2"].ToString(); var param4L = Request.Params["param4"].ToString(); var param5L = Request.Params["param5"].ToString(); var param35L = Request.Params["param35"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List36("P_REGIST", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userid, "", "",param35L,""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); //groupsid = Session["groups"].ToString(); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["penlapNmrPen"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregNmrPra"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registAssign"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registLanjut"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaNamass"].ToString()) + "</cell>"); if (dt.Rows[i]["registNmrReg"].ToString() != "") { if (groups.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("View^RegistrasiForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Edit^RegistrasiForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^RegistrasiForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>"); } else { if (RegistrasiView.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("View^RegistrasiForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>"); } if (RegistrasiEdit.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("Edit^RegistrasiForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>"); } if (RegistrasiDelete.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("Delete^RegistrasiForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>"); } } } Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "V": var Param1 = Request.Params["param1"].ToString(); var Param2 = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List25("P_PMBYRN", Param1, Param2, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["pmbyrnNmrByr"].ToString() + "|"); //0 Response.Write(dt.Rows[0]["registNmrReg"].ToString() + "|");//1 Response.Write(dt.Rows[0]["pmbyrnNmrPid"].ToString() + "|");//2 Response.Write(dt.Rows[0]["pmbyrnNmrNeg"].ToString() + "|");//3 Response.Write(dt.Rows[0]["pmbyrnNovism"].ToString() + "|");//4 Response.Write(dt.Rows[0]["berks1NmrBr1"].ToString() + "|");//5 Response.Write(dt.Rows[0]["pmbyrnTglASH"].ToString() + "|");//6 Response.Write(dt.Rows[0]["pmbyrnTglAMn"].ToString() + "|");//7 Response.Write(dt.Rows[0]["pmbyrnTglSrv"].ToString() + "|");//8 Response.Write(dt.Rows[0]["pmbyrnTglAGm"].ToString() + "|");//9 Response.Write(dt.Rows[0]["pmbyrnTgABod"].ToString() + "|");//10 Response.Write(dt.Rows[0]["pmbyrnTglAcc"].ToString() + "|");//11 Response.Write(dt.Rows[0]["pmbyrnPengBer"].ToString() + "|");//12 Response.Write(dt.Rows[0]["pmbyrnKetrgn"].ToString() + "|");//13 Response.Write(dt.Rows[0]["pmbyrnLnjuts"].ToString() + "|");//14 Response.Write(dt.Rows[0]["pmbyrnEkseps"].ToString() + "|");//15 Response.Write(dt.Rows[0]["pmbyrnKeteks"].ToString() + "|");//16 Response.Write(dt.Rows[0]["pmbyrnNamPer"].ToString() + "|");//17 Response.Write(dt.Rows[0]["tawar"].ToString() + "|");//18 //Response.Write(dt.Rows[0]["pmbyrnKeteks"].ToString() + "|"); dt.Dispose(); Response.End(); Response.End(); return false; case "CRUD": Response.ContentType = "text/plain"; Response.Write(Save()); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "V": param1 = Request.Params["param1"].ToString(); param2 = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List10("P_PREDOK", param1, param2, "", "", "", "", "", "", "", ""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["ClausrNmrClm"].ToString() + "|"); //0 Response.Write(dt.Rows[0]["PredokNmrDok"].ToString() + "|"); //1 Response.Write(dt.Rows[0]["ClausrNamass"].ToString() + "|"); //2 Response.Write(dt.Rows[0]["ClausrLokKab"].ToString() + "|"); //3 Response.Write(dt.Rows[0]["ClausrLokKec"].ToString() + "|"); //4 Response.Write(dt.Rows[0]["ClausrLokDes"].ToString() + "|"); //5 Response.Write(dt.Rows[0]["ClausrKodPer"].ToString() + "|"); //6 Response.Write(dt.Rows[0]["PredokLanjut"].ToString() + "|"); //7 dt.Dispose(); Response.End(); Response.End(); return false; case "L": param1 = Request.Params["param1"].ToString(); param2 = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP_SA = new ALMIS.ExecuteSTP(); eSTP_SA.Datas(); DataSet ds_SA = new DataSet(); ds_SA = eSTP_SA.List9("P_PREDOK_D", param1, param2, "", "", "", "", "", "", ""); dt = ds_SA.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["PredokNmrPid"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:Hapus(\"" + "DA" + "\",\"" + "D" + "\",\"" + dt.Rows[i]["PredokNmrPid"].ToString() + "\");^_self") + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; case "LP": var param1l = Request.Params["param1"].ToString(); var param2l = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTPx = new ALMIS.ExecuteSTP(); eSTPx.Datas(); DataSet dsx = new DataSet(); dsx = eSTPx.List9("P_PREDOK_D", param1l, param2l, "", "", "", "", "", "", ""); dt = dsx.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); return false; case "CRUD": Response.ContentType = "text/plain"; Response.Write(CRUD()); Response.End(); return false; case "CRUD_D": Response.ContentType = "text/plain"; Response.Write(CRUD_D()); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "HA": if (Session["userid"] is object) { userid = Session["userid"].ToString(); } //Response.ContentType = "text/plain"; var param1 = Request.Params["param1"].ToString(); var param2 = Request.Params["param2"].ToString(); var param3 = Request.Params["param3"].ToString(); var param4 = Request.Params["param4"].ToString(); var param5 = Request.Params["param5"].ToString(); var param6 = Request.Params["param6"].ToString(); var param7 = Session["userid"].ToString(); var param8 = Request.Params["param8"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); //DataSet ds = new DataSet(); eSTP.save8("P_MENU", param1, param2, param3, param4, param5, param6, userid, param8); //Response.End(); return false; case "L": var param1L = Request.Params["param1"].ToString(); var param2L = Request.Params["param2"].ToString(); var param3L = Request.Params["param3"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List8("P_MENU", param1L, param2L, param3L, "", "", "", "", ""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Modul"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Ad"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Edit"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Delet"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Vie"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Prin"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "L": var param1L = Request.Params["param1"].ToString(); var param2L = Request.Params["param2"].ToString(); var param4L = Request.Params["param4"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List10("P_VISUMS_D", param1L, param2L, "", param4L, "", "", "", "", "", ""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); if (param1L == "LRK") { for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsCodess"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsKtrgn"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsRekom"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsAksi"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsSequen"].ToString()) + "</cell>"); Response.Write("</row>"); } } else { for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsCodess"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsKtrgn"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Hapus^javascript:Hapus(\"" + "DO" + "\",\"" + "DO" + "\",\"" + dt.Rows[i]["visumsNovism"].ToString() + "\",\"" + dt.Rows[i]["visumsSequen"].ToString() + "\",\"" + "\");^_self") + "</cell>"); Response.Write("</row>"); } } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; case "V": var Param1 = Request.Params["param1"].ToString(); var Param2 = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List13("P_VISUMS", Param1, Param2, "", "", "", "", "", "", "", "", "", "", ""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["visumsNovism"].ToString() + "|"); //0 Response.Write(dt.Rows[0]["registNmrReg"].ToString() + "|"); //1 Response.Write(dt.Rows[0]["pengtoNmrPid"].ToString() + "|"); //2 Response.Write(dt.Rows[0]["visumsVerLnj"].ToString() + "|"); //3 Response.Write(dt.Rows[0]["visumsEkseps"].ToString() + "|"); //4 Response.Write(dt.Rows[0]["VisumsKetEks"].ToString() + "|"); //5 dt.Dispose(); Response.End(); Response.End(); return false; case "CRUD": Response.ContentType = "text/plain"; Response.Write(Save()); Response.End(); return false; case "CRUDOS": Response.ContentType = "text/plain"; Response.Write(SaveOS()); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private String SaveOS() { String param1 = ""; if (Request.Params["param1"] is object) param1 = Request.Params["param1"].ToString(); String param2 = ""; if (Request.Params["param2"] is object) param2 = Request.Params["param2"].ToString(); String param3 = ""; if (Request.Params["param3"] is object) param3 = Request.Params["param3"].ToString(); String param4 = ""; if (Request.Params["param4"] is object) param4 = Request.Params["param4"].ToString(); String param5 = ""; if (Request.Params["param5"] is object) param5 = Request.Params["param5"].ToString(); String param6 = ""; if (Request.Params["param6"] is object) param6 = Request.Params["param6"].ToString(); String param7 = ""; if (Request.Params["param7"] is object) param7 = Request.Params["param7"].ToString(); String param8 = ""; if (Request.Params["param8"] is object) param8 = Request.Params["param8"].ToString(); String param9 = ""; if (Request.Params["param9"] is object) param9 = Request.Params["param9"].ToString(); String param10 = ""; if (Request.Params["param10"] is object) param10 = Request.Params["param10"].ToString(); //String sql = ""; String output = ""; try { output = param1; if (output == "I" || output == "DO" || output == "IR") { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save10("P_VISUMS_D", param1, param2, param3, param4, param5, param6, param7, param8, param9, param10); return output; } else output = "gagal"; } catch (Exception ex) { Response.Write(ex.Message); Response.End(); return ex.Message; } return output; }
private bool ServiceSelect(string sm) { switch (sm) { case "L": var param1L = Request.Params["param1"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List14("P_COMPLA", param1L, "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["namexx"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; case "E": Response.ContentType = "text/plain"; var param1 = Request.Params["param1"].ToString(); var param2 = Request.Params["param2"].ToString(); var param3 = Request.Params["param3"].ToString(); var param4 = Request.Params["param4"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save4("almisgis.SDE.p_ULANDCMP", param1, param2, param3, param4); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "L": var param1L = Request.Params["param1"].ToString(); var param2L = Request.Params["param2"].ToString(); var param4L = Request.Params["param4"].ToString(); var param5L = Request.Params["param5"].ToString(); var param9L = Request.Params["param9"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List14("P_LEGALL", param1L, param2L, "", param4L, param5L, "", userid, "", param9L, "", "", "", "", ""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["LegallNmrLeg"].ToString()) + "</cell>"); //1 Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["VerdokNmrVrd"].ToString()) + "</cell>"); //2 Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrNmrClm"].ToString()) + "</cell>"); //3 Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrNmrIdn"].ToString()) + "</cell>"); //4 Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrNamass"].ToString()) + "</cell>"); //5 Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrLokDes"].ToString()) + "</cell>"); //6 Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaNamass"].ToString()) + "</cell>"); //7 Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["LegallAssign"].ToString()) + "</cell>"); //8 Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Assign"].ToString()) + "</cell>"); //9 Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); return false; case "A": var param1 = Request.Params["param1"].ToString(); var param2 = Request.Params["param2"].ToString(); var param4 = Request.Params["param4"].ToString(); var param9 = Request.Params["param9"].ToString(); var param12 = Request.Params["param12"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save14("P_LEGALL", param1, param2, "", param4, "", "", userid, "", param9, "", "", param12, "", ""); Response.End(); return false; case "UA": Response.ContentType = "text/plain"; Response.Write(UA()); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "L": var param1L = Request.Params["param1"].ToString(); var param2L = Request.Params["param2"].ToString(); var param3L = Request.Params["param3"].ToString(); var param4L = Request.Params["param4"].ToString(); var param5L = Request.Params["param5"].ToString(); var param6L = Request.Params["param6"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List6("P_HOME", param1L, userid, param3L, param4L, param5L, param6L); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentIdents"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>"); //Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>"); /////////// Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiSepakt"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsVerLnj"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks1Lanjut"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnLnjuts"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2Slesai"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; case "graph": Response.ContentType = "application/xhtml+xml"; Response.Write(graphic()); Response.End(); return false; break; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "V": var Param1 = Request.Params["param1"].ToString(); var Param2 = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List24("P_PENGTO", Param1, Param2, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["pengtoNmrPid"].ToString() + "|"); //0 Response.Write(dt.Rows[0]["pengtoDatess"].ToString() + "|"); //1 Response.Write(dt.Rows[0]["registNmrReg"].ToString() + "|"); //2 Response.Write(dt.Rows[0]["pengtoTgljdw"].ToString() + "|"); //3 Response.Write(dt.Rows[0]["MidentNamass"].ToString() + "|"); //4 Response.Write(dt.Rows[0]["MidentIdents"].ToString() + "|"); //5 Response.Write(dt.Rows[0]["MidentNmrHps"].ToString() + "|"); //6 Response.Write(dt.Rows[0]["MidentAlamat"].ToString() + "|"); //7 Response.Write(dt.Rows[0]["registDatess"].ToString() + "|"); //8 Response.Write(dt.Rows[0]["pengtoKeteks"].ToString() + "|"); //9 Response.Write(dt.Rows[0]["pengtoEkseps"].ToString() + "|"); //10 Response.Write(dt.Rows[0]["pengtoTglpen"].ToString() + "|"); //11 Response.Write(dt.Rows[0]["pengtoToLMss"].ToString() + "|"); //12 Response.Write(dt.Rows[0]["pengtoToSurv"].ToString() + "|"); //13 Response.Write(dt.Rows[0]["pengtoAppsur"].ToString() + "|"); //14 Response.Write(dt.Rows[0]["pengtoAppTss"].ToString() + "|"); //15 Response.Write(dt.Rows[0]["pengtoDiteri"].ToString() + "|"); //16 Response.Write(dt.Rows[0]["pengtoKtergn"].ToString() + "|"); //17 Response.Write(dt.Rows[0]["pengtoLanjut"].ToString() + "|"); //18 Response.Write(dt.Rows[0]["pengtoOverlp"].ToString() + "|"); //19 Response.Write(dt.Rows[0]["pengtoIdents"].ToString() + "|"); //20 Response.Write(dt.Rows[0]["pengtoNamPLK"].ToString() + "|"); //21 Response.Write(dt.Rows[0]["pengtoLuasPL"].ToString() + "|"); //22 dt.Dispose(); Response.End(); Response.End(); return false; //return false; case "CRUD": Response.ContentType = "text/plain"; Response.Write(CRUD()); Response.End(); return false; case "ID": Response.ContentType = "text/plain"; Response.Write(SaveDetail()); Response.End(); return false; case "df": Response.Clear(); string namafile = (Request.Params["filelama"] is object ? Request.Params["filelama"].ToString() : ""); String urlfile = (Request.Params["namafile"] is object ? Request.Params["namafile"].ToString() : ""); String randomfile = (Request.Params["random"] is object ? Request.Params["random"].ToString() : ""); string type = ""; switch (namafile.Substring(namafile.Length - 4)) { case ".htm": case ".html": type = "text/HTML"; break; case ".txt": type = "text/plain"; break; case ".doc": case ".docx": case ".rtf": type = "Application/msword"; break; case ".xls": case ".xlsx": type = "Application/msexcel"; break; case ".zip": case ".rar": type = "application/zip"; break; case ".pdf": type = "application/pdf"; break; case ".jpg": type = "image/JPG"; break; case ".pgn": type = "image/PNG"; break; case ".tif": type = "image/tif"; break; } Response.AddHeader("content-disposition", "attachment;filename=" + namafile + ""); Response.ContentType = type; Response.WriteFile(Server.MapPath(@"~/uploaddocument/" + Request.Params["namafile"].ToString().Replace("&", "&"))); Response.End(); return false; break; case "SavePic": Response.ContentType = "text/plain"; Response.Write(SaveUploadGIFDUMP()); Response.End(); return false; case "DOCpic": String path_pic = (HttpContext.Current.Request.Url.AbsolutePath).ToLower(); string IDREGISTRASI = Request.Params["IDREGISTRASI"].ToString(); string param1 = Request.Params["param1"].ToString(); ALMIS.ExecuteSTP eSTPx = new ALMIS.ExecuteSTP(); eSTPx.Datas(); DataSet dsx = new DataSet(); dsx = eSTPx.List24("P_PENGTO", param1, IDREGISTRASI, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = dsx.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumFiless"].ToString()) + "</cell>"); Response.Write("<cell>" + "Download^" + path_pic + "?sm=df&namafile=" + dt.Rows[i]["hdocumIdLink"].ToString() + "&filelama=" + dt.Rows[i]["hdocumFiless"].ToString() + "</cell>"); //Response.Write("<cell>" + "Delete^" + path_pic + "?sm=Deletepic&IDSOURCE=" + dt.Rows[i]["IDSource"].ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:DeletePic(\"" + dt.Rows[i]["hdocumIdLink"].ToString()) + "\",\"" + IDREGISTRASI + "\");^_self" + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdSour"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdLink"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); return false; case "SD": var param1SA = Request.Params["param1"].ToString(); var param2SA = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP_SA = new ALMIS.ExecuteSTP(); eSTP_SA.Datas(); DataSet ds_SA = new DataSet(); ds_SA = eSTP_SA.List9("P_PENGTO_D", param1SA, param2SA, "", "", "", "", "", "", ""); dt = ds_SA.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNamPlk"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoLuaPlk"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoStatus"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoIdents"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoSequen"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "select": param1 = Request.Params["param1"].ToString(); param2 = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List29("P_MINDENT", param1, param2, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["MidentIdents"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentJnsIdn"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentNamass"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentJnsKel"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentTmplhr"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentTgllhr"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentPekerj"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentNmrPeg"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentAlamat"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentNmrHps"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentStatus"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentNmPsng"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentTmpPas"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentTglPas"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentThnNkh"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentNmAyah"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentTglAyh"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentKrjAyh"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentAlmAyh"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentNmIbus"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentTglIbu"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentKrjIbu"].ToString() + "|"); Response.Write(dt.Rows[0]["MidentAlmIbu"].ToString() + "|"); Response.Write(dt.Rows[0]["Midentkodper"].ToString() + "|"); dt.Dispose(); Response.End(); Response.End(); return false; case "SA": param1 = Request.Params["param1"].ToString(); param2 = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP_SA = new ALMIS.ExecuteSTP(); eSTP_SA.Datas(); DataSet ds_SA = new DataSet(); ds_SA = eSTP_SA.List12("P_MINDENT_A", param1, param2, "", "", "", "", "", "", "", "", "", ""); dt = ds_SA.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentTgllhr"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentPkrjan"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentAlamat"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:Hapus(\"" +"DA" + "\",\"" + "DA" + "\",\"" + dt.Rows[i]["MidentIdents"].ToString() + "\",\"" + dt.Rows[i]["midentSequen"].ToString() + "\");^_self") + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; case "SS": param1 = Request.Params["param1"].ToString(); param2 = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP_SS = new ALMIS.ExecuteSTP(); eSTP_SS.Datas(); DataSet ds_SS = new DataSet(); ds_SA = eSTP_SS.List12("P_MINDENT_S", param1, param2, "", "", "", "", "", "", "", "", "", ""); dt = ds_SA.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentTgllhr"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentPkrjan"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentAlamat"].ToString()) + "</cell>"); //Response.Write("<cell>" + RemoveWhiteSpace("View^javascript:View(\"" + "SS" + "\",\"" + "SS" + "\",\"" + dt.Rows[i]["MidentIdents"].ToString() + "\",\"" + dt.Rows[i]["midentSequen"].ToString() + "\");^_self") + "</cell>"); //Response.Write("<cell>" + RemoveWhiteSpace("Edit^javascript:Edit(\"" + "US" + "\",\"" + "US" + "\",\"" + dt.Rows[i]["MidentIdents"].ToString() + "\",\"" + dt.Rows[i]["midentSequen"].ToString() + "\");^_self") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:Hapus(\"" + "DS" + "\",\"" + "DS" + "\",\"" + dt.Rows[i]["MidentIdents"].ToString() + "\",\"" + dt.Rows[i]["midentSequen"].ToString() + "\");^_self") + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; case "ListUploadIdentitasLahan": param1 = Request.Params["param1"].ToString(); param2 = Request.Params["IDRegistrasi"].ToString(); String path_pic = (HttpContext.Current.Request.Url.AbsolutePath).ToLower(); ALMIS.ExecuteSTP eSTPz = new ALMIS.ExecuteSTP(); eSTPz.Datas(); DataSet dsz = new DataSet(); dsz = eSTPz.List29("P_MINDENT", param1, param2, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = dsz.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); //Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["codessDescs1"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumFiless"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumFiless"].ToString()) + "</cell>"); Response.Write("<cell>" + "Download^" + path_pic + "?sm=df&namafile=" + dt.Rows[i]["hdocumIdLink"].ToString() + "&filelama=" + dt.Rows[i]["hdocumFiless"].ToString() + "</cell>"); //Response.Write("<cell>" + "Delete^" + path_pic + "?sm=Deletepic&IDSOURCE=" + dt.Rows[i]["IDSource"].ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:DeletePic(\"" + dt.Rows[i]["hdocumIdLink"].ToString()) + "\",\"" + param2 + "\");^_self" + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdSour"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdLink"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); //conn.myConnectionClose(); Response.End(); return false; case "ListUploadKelengkapan": param1 = Request.Params["param1"].ToString(); param2 = Request.Params["IDRegistrasi"].ToString(); String path_pica = (HttpContext.Current.Request.Url.AbsolutePath).ToLower(); ALMIS.ExecuteSTP eSTPa = new ALMIS.ExecuteSTP(); eSTPa.Datas(); DataSet dsa = new DataSet(); dsa = eSTPa.List6("P_REGIST_D", param1, param2, "", "", "", ""); dt = dsa.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumFiless"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumFiless"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumFiless"].ToString()) + "</cell>"); Response.Write("<cell>" + "Download^" + path_pica + "?sm=df&namafile=" + dt.Rows[i]["hdocumIdLink"].ToString() + "&filelama=" + dt.Rows[i]["hdocumFiless"].ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:DeletePic(\"" + dt.Rows[i]["hdocumIdLink"].ToString()) + "\",\"" + param2 + "\");^_self" + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdSour"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdLink"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); return false; case "df": Response.Clear(); string namafile = (Request.Params["filelama"] is object ? Request.Params["filelama"].ToString() : ""); String urlfile = (Request.Params["namafile"] is object ? Request.Params["namafile"].ToString() : ""); String randomfile = (Request.Params["random"] is object ? Request.Params["random"].ToString() : ""); string type = ""; switch (namafile.Substring(namafile.Length - 4)) { case ".htm": case ".html": type = "text/HTML"; break; case ".txt": type = "text/plain"; break; case ".doc": case ".docx": case ".rtf": type = "Application/msword"; break; case ".xls": case ".xlsx": type = "Application/msexcel"; break; case ".zip": case ".rar": type = "application/zip"; break; case ".pdf": type = "application/pdf"; break; case ".jpg": type = "image/JPG"; break; case ".pgn": type = "image/PNG"; break; case ".tif": type = "image/tif"; break; } Response.AddHeader("content-disposition", "attachment;filename=" + namafile + ""); Response.ContentType = type; Response.WriteFile(Server.MapPath(@"~/uploaddocument/" + Request.Params["namafile"].ToString().Replace("&", "&"))); dt.Dispose(); Response.End(); return false; case "SaveUploadRegistrasi": Response.ContentType = "text/plain"; Response.Write(SaveUploadRegistrasi()); Response.End(); return false; case "IA": param1 = Request.Params["param1"].ToString(); param2 = Request.Params["param2"].ToString(); param5 = Request.Params["param5"].ToString(); param6 = Request.Params["param6"].ToString(); param7 = Request.Params["param7"].ToString(); param8 = Request.Params["param8"].ToString(); param11 = Request.Params["param11"].ToString(); ALMIS.ExecuteSTP eSTP_IA = new ALMIS.ExecuteSTP(); eSTP_IA.Datas(); eSTP_IA.save12("P_MINDENT_A", param1, param2, param3, param4, param5, param6, param7, param8, userid, param10, param11, "0"); dt.Dispose(); return false; case "IS": param1 = Request.Params["param1"].ToString(); param2 = Request.Params["param2"].ToString(); param5 = Request.Params["param5"].ToString(); param6 = Request.Params["param6"].ToString(); param7 = Request.Params["param7"].ToString(); param8 = Request.Params["param8"].ToString(); param11 = Request.Params["param11"].ToString(); ALMIS.ExecuteSTP eSTP_IS = new ALMIS.ExecuteSTP(); eSTP_IS.Datas(); eSTP_IS.save12("P_MINDENT_S", param1, param2, "", param4, param5, param6, param7, param8, userid, param10, param11, "0"); dt.Dispose(); return false; case "DA": param1 = Request.Params["param1"].ToString(); param2 = Request.Params["param2"].ToString(); param4 = Request.Params["param4"].ToString(); ALMIS.ExecuteSTP eSTP_DA = new ALMIS.ExecuteSTP(); eSTP_DA.Datas(); eSTP_DA.save12("P_MINDENT_A", param1, param2, param3, param4, param5, param6, param7, param8, userid, param10, param11, "0"); dt.Dispose(); return false; case "DS": param1 = Request.Params["param1"].ToString(); param2 = Request.Params["param2"].ToString(); param4 = Request.Params["param4"].ToString(); ALMIS.ExecuteSTP eSTP_DS = new ALMIS.ExecuteSTP(); eSTP_DS.Datas(); eSTP_DS.save12("P_MINDENT_S", param1, param2, param3, param4, param5, param6, param7, param8, userid, param10, param11, "0"); dt.Dispose(); return false; case "CRUD": Response.ContentType = "text/plain"; Response.Write(CRUD()); dt.Dispose(); Response.End(); return false; default: Response.ContentType = "text/plain"; dt.Dispose(); Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "E": Response.ContentType = "text/plain"; var param1 = Request.Params["param1"].ToString(); var param2 = Request.Params["param2"].ToString(); var param4 = Request.Params["param4"].ToString(); var param34 = Request.Params["param34"].ToString(); var param5 = Request.Params["param5"].ToString(); var param35 = Request.Params["param35"].ToString(); var param32 = Session["userid"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List36("P_REGIST", param1, param2, "", param4, param5, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", param32, "", param34, param35, ""); Response.End(); return false; case "L": var param1L = Request.Params["param1"].ToString(); var param2L = Request.Params["param2"].ToString(); var param4L = Request.Params["param4"].ToString(); var param5L = Request.Params["param5"].ToString(); var param35L = Request.Params["param35"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List36("P_REGIST", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userid, "", "", param35L, ""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["penlapNmrPen"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregLokkec"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregLokdes"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registAssign"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Assign"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregIdents"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; case "UA": Response.ContentType = "text/plain"; Response.Write(UA()); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "V": var Param1 = Request.Params["param1"].ToString(); var Param2 = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List9("P_GROUPS", Param1, Param2, "", "", "", "", "", "", ""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["GroupIDents"].ToString() + "|"); //0 Response.Write(dt.Rows[0]["GroupsNamess"].ToString() + "|"); //1 Response.Write(dt.Rows[0]["GroupsLanjut"].ToString() + "|"); //2 Response.Write(dt.Rows[0]["GroupsExcept"].ToString() + "|"); //3 dt.Dispose(); Response.End(); Response.End(); return false; //return false; case "CRUD": Response.ContentType = "text/plain"; Response.Write(Save()); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private String CRUD_D() { if (Session["userid"] is object) { userid = Session["userid"].ToString(); } param1 = Request.Params["param1"].ToString(); param2 = Request.Params["param2"].ToString(); param3 = Request.Params["param3"].ToString(); param4 = Request.Params["param4"].ToString(); param5 = Request.Params["param5"].ToString(); param6 = Request.Params["param6"].ToString(); param7 = Request.Params["param7"].ToString(); param8 = Request.Params["param8"].ToString(); param9 = Request.Params["param9"].ToString(); String sql = ""; String output = ""; try { output = param1; if (output == "I" || output == "E" || output == "D") { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List9("P_PREDOK_D", "X", param2, "", param4, param5, "", "", "", ""); dt = ds.Tables[0]; if (output == "I") { if (dt.Rows.Count > 0) { if (output == "I") output = "noadd"; return output; } } eSTP.Datas(); eSTP.save9("P_PREDOK_D", param1, param2, param3, param4, param5, userid, param7, param8, param9); if (output == "I") output = "ID"; if (output == "D") output = "DD"; return output; } else output = "gagal"; } catch (Exception ex) { Response.Write(ex.Message); Response.End(); return ex.Message; } return output; }
private String Save() { if (Session["userid"] is object) { userid = Session["userid"].ToString(); } String param1 = ""; if (Request.Params["param1"] is object) param1 = Request.Params["param1"].ToString(); String param2 = ""; if (Request.Params["param2"] is object) param2 = Request.Params["param2"].ToString(); String param3 = ""; if (Request.Params["param3"] is object) param3 = Request.Params["param3"].ToString(); String param4 = ""; if (Request.Params["param4"] is object) param4 = Request.Params["param4"].ToString(); String param5 = ""; if (Request.Params["param5"] is object) param5 = Request.Params["param5"].ToString(); String param6 = ""; if (Request.Params["param6"] is object) param6 = Request.Params["param6"].ToString(); String param7 = ""; if (Request.Params["param7"] is object) param7 = Request.Params["param7"].ToString(); String param8 = ""; if (Request.Params["param8"] is object) param8 = Request.Params["param8"].ToString(); String param9 = ""; if (Request.Params["param9"] is object) param9 = Request.Params["param9"].ToString(); String param10 = ""; if (Request.Params["param10"] is object) param10 = Request.Params["param10"].ToString(); String param11 = ""; if (Request.Params["param11"] is object) param11 = Request.Params["param11"].ToString(); //String sql = ""; String output = ""; try { output = param1; //if (output == "I") //{ //} if (output == "I" ) { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List11("P_USERSS", "X", param2, param8, "", "", "", userid, "", "", "", ""); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { if (output == "E") output = "noedit"; if (output == "D") output = "nodelete"; if (output == "I") output = "notambah"; return output; } } if (output == "D" || output == "I" || output == "E") { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); eSTP.save11("P_USERSS", param1, param2, param3, param4, param5, param6, userid, param8, param9, param10, param11); return output; } } catch (Exception ex) { Response.Write(ex.Message); Response.End(); return ex.Message; } return output; }
private String Save() { if (Session["userid"] is object) { userid = Session["userid"].ToString(); } String param1 = ""; if (Request.Params["param1"] is object) param1 = Request.Params["param1"].ToString(); String param2 = ""; if (Request.Params["param2"] is object) param2 = Request.Params["param2"].ToString(); String param3 = ""; if (Request.Params["param3"] is object) param3 = Request.Params["param3"].ToString(); String param4 = ""; if (Request.Params["param4"] is object) param4 = Request.Params["param4"].ToString(); String param5 = ""; if (Request.Params["param5"] is object) param5 = Request.Params["param5"].ToString(); String param6 = ""; if (Request.Params["param6"] is object) param6 = Request.Params["param6"].ToString(); String param7 = ""; if (Request.Params["param7"] is object) param7 = Request.Params["param7"].ToString(); String param8 = ""; if (Request.Params["param8"] is object) param8 = Request.Params["param8"].ToString(); String param9 = ""; if (Request.Params["param9"] is object) param9 = Request.Params["param9"].ToString(); String param10 = ""; if (Request.Params["param10"] is object) param10 = Request.Params["param10"].ToString(); String param11 = ""; if (Request.Params["param11"] is object) param11 = Request.Params["param11"].ToString(); String param12 = ""; if (Request.Params["param12"] is object) param12 = Request.Params["param12"].ToString(); String param13 = ""; if (Request.Params["param13"] is object) param13 = Request.Params["param13"].ToString(); String param14 = ""; if (Request.Params["param14"] is object) param14 = Request.Params["param14"].ToString(); String param15 = ""; if (Request.Params["param15"] is object) param15 = Request.Params["param15"].ToString(); String param16 = ""; if (Request.Params["param16"] is object) param16 = Request.Params["param16"].ToString(); String param17 = ""; if (Request.Params["param17"] is object) param17 = Request.Params["param17"].ToString(); String param18 = ""; if (Request.Params["param18"] is object) param18 = Request.Params["param18"].ToString(); String param19 = ""; if (Request.Params["param19"] is object) param19 = Request.Params["param19"].ToString(); String param20 = ""; if (Request.Params["param20"] is object) param20 = Request.Params["param20"].ToString(); String param21 = ""; if (Request.Params["param21"] is object) param21 = Request.Params["param21"].ToString(); String param22 = ""; if (Request.Params["param22"] is object) param22 = Request.Params["param22"].ToString(); String param23 = ""; if (Request.Params["param23"] is object) param23 = Request.Params["param23"].ToString(); String param24 = ""; if (Request.Params["param24"] is object) param24 = Request.Params["param24"].ToString(); String param25 = ""; if (Request.Params["param25"] is object) param25 = Request.Params["param25"].ToString(); //String sql = ""; String output = ""; try { output = param1; if (output == "E" || output == "D" || output == "A") { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List25("P_PMBYRN", "X", param2, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { if (output == "E") output = "noedit"; if (output == "D") output = "nodelete"; if (output == "A") output = "noadd"; return output; } } if (output == "I" || output == "E" || output == "D") { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save25("P_PMBYRN", param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13, param14, param15, param16, param17, param18, param19, param20, param21, userid, param23, param24, "0"); return output; } else output = "gagal"; } catch (Exception ex) { Response.Write(ex.Message); Response.End(); return ex.Message; } return output; }
private bool ServiceSelect(string sm) { switch (sm) { case "V": var param1 = Request.Params["param1"].ToString(); var param2 = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List11("P_USERSS", param1, param2, "", "", "", "", "", "", "", "",""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["UserssIDents"].ToString() + "|"); //0 //Response.Write(dt.Rows[0]["UserssPasswd"].ToString() + "|"); //1 Response.Write(dt.Rows[0]["UserssNamess"].ToString() + "|"); //2 Response.Write(dt.Rows[0]["UserssGroups"].ToString() + "|"); //3 Response.Write(dt.Rows[0]["UserrsActive"].ToString() + "|"); //4 Response.Write(dt.Rows[0]["UserssEmails"].ToString() + "|"); //5 dt.Dispose(); Response.End(); Response.End(); return false; case "L": var param1L = Request.Params["param1"].ToString(); var param2L = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List9("P_USRPRS", param1L, param2L, "", "", "", "", "", "", ""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaIdents"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["UsrprsKeters"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:Hapus(\"" + "ID" + "\",\"" + "DD" + "\",\"" + dt.Rows[i]["usrprsuserss"].ToString() + "\",\"" + dt.Rows[i]["perusaIdents"].ToString() + "\");^_self") + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); return false; case "CRUD": Response.ContentType = "text/plain"; Response.Write(Save()); Response.End(); return false; case "ID": Response.ContentType = "text/plain"; Response.Write(ID()); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
public void HakAkses() { var Param1 = ""; bool cek = true; if (cek && (Request.Params["param1"] is object)) { Param1 = Request.Params["param1"].ToString(); } else { Param1 = ""; } if (Session["userid"] is object) { userid = Session["userid"].ToString(); if (Session["lanjut"] is object) { lanjut = Session["lanjut"].ToString(); } if (Session["except"] is object) { except = Session["except"].ToString(); } if (Session["groups"] is object) { groups = Session["groups"].ToString(); } } if (!(Session["userid"] is object)) { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Session sudah habis. Silakan login kembali.');"); Response.Write("location.href = '../login.aspx';"); Response.Write("</script>"); } ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List8("P_MENU", "CHA", "", groups, "Pembayaran", "", "", "", ""); dt = ds.Tables[0]; PembayaranView = dt.Rows[0]["VIEWXXX"].ToString(); //0 PembayaranEdit = dt.Rows[0]["EDITXXX"].ToString(); //1 PembayaranDelete = dt.Rows[0]["DELETEX"].ToString(); //2 PembayaranAssign = dt.Rows[0]["ASSIGNX"].ToString(); //3 dt.Dispose(); if (Param1 == "") { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Tidak Ada Aksi Yang Ada Pilih');"); Response.Write("location.href = '../Pages/home.aspx';"); Response.Write("</script>"); } else if (Param1 == "V") { if (PembayaranView.ToString() != "1") { if (groups.ToString() != "1") { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Anda Tidak Memiliki Akses Untuk Melihat Di Modul Ini');"); Response.Write("location.href = '../Pages/home.aspx';"); Response.Write("</script>"); } } } else if (Param1 == "E") { if (PembayaranEdit.ToString() != "1") { if (groups.ToString() != "1") { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Anda Tidak Memiliki Akses Untuk Edit Di Modul Ini');"); Response.Write("location.href = '../Pages/home.aspx';"); Response.Write("</script>"); } } } else if (Param1.ToString() == "D") { if (PembayaranDelete.ToString() != "1") { if (groups.ToString() != "1") { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Anda Tidak Memiliki Akses Untuk Delete Di Modul Ini');"); Response.Write("location.href = '../Pages/home.aspx';"); Response.Write("</script>"); } } } else { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Aksi Yang Anda Cari Tidak Ditemukan');"); Response.Write("location.href = '../Pages/home.aspx';"); Response.Write("</script>"); } }
private bool ServiceSelect(string sm) { switch (sm) { case "V": var Param1 = Request.Params["param1"].ToString(); var Param2 = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List16("P_BERKS1", Param1, Param2, "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["berks1NmrBr1"].ToString() + "|"); //0 Response.Write(dt.Rows[0]["berks1NmrReg"].ToString() + "|"); //1 Response.Write(dt.Rows[0]["berks1NmrPid"].ToString() + "|"); //2 Response.Write(dt.Rows[0]["berks1NmrNeg"].ToString() + "|"); //3 Response.Write(dt.Rows[0]["berks1Novism"].ToString() + "|"); //4 Response.Write(dt.Rows[0]["berks1Lanjut"].ToString() + "|"); //5 Response.Write(dt.Rows[0]["berks1Ketrgn"].ToString() + "|"); //6 Response.Write(dt.Rows[0]["berks1Ekseps"].ToString() + "|"); //7 Response.Write(dt.Rows[0]["berks1Keteks"].ToString() + "|"); //8 dt.Dispose(); Response.End(); Response.End(); return false; case "CRUD": Response.ContentType = "text/plain"; Response.Write(Save()); Response.End(); return false; case "df": Response.Clear(); string namafile = (Request.Params["filelama"] is object ? Request.Params["filelama"].ToString() : ""); String urlfile = (Request.Params["namafile"] is object ? Request.Params["namafile"].ToString() : ""); String randomfile = (Request.Params["random"] is object ? Request.Params["random"].ToString() : ""); string type = ""; switch (namafile.Substring(namafile.Length - 4)) { case ".htm": case ".html": type = "text/HTML"; break; case ".txt": type = "text/plain"; break; case ".doc": case ".docx": case ".rtf": type = "Application/msword"; break; case ".xls": case ".xlsx": type = "Application/msexcel"; break; case ".zip": case ".rar": type = "application/zip"; break; case ".pdf": type = "application/pdf"; break; case ".jpg": type = "image/JPG"; break; case ".pgn": type = "image/PNG"; break; case ".tif": type = "image/tif"; break; } Response.AddHeader("content-disposition", "attachment;filename=" + namafile + ""); Response.ContentType = type; Response.WriteFile(Server.MapPath(@"~/uploaddocument/" + Request.Params["namafile"].ToString().Replace("&", "&"))); Response.End(); return false; break; case "SavePic": Response.ContentType = "text/plain"; Response.Write(SaveUploadPemberkasan()); Response.End(); return false; case "DOCpic": String path_pic = (HttpContext.Current.Request.Url.AbsolutePath).ToLower(); string IDPemberkasan = Request.Params["IDPemberkasan"].ToString(); string param1 = Request.Params["param1"].ToString(); ALMIS.ExecuteSTP eSTPx = new ALMIS.ExecuteSTP(); eSTPx.Datas(); DataSet dsx = new DataSet(); dsx = eSTPx.List7("P_BERKS1_D", param1, IDPemberkasan, "", "", "", "", ""); dt = dsx.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["codessDescs1"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks1Ketrgn"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumFiless"].ToString()) + "</cell>"); Response.Write("<cell>" + "Download^" + path_pic + "?sm=df&namafile=" + dt.Rows[i]["hdocumIdLink"].ToString() + "&filelama=" + dt.Rows[i]["hdocumFiless"].ToString() + "</cell>"); //Response.Write("<cell>" + "Delete^" + path_pic + "?sm=Deletepic&IDSOURCE=" + dt.Rows[i]["IDSource"].ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:DeletePic(\"" + dt.Rows[i]["hdocumIdLink"].ToString()) + "\",\"" + IDPemberkasan + "\");^_self" + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdSour"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdLink"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "E": Response.ContentType = "text/plain"; var param1 = Request.Params["param1"].ToString(); var param2 = Request.Params["param2"].ToString(); var param4 = Request.Params["param4"].ToString(); var param5 = Request.Params["param5"].ToString(); var param11 = Request.Params["param11"].ToString(); var param12 = Request.Params["param12"].ToString(); //var param17 = "hanny"; //session var param9 = Session["userid"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save13("P_VISUMS", param1, param2, "", param4, param5, "", "", "", param9, "", param11, param12, ""); Response.End(); return false; case "L": var param1L = Request.Params["param1"].ToString(); var param2L = Request.Params["param2"].ToString(); var param4L = Request.Params["param4"].ToString(); var param5L = Request.Params["param5"].ToString(); var param12L = Request.Params["param12"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List13("P_VISUMS", param1L, param2L, "", param4L, param5L, "", "", "", userid, "", "", param12L, ""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsNovism"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsAssign"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsVerLnj"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNamPLK"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Assign"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; case "UA": Response.ContentType = "text/plain"; Response.Write(UA()); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
public void HakAkses() { if (Session["userid"] is object) { userid = Session["userid"].ToString(); if (Session["groups"] is object) { groups = Session["groups"].ToString(); } } if (!(Session["userid"] is object)) { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Session sudah habis. Silakan login kembali.');"); Response.Write("location.href = '../Pages/login.aspx';"); Response.Write("</script>"); } ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); var Param1 = ""; bool cek = true; if (cek && (Request.Params["param1"] is object)) { Param1 = Request.Params["param1"].ToString(); } else { Param1 = ""; } ds = eSTP.List8("P_MENU", "CHA", "", groups, "", "", "", "", ""); dt = ds.Tables[0]; MasterIdentitasView = dt.Rows[11]["MasterIdentitas"].ToString(); //0 MasterIdentitasEdit = dt.Rows[11]["MasterIdentitasEdit"].ToString(); //1 MasterIdentitasDelete = dt.Rows[11]["MasterIdentitasDelete"].ToString(); //2 MasterIdentitasAssign = dt.Rows[11]["MasterIdentitasAssign"].ToString(); //3 dt.Dispose(); if (Param1 == "") { if (MasterIdentitasView.ToString() != "1") { if (groups.ToString() != "1") { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Anda Tidak Memiliki Akses Untuk Menambah Di Modul Ini');"); Response.Write("location.href = '../Pages/home.aspx';"); Response.Write("</script>"); } } } else if (Param1 == "F") { if (MasterIdentitasView.ToString() != "1") { if (groups.ToString() != "1") { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Anda Tidak Memiliki Akses Untuk Melihat Di Modul Ini');"); Response.Write("location.href = '../Pages/home.aspx';"); Response.Write("</script>"); } } } else if (Param1 == "E") { if (MasterIdentitasEdit.ToString() != "1") { if (groups.ToString() != "1") { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Anda Tidak Memiliki Akses Untuk Edit Di Modul Ini');"); Response.Write("location.href = '../Pages/home.aspx';"); Response.Write("</script>"); } } } else if (Param1.ToString() == "D") { if (MasterIdentitasDelete.ToString() != "1") { if (groups.ToString() != "1") { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Anda Tidak Memiliki Akses Untuk Delete Di Modul Ini');"); Response.Write("location.href = '../Pages/home.aspx';"); Response.Write("</script>"); } } } else if (Param1.ToString() == "I") { if (MasterIdentitasAssign.ToString() != "1") { if (groups.ToString() != "1") { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Anda Tidak Memiliki Akses Untuk Menambah Di Modul Ini');"); Response.Write("location.href = '../Pages/home.aspx';"); Response.Write("</script>"); } } } else { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Aksi Yang Anda Cari Tidak Ditemukan');"); Response.Write("location.href = '../Pages/home.aspx';"); Response.Write("</script>"); } }
private bool ServiceSelect(string sm) { switch (sm) { case "L": var param1L = Request.Params["param1"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List11("P_USERSS", param1L, "", "", "", "", "", "", "", "", "",""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["UserssIDents"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["UserssNamess"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["UserssGroups"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["UserrsActive"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["UserssKodper"].ToString()) + "</cell>"); if (groups.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("View^UserManagementForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["UserssIDents"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Edit^UserManagementForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["UserssIDents"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^UserManagementForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["UserssIDents"].ToString() + "") + "</cell>"); } else { if (UserManagementView.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("View^UserManagementForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["UserssIDents"].ToString() + "") + "</cell>"); } if (UserManagementEdit.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("Edit^UserManagementForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["UserssIDents"].ToString() + "") + "</cell>"); } if (UserManagementDelete.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("Delete^UserManagementForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["UserssIDents"].ToString() + "") + "</cell>"); } } Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private String CRUD() { param1 = Request.Params["param1"].ToString(); param2 = Request.Params["param2"].ToString(); param4 = Request.Params["param4"].ToString(); param5 = Request.Params["param5"].ToString(); param6 = Request.Params["param6"].ToString(); param7 = Request.Params["param7"].ToString(); param8 = Request.Params["param8"].ToString(); param9 = Request.Params["param9"].ToString(); param10 = Request.Params["param10"].ToString(); param11 = Request.Params["param11"].ToString(); param12 = Request.Params["param12"].ToString(); param13 = Request.Params["param13"].ToString(); param14 = Request.Params["param14"].ToString(); param15 = Request.Params["param15"].ToString(); param16 = Request.Params["param16"].ToString(); param17 = Request.Params["param17"].ToString(); param18 = Request.Params["param18"].ToString(); param19 = Request.Params["param19"].ToString(); param20 = Request.Params["param20"].ToString(); param21 = Request.Params["param21"].ToString(); param22 = Request.Params["param22"].ToString(); param23 = Request.Params["param23"].ToString(); param24 = Request.Params["param24"].ToString(); param25 = Request.Params["param25"].ToString(); param28 = Request.Params["param28"].ToString(); String sql = ""; String output = ""; try { output = param1; if (output == "I") { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List29("P_MINDENT", "X", param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13, param14, param15, param16, param17, param18, param19, param20, param21, param22, param23, param24, param25, userid, param27, param28, "0"); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { if (output == "I") output = "notambah"; return output; } } if (output == "I" || output == "E" || output == "D") //if (output == "E" || output == "D") { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save29("P_MINDENT", param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13, param14, param15, param16, param17, param18, param19, param20, param21, param22, param23, param24, param25, userid, param27, param28, "0"); return output; } //if (output == "I") //{ // LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); // eSTP.Datas(); // DataSet ds = new DataSet(); // eSTP.save26("P_MINDENT", "E", param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13, param14, param15, param16, param17, param18, param19, param20, param21, param22, param23, param24, param25, param26); // return output; //} else output = "gagal"; } catch (Exception ex) { Response.Write(ex.Message); dt.Dispose(); Response.End(); return ex.Message; } return output; }
private String UA() { var Param1 = Request.Params["param1"].ToString(); var Param2 = Request.Params["param2"].ToString(); string output = ""; try { ALMIS.ExecuteSTP eSTP_p = new ALMIS.ExecuteSTP(); eSTP_p.Datas(); DataSet ds_p = new DataSet(); ds_p = eSTP_p.List2("C_ADMINS", Param1, Param2); dt = ds_p.Tables[0]; Response.ContentType = "text/plain"; for (int i = 0; i < dt.Rows.Count; i++) { output += dt.Rows[i]["UserssNamess"].ToString() + "|"; output += dt.Rows[i]["UserssIdents"].ToString() + "*"; } dt.Dispose(); } catch (Exception ex) { Response.Write(ex.Message); } return output; }
private String SaveUploadRegistrasi() { string IDRegistrasi = Request.Params["IDREGISTRASI"].ToString(); string _stNamaFile = Request.Params["NAMA"].ToString(); string _stKeterangan = Request.Params["KETERANGAN"].ToString(); string _stNomor = Request.Params["NOMOR"].ToString(); ALMIS.UploadFile uf = new ALMIS.UploadFile(); uf.Datas(); string _stDates = DateTime.Today.ToString("yyyyMMdd"); string param1 = Request.Params["param1"].ToString(); string param5 = Request.Params["param5"].ToString(); string user = Request.Params["user"].ToString(); string wilayah = Request.Params["wilay"].ToString(); string _stUploadKeterangan = ""; _stUploadKeterangan = _stKeterangan; string uploadFolder = Request.PhysicalApplicationPath + "uploadDocument\\"; string extension = Path.GetExtension(_stNamaFile); ALMIS.paramz ext = new ALMIS.paramz(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); //eSTP.save5("P_REGIST_U", param1, IDRegistrasi, "", param5, _stKeterangan); if (extension != ".exe") { uf.UploadFilesWeb("I", user, _stDates, "Master Identitas", param5, uploadFolder, IDRegistrasi, _stNomor + extension, _stNamaFile, _stUploadKeterangan,"",""); } var _stOutput = IDRegistrasi; return _stOutput; }