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 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 "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.param26("P_MINDENT", Param1z, Param2z, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); //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>" + 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>" + 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()) + "\",\"" + 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 "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; case "SaveUploadRegistrasi": Response.ContentType = "text/plain"; Response.Write(SaveUploadRegistrasi()); 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 "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.List17("P_BERKS2", Param1, Param2, "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["berks2NmrBr2"].ToString() + "|"); //0 Response.Write(dt.Rows[0]["pmbyrnNmrByr"].ToString() + "|"); //1 Response.Write(dt.Rows[0]["berks2NmrReg"].ToString() + "|"); //2 Response.Write(dt.Rows[0]["berks2NmrPid"].ToString() + "|"); //3 Response.Write(dt.Rows[0]["pmbyrnNmrNeg"].ToString() + "|"); //4 Response.Write(dt.Rows[0]["pmbyrnNovism"].ToString() + "|"); //5 Response.Write(dt.Rows[0]["pmbyrnNmrPbr"].ToString() + "|"); //6 Response.Write(dt.Rows[0]["berks2NmrByr"].ToString() + "|"); //7 Response.Write(dt.Rows[0]["berks2Ketrgn"].ToString() + "|"); //8 Response.Write(dt.Rows[0]["berks2Slesai"].ToString() + "|"); //9 Response.Write(dt.Rows[0]["berks2Ekseps"].ToString() + "|"); //10 Response.Write(dt.Rows[0]["berks2EKeteks"].ToString() + "|"); //11 dt.Dispose(); Response.End(); Response.End(); return false; case "CRUD": Response.ContentType = "text/plain"; Response.Write(Save()); Response.End(); return false; case "SavePic": Response.ContentType = "text/plain"; Response.Write(SaveUploadFinal()); Response.End(); return false; case "DOCpic": String path_pic = (HttpContext.Current.Request.Url.AbsolutePath).ToLower(); string IDFinal = Request.Params["IDFinal"].ToString(); string param1 = Request.Params["param1"].ToString(); LANDCOMP.ExecuteSTP eSTPx = new LANDCOMP.ExecuteSTP(); eSTPx.Datas(); DataSet dsx = new DataSet(); dsx = eSTPx.List6("P_BERKS2_D", param1, IDFinal, "", "", "", ""); dt = dsx.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["codessDescs1"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2Ketrgn"].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()) + "\",\"" + IDFinal + "\");^_self" + "</cell>"); //output += "<cell>" + RemoveWhiteSpace("Delete^javascript:Delete(\"D\",\"AMR\",\"" + dt.Rows[i]["IDSOURCE"].ToString() + "\",\"" + dt.Rows[i]["IDAMR"].ToString() + "\",\"" + userID) + "\");^_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("&", "&"))); Response.End(); return false; break; default: Response.ContentType = "text/plain"; Response.End(); return true; } }