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 param21 = Request.Params["param21"].ToString();
var param22 = Session["userid"].ToString();
var param24 = Request.Params["param24"].ToString();
ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
eSTP.save25("P_PMBYRN", param1, param2, "", param4, param5, param6, param7, param8, "", "", "", "", "", "", "", "", "", "", "", "", param21, param22, "", param24, "");
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 param24L = Request.Params["param24"].ToString();
ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP();
eSTP_L.Datas();
DataSet ds_L = new DataSet();
ds_L = eSTP_L.List25("P_PMBYRN", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userid, "", param24L, "");
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]["pmbyrnNmrByr"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks1NmrReg"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnAssign"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnLnjuts"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaNamass"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Assign"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks1NmrNeg"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsNovism"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks1NmrBr1"].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 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 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.List25("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")
{
ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
eSTP.save25("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, param24, "0");
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();
ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
ds = eSTP.List25("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 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 param24L = Request.Params["param24"].ToString();
ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP();
eSTP_L.Datas();
DataSet ds_L = new DataSet();
ds_L = eSTP_L.List25("P_PMBYRN", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userid, "", param24L, "");
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]["pmbyrnNmrByr"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks1NmrReg"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnAssign"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnLnjuts"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaNamass"].ToString()) + "</cell>");
if (dt.Rows[i]["pmbyrnNmrByr"].ToString() != "")
{
if (groups.ToString() == "1")
{
Response.Write("<cell>" + RemoveWhiteSpace("View^PembayaranForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["berks1NmrBr1"].ToString() + "") + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace("Edit^PembayaranForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["berks1NmrBr1"].ToString() + "") + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace("Delete^PembayaranForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["berks1NmrBr1"].ToString() + "") + "</cell>");
}
else
{
if (dt.Rows[i]["pmbyrnLnjuts"].ToString() != "Sepakat")
{
if (PembayaranView.ToString() == "1")
{
Response.Write("<cell>" + RemoveWhiteSpace("View^PembayaranForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["berks1NmrBr1"].ToString() + "") + "</cell>");
}
if (PembayaranEdit.ToString() == "1")
{
Response.Write("<cell>" + RemoveWhiteSpace("Edit^PembayaranForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["berks1NmrBr1"].ToString() + "") + "</cell>");
}
if (PembayaranDelete.ToString() == "1")
{
Response.Write("<cell>" + RemoveWhiteSpace("Delete^PembayaranForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["berks1NmrBr1"].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;
}
}