private bool ServiceSelect(string sm) { switch (sm) { case "E": Response.ContentType = "text/plain"; var param1 = Request.Params["param1"].ToString(); var param2 = Request.Params["param2"].ToString(); var param4 = Request.Params["param4"].ToString(); var param5 = Request.Params["param5"].ToString(); var param11 = Request.Params["param11"].ToString(); var param12 = Request.Params["param12"].ToString(); //var param17 = "hanny"; //session var param9 = Session["userid"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save13("P_VISUMS", param1, param2, "", param4, param5, "", "", "", param9, "", param11, param12, ""); Response.End(); return false; case "L": var param1L = Request.Params["param1"].ToString(); var param2L = Request.Params["param2"].ToString(); var param4L = Request.Params["param4"].ToString(); var param5L = Request.Params["param5"].ToString(); var param12L = Request.Params["param12"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List13("P_VISUMS", param1L, param2L, "", param4L, param5L, "", "", "", userid, "", "", param12L, ""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsNovism"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsAssign"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsVerLnj"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNamPLK"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaNamass"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Assign"].ToString()) + "</cell>"); Response.Write("</row>"); } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; case "UA": Response.ContentType = "text/plain"; Response.Write(UA()); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
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 sql = ""; String output = ""; try { output = param1; if (output == "E" || output == "D" || output == "A") { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List13("P_VISUMS", "X", param2, "", "", "", "", "", "", "", "", "", "", ""); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { if (output == "E") output = "noedit"; if (output == "D") output = "nodelete"; if (output == "A") output = "noadd"; return output; } } if (output == "I" || output == "E" || output == "D") { ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); eSTP.save13("P_VISUMS", param1, param2, param3, param4, param5, param6, param7, param8, userid, 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(); var param2L = Request.Params["param2"].ToString(); var param4L = Request.Params["param4"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List10("P_VISUMS_D", param1L, param2L, "", param4L, "", "", "", "", "", ""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); if (param1L == "LRK") { for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsCodess"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsKtrgn"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsRekom"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsAksi"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsSequen"].ToString()) + "</cell>"); Response.Write("</row>"); } } else { for (int i = 0; i < dt.Rows.Count; i++) { Random r = new Random(); Response.Write("<row id=\"" + (i + 1).ToString() + "\">"); Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsCodess"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsKtrgn"].ToString()) + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Hapus^javascript:Hapus(\"" + "DO" + "\",\"" + "DO" + "\",\"" + dt.Rows[i]["visumsNovism"].ToString() + "\",\"" + dt.Rows[i]["visumsSequen"].ToString() + "\",\"" + "\");^_self") + "</cell>"); Response.Write("</row>"); } } Response.Write("</rows>"); dt.Dispose(); Response.End(); Response.End(); return false; case "V": var Param1 = Request.Params["param1"].ToString(); var Param2 = Request.Params["param2"].ToString(); ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP(); eSTP.Datas(); DataSet ds = new DataSet(); ds = eSTP.List13("P_VISUMS", Param1, Param2, "", "", "", "", "", "", "", "", "", "", ""); dt = ds.Tables[0]; Response.ContentType = "text/plain"; Response.Write(dt.Rows[0]["visumsNovism"].ToString() + "|"); //0 Response.Write(dt.Rows[0]["registNmrReg"].ToString() + "|"); //1 Response.Write(dt.Rows[0]["pengtoNmrPid"].ToString() + "|"); //2 Response.Write(dt.Rows[0]["visumsVerLnj"].ToString() + "|"); //3 Response.Write(dt.Rows[0]["visumsEkseps"].ToString() + "|"); //4 Response.Write(dt.Rows[0]["VisumsKetEks"].ToString() + "|"); //5 dt.Dispose(); Response.End(); Response.End(); return false; case "CRUD": Response.ContentType = "text/plain"; Response.Write(Save()); Response.End(); return false; case "CRUDOS": Response.ContentType = "text/plain"; Response.Write(SaveOS()); Response.End(); return false; default: Response.ContentType = "text/plain"; Response.End(); return true; } }
private bool ServiceSelect(string sm) { switch (sm) { case "L": HakAkses(); var param1L = Request.Params["param1"].ToString(); var param2L = Request.Params["param2"].ToString(); var param4L = Request.Params["param4"].ToString(); var param5L = Request.Params["param5"].ToString(); var param12L = Request.Params["param12"].ToString(); ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP(); eSTP_L.Datas(); DataSet ds_L = new DataSet(); ds_L = eSTP_L.List13("P_VISUMS", param1L, param2L, "", param4L, param5L, "", "", "", userid, "", "", param12L, ""); dt = ds_L.Tables[0]; Response.ContentType = "application/xhtml+xml"; Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); Response.Write("<rows>"); //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>"); Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaNamass"].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; } }