public string physicalCountData([FromBody] TransferDetailsInputJson value1)
{
try
{
string value = value1.JsonData;
//string value = "<?xml version=\"1.0\" encoding=\"UTF-8\"?><ale:ECReports xmlns:ale=\"urn:epcglobal:ale:xsd:1\" xmlns:epcglobal=\"urn:epcglobal:xsd:1\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:ale_mojix_ext=\"urn:mojix:ale:xsd:1\" ale_mojix_ext:longitude=\"-118.47\" ale_mojix_ext:elevation=\"41.15\" ale_mojix_ext:latitude=\"34.03\" ale_mojix_ext:declination=\"0.0\" ale_mojix_ext:units=\"meters\" date=\"2013-01-31T22:02:26.154+00:00\" specName=\"_mojix_ECSpec_loc\" schemaVersion=\"1.1\" terminationTrigger=\" urn:com.mojix.epc.triggers:duration_elapsed:_mojix_ECSpec_loc\" creationDate=\"2013-01-31T22:02:26.154+00:00\" totalMilliseconds=\"1000\" terminationCondition=\"TRIGGER\" initiationCondition=\"REQUESTED\" ALEID=\"D4BED9A84EE0\" ><!-- Version ID : 002 --><!-- xsi:schemaLocation=\"http://*****:*****@EPC", SqlDbType.VarChar).Value = rawHex;
cmd.Parameters.Add("@posX", SqlDbType.VarChar).Value = x;
cmd.Parameters.Add("@posY", SqlDbType.VarChar).Value = y;
cmd.Parameters.Add("@InventoryCount", SqlDbType.Int).Value = count;
conn.Open();
Common.ExecuteNonQuery(cmd);
conn.Close();
}
}
return("OK ");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public HttpResponseMessage updateTransferDetails([FromBody] TransferDetailsInputJson value)
{
var result = JsonConvert.DeserializeObject <List <TransferDetails> >(value.JsonData);
string stringConnect = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlDBHelper sql = new SqlDBHelper();
DataTable dt;
try
{
using (SqlConnection conn = new SqlConnection(stringConnect))
{
foreach (TransferDetails item in result)
{
using (SqlCommand cmd = new SqlCommand("insertOrUpdateTransferDetails", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MTF", SqlDbType.VarChar).Value = value.MTF;
cmd.Parameters.Add("@EPC", SqlDbType.VarChar).Value = item.EPC;
cmd.Parameters.Add("@FromBin", SqlDbType.VarChar).Value = item.FromBin;
cmd.Parameters.Add("@ToBin", SqlDbType.VarChar).Value = item.ToBin;
cmd.Parameters.Add("@UOM", SqlDbType.VarChar).Value = item.UOM;
cmd.Parameters.Add("@BatchNo", SqlDbType.VarChar).Value = item.BatchNo;
cmd.Parameters.Add("@Type", SqlDbType.Int).Value = item.Type;
cmd.Parameters.Add("@ItemCode", SqlDbType.VarChar).Value = item.ItemCode;
//var json11 = Newtonsoft.Json.JsonConvert.SerializeObject(item);
//Common.WriteLog("Request", json11);
conn.Open();
dt = Common.ExecuteNonQuery(cmd);
conn.Close();
}
}
var json1 = Newtonsoft.Json.JsonConvert.SerializeObject(new InternalTransferReturnJson(true, "Thành công", null));
var response1 = Request.CreateResponse(HttpStatusCode.OK);
response1.Content = new StringContent(json1, System.Text.Encoding.UTF8, "application/json");
return(response1);
}
}
catch (Exception ex)
{
var json1 = Newtonsoft.Json.JsonConvert.SerializeObject(new InternalTransferReturnJson(false, ex.Message, null));
var response1 = Request.CreateResponse(HttpStatusCode.OK);
response1.Content = new StringContent(json1, System.Text.Encoding.UTF8, "application/json");
return(response1);
}
}
