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