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 { LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List2("LANDCOMP.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 String Admin() { var Param1 = Request.Params["param1"].ToString(); var Param2 = Request.Params["param2"].ToString(); string output = ""; try { LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List2("landcomp.C_ADMINS", Param1, Param2); dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { output += dt.Rows[i]["namass"].ToString() + "|"; output += dt.Rows[i]["idents"].ToString() + "*"; } dt.Dispose(); } catch (Exception ex) { Response.Write(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(); LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List23("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 String SaveUploadKelengkapan() { string IDRegistrasi = Request.Params["IDREGISTRASI"].ToString(); string _stNamaFile = Request.Params["NAMA"].ToString(); string _stKeterangan = Request.Params["KETERANGAN"].ToString(); string _stNomor = Request.Params["NOMOR"].ToString(); LANDCOMP.UploadFile uf = new LANDCOMP.UploadFile(); uf.Datas(); string _stDates = DateTime.Today.ToString("yyyyMMdd"); string param1 = Request.Params["param1"].ToString(); string param3 = Request.Params["param3"].ToString(); string param4 = Request.Params["param4"].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); LANDCOMP.paramz ext = new LANDCOMP.paramz(); LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save6("P_REGIST_D", param1, IDRegistrasi, param3, param4, _stKeterangan, ""); if (param3 == "1") { param3 = "10"; } if (param3 == "2") { param3 = "11"; } if (param3 == "3") { param3 = "12"; } if (param3 == "4") { param3 = "13"; } if (extension != ".exe") { uf.UploadFilesWeb("I", user, _stDates, "Registrasi", param3, uploadFolder, IDRegistrasi, _stNomor + extension, _stNamaFile, param4); } var _stOutput = IDRegistrasi; return(_stOutput); }
private bool ServiceSelect(string sm) { switch (sm) { case "L": var param1L = Request.Params["param1"].ToString(); LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List7("P_GROUPS", param1L, "", "", "", "", "", ""); 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]["GroupIDents"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["GroupsNamess"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["GroupsLanjut"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["GroupsExcept"].ToString()) + "</cell>"); if (groupsid == "Operator") { Response.Write("<cell>" + RemoveWhiteSpace("View^PengecekanLapanganForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["GroupIDents"].ToString() + "") + "</cell>"); } else { Response.Write("<cell>" + RemoveWhiteSpace("View^GroupManagementForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["GroupIDents"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Edit^GroupManagementForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["GroupIDents"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^GroupManagementForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["GroupIDents"].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(); LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List2("P_HOME", 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]["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 "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(); LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List34("P_REGIST", 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>"); 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]["praregNmrPra"].ToString()) + "</cell>"); 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]["registAssign"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registLanjut"].ToString()) + "</cell>"); if (dt.Rows[i]["registNmrReg"].ToString() != "") { 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>"); } 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(); var param5L = Request.Params["param5"].ToString(); LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List17("P_BERKS2", 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>"); //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]["berks2NmrBr2"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnNmrByr"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2Assign"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2Slesai"].ToString()) + "</cell>"); //"Status" Tidak Tahu Fieldnya Response.Write("<cell>" + RemoveWhiteSpace("View^PemberkasanDuaForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["pmbyrnNmrByr"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Edit^PemberkasanDuaForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["pmbyrnNmrByr"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^PemberkasanDuaForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["pmbyrnNmrByr"].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 void HakAkses() { //Response.ContentType = "text/plain"; LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List8("P_MENU", "CHA", "", groups, "", "", "", "", ""); dt = ds.Tables[0]; //Response.ContentType = "text/plain"; praregistrasi = dt.Rows[0]["PraRegistrasi"].ToString(); //0 PengecekanLapangan = dt.Rows[1]["PengecekanLapangan"].ToString(); //1 Registrasi = dt.Rows[2]["Registrasi"].ToString(); //2 PengukuranT0 = dt.Rows[5]["PengukuranT0"].ToString(); //3 Verifikasi = dt.Rows[4]["Verifikasi"].ToString(); //4 Negosiasi = dt.Rows[3]["Negosiasi"].ToString(); //5 Pemberkasan = dt.Rows[6]["Pemberkasan"].ToString(); //6 Pembayaran = dt.Rows[7]["Pembayaran"].ToString(); //7 Finalisasi = dt.Rows[8]["Finalisasi"].ToString(); //8 GroupManagement = dt.Rows[9]["GroupManagement"].ToString(); //9 UserManagement = dt.Rows[10]["UserManagement"].ToString(); //10 MasterIdentitas = dt.Rows[11]["MasterIdentitas"].ToString(); //11 MasterPerusahaan = dt.Rows[12]["MasterPerusahaan"].ToString(); //12 MasterCodes = dt.Rows[13]["MasterCodes"].ToString(); //13 MasterMenu = dt.Rows[14]["MasterMenu"].ToString(); //14 SerahTerimaBerkas = dt.Rows[15]["SerahTerimaBerkas"].ToString(); //15 TopPriority = dt.Rows[16]["TopPriority"].ToString(); //16 FiveYears = dt.Rows[17]["FiveYears"].ToString(); //17 LOM = dt.Rows[18]["LOM"].ToString(); //18 Other = dt.Rows[19]["Other"].ToString(); //19 ReportPraRegistrasi = dt.Rows[0]["ReportPraRegistrasi"].ToString(); //20 ReportPengecekanLapangan = dt.Rows[1]["ReportPengecekanLapangan"].ToString(); //21 ReportRegistrasi = dt.Rows[2]["ReportRegistrasi"].ToString(); //22 ReportPengukuranT0 = dt.Rows[3]["ReportPengukuranT0"].ToString(); //23 ReportNegosiasi = dt.Rows[5]["ReportNegosiasi"].ToString(); //24 ReportVerifikasi = dt.Rows[4]["ReportVerifikasi"].ToString(); //25 ReportFinalisasi = dt.Rows[8]["ReportFinalisasi"].ToString(); //26 //Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); //Response.Write("alert('Viky Ganteng');" + ReportFinalisasi); //Response.Write("</script>"); dt.Dispose(); //Response.End(); }
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(); } try { LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save7("P_PENGTO_D", param1, param2, param3, param4, param5, param6, param7); } catch (Exception ex) { Response.Write(ex.Message); Response.End(); return(ex.Message); } return(param1); }
private 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>"); } LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List8("P_MENU", "CHA", "", groups, "", "", "", "", ""); dt = ds.Tables[0]; MasterCodesEdit = dt.Rows[13]["MasterCodesEdit"].ToString(); //0 MasterCodesDelete = dt.Rows[13]["MasterCodesDelete"].ToString(); //1 MasterCodesView = dt.Rows[13]["MasterCodes"].ToString(); //2 MasterCodesAssign = dt.Rows[13]["MasterCodesAssign"].ToString(); //3 dt.Dispose(); if (MasterCodesView.ToString() != "1") { if (groups.ToString() != "1") { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Anda Tidak Memiliki Akses Untuk Melihat Modul Ini');"); Response.Write("location.href = '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(); LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List7("P_PERUSA", Param1, Param2, "", "", "", "", ""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["perusaIdents"].ToString() + "|"); // Response.Write(dt.Rows[0]["perusaDatess"].ToString() + "|"); //1 Response.Write(dt.Rows[0]["perusaNamass"].ToString() + "|"); //2 Response.Write(dt.Rows[0]["perusaKeterg"].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 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(); LANDCOMP.UploadFile uf = new LANDCOMP.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); LANDCOMP.paramz ext = new LANDCOMP.paramz(); LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.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); }
private bool ServiceSelect(string sm) { switch (sm) { case "V": var param1 = Request.Params["param1"].ToString(); var param2 = Request.Params["param2"].ToString(); LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List8("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 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 void HakAkses() { if (Session["userid"] is object) { userid = Session["userid"].ToString(); if (Session["groups"] is object) { groups = Session["groups"].ToString(); } } LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List8("P_MENU", "CHA", "", groups, "", "", "", "", ""); dt = ds.Tables[0]; UserManagementEdit = dt.Rows[10]["UserManagementEdit"].ToString(); //0 UserManagementDelete = dt.Rows[10]["UserManagementDelete"].ToString(); //1 UserManagementView = dt.Rows[10]["UserManagement"].ToString(); //2 UserManagementAssign = dt.Rows[10]["UserManagementAssign"].ToString(); //3 dt.Dispose(); if (UserManagementView.ToString() != "1") { if (groups.ToString() != "1") { Response.Write("<script language=\"javascript\" type=\"text/javascript\">"); Response.Write("alert('Anda Tidak Memiliki Akses Untuk Melihat Modul Ini');"); Response.Write("location.href = 'home.aspx';"); Response.Write("</script>"); } } }
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 sql = ""; String output = ""; try { output = param1; if (output == "E" || output == "D" || output == "A") { LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List23("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") { LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save23("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); return(output); } else { output = "gagal"; } } catch (Exception ex) { Response.Write(ex.Message); Response.End(); return(ex.Message); } return(output); }
private String Save() { //string strCon = System.Configuration.ConfigurationManager.ConnectionStrings["ConStrLANDCOMPLocal2"].ToString(); //conn2 = new Connection(strCon); 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 sql = ""; String output = ""; try { output = param1; if (output == "E" || output == "D" || output == "A") { LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List13("P_NEGOSI", "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") { LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save13("P_NEGOSI", param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13); 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(); LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List8("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>"); 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); } }
public void HakAkses() { if (Session["userid"] is object) { userid = Session["userid"].ToString(); if (Session["groups"] is object) { groups = Session["groups"].ToString(); } } LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.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]; UserManagementView = dt.Rows[10]["UserManagement"].ToString(); //0 UserManagementEdit = dt.Rows[10]["UserManagementEdit"].ToString(); //1 UserManagementDelete = dt.Rows[10]["UserManagementDelete"].ToString(); //2 UserManagementAssign = dt.Rows[10]["UserManagementAssign"].ToString(); //3 dt.Dispose(); if (Param1 == "") { if (UserManagementView.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 = 'home.aspx';"); Response.Write("</script>"); } } } else if (Param1 == "V") { if (UserManagementView.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 = 'home.aspx';"); Response.Write("</script>"); } } } else if (Param1 == "E") { if (UserManagementEdit.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 = 'home.aspx';"); Response.Write("</script>"); } } } else if (Param1.ToString() == "D") { if (UserManagementDelete.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 = '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 = 'home.aspx';"); Response.Write("</script>"); } }
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 sql = ""; String output = ""; try { output = param1; if (output == "E") { LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List8("P_USERSS", "X", param2, param8, "", "", "", "", ""); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { eSTP.Datas(); eSTP.save8("P_USERSS", param1, param2, param3, param4, param5, param6, userid, ""); return(output); } output = "noedit"; return(output); } if (output == "D" || output == "I") { LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); eSTP.save8("P_USERSS", param1, param2, param3, param4, param5, param6, userid, param8); return(output); } } catch (Exception ex) { Response.Write(ex.Message); Response.End(); return(ex.Message); } return(output); }
private bool ServiceSelect(string sm) { switch (sm) { case "V": // Untuk Menampilkan Data Form Registrasi var Param1 = Request.Params["param1"].ToString(); var Param2 = Request.Params["param2"].ToString(); LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List34("P_REGIST", Param1, Param2, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["registNmrReg"].ToString() + "|"); //0 Response.Write(dt.Rows[0]["penlapNmrPen"].ToString() + "|"); //1 Response.Write(dt.Rows[0]["registIdents"].ToString() + "|"); //2 Response.Write(dt.Rows[0]["MidentNamass"].ToString() + "|"); //3 Response.Write(dt.Rows[0]["MidentIdents"].ToString() + "|"); //4 Response.Write(dt.Rows[0]["MidentNamass"].ToString() + "|"); //5 Response.Write(dt.Rows[0]["MidentJnsKel"].ToString() + "|"); //6 Response.Write(dt.Rows[0]["MidentTmplhr"].ToString() + "|"); //7 Response.Write(dt.Rows[0]["MidentTgllhr"].ToString() + "|"); //8 Response.Write(dt.Rows[0]["MidentPekerj"].ToString() + "|"); //9 Response.Write(dt.Rows[0]["MidentNmrPeg"].ToString() + "|"); //10 Response.Write(dt.Rows[0]["MidentAlamat"].ToString() + "|"); //11 Response.Write(dt.Rows[0]["MidentJnsIdn"].ToString() + "|"); //12 Response.Write(dt.Rows[0]["MidentNmrHps"].ToString() + "|"); //13 Response.Write(dt.Rows[0]["MidentStatus"].ToString() + "|"); //14 Response.Write(dt.Rows[0]["MidentNmPsng"].ToString() + "|"); //15 Response.Write(dt.Rows[0]["MidentTmpPas"].ToString() + "|"); //16 Response.Write(dt.Rows[0]["MidentTglPas"].ToString() + "|"); //17 Response.Write(dt.Rows[0]["MidentThnNkh"].ToString() + "|"); //18 Response.Write(dt.Rows[0]["registTy1Sts"].ToString() + "|"); //19 Response.Write(dt.Rows[0]["registTy1Sts"].ToString() + "|"); //20 Response.Write(dt.Rows[0]["registTy2Jml"].ToString() + "|"); //21 Response.Write(dt.Rows[0]["registTy2Sts"].ToString() + "|"); //22 Response.Write(dt.Rows[0]["registAlshak"].ToString() + "|"); //23 Response.Write(dt.Rows[0]["registSHMsss"].ToString() + "|"); //24 Response.Write(dt.Rows[0]["registSHMNmr"].ToString() + "|"); //25 Response.Write(dt.Rows[0]["registSKTsss"].ToString() + "|"); //26 Response.Write(dt.Rows[0]["registSKTNmr"].ToString() + "|"); //27 Response.Write(dt.Rows[0]["registTahuns"].ToString() + "|"); //28 Response.Write(dt.Rows[0]["praregLokkab"].ToString() + "|"); //29 Response.Write(dt.Rows[0]["praregLokkec"].ToString() + "|"); //30 Response.Write(dt.Rows[0]["praregLokdes"].ToString() + "|"); //31 Response.Write(dt.Rows[0]["registLuasss"].ToString() + "|"); //32 Response.Write(dt.Rows[0]["registBtsutr"].ToString() + "|"); //33 Response.Write(dt.Rows[0]["registBtsslt"].ToString() + "|"); //34 Response.Write(dt.Rows[0]["registBtstmr"].ToString() + "|"); //35 Response.Write(dt.Rows[0]["registBtsbrt"].ToString() + "|"); //36 Response.Write(dt.Rows[0]["registTy3Sts"].ToString() + "|"); //37 Response.Write(dt.Rows[0]["registTy3Thn"].ToString() + "|"); //38 Response.Write(dt.Rows[0]["registTy4Sts"].ToString() + "|"); //39 Response.Write(dt.Rows[0]["registTy4Thn"].ToString() + "|"); //40 Response.Write(dt.Rows[0]["registTy5Sts"].ToString() + "|"); //41 Response.Write(dt.Rows[0]["registTy5Thn"].ToString() + "|"); //42 Response.Write(dt.Rows[0]["registKtergn"].ToString() + "|"); //43 Response.Write(dt.Rows[0]["registEkspsi"].ToString() + "|"); //44 Response.Write(dt.Rows[0]["registLanjut"].ToString() + "|"); //45 Response.Write(dt.Rows[0]["registKeteks"].ToString() + "|"); //46 dt.Dispose(); Response.End(); Response.End(); return(false); case "cek": var Param1x = Request.Params["param1"].ToString(); var Param2x = Request.Params["param2"].ToString(); LANDCOMP.ExecuteSTP eSTPx = new LANDCOMP.ExecuteSTP(); eSTPx.Datas(); DataSet dsx = new DataSet(); dsx = eSTPx.List34("P_REGIST", Param1x, "", "", "", "", "", "", "", "", "", "", Param2x, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = dsx.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["duplikat"].ToString() + "|"); //0 Response.Write(dt.Rows[0]["registNmrReg"].ToString() + "|"); //1 dt.Dispose(); Response.End(); return(false); case "LAN": var param1LAN = Request.Params["param1"].ToString(); var param2LAN = Request.Params["param2"].ToString(); LANDCOMP.ExecuteSTP eSTP_LAN = new LANDCOMP.ExecuteSTP(); eSTP_LAN.Datas(); DataSet ds_LAN = new DataSet(); ds_LAN = eSTP_LAN.List34("P_REGIST", param1LAN, param2LAN, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = ds_LAN.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("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return(false); case "LAY": var param1LAY = Request.Params["param1"].ToString(); var param2LAY = Request.Params["param2"].ToString(); LANDCOMP.ExecuteSTP eSTP_LAY = new LANDCOMP.ExecuteSTP(); eSTP_LAY.Datas(); DataSet ds_LAY = new DataSet(); ds_LAY = eSTP_LAY.List34("P_REGIST", param1LAY, param2LAY, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = ds_LAY.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < 1; 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]["MidentNmAyah"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentTglAyh"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentKrjAyh"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentAlmAyh"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return(false); case "LIB": var param1LIB = Request.Params["param1"].ToString(); var param2LIB = Request.Params["param2"].ToString(); LANDCOMP.ExecuteSTP eSTP_LIB = new LANDCOMP.ExecuteSTP(); eSTP_LIB.Datas(); DataSet ds_LIB = new DataSet(); ds_LIB = eSTP_LIB.List34("P_REGIST", param1LIB, param2LIB, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = ds_LIB.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < 1; 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]["MidentNmIbus"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentTglIbu"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentKrjIbu"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentAlmIbu"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return(false); case "CRUD": Response.ContentType = "text/plain"; Response.Write(Save()); Response.End(); return(false); case "ddkl": Response.ContentType = "text/plain"; Response.Write(IsiKelengkapan("1")); Response.End(); return(false); case "IA": string param1IA = Request.Params["param1"].ToString(); string param2IA = Request.Params["param2"].ToString(); string param3IA = Request.Params["param3"].ToString(); string param4IA = Request.Params["param4"].ToString(); string param5IA = Request.Params["param5"].ToString(); string param6IA = Request.Params["param6"].ToString(); LANDCOMP.ExecuteSTP eSTP_IA = new LANDCOMP.ExecuteSTP(); eSTP_IA.Datas(); eSTP_IA.param6("P_REGIST_D", param1IA, param2IA, param3IA, param4IA, param5IA, param6IA); return(false); case "SA": // Untuk Menampilkan Data Grid Kondisi Lahan Dan Ifra Stuktur var param1SA = Request.Params["param1"].ToString(); var param2SA = Request.Params["param2"].ToString(); var param3SA = Request.Params["param3"].ToString(); LANDCOMP.ExecuteSTP eSTP_SA = new LANDCOMP.ExecuteSTP(); eSTP_SA.Datas(); DataSet ds_SA = new DataSet(); ds_SA = eSTP_SA.param6("P_REGIST_D", param1SA, param2SA, param3SA, "", "", ""); 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]["registKondis"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registKeters"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:Hapus(\"" + "DA" + "\",\"" + "DA" + "\",\"" + dt.Rows[i]["registNmrReg"].ToString() + "\",\"" + dt.Rows[i]["registSequen"].ToString() + "\",\"" + dt.Rows[i]["registSequen"].ToString() + "\");^_self") + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); return(false); case "DA": string param1DA = Request.Params["param1"].ToString(); string param2DA = Request.Params["param2"].ToString(); string param3DA = Request.Params["param3"].ToString(); LANDCOMP.ExecuteSTP eSTP_DA = new LANDCOMP.ExecuteSTP(); eSTP_DA.Datas(); eSTP_DA.save6("P_REGIST_D", param1DA, param2DA, "", "", "", param3DA); return(false); case "ListUploadIdentitasLahan": var Param1z = Request.Params["param1"].ToString(); var Param2z = Request.Params["IDRegistrasi"].ToString(); String path_pic = (HttpContext.Current.Request.Url.AbsolutePath).ToLower(); LANDCOMP.ExecuteSTP eSTPz = new LANDCOMP.ExecuteSTP(); eSTPz.Datas(); DataSet dsz = new DataSet(); dsz = eSTPz.List34("P_REGIST", Param1z, Param2z, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); 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>" + "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()) + "\",\"" + Param2z + "\");^_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": var Param1a = Request.Params["param1"].ToString(); var Param2a = Request.Params["IDRegistrasi"].ToString(); String path_pica = (HttpContext.Current.Request.Url.AbsolutePath).ToLower(); LANDCOMP.ExecuteSTP eSTPa = new LANDCOMP.ExecuteSTP(); eSTPa.Datas(); DataSet dsa = new DataSet(); dsa = eSTPa.List6("P_REGIST_D", Param1a, Param2a, "", "", "", ""); 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]["codessDescs1"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["codessDescs2"].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()) + "\",\"" + Param2a + "\");^_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 "SaveUploadRegistrasi": Response.ContentType = "text/plain"; Response.Write(SaveUploadRegistrasi()); Response.End(); return(false); case "SaveUploadKelengkapan": Response.ContentType = "text/plain"; Response.Write(SaveUploadKelengkapan()); 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); default: Response.ContentType = "text/plain"; Response.End(); return(true); } }
private String Save() { 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 param26 = ""; if (Request.Params["param26"] is object) { param26 = Request.Params["param26"].ToString(); } String sql = ""; String output = ""; try { output = param1; if (output == "I" || output == "E" || output == "D") { LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save26("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, param26); 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 "select": var param1SM = Request.Params["param1"].ToString(); var param2SM = Request.Params["param2"].ToString(); LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.param26("P_MINDENT", param1SM, param2SM, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); 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() + "|"); dt.Dispose(); Response.End(); Response.End(); return(false); case "SA": var param1SA = Request.Params["param1"].ToString(); var param2SA = Request.Params["param2"].ToString(); LANDCOMP.ExecuteSTP eSTP_SA = new LANDCOMP.ExecuteSTP(); eSTP_SA.Datas(); DataSet ds_SA = new DataSet(); ds_SA = eSTP_SA.param7("P_MINDENT_A", 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]["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(\"" + "SA" + "\",\"" + "SA" + "\",\"" + dt.Rows[i]["MidentIdents"].ToString() + "\",\"" + dt.Rows[i]["midentSequen"].ToString() + "\");^_self") + "</cell>"); //Response.Write("<cell>" + RemoveWhiteSpace("Edit^javascript:EditDetil(\"" + "UA" + "\",\"" + "UA" + "\",\"" + dt.Rows[i]["MidentIdents"].ToString() + "\",\"" + dt.Rows[i]["midentSequen"].ToString() + "\");^_self") + "</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": var param1SS = Request.Params["param1"].ToString(); var param2SS = Request.Params["param2"].ToString(); LANDCOMP.ExecuteSTP eSTP_SS = new LANDCOMP.ExecuteSTP(); eSTP_SS.Datas(); DataSet ds_SS = new DataSet(); ds_SA = eSTP_SS.param7("P_MINDENT_S", param1SS, param2SS, "", "", "", "", ""); 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 "IA": string param1IA = Request.Params["param1"].ToString(); string param2IA = Request.Params["param2"].ToString(); //string param3IA = Request.Params["param3"].ToString(); string param4IA = Request.Params["param4"].ToString(); string param5IA = Request.Params["param5"].ToString(); string param6IA = Request.Params["param6"].ToString(); string param7IA = Request.Params["param7"].ToString(); LANDCOMP.ExecuteSTP eSTP_IA = new LANDCOMP.ExecuteSTP(); eSTP_IA.Datas(); eSTP_IA.save7("P_MINDENT_A", param1IA, param2IA, "", param4IA, param5IA, param6IA, param7IA); return(false); case "IS": string param1IS = Request.Params["param1"].ToString(); string param2IS = Request.Params["param2"].ToString(); //string param3IS = Request.Params["param3"].ToString(); string param4IS = Request.Params["param4"].ToString(); string param5IS = Request.Params["param5"].ToString(); string param6IS = Request.Params["param6"].ToString(); string param7IS = Request.Params["param7"].ToString(); LANDCOMP.ExecuteSTP eSTP_IS = new LANDCOMP.ExecuteSTP(); eSTP_IS.Datas(); eSTP_IS.save7("P_MINDENT_S", param1IS, param2IS, "", param4IS, param5IS, param6IS, param7IS); return(false); case "DA": string param1DA = Request.Params["param1"].ToString(); string param2DA = Request.Params["param2"].ToString(); string param3DA = Request.Params["param3"].ToString(); LANDCOMP.ExecuteSTP eSTP_DA = new LANDCOMP.ExecuteSTP(); eSTP_DA.Datas(); eSTP_DA.save7("P_MINDENT_A", param1DA, param2DA, param3DA, "", "", "", ""); return(false); case "DS": string param1DS = Request.Params["param1"].ToString(); string param2DS = Request.Params["param2"].ToString(); string param3DS = Request.Params["param3"].ToString(); LANDCOMP.ExecuteSTP eSTP_DS = new LANDCOMP.ExecuteSTP(); eSTP_DS.Datas(); eSTP_DS.save7("P_MINDENT_S", param1DS, param2DS, param3DS, "", "", "", ""); return(false); case "Save": Response.ContentType = "text/plain"; Response.Write(Save()); Response.End(); return(false); case "Insert": Response.ContentType = "text/plain"; Response.Write(Save()); Response.End(); return(false); case "Delete": 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 "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(); LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List11("P_VISUMS", 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>"); //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]["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>"); if (dt.Rows[i]["visumsNovism"].ToString() != "") { if (groups.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("View^VisumForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Edit^VisumForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^VisumForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>"); } else { if (dt.Rows[i]["visumsVerLnj"].ToString() != "Lanjut") { if (VerifikasiView.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("View^VisumForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>"); } if (VerifikasiEdit.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("Edit^VisumForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>"); } if (VerifikasiDelete.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("Delete^VisumForm.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 "select": var Param1 = Request.Params["param1"].ToString(); var Param2 = Request.Params["param2"].ToString(); LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.select9("landcomp.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 dt.Dispose(); Response.End(); Response.End(); return(false); case "Save": Response.ContentType = "text/plain"; Response.Write(Save()); Response.End(); return(false); case "Delete": Response.ContentType = "text/plain"; Response.Write(Delete()); 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 String Delete() { 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) { param8 = Request.Params["param9"].ToString(); } String sql = ""; String output = ""; try { output = param1; if (output == "I" || output == "E" || output == "D") { LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List9("P_PRAREG", "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); } eSTP.Datas(); eSTP.save9("P_PRAREG", param1, param2, param3, param4, param5, param6, param7, param8, param9); 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(); LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List20("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 dt.Dispose(); Response.End(); Response.End(); return(false); //return false; case "CRUD": Response.ContentType = "text/plain"; Response.Write(Save()); 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(); LANDCOMP.ExecuteSTP eSTPx = new LANDCOMP.ExecuteSTP(); eSTPx.Datas(); DataSet dsx = new DataSet(); dsx = eSTPx.List20("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(); LANDCOMP.ExecuteSTP eSTP_SA = new LANDCOMP.ExecuteSTP(); eSTP_SA.Datas(); DataSet ds_SA = new DataSet(); ds_SA = eSTP_SA.param7("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); } }
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>"); } LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List8("P_MENU", "CHA", "", groups, "", "", "", "", ""); dt = ds.Tables[0]; PembayaranView = dt.Rows[7]["Pembayaran"].ToString(); //0 PembayaranEdit = dt.Rows[7]["PembayaranEdit"].ToString(); //1 PembayaranDelete = dt.Rows[7]["PembayaranDelete"].ToString(); //2 PembayaranAssign = dt.Rows[7]["PembayaranAssign"].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 = '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 = '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 = '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 = '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 = 'home.aspx';"); Response.Write("</script>"); } }
private String Save() { 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) { param8 = Request.Params["param9"].ToString(); } String sql = ""; String output = ""; try { output = param1; if (output == "I" || output == "E" || output == "D") { LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save9("P_PRAREG", param1, param2, param3, param4, param5, param6, param7, param8, param9); 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 "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 param17 = "hanny"; //session var param32 = Session["userid"].ToString(); LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List34("P_REGIST", param1, param2, "", param4, param5, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", param32, "", param34); 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(); LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List34("P_REGIST", 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]["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]["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); default: Response.ContentType = "text/plain"; Response.End(); return(true); } }