public bool Insertar(ref BE.Planificacion planificacion)
{
try
{
string sp = "SpTbPlanificacionInsertar";
int rowsAffected = 0;
using (var cnn = new SqlConnection(Conexion.strCnxBD))
{
cnn.Open();
var cmd = new SqlCommand(sp, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IDPLANIFICACION", planificacion.Id));
cmd.Parameters["@IDPLANIFICACION"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@DIA", planificacion.Dia));
//cmd.Parameters.Add(new SqlParameter("@HORA", planificacion.Hora.TimeOfDay));
cmd.Parameters.Add("@HORA", SqlDbType.Time).Value = planificacion.Hora.TimeOfDay;
rowsAffected = cmd.ExecuteNonQuery();
planificacion.Id = int.Parse(cmd.Parameters["@IDPLANIFICACION"].Value.ToString());
}
return(rowsAffected > 0);
}
catch (Exception ex)
{
throw ex;
}
}
private void btnAgregar_Click(object sender, EventArgs e)
{
try
{
var plan = new BE.Planificacion();
plan.Id = 0;
plan.Dia = this.cboDia.SelectedIndex;
plan.Hora = this.dtpHora.Value;
bool rpta = new BD.Planificacion().Insertar(ref plan);
if (rpta)
{
this.CargarPlanificaciones();
}
}
catch (Exception ex)
{
General.ErrorMessage(ex.Message);
}
}
public List <BE.Planificacion> Listar()
{
var lstBePlanificacion = new List <BE.Planificacion>();
try
{
string sp = "SpTbPlanificacionListar";
using (var cnn = new SqlConnection(Conexion.strCnxBD))
{
cnn.Open();
var cmd = new SqlCommand(sp, cnn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var bePlaninficacion = new BE.Planificacion();
bePlaninficacion.Id = int.Parse(reader["IdPlanificacion"].ToString());
bePlaninficacion.Dia = int.Parse(reader["Dia"].ToString());
bePlaninficacion.Hora = DateTime.Parse(reader["Hora"].ToString());
lstBePlanificacion.Add(bePlaninficacion);
}
cnn.Close();
}
return(lstBePlanificacion);
}
catch (Exception ex)
{
throw ex;
}
}
