public BE.OnpComision Obtener(int anho, int mes)
{
BE.OnpComision beOnpComision = null;
try
{
string sp = "SpTbOnpComisionObtener";
using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal))
{
cnn.Open();
SqlCommand cmd = new SqlCommand(sp, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ANHO", anho));
cmd.Parameters.Add(new SqlParameter("@MES", mes));
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
beOnpComision = new BE.OnpComision();
beOnpComision.IdOnpComision = int.Parse(reader["IdOnpComision"].ToString());
beOnpComision.Anho = int.Parse(reader["Anho"].ToString());
beOnpComision.Mes = int.Parse(reader["Mes"].ToString());
beOnpComision.PorcentajeAporte = double.Parse(reader["PorcentajeAporte"].ToString());
}
}
return(beOnpComision);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Insertar(ref BE.OnpComision BeOnpComision)
{
try
{
string sp = "SpTbOnpComisionInsertar";
int rowsAffected = 0;
using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal))
{
cnn.Open();
SqlCommand cmd = new SqlCommand(sp, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IDONPCOMISION", BeOnpComision.IdOnpComision));
cmd.Parameters["@IDONPCOMISION"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@ANHO", BeOnpComision.Anho));
cmd.Parameters.Add(new SqlParameter("@MES", BeOnpComision.Mes));
cmd.Parameters.Add(new SqlParameter("@PORCENTAJEAPORTE", BeOnpComision.PorcentajeAporte));
rowsAffected = cmd.ExecuteNonQuery();
BeOnpComision.IdOnpComision = int.Parse(cmd.Parameters["@IDONPCOMISION"].Value.ToString());
}
return(rowsAffected > 0);
}
catch (Exception ex)
{
throw ex;
}
}
private BE.OnpComision UItoBE(BE.UI.OnpComision UiOnpComision)
{
var BeOnpComision = new BE.OnpComision();
BeOnpComision.IdOnpComision = UiOnpComision.IdOnpComision;
BeOnpComision.Anho = UiOnpComision.Anho;
BeOnpComision.Mes = UiOnpComision.MesNumero;
BeOnpComision.PorcentajeAporte = UiOnpComision.AportePorcentual;
return(BeOnpComision);
}
private BE.UI.OnpComision BEtoUI(BE.OnpComision BeOnpComision)
{
var UiOnpComision = new BE.UI.OnpComision();
UiOnpComision.IdOnpComision = BeOnpComision.IdOnpComision;
UiOnpComision.Anho = BeOnpComision.Anho;
UiOnpComision.MesNumero = BeOnpComision.Mes;
UiOnpComision.MesNombre = this.MesNombre(BeOnpComision.Mes);
UiOnpComision.AportePorcentual = BeOnpComision.PorcentajeAporte;
return(UiOnpComision);
}
public List <BE.OnpComision> Listar()
{
var lstOnpComision = new List <BE.OnpComision>();
try
{
string sp = "SpTbOnpComisionListar";
using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal))
{
cnn.Open();
SqlCommand cmd = new SqlCommand(sp, cnn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var beOnpComision = new BE.OnpComision();
beOnpComision.IdOnpComision = int.Parse(reader["IdOnpComision"].ToString());
beOnpComision.Anho = int.Parse(reader["Anho"].ToString());
beOnpComision.Mes = int.Parse(reader["Mes"].ToString());
beOnpComision.PorcentajeAporte = double.Parse(reader["PorcentajeAporte"].ToString());
lstOnpComision.Add(beOnpComision);
}
}
return(lstOnpComision);
}
catch (Exception ex)
{
throw ex;
}
}
