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