//EDITAR ONP
public int EditOnp(Dafp daf)
{
result = 0;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlTransaction sqltra = conect.BeginTransaction())
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "SP_UPDATE_COMISIONES_ONP";
cmd.Connection = conect;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Transaction = sqltra;
cmd.Parameters.Add("@comision", SqlDbType.Decimal).Value = daf.Comision;
cmd.Parameters.Add("@idcomision", SqlDbType.Int).Value = daf.Id_comision;
result = cmd.ExecuteNonQuery();
}
sqltra.Commit();
}
catch (Exception ex)
{
sqltra.Rollback();
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
}
return(result);
}
public DataTable Show_comisionafp(Dafp entity, string tipo_regimen)
{
DataTable dt = null;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conect;
cmd.CommandText = "SP_SHOW_COMISIONPENSIONES";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idmes", entity.Idmes);
cmd.Parameters.AddWithValue("@idperiodo", entity.Idperiodo);
cmd.Parameters.AddWithValue("@tipo_regimen", tipo_regimen);
SqlDataReader reader = cmd.ExecuteReader();
using (dt = new DataTable())
{
if (reader.HasRows)
{
dt.Load(reader);
reader.Close();
}
}
}
}
return(dt);
}
// MOSTRAR COMISION AFP
public IEnumerable <Nafp> Show_comisionafp(string tipo_regimen)
{
Dafp daf = new Dafp();
daf.Idmes = Idmes;
daf.Idperiodo = Idperiodo;
using (DataTable dt = new Rafp().Show_comisionafp(daf, tipo_regimen))
{
list_comisionAfp = new List <Nafp>();
foreach (DataRow item in dt.Rows)
{
list_comisionAfp.Add(new Nafp()
{
Codigo_regimen = Convert.ToInt32(item[0]),
descripcion = item[1].ToString(),
Id_comision = Convert.ToInt32(item[2]),
Comision = Convert.ToDecimal(item[3]),
Saldo = Convert.ToDecimal(item[4]),
Seguro = Convert.ToDecimal(item[5]),
Aporte = Convert.ToDecimal(item[6]),
Tope = Convert.ToDecimal(item[7])
//Idmes = Convert.ToInt32(item[]),
//Idperiodo=Convert.ToInt32(item[])
});
}
}
return(list_comisionAfp);
}
//EDIT COMISION
public int EditComision(Dafp lisaf)
{
int i = 0;
foreach (Dafp item in lisaf.DlistAfp)
{
i = Edit(item);
}
return(i);
}
//Guardar Comision
public int SaveComision(Dafp lisaf)
{
int i = 0;
foreach (Dafp item in lisaf.DlistAfp)
{
i = Add(item);
}
return(i);
}
public int Add(Dafp daf)
{
result = 0;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlTransaction sqltra = conect.BeginTransaction())
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "SP_INSERT_COMISIONES";
cmd.Connection = conect;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Transaction = sqltra;
cmd.Parameters.Add("@codigo_regimen", SqlDbType.Int).Value = daf.Codigo_regimen;
cmd.Parameters.Add("@comision", SqlDbType.Decimal).Value = daf.Comision;
cmd.Parameters.Add("@saldo", SqlDbType.Decimal).Value = daf.Saldo;
cmd.Parameters.Add("@seguro", SqlDbType.Decimal).Value = daf.Seguro;
cmd.Parameters.Add("@aporte", SqlDbType.Decimal).Value = daf.Aporte;
cmd.Parameters.Add("@tope", SqlDbType.Decimal).Value = daf.Tope;
cmd.Parameters.Add("@idmes", SqlDbType.Int).Value = daf.Idmes;
cmd.Parameters.Add("@idperiodo", SqlDbType.Int).Value = daf.Idperiodo;
result = cmd.ExecuteNonQuery();
//System.Windows.Forms.MessageBox.Show("EXECUTE: " + result);
}
sqltra.Commit();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
sqltra.Rollback();
}
}
}
return(result);
}
public IEnumerable <Nafp> Show_comisionOnp(string tipo_regimen)
{
list_comisionOnp = new List <Nafp>();
Dafp daf = new Dafp();
daf.Idmes = Idmes;
daf.Idperiodo = Idperiodo;
using (DataTable dt = new Rafp().Show_comisionafp(daf, tipo_regimen))
{
foreach (DataRow item in dt.Rows)
{
list_comisionOnp.Add(new Nafp()
{
Codigo_regimen = Convert.ToInt32(item[0]),
descripcion = item[1].ToString(),
Id_comision = Convert.ToInt32(item[2]),
Comision = Convert.ToDecimal(item[3])
});
}
}
return(list_comisionOnp);
}
public Nafp()
{
daf = new Dafp();
raf = new Rafp();
}
