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