public int SendDataToWebService(string referenceNo)
{
List <Picking> pickngList = new List <Picking>();
var script =
@"SELECT [Delivery Order Tag], [Part No.], [Tag No.], [Scan DateTime] FROM FGPicking
WHERE ([Delivery Order Tag] = @REFERENCENO)";
using (var conn = dbConnect.GetConnection())
{
conn.Open();
using (var cmd = new SqlCeCommand(script, conn))
{
cmd.Parameters.Add("REFERENCENO", referenceNo);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var pg = new Picking();
pg.PartNo = reader["Part No."].ToString();
pg.TagNo = reader["Tag No."].ToString();
pg.ScanDateTime = reader["Scan DateTime"].ToString();
pickngList.Add(pg);
}
}
}
int result = 0;
if (pickngList.Count > 0)
{
Hashtable hs = new Hashtable();
hs.Add("referenceNo", referenceNo);
hs.Add("pickingList", pickngList);
var request = JsonConvert.SerializeObject(hs);
var serviceReference = new ServicesBLService();
string userId = Session.GetCurrentUser().UserID;
var response = serviceReference.insertPickingDetail(request, userId);
if (response.Equals("success"))
{
result = 1;
}
}
return(result);
}
public int SendDataToWebService(string doCode)
{
List <ShippingTransaction> shippingList = new List <ShippingTransaction>();
List <OperationLog> logData = new List <OperationLog>();
var script =
@"SELECT Shipping.[Delivery Order Tag], Shipping.[DO Part No.], FATHTag.[Tag No.], FATHTag.[Scan DateTime]
FROM Shipping INNER JOIN
FATHTag ON Shipping.[Delivery Order Tag] = FATHTag.[Delivery Order Tag] AND Shipping.[DO Part No.] = FATHTag.[Part No.]
WHERE Shipping.[Delivery Order Tag] = @DELIVERYORDERTAG";
var logScript =
@"SELECT [MenuID], [Operation DateTime], [UserID], [Event], [FieldName], [FieldValue], [Error Flag], [Error Msg ID]
FROM TBL_OPER_LOG WHERE [MenuID] = @MENUID";
using (var conn = dbConnect.GetConnection())
{
conn.Open();
using (var cmd = new SqlCeCommand(script, conn))
{
cmd.Parameters.Add("DELIVERYORDERTAG", doCode);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var shipping = new ShippingTransaction();
shipping.PartNo = reader["DO Part No."].ToString();
shipping.TagNo = reader["Tag No."].ToString();
shipping.ScanDateTime = reader["Scan DateTime"].ToString();
shippingList.Add(shipping);
}
}
using (var cmd = new SqlCeCommand(logScript, conn))
{
cmd.Parameters.Add("MENUID", "M02");
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var log = new OperationLog(
reader["MenuID"].ToString(),
Session.GetCurrentUser().UserID,
Convert.ToBoolean(reader["Event"]) == true ? OperationLog.LogEvent.Scan : OperationLog.LogEvent.ClickButton,
reader["FieldName"].ToString(),
reader["FieldValue"].ToString(),
Convert.ToBoolean(reader["Error Flag"]) == true ? OperationLog.ErrorFlag.Error : OperationLog.ErrorFlag.NotError,
reader["Error Msg ID"].ToString(),
Convert.ToDateTime(reader["Operation DateTime"]));
logData.Add(log);
}
}
}
int result = 0;
if (shippingList.Count > 0)
{
Hashtable hs = new Hashtable();
hs.Add("doCode", doCode);
hs.Add("shippingList", shippingList);
hs.Add("logData", logData);
var request = JsonConvert.SerializeObject(hs);
var serviceReference = new ServicesBLService();
string userId = Session.GetCurrentUser().UserID;
var response = serviceReference.insertShippingDetail(request, userId);
if (response == "success")
{
result = 1;
}
}
return(result);
}
