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 "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 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 sql = "";
String output = "";
try
{
output = param1;
if (output == "A")
{
LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
ds = eSTP.List7("P_GROUPS", "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" || output == "A")
{
LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
eSTP.save7("P_GROUPS", param1, param2, param3, param4, param5, userid, param7);
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.List7("P_PERUSA", 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]["perusaIdents"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaDatess"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaNamass"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaKeterg"].ToString()) + "</cell>");
if (groups.ToString() == "1")
{
Response.Write("<cell>" + RemoveWhiteSpace("View^MasterPerusahaanForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["perusaIdents"].ToString() + "") + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace("Edit^MasterPerusahaanForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["perusaIdents"].ToString() + "") + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace("Delete^MasterPerusahaanForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["perusaIdents"].ToString() + "") + "</cell>");
}
else
{
if (MasterPerusahaanView.ToString() == "1")
{
Response.Write("<cell>" + RemoveWhiteSpace("View^MasterPerusahaanForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["perusaIdents"].ToString() + "") + "</cell>");
}
if (MasterPerusahaanEdit.ToString() == "1")
{
Response.Write("<cell>" + RemoveWhiteSpace("View^MasterPerusahaanForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["perusaIdents"].ToString() + "") + "</cell>");
}
if (MasterPerusahaanDelete.ToString() == "1")
{
Response.Write("<cell>" + RemoveWhiteSpace("View^MasterPerusahaanForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["perusaIdents"].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;
}
}