public static int GravarTratamentoFiscal(Domain.TratamentoFiscal tratFiscal) { using (var _sqlCon = GetConn()) using (var sqlCmd = new SqlCommand("dbo.P_TRATAMENTO_FISCAL", _sqlCon)) { sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddRange(new[] { new SqlParameter("@pId", tratFiscal.Id) { Direction = ParameterDirection.InputOutput }, new SqlParameter("@pEstadoOrigem", tratFiscal.EstadoOrigem), new SqlParameter("@pEstadoDestino", tratFiscal.EstadoDestino), new SqlParameter("@pCfop", tratFiscal.Cfop), new SqlParameter("@pBrinde", tratFiscal.Brinde), new SqlParameter("@pTipoIcms", tratFiscal.TipoIcms), new SqlParameter("@pAliquotaIcms", tratFiscal.AliquotaIcms), new SqlParameter("@pAliquotaIpi", tratFiscal.AliquotaIpi), new SqlParameter("@pReducaoBaseIcms", tratFiscal.ReducaoBaseIcms), new SqlParameter("@pDesconto", tratFiscal.Desconto) }); _sqlCon.Open(); sqlCmd.ExecuteScalar(); return(Convert.ToInt32(sqlCmd.Parameters["@pId"].Value)); } }
public static Domain.TratamentoFiscal ObterTratamentoFiscal(string ufOrigem, string ufDestino, bool brinde) { var tratFiscal = new Domain.TratamentoFiscal(); using (var con = GetConn()) using (var sqlCmd = new SqlCommand(@"SELECT [Id] ,[EstadoOrigem] ,[EstadoDestino] ,[Cfop] ,[TipoIcms] ,[AliquotaIcms] ,[AliquotaIpi] ,[ReducaoBaseIcms] ,[Brinde] ,[Desconto] ,[DataAlteracao] FROM [dbo].[TratamentoFiscal] WHERE estadoOrigem = @estadoOrigem and estadoDestino = @estadoDestino and brinde = @brinde", con)) { sqlCmd.CommandType = CommandType.Text; sqlCmd.Parameters.AddWithValue("@estadoOrigem", ufOrigem); sqlCmd.Parameters.AddWithValue("@estadoDestino", ufDestino); sqlCmd.Parameters.AddWithValue("@brinde", brinde); con.Open(); var sqlDR = sqlCmd.ExecuteReader(); if (sqlDR.HasRows) { while (sqlDR.Read()) { tratFiscal.Id = Convert.ToInt32(sqlDR["Id"]); tratFiscal.EstadoOrigem = sqlDR["EstadoOrigem"].ToString(); tratFiscal.EstadoDestino = sqlDR["EstadoDestino"].ToString(); tratFiscal.Cfop = sqlDR["Cfop"].ToString(); tratFiscal.TipoIcms = sqlDR["TipoIcms"].ToString(); tratFiscal.AliquotaIcms = Convert.ToDouble(sqlDR["AliquotaIcms"]); tratFiscal.AliquotaIpi = Convert.ToDouble(sqlDR["AliquotaIpi"]); tratFiscal.ReducaoBaseIcms = Convert.ToInt32(sqlDR["ReducaoBaseIcms"]); tratFiscal.Brinde = Convert.ToBoolean(sqlDR["Brinde"]); tratFiscal.Desconto = Convert.ToDouble(sqlDR["Desconto"]); tratFiscal.DataAlteracao = Convert.ToDateTime(sqlDR["DataAlteracao"]); } } } return(tratFiscal); }