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); } }