/// <summary>
/// Retorna o ID gerado pelo Banco de dados caso a instrução seja bem sucedida.
/// </summary>
public int Insert(FAPDTO fap)
{
try
{
dbCommand = db.GetSqlStringCommand(" INSERT INTO public.fap(" +
" id_empresa," +
" mesano," +
" percentualrat," +
" percentualfap," +
" aliquota" +
") VALUES (" +
" @id_empresa," +
" @mesano," +
" @percentualrat," +
" @percentualfap," +
" @aliquota);" +
" SELECT currval('fap_id_seq');");
db.AddInParameter(dbCommand, "@id_empresa", DbType.Int32, fap.ID_Empresa);
db.AddInParameter(dbCommand, "@mesano", DbType.Date, new DateTime(fap.MesAno.Year, fap.MesAno.Month, 1));
db.AddInParameter(dbCommand, "@percentualrat", DbType.Decimal, fap.PercentualRAT);
db.AddInParameter(dbCommand, "@percentualfap", DbType.Decimal, fap.PercentualFAP);
db.AddInParameter(dbCommand, "@aliquota", DbType.Decimal, fap.Aliquota);
int id = Convert.ToInt32(db.ExecuteScalar(dbCommand, Transaction));
return(id);
}
catch
{
throw;
}
}
/// <summary>
/// Retorna uma lista de objetos FAPDTO caso a instrução seja bem sucedida.
/// </summary>
public List <FAPDTO> GetListFAP(int id_empresa)
{
try
{
dbCommand = db.GetStoredProcCommand("GetListFAP");
db.AddInParameter(dbCommand, "@id_empresa", DbType.Int32, id_empresa);
using (IDataReader DR = (Transaction == null ? db.ExecuteReader(dbCommand) : db.ExecuteReader(dbCommand, Transaction)))
{
List <FAPDTO> List = new List <FAPDTO>();
while (DR.Read())
{
FAPDTO tab = new FAPDTO();
tab.ID = int.Parse(DR["id"].ToString());
tab.ID_Empresa = int.Parse(DR["id_empresa"].ToString());
tab.MesAno = (DateTime)DR["mesano"];
tab.PercentualRAT = decimal.Parse(DR["percentualrat"].ToString());
tab.PercentualFAP = decimal.Parse(DR["percentualfap"].ToString());
tab.Aliquota = decimal.Parse(DR["aliquota"].ToString());
List.Add(tab);
}
return(List);
}
}
catch
{
throw;
}
}
/// <summary>
/// Atualização de Módulos.
/// </summary>
public void Insert2(FAPDTO fap)
{
DbConnection connection = null;
bool transactionstart = false;
try
{
using (connection = db.CreateConnection())
{
connection.Open();
if (Transaction == null)
{
Transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);
transactionstart = true;
db.ExecuteNonQuery(Transaction, CommandType.Text, "SELECT GravaLOG_App(2, '', '" + MechTech.Util.Global.UsuarioAtivo + "');");
}
dbCommand = db.GetSqlStringCommand(" INSERT INTO public.fap(" +
" id_empresa," +
" mesano," +
" percentualrat," +
" percentualfap," +
" aliquota" +
") VALUES (" +
" @id_empresa," +
" @mesano," +
" @percentualrat," +
" @percentualfap," +
" @aliquota);" +
" SELECT currval('fap_id_seq');");
db.AddInParameter(dbCommand, "@id_empresa", DbType.Int32, fap.ID_Empresa);
db.AddInParameter(dbCommand, "@mesano", DbType.Date, (DateTime?)fap.MesAno);
db.AddInParameter(dbCommand, "@percentualrat", DbType.Decimal, fap.PercentualRAT);
db.AddInParameter(dbCommand, "@percentualfap", DbType.Decimal, fap.PercentualFAP);
db.AddInParameter(dbCommand, "@aliquota", DbType.Decimal, fap.Aliquota);
db.ExecuteNonQuery(dbCommand, Transaction);
if (transactionstart)
{
Transaction.Commit();
Transaction = null;
}
connection.Close();
}
}
catch
{
if (transactionstart)
{
if (Transaction.Connection.State == ConnectionState.Open)
{
Transaction.Rollback();
}
Transaction = null;
}
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
throw;
}
}
