public Horario DeleteHorario(string idLaboratorio) { try { Horario Horario = new Horario(); string sql = @"DELETE FROM Laboratorios_Horas WHERE idLaboratorio = @idLaboratorio"; using (SqlConnection connection = new SqlConnection(GetConnectionString())) { using (SqlCommand command = new SqlCommand(sql, connection)) { command.Parameters.AddWithValue("@idLaboratorio", idLaboratorio); connection.Open(); command.ExecuteNonQuery(); connection.Close(); } } return(Horario); } catch (Exception ex) { return(new Horario { mensajeError = ex.Message }); } }
public Horario PostHorario(Horario horarioInsert) { try { Horario horario = new Horario(); horario = DeleteHorario(horarioInsert.idLaboratorio); if (String.IsNullOrEmpty(horario.mensajeError)) { string sql = @"INSERT INTO Laboratorios_Horas VALUES (@idLaboratorio, @idDia, @idHora,@idMateria)"; using (SqlConnection connection = new SqlConnection(GetConnectionString())) { connection.Open(); int cont = 1; foreach (var item in horarioInsert.lstHorarios) { int contHora = 1; for (int i = 0; i < item.Count; i++) { using (SqlCommand command = new SqlCommand(sql, connection)) { command.Parameters.AddWithValue("@idLaboratorio", horarioInsert.idLaboratorio); var idDia = obtenerDia(cont); command.Parameters.AddWithValue("@idDia", idDia); var idHora = Convert.ToString(contHora); command.Parameters.AddWithValue("@idHora", idHora); var idMateria = item[i]; command.Parameters.AddWithValue("@idMateria", item[i]); command.ExecuteNonQuery(); } contHora++; } cont++; } connection.Close(); } } return(horario); } catch (Exception ex) { return(new Horario { mensajeError = ex.Message }); } }