/// <summary>
/// Using the base url, invokes the WebMethod with the given name
/// </summary>
/// <param name="methodName">Web Method name</param>
public void Invoke(string methodName)
{
Tools tool = new Tools();
int idNEPSBI_PROC;
using (EntitiesNetworkElement data_nepsbi = new EntitiesNetworkElement())
{
var id_process = (from p in data_nepsbi.BI_PROC_GRN_OSP
select p).OrderByDescending(p => p.PROC_ID).First();
idNEPSBI_PROC = Convert.ToInt32(id_process.PROC_ID);
}
string jobid = "";
string userId = "";
foreach (var param in Params)
{
if (param.Key == "UserId")
{
userId = param.Value;
}
if (param.Key == "JobId")
{
jobid = param.Value;
}
}
Invoke(methodName, true, idNEPSBI_PROC);
}
/// <summary>
/// Invokes a Web Method, with its parameters encoded or not.
/// </summary>
/// <param name="methodName">Name of the web method you want to call (case sensitive)</param>
/// <param name="encode">Do you want to encode your parameters? (default: true)</param>
private void Invoke(string methodName, bool encode, int proc_id)
{
Tools tool = new Tools();
bool success = true;
AssertCanInvoke(methodName);
string jobid = "";
string userId = "";
foreach (var param in Params)
{
if (param.Key == "UserId")
{
userId = param.Value;
}
if (param.Key == "JobId")
{
jobid = param.Value;
}
}
string soapStr = "";
int idNEPSBI_REQ;
using (Entities7 ctxData = new Entities7())
{
var pathData = (from p in ctxData.WV_LOAD_PATH_CONSUMER_ODP
where p.JOBID == jobid
select p);
foreach (var data_val in pathData)
{
soapStr =
@"<?xml version=""1.0"" encoding=""utf-8""?>
<soap:Envelope xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance""
xmlns:xsd=""http://www.w3.org/2001/XMLSchema""
xmlns:soap=""http://schemas.xmlsoap.org/soap/envelope/""
xmlns:nep=""http://www.tm.com.my/hsbb/eai/NEPSLoadPathConsumer/"">
<soap:Body>
<nep:NEPSLoadPathConsumerRequest>
<!--Optional:-->
<eventName>NEPSLoadPathConsumer</eventName>
<UserId>" + userId + @"</UserId>
<EquipmentASide>
<!--Optional:-->
<AName>" + data_val.ANAME + @"</AName>
<!--Optional:-->
<ASite>" + data_val.ASITE + @"</ASite>
<!--Optional:-->
<AType>" + data_val.ATYPE + @"</AType>
<ESide>
<!--Optional:-->
<ACard2>" + data_val.ACARD2 + @"</ACard2>
<!--Optional:-->
<APort2>" + data_val.APORT2 + @"</APort2>
</ESide>
<Splitter>
<!--Optional:-->
<ACard3>" + data_val.ACARD3 + @"</ACard3>
<!--Optional:-->
<APort3>" + data_val.APORT3 + @"</APort3>
</Splitter>
</EquipmentASide>
<EquipmentZSide>
<!--Optional:-->
<ZName>" + data_val.ZNAME + @"</ZName><ZSite>" + data_val.ZSITE + @"</ZSite>
<!--Optional:-->
<!--Optional:-->
<ZType>" + data_val.ZTYPE + @"</ZType>
<!--Optional:-->
<ZCard>" + data_val.ZCARD + @"</ZCard><ZPort>" + data_val.ZPORT + @"</ZPort>
</EquipmentZSide>
<EquipDP>
<DPName>" + data_val.DPNAME + @"</DPName>
<DPSite>" + data_val.DPSITE + @"</DPSite><DPPort>" + data_val.DPPORT + @"</DPPort>
<!--Optional:-->
</EquipDP>
</nep:NEPSLoadPathConsumerRequest>
</soap:Body>
</soap:Envelope>";
using (EntitiesNetworkElement data_nepsbi = new EntitiesNetworkElement())
{
var id_process = (from p in data_nepsbi.BI_GRNOSPDLDPATHCONS_REQ
select p).OrderByDescending(p => p.REQUEST_ID).First();
idNEPSBI_REQ = Convert.ToInt32(id_process.REQUEST_ID) + 1;
}
string sqlStr = "insert into NEPSBI.BI_GRNOSPDLDPATHCONS_REQ(REQUEST_ID,PROC_ID,TIME_SENT,EVENTNAME,USERID,ANAME ,ASITE ,ATYPE ,ACARD2,APORT2,ACARD3,APORT3,ZNAME ,ZSITE ,ZTYPE ,ZCARD ,ZPORT ,DPNAME,DPSITE,DPPORT) values";
OracleParameter[] oraPrm = new OracleParameter[20];
oraPrm[0] = new OracleParameter("v_REQUEST_ID", OracleDbType.Int32);
oraPrm[0].Value = idNEPSBI_REQ;
oraPrm[1] = new OracleParameter("v_PROC_ID", OracleDbType.Varchar2);
oraPrm[1].Value = proc_id;
oraPrm[2] = new OracleParameter("v_TIME_SENT", OracleDbType.TimeStamp);
oraPrm[2].Value = DateTime.Now;
oraPrm[3] = new OracleParameter("v_EVENTNAME", OracleDbType.Varchar2);
oraPrm[3].Value = "NEPSLoadPathConsumer";
oraPrm[4] = new OracleParameter("v_CLASS", OracleDbType.Varchar2);
oraPrm[4].Value = "Webview.Granite.LoadPath";
oraPrm[5] = new OracleParameter("v_ANAME", OracleDbType.Varchar2);
oraPrm[5].Value = data_val.ANAME;
oraPrm[6] = new OracleParameter("v_ASITE", OracleDbType.Varchar2);
oraPrm[6].Value = data_val.ASITE;
oraPrm[7] = new OracleParameter("v_ATYPE", OracleDbType.Varchar2);
oraPrm[7].Value = data_val.ATYPE;
oraPrm[8] = new OracleParameter("v_ACARD2", OracleDbType.Varchar2);
oraPrm[8].Value = data_val.ACARD2;
oraPrm[9] = new OracleParameter("v_APORT2", OracleDbType.Varchar2);
oraPrm[9].Value = data_val.APORT2;
oraPrm[10] = new OracleParameter("v_ACARD3", OracleDbType.Varchar2);
oraPrm[10].Value = data_val.ACARD3;
oraPrm[11] = new OracleParameter("v_APORT3", OracleDbType.Varchar2);
oraPrm[11].Value = data_val.APORT3;
oraPrm[12] = new OracleParameter("v_ZNAME", OracleDbType.Varchar2);
oraPrm[12].Value = data_val.ZNAME;
oraPrm[13] = new OracleParameter("v_ZSITE", OracleDbType.Varchar2);
oraPrm[13].Value = data_val.ZSITE;
oraPrm[14] = new OracleParameter("v_ZTYPE", OracleDbType.Varchar2);
oraPrm[14].Value = data_val.ZTYPE;
oraPrm[15] = new OracleParameter("v_ZCARD", OracleDbType.Varchar2);
oraPrm[15].Value = data_val.ZCARD;
oraPrm[16] = new OracleParameter("v_ZPORT", OracleDbType.Varchar2);
oraPrm[16].Value = data_val.ZPORT;
oraPrm[17] = new OracleParameter("v_DPNAME", OracleDbType.Varchar2);
oraPrm[17].Value = data_val.DPNAME;
oraPrm[18] = new OracleParameter("v_DPSITE", OracleDbType.Varchar2);
oraPrm[18].Value = data_val.DPSITE;
oraPrm[19] = new OracleParameter("v_DPPORT", OracleDbType.Varchar2);
oraPrm[19].Value = data_val.DPPORT;
string result2 = tool.ExecuteStored(connString, sqlStr, CommandType.StoredProcedure, oraPrm, false);
System.Diagnostics.Debug.WriteLine("result :" + result2);
HttpWebRequest req = (HttpWebRequest)WebRequest.Create(Url);
req.Headers.Add("SOAPAction", "\"http://tempuri.org/" + methodName + "\"");
req.ContentType = "text/xml;charset=\"utf-8\"";
req.Accept = "text/xml";
req.Method = "POST";
//Stream stm = req.GetRequestStream();
//StreamWriter stmw = new StreamWriter(stm);
//stmw.Write(soapStr);
////StreamReader objReader = new StreamReader(req.GetResponse().GetResponseStream());
//WebResponse wr = req.GetResponse();
//Stream receiveStream = wr.GetResponseStream();
//StreamReader reader = new StreamReader(receiveStream);
//string result = reader.ReadToEnd();
//ResponseSOAP = XDocument.Parse(Utils.UnescapeString(result));
//ExtractResult(methodName, proc_id, idNEPSBI_REQ);
//req.Timeout = 300000;
//req.AllowWriteStreamBuffering = true;
using (Stream stm = req.GetRequestStream())
{
//string postValues = "";
//foreach (var param in Params)
//{
// if (encode) postValues += string.Format("<{0}>{1}</{0}>", HttpUtility.HtmlEncode(param.Key), HttpUtility.HtmlEncode(param.Value));
// else postValues += string.Format("<{0}>{1}</{0}>", param.Key, param.Value);
//}
//soapStr = string.Format(soapStr, methodName, postValues);
using (StreamWriter stmw = new StreamWriter(stm))
{
//Response.BufferOutput = true;
stmw.Write(soapStr);
stmw.Close();
}
}
using (StreamReader responseReader = new StreamReader(req.GetResponse().GetResponseStream()))
{
string result = responseReader.ReadToEnd();
ResponseSOAP = XDocument.Parse(Utils.UnescapeString(result));
ExtractResult(methodName, proc_id, idNEPSBI_REQ);
}
}
}
}
public ActionResult GetDetails_Batch(int id)
{
string outputATag = "";
string outputATagNis = "";
string output046 = "";
string output047 = "";
string output048 = "";
string output049 = "";
string output309 = "";
string output310 = "";
//string soutput310 = "";
string output311 = "";
string output312 = "";
string output589 = "";
string output591 = "";
using (EntitiesNetworkElement ctxData = new EntitiesNetworkElement())
{
var query = (from p in ctxData.BI_BATCH
where p.BATCH_ID == id
select p).Single();
var checkATag = (from a in ctxData.BI_ASSET_TAGGING
where a.BI_BATCH_ID == id
select a).Count();
var checkATagNis = (from a in ctxData.BI_ASSET_TAGGING_NIS
where a.BI_BATCH_ID == id
select a).Count();
var check046 = (from a in ctxData.BI_NNW_PU_MAST
where a.BI_BATCH_ID == id
select a).Count();
var check047 = (from a in ctxData.BI_NNW_MAT_MAST
where a.BI_BATCH_ID == id
select a).Count();
var check048 = (from a in ctxData.BI_NNW_PU_MAT_REF
where a.BI_BATCH_ID == id
select a).Count();
var check049 = (from a in ctxData.BI_CONTRACT
where a.BI_BATCH_ID == id
select a).Count();
var check309 = (from a in ctxData.BI_NNW_EXT_SCH_GEM
where a.BI_BATCH_ID == id
select a).Count();
var check310 = (from a in ctxData.BI_NNW_GEM_PROJNO
where a.BI_BATCH_ID == id
select a).Count();
var check311 = (from a in ctxData.BI_TOGEMS_SEQ1
where a.BI_BATCH_ID == id
select a).Count();
var check312 = (from a in ctxData.BI_GEMS_BOQ_MAT
where a.BI_BATCH_ID == id
select a).Count();
var check589 = (from a in ctxData.BI_ASSET_NO
where a.BI_BATCH_ID == id
select a).Count();
var check591 = (from a in ctxData.BI_DECOMM_TABLE
where a.BI_BATCH_ID == id
select a).Count();
if (checkATag > 0)
{
var queryATag = (from a in ctxData.BI_ASSET_TAGGING
where a.BI_BATCH_ID == id
select new
{
a.ASSET_NO,
a.CABLE_EQUIP_ID,
a.TAGGING_DATE,
a.LAST_INVENTORY_ON,
a.EXC_ABB,
a.TYPE_NAME,
a.VERIFICATION_STATUS
});
System.Diagnostics.Debug.WriteLine(queryATag);
if (queryATag.Count() > 0)
{
int counter = 0;
foreach (var lp in queryATag)
{
counter++;
string carry = "";
outputATag += lp.ASSET_NO.ToString() + "|" + lp.CABLE_EQUIP_ID.ToString() + "|" + lp.TAGGING_DATE.ToString() + "|" + lp.LAST_INVENTORY_ON.ToString() + "|" + lp.EXC_ABB + "|" + lp.TYPE_NAME + "|" + lp.VERIFICATION_STATUS;
outputATag += "!";
System.Diagnostics.Debug.WriteLine("agak:" + outputATag);
}
}
}
if (checkATagNis > 0)
{
var queryATagNis = (from a in ctxData.BI_ASSET_TAGGING_NIS
where a.BI_BATCH_ID == id
select new
{
a.NIS_ID,
a.ASSET_NO,
a.TAGGING_DATE,
a.LAST_INVENTORY_ON,
a.EXCHANGE_CODE,
a.TYPE_NAME,
a.VERIFICATION_STATUS
});
System.Diagnostics.Debug.WriteLine(queryATagNis);
if (queryATagNis.Count() > 0)
{
int counter = 0;
foreach (var lp in queryATagNis)
{
counter++;
string carry = "";
outputATagNis += lp.NIS_ID.ToString() + "|" + lp.ASSET_NO.ToString() + "|" + lp.TAGGING_DATE.ToString() + "|" + lp.LAST_INVENTORY_ON.ToString() + "|" + lp.EXCHANGE_CODE + "|" + lp.TYPE_NAME + "|" + lp.VERIFICATION_STATUS;
outputATagNis += "!";
System.Diagnostics.Debug.WriteLine("agak:" + outputATagNis);
}
}
}
if (check046 > 0)
{
var query046 = (from a in ctxData.BI_NNW_PU_MAST
where a.BI_BATCH_ID == id
select new
{
a.PU_ID,
a.PU_DESC,
a.PU_INST_PR,
a.PU_UOM,
a.NETWORK_FLAG,
a.BILL_RATE
});
System.Diagnostics.Debug.WriteLine(query);
if (query046.Count() > 0)
{
int counter = 0;
foreach (var lp in query046)
{
counter++;
string carry = "";
output046 += lp.PU_ID.ToString() + "|" + lp.PU_DESC.ToString() + "|" + lp.PU_INST_PR.ToString() + "|" + lp.PU_UOM.ToString() + "|" + lp.NETWORK_FLAG + "|" + lp.BILL_RATE;
output046 += "!";
System.Diagnostics.Debug.WriteLine("agak:" + output046);
}
}
}
if (check047 > 0)
{
var query047 = (from a in ctxData.BI_NNW_MAT_MAST
where a.BI_BATCH_ID == id
select new
{
a.MAT_ID,
a.MAT_NAME,
a.MAT_UOM,
a.MAT_CAT,
a.MAT_PRICE
});
System.Diagnostics.Debug.WriteLine(query);
if (query047.Count() > 0)
{
int counter = 0;
foreach (var lp in query047)
{
counter++;
string carry = "";
output047 += lp.MAT_ID + "|" + lp.MAT_NAME + "|" + lp.MAT_UOM + "|" + lp.MAT_CAT + "|" + lp.MAT_PRICE.ToString();
output047 += "!";
System.Diagnostics.Debug.WriteLine("agak:" + output047);
}
}
}
if (check048 > 0)
{
var query048 = (from a in ctxData.BI_NNW_PU_MAT_REF
where a.BI_BATCH_ID == id
select new
{
a.PU_ID,
a.MAT_ID,
a.PM_QTY
});
System.Diagnostics.Debug.WriteLine(query);
if (query048.Count() > 0)
{
int counter = 0;
foreach (var lp in query048)
{
counter++;
string carry = "";
output048 += lp.PU_ID + "|" + lp.MAT_ID + "|" + lp.PM_QTY;
output048 += "!";
System.Diagnostics.Debug.WriteLine("agak:" + output048);
}
}
}
if (check049 > 0)
{
var query049 = (from a in ctxData.BI_CONTRACT
where a.BI_BATCH_ID == id
select new
{
a.CONTRACT_NO,
a.ITEM_NO,
a.SHORT_TEXT,
a.ITEM_CATEGORY,
a.ORDER_UNIT,
a.NET_PRICE
});
System.Diagnostics.Debug.WriteLine(query);
if (query049.Count() > 0)
{
int counter = 0;
foreach (var lp in query049)
{
counter++;
string carry = "";
output049 += lp.CONTRACT_NO + "|" + lp.ITEM_NO + "|" + lp.SHORT_TEXT + "|" + lp.ITEM_CATEGORY + "|" + lp.ORDER_UNIT + "|" + lp.NET_PRICE.ToString();
output049 += "!";
System.Diagnostics.Debug.WriteLine("agak:" + output049);
}
}
}
if (check309 > 0)
{
var query309 = (from a in ctxData.BI_NNW_EXT_SCH_GEM
where a.BI_BATCH_ID == id
select new
{
a.PROJ_NUM,
a.NETWORK_HDR,
a.RATE_INDICATOR,
a.PU_ID,
a.PU_QTY,
a.WBS_NUM
});
System.Diagnostics.Debug.WriteLine(query);
if (query309.Count() > 0)
{
int counter = 0;
foreach (var lp in query309)
{
counter++;
string carry = "";
output309 += lp.PROJ_NUM + "|" + lp.NETWORK_HDR + "|" + lp.RATE_INDICATOR + "|" + lp.PU_ID + "|" + lp.PU_QTY + "|" + lp.WBS_NUM;
output309 += "!";
}
}
}
if (check310 > 0)
{
var query310 = (from a in ctxData.BI_NNW_GEM_PROJNO
where a.BI_BATCH_ID == id
select new
{
a.WBS_NUM,
a.PROJ_DESC,
a.WBS_DESC,
a.EXC_ABB,
a.AMOUNT,
a.NETWORK_HDR
});
System.Diagnostics.Debug.WriteLine(query310);
if (query310.Count() > 0)
{
int counter = 0;
foreach (var lp in query310)
{
counter++;
string carry = "";
output310 += lp.WBS_NUM + "|" + lp.PROJ_DESC + "|" + lp.WBS_DESC + "|" + lp.EXC_ABB + "|" + lp.AMOUNT.ToString() + "|" + lp.NETWORK_HDR;
output310 += "!";
System.Diagnostics.Debug.WriteLine("agak:" + output310);
}
}
}
//output310 = soutput310;
if (check311 > 0)
{
var query311 = (from a in ctxData.BI_TOGEMS_SEQ1
where a.BI_BATCH_ID == id
select new
{
a.PROJECT_NO,
a.EQUIPMENT_CODE,
a.EXC_ABB,
a.ASSET_ADDRESS1,
a.ASSET_ADDRESS2,
a.ASSET_ADDRESS3,
a.WBS_NO
});
System.Diagnostics.Debug.WriteLine(query);
if (query311.Count() > 0)
{
int counter = 0;
foreach (var lp in query311)
{
counter++;
string address = lp.ASSET_ADDRESS1 + "," + lp.ASSET_ADDRESS2 + "," + lp.ASSET_ADDRESS3;
string carry = "";
output311 += lp.PROJECT_NO + "|" + lp.WBS_NO + "|" + lp.EQUIPMENT_CODE + "|" + lp.EXC_ABB + "|" + address;
output311 += "!";
}
}
}
if (check312 > 0)
{
var query312 = (from a in ctxData.BI_GEMS_BOQ_MAT
where a.BI_BATCH_ID == id
select new
{
a.PROJ_NO,
a.NETWORK_HEADER,
a.CONTRACT_NO,
a.CONTRACT_ITEM_NO,
a.QUANTITY,
a.WBS_NUM
});
System.Diagnostics.Debug.WriteLine(query);
if (query312.Count() > 0)
{
int counter = 0;
foreach (var lp in query312)
{
counter++;
string carry = "";
output312 += lp.PROJ_NO + "|" + lp.NETWORK_HEADER + "|" + lp.CONTRACT_NO + "|" + lp.CONTRACT_ITEM_NO + "|" + lp.QUANTITY + "|" + lp.WBS_NUM;
output312 += "!";
}
}
}
if (check589 > 0)
{
var query589 = (from a in ctxData.BI_ASSET_NO
where a.BI_BATCH_ID == id
select new
{
a.PROJECT_NO,
a.ASSET_NO,
a.ASSET_SUB_NO,
a.CABLE_EQUIP_ID,
a.EXC_ABB,
a.ASSET_TYPE
});
System.Diagnostics.Debug.WriteLine(query);
if (query589.Count() > 0)
{
int counter = 0;
foreach (var lp in query589)
{
counter++;
string carry = "";
output589 += lp.PROJECT_NO.ToString() + "|" + lp.ASSET_NO.ToString() + "|" + lp.ASSET_SUB_NO.ToString() + "|" + lp.CABLE_EQUIP_ID + "|" + lp.EXC_ABB + "|" + lp.ASSET_TYPE;
output589 += "!";
System.Diagnostics.Debug.WriteLine("agak:" + output591);
}
}
}
if (check591 > 0)
{
var query591 = (from a in ctxData.BI_DECOMM_TABLE
where a.BI_BATCH_ID == id
select new
{
a.ASSET_NO,
a.CABLE_ID,
a.DECOMM_REASON,
a.DECOMM_DATE
});
System.Diagnostics.Debug.WriteLine(query);
if (query591.Count() > 0)
{
int counter = 0;
foreach (var lp in query591)
{
counter++;
string carry = "";
output591 += lp.ASSET_NO.ToString() + "|" + lp.CABLE_ID.ToString() + "|" + lp.DECOMM_REASON + "|" + lp.DECOMM_DATE.ToString();
output591 += "!";
System.Diagnostics.Debug.WriteLine("agak:" + output591);
}
}
}
return(Json(new
{
Success = true,
BATCH_ID = id,
CLASS_NAME = query.CLASS_NAME,
EXCEPTION = query.EXCEPTION,
EXCEPTION_MSG = query.EXCEPTION_MSG,
FILE_HAS_ERROR = query.FILE_HAS_ERROR,
FILENAME = query.FILENAME,
INSTANCE_ID = query.INSTANCE_ID,
SERVICE_NAME = query.SERVICE_NAME,
STACKTRACE = query.STACKTRACE,
TIME_END = query.TIME_END.ToString(),
TIME_START = query.TIME_START.ToString(),
TYPE = query.TYPE,
outputATag = outputATag,
outputATagNis = outputATagNis,
output046 = output046,
output047 = output047,
output048 = output048,
output049 = output049,
output309 = output309,
output310 = output310,
output311 = output311,
output312 = output312,
output589 = output589,
output591 = output591
}, JsonRequestBehavior.AllowGet)); //
}
}
private void ExtractResult(string methodName, int procid, int req_id)
{
WebService2 WS2 = new WebService2();
// Selects just the elements with namespace http://tempuri.org/ (i.e. ignores SOAP namespace)
XmlNamespaceManager namespMan = new XmlNamespaceManager(new NameTable());
namespMan.AddNamespace("nep", "http://www.tm.com.my/hsbb/eai/NEPSLoadPathConsumer/");
XElement webMethodResult = ResponseSOAP.XPathSelectElement("//nep:NEPSLoadPathConsumerResponse", namespMan);
System.Diagnostics.Debug.WriteLine(webMethodResult.Value.ToString());
// If the result is an XML, return it and convert it to string
string status = "";
string code = "";
string msg = "";
if (webMethodResult.FirstNode.NodeType == XmlNodeType.Element)
{
foreach (XNode ex in ((XElement)webMethodResult).Nodes())
{
ResultXML = XDocument.Parse(ex.ToString());
ResultXML = Utils.RemoveNamespaces(ResultXML);
XElement a = ResultXML.Root;
System.Diagnostics.Debug.WriteLine(a.FirstNode.ToString());
System.Diagnostics.Debug.WriteLine(a.Elements().Count());
foreach (XNode no in ((XElement)a).Nodes())
{
XDocument ResultXMLN = XDocument.Parse(no.ToString());
XElement b = ResultXMLN.Root;
System.Diagnostics.Debug.WriteLine(b.Elements().Count());
System.Diagnostics.Debug.WriteLine(no.ToString());
if (b.Elements().Count() == 0)
{
string[] arr = no.ToString().Split('>');
string[] arr2 = arr[1].Split('<');
string[] arr3 = arr[0].Split('<');
System.Diagnostics.Debug.WriteLine(arr2[0]);
WS2.NodeParameter(arr3[1], arr2[0]);
if (arr3[1].Contains("Status"))
{
status = arr2[0];
}
else if (arr3[1].Contains("MessageCode"))
{
code = arr2[0];
}
else if (arr3[1].Contains("Message"))
{
msg = arr2[0];
}
}
else
{
foreach (XNode no2 in ((XElement)a).Nodes())
{
string[] arr = no2.ToString().Split('>');
string[] arr2 = arr[1].Split('<');
System.Diagnostics.Debug.WriteLine(arr2[0]);
}
}
ResultString = ResultXML.ToString();
System.Diagnostics.Debug.WriteLine(ResultString);
}
}
int idNEPSBI_RES;
using (EntitiesNetworkElement data_nepsbi = new EntitiesNetworkElement())
{
var id_process = (from p in data_nepsbi.BI_GRNOSPDLDPATHCONS_RES
select p).OrderByDescending(p => p.REQUEST_ID).First();
idNEPSBI_RES = Convert.ToInt32(id_process.REQUEST_ID) + 1;
}
Tools tool = new Tools();
string sqlStr = "insert into NEPSBI.BI_GRNOSPDLDPATHCONS_RES(REPLY_ID,PROC_ID,REQUEST_ID,TIME_RETURNED,CALLSTATUS_STATUS,CALLSTATUS_MSGCODE,CALLSTATUS_MSG) values";
OracleParameter[] oraPrm = new OracleParameter[7];
oraPrm[0] = new OracleParameter("v_REPLY_ID", OracleDbType.Int32);
oraPrm[0].Value = idNEPSBI_RES;
oraPrm[1] = new OracleParameter("v_PROC_ID", OracleDbType.Int32);
oraPrm[1].Value = procid;
oraPrm[2] = new OracleParameter("v_REQUEST_ID", OracleDbType.Int32);
oraPrm[2].Value = req_id;
oraPrm[3] = new OracleParameter("v_TIME_RETURNED", OracleDbType.TimeStamp);
oraPrm[3].Value = DateTime.Now;
oraPrm[4] = new OracleParameter("v_CALLSTATUS_STATUS", OracleDbType.Varchar2);
oraPrm[4].Value = status;
oraPrm[5] = new OracleParameter("v_CALLSTATUS_MSGCODE", OracleDbType.Varchar2);
oraPrm[5].Value = code;
oraPrm[6] = new OracleParameter("v_CALLSTATUS_MSG", OracleDbType.Varchar2);
oraPrm[6].Value = msg;
string result2 = tool.ExecuteStored(connString, sqlStr, CommandType.StoredProcedure, oraPrm, false);
System.Diagnostics.Debug.WriteLine("result :" + result2);
}
// If the result is a string, return it and convert it to XML (creating a root node to wrap the result)
else
{
ResultString = webMethodResult.FirstNode.ToString();
ResultXML = XDocument.Parse("<root>" + ResultString + "</root>");
}
}
public ActionResult BatchList(string FILENAME, string SERVICENAME, string HASERROR, string TYPE, int?page)
{
WebView.WebService._base myWebService;
myWebService = new WebService._base();
WebService._base.BiBatch BiBatchMain = new WebService._base.BiBatch();
if (FILENAME != null || SERVICENAME != null)
{
if (FILENAME.Equals("Select") && SERVICENAME.Equals("Select") && HASERROR.Equals("false") && TYPE.Equals("Select"))
{
BiBatchMain = myWebService.GetBatch(0, 100000, null, null, null, null);
}
else
{
BiBatchMain = myWebService.GetBatch(0, 100000, FILENAME, SERVICENAME, HASERROR, TYPE);
}
}
else
{
BiBatchMain = myWebService.GetBatch(0, 100000, null, null, null, null);
}
string input = "\\\\adsvr";
//string input = "\\\\server\\d$\\x\\y\\z\\AAA";
string output = String.Format("http:{0}", input.Replace("\\d$\\x\\y", String.Empty).Replace("\\", "/"));
ViewBag.output = output;
using (EntitiesNetworkElement ctxData = new EntitiesNetworkElement())
{
//filter FILENAME
List <SelectListItem> list3 = new List <SelectListItem>();
var queryFILENAME = from p in ctxData.BI_BATCH
select new { Text = p.INSTANCE_ID, Value = p.INSTANCE_ID };
list3.Add(new SelectListItem()
{
Text = "", Value = "Select"
});
foreach (var a in queryFILENAME.Distinct().OrderBy(it => it.Value))
{
if (a.Value != null)
{
list3.Add(new SelectListItem()
{
Text = a.Text.ToString(), Value = a.Value.ToString()
});
}
}
ViewBag.FILENAME = list3;
//filter servicename
List <SelectListItem> list2 = new List <SelectListItem>();
var querySERVICENAME = from p in ctxData.BI_BATCH
select new { Text = p.SERVICE_NAME, Value = p.SERVICE_NAME };
list2.Add(new SelectListItem()
{
Text = "", Value = "Select"
});
foreach (var a in querySERVICENAME.Distinct().OrderBy(it => it.Value))
{
if (a.Value != null)
{
list2.Add(new SelectListItem()
{
Text = a.Text.ToString(), Value = a.Value.ToString()
});
}
}
ViewBag.SERVICENAME = list2;
List <SelectListItem> list1 = new List <SelectListItem>();
list1.Add(new SelectListItem()
{
Text = "", Value = "Select"
});
list1.Add(new SelectListItem()
{
Text = "INBOUND", Value = "INBOUND"
});
list1.Add(new SelectListItem()
{
Text = "OUTBOUND", Value = "OUTBOUND"
});
ViewBag.TYPE = list1;
if (HASERROR == "true")
{
ViewBag.HASERROR = "true";
}
else
{
ViewBag.HASERROR = "false";
}
}
int pageSize = 15;
int pageNumber = (page ?? 1);
ViewBag.FILENAME_1 = FILENAME;
ViewBag.SERVICENAME_1 = SERVICENAME;
ViewBag.HASERROR_1 = HASERROR;
ViewBag.TYPE_1 = TYPE;
return(View(BiBatchMain.bacthList.ToPagedList(pageNumber, pageSize)));
}
