public void SaveDB(Domain.NotaFiscalItem obj) { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "P_NOTA_FISCAL_ITEM"; SqlParameter output = new SqlParameter("@pId", System.Data.SqlDbType.Int) { Direction = System.Data.ParameterDirection.Output, Value = obj.Id }; cmd.Parameters.Add(output); cmd.Parameters.Add(new SqlParameter("pIdNotaFiscal", obj.IdNotaFiscal)); cmd.Parameters.Add(new SqlParameter("pCfop", obj.Cfop)); cmd.Parameters.Add(new SqlParameter("pTipoIcms", obj.TipoIcms)); cmd.Parameters.Add(new SqlParameter("pBaseIcms", obj.BaseIcms)); cmd.Parameters.Add(new SqlParameter("pAliquotaIcms", obj.AliquotaIcms)); cmd.Parameters.Add(new SqlParameter("pValorIcms", obj.ValorIcms)); cmd.Parameters.Add(new SqlParameter("pNomeProduto", obj.NomeProduto)); cmd.Parameters.Add(new SqlParameter("pCodigoProduto", obj.CodigoProduto)); cmd.Parameters.Add(new SqlParameter("pBaseIpi", obj.BaseIpi)); cmd.Parameters.Add(new SqlParameter("pAliquotaIpi", obj.AliquotaIpi)); cmd.Parameters.Add(new SqlParameter("pValorIpi", obj.ValorIpi)); cmd.Parameters.Add(new SqlParameter("pDesconto", obj.Desconto)); ExecuteNonQuery(cmd); } }
public static void GravarNotaFiscalItem(Domain.NotaFiscalItem item) { using (var _sqlCon = GetConn()) using (var sqlCmd = new SqlCommand("dbo.P_NOTA_FISCAL_ITEM", _sqlCon)) { sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddRange(new[] { new SqlParameter("@pId", item.Id), new SqlParameter("@pIdNotaFiscal", item.IdNotaFiscal), new SqlParameter("@pCfop", item.Cfop), new SqlParameter("@pTipoIcms", item.TipoIcms), new SqlParameter("@pBaseIcms", item.BaseIcms), new SqlParameter("@pAliquotaIcms", item.AliquotaIcms), new SqlParameter("@pValorIcms", item.ValorIcms), new SqlParameter("@pBaseIpi", item.BaseIpi), new SqlParameter("@pAliquotaIpi", item.AliquotaIpi), new SqlParameter("@pValorIpi", item.ValorIpi), new SqlParameter("@pNomeProduto", item.NomeProduto), new SqlParameter("@pCodigoProduto", item.CodigoProduto), new SqlParameter("@pDesconto", item.Desconto), new SqlParameter("@pValorItemPedido", item.ValorItemPedido), new SqlParameter("@pBrinde", item.Brinde ) }); _sqlCon.Open(); sqlCmd.ExecuteNonQuery(); } }