public FormXML MontarControleServicoImpXML(string xmlDocForm) { var formXML = new FormXML(); XmlSerializer serializer = new XmlSerializer(typeof(FormXML)); using (TextReader reader = new StringReader(xmlDocForm)) { formXML = (FormXML)serializer.Deserialize(reader); } return(formXML); }
public FormXML MontarOrdemServicoImpXML(string xmlDocForm) { var formXML = new FormXML(); XmlSerializer serializer = new XmlSerializer(typeof(FormXML)); using (TextReader reader = new StringReader(xmlDocForm)) { formXML = (FormXML)serializer.Deserialize(reader); formXML.field.Field[13].Id = "LOCALIZACAO_ATUAL"; } return(formXML); }
public FormXML MontarControleServicoXML(string xmlDocForm) { var formXML = new FormXML(); XmlSerializer serializer = new XmlSerializer(typeof(FormXML)); using (TextReader reader = new StringReader(xmlDocForm)) { formXML = (FormXML)serializer.Deserialize(reader); formXML.field.Field[4].Id = "NUM_ENDERECO"; formXML.field.Field[58].Id = "TESTE_MONITOR"; } return(formXML); }
public FormXML MontarOrdemServicoXML(string xmlDocForm) { var formXML = new FormXML(); XmlSerializer serializer = new XmlSerializer(typeof(FormXML)); using (TextReader reader = new StringReader(xmlDocForm)) { formXML = (FormXML)serializer.Deserialize(reader); formXML.field.Field[0].Id = "N_CONTRATO"; formXML.field.Field[1].Id = "N_CHAMADO"; formXML.field.Field[6].Id = "NUM_ENDERECO"; formXML.field.Field[30].Id = "NM_COMPLETO_RESP"; } return(formXML); }
public bool InserirOrdemServicoXML(FormXML os) { bool status = true; using (SqlConnection conn = GetConnection()) { try { string queryString = "InsertOrdemServico"; SqlCommand cm = new SqlCommand(queryString, conn); cm.Parameters.Add("@Code", SqlDbType.VarChar).Value = os.Code; cm.Parameters.Add("@DS_NAME", SqlDbType.VarChar).Value = os.DS_NAME; cm.Parameters.Add("@NR_VERSION", SqlDbType.VarChar).Value = os.NR_VERSION; cm.Parameters.Add("@Category", SqlDbType.VarChar).Value = os.Category; foreach (var item in os.field.Field) { cm.Parameters.Add("@" + item.Id, SqlDbType.VarChar).Value = item.Value; } cm.Parameters.Add("@CustomerID", SqlDbType.Int).Direction = ParameterDirection.Output; cm.CommandType = CommandType.StoredProcedure; conn.Open(); cm.ExecuteNonQuery(); int contractID = Convert.ToInt32(cm.Parameters["@CustomerID"].Value); } catch (Exception Ex) { status = false; Console.WriteLine(Ex); } finally { conn.Close(); } } return(status); }