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