public int CambiarHorario(string dni, DateTime annoMes, string HoraE, string HoraS)
{
HorarioCE horario = BuscarByDniAnnoMes(dni, annoMes);
if (horario.Codigo != null)
{
annoMes = annoMes.AddMonths(1);
horario = BuscarByDniAnnoMes(dni, annoMes);
if (horario.Codigo != null)
{
cnx.Close();
return(0);
}
}
SqlCommand cmd = ConexionCD.CrearCmd(cnx);
cmd.CommandText = "EstablecerHorario";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@dni", dni));
cmd.Parameters.Add(new SqlParameter("@HorE", HoraE));
cmd.Parameters.Add(new SqlParameter("@HorS", HoraS));
cmd.Parameters.Add(new SqlParameter("@AnnoMes", annoMes.ToString("yyyy-MM")));
int FilasAfectadas = cmd.ExecuteNonQuery();
cnx.Close();
return(FilasAfectadas);
}
public HorarioCE BuscarByDniAnnoMes(string dni, DateTime annoMes)
{
string AnnoMes = annoMes.ToString("yyyy-MM");
SqlCommand cmd = ConexionCD.CrearCmd(cnx);
cmd.CommandText = "HorarioByDniAnnoMes";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@dni", dni));
cmd.Parameters.Add(new SqlParameter("@AnnoMes", AnnoMes));
SqlDataReader drHorario = cmd.ExecuteReader();
HorarioCE horario = new HorarioCE();
if (drHorario.Read())
{
horario.Codigo = drHorario.GetString(0);
horario.AnnoMes = drHorario.GetString(1);
horario.HrEntrada = Convert.ToDateTime(drHorario["hrEntrada"].ToString());
horario.HrSalida = Convert.ToDateTime(drHorario["hrSalida"].ToString());
}
cnx.Close();
return(horario);
}