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 "select": 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.List12("almis.P_PRAREG", Param1, Param2, "", "", "", "", "", "", "", "", "",""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["praregNmrPra"].ToString() + "|"); //0 Response.Write(dt.Rows[0]["praregIdents"].ToString() + "|"); //1 Response.Write(dt.Rows[0]["MidentNamass"].ToString() + "|"); //2 Response.Write(dt.Rows[0]["MidentJnsKel"].ToString() + "|"); //3 Response.Write(dt.Rows[0]["MidentTmplhr"].ToString() + "|"); //4 Response.Write(dt.Rows[0]["MidentTgllhr"].ToString() + "|"); //5 Response.Write(dt.Rows[0]["MidentPekerj"].ToString() + "|"); //6 Response.Write(dt.Rows[0]["MidentAlamat"].ToString() + "|"); //7 Response.Write(dt.Rows[0]["MidentNmrHps"].ToString() + "|"); //8 Response.Write(dt.Rows[0]["MidentJnsIdn"].ToString() + "|"); //9 Response.Write(dt.Rows[0]["praregLokkab"].ToString() + "|"); //10 Response.Write(dt.Rows[0]["praregLokkec"].ToString() + "|"); //11 Response.Write(dt.Rows[0]["praregLokdes"].ToString() + "|"); //12 Response.Write(dt.Rows[0]["praregLanjut"].ToString() + "|"); //13 Response.Write(dt.Rows[0]["praregKodper"].ToString() + "|"); //14 dt.Dispose(); Response.End(); Response.End(); return false; case "CRUD": Response.ContentType = "text/plain"; Response.Write(CRUD()); Response.End(); return false; case "dd": Response.ContentType = "text/plain"; Response.Write(Admin()); 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 param11L = Request.Params["param11"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List12("P_PRAREG", param1L, param2L, "", param4L, param5L, "", "", "", userid, "", param11L, ""); 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]["praregNmrPra"].ToString()) + "</cell>"); 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]["praregLokkab"].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]["perusaNamass"].ToString()) + "</cell>"); if (dt.Rows[i]["praregNmrPra"].ToString() != "") { if (groups.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("View^PraregistrasiForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["praregNmrPra"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Edit^PraregistrasiForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["praregNmrPra"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^PraregistrasiForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["praregNmrPra"].ToString() + "") + "</cell>"); } else { //if (dt.Rows[i]["pengtoLanjut"].ToString() != "Lanjut") //{ if (PraRegistrasiView.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("View^PraregistrasiForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["praregNmrPra"].ToString() + "") + "</cell>"); } if (PraRegistrasiEdit.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("Edit^PraregistrasiForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["praregNmrPra"].ToString() + "") + "</cell>"); } if (PraRegistrasiDelete.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("Delete^PraregistrasiForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["praregNmrPra"].ToString() + "") + "</cell>"); } //} } } Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private String CRUD() { 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" || output == "E" || output == "D") { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List12("P_PRAREG", "X", param2, param3, param4, param5, param6, param7, param8, userid, param10, param11, "0"); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { if (output == "E") output = "noedit"; if (output == "D") output = "nodelete"; if (output == "D") output = "notam"; return output; } } if (output == "I" || output == "E" || output == "D") { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save12("P_PRAREG", param1, param2, param3, param4, param5, param6, param7, param8, userid, param10, param11, "0"); return output; } else output = "gagal"; } catch (Exception ex) { Response.Write(ex.Message); Response.End(); return ex.Message; } return output; }