public void Inserir(NotRestr notrestr)
{
var strQuery = "";
strQuery += "INSERT INTO tblnotrestr(notificacaoid, restricaoid, ordem, complemento, " +
"formatacao, valor) ";
strQuery += string.Format("VALUES ({0}, {1}, '{2}', '{3}', {4})", notrestr.NotificacaoId,
notrestr.RestricaoId, notrestr.Complemento, notrestr.Formatacao,
notrestr.Valor);
using (cnx = new ConexaoBD())
cnx.CommNom(strQuery);
}
private NotRestr One(DataTable dt, int pos)
{
if (dt.Rows.Count > 0)
{
var registro = new NotRestr()
{
NotificacaoId = int.Parse(dt.Rows[pos]["notificacaoid"].ToString()),
RestricaoId = int.Parse(dt.Rows[pos]["restricaoid"].ToString()),
Complemento = dt.Rows[pos]["complemento"].ToString(),
Formatacao = dt.Rows[pos]["formatacao"].ToString(),
Valor = Double.Parse(dt.Rows[pos]["valor"].ToString())
};
return(registro);
}
else
{
return(new NotRestr());
}
}
