private bool ServiceSelect(string sm) { switch (sm) { case "E": Response.ContentType = "text/plain"; var param1 = Request.Params["param1"].ToString(); var param2 = Request.Params["param2"].ToString(); var param4 = Request.Params["param4"].ToString(); var param5 = Request.Params["param5"].ToString(); var param6 = Request.Params["param6"].ToString(); var param7 = Request.Params["param7"].ToString(); var param8 = Request.Params["param8"].ToString(); var param9 = Request.Params["param9"].ToString(); // var param10 = Request.Params["param10"].ToString(); var param15 = Request.Params["param15"].ToString(); var param16 = Session["userid"].ToString(); LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save17("P_BERKS2", param1, param2, "", param4, param5, param6, param7, param8, param9, "", "", "", "", "", param15, param16, ""); 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.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>"); 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]["pmbyrnNmrPid"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2Assign"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2Slesai"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Assign"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnNmrNeg"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnNovism"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnNmrPbr"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnNmrByr"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnNmrReg"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private String 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 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.List17("P_BERKS2", "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.save17("P_BERKS2", param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13, param14, param15, param16, param17); 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.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; } }
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.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]["pmbyrnNmrReg"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnNmrPid"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2Assign"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2Slesai"].ToString()) + "</cell>"); if (dt.Rows[i]["berks2NmrBr2"].ToString() != "") { if (groups.ToString() == "1") { 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>"); } else { if (dt.Rows[i]["berks2Slesai"].ToString() != "Lanjut") { if (FinalisasiView.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("View^PemberkasanDuaForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["pmbyrnNmrByr"].ToString() + "") + "</cell>"); } if (FinalisasiEdit.ToString() == "1") { Response.Write("<cell>" + RemoveWhiteSpace("Edit^PemberkasanDuaForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["pmbyrnNmrByr"].ToString() + "") + "</cell>"); } if (FinalisasiDelete.ToString() == "1") { 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; } }