public bool UpdateRecord(Horario obj, int idHorario)
{
SqlConnection con = new SqlConnection(Info.sqlSet());
SqlCommand cmd = new SqlCommand("SP_Horario_Update", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IdHorario", idHorario);
cmd.Parameters.AddWithValue("@HoraIn", obj.HoraIn);
cmd.Parameters.AddWithValue("@HoraOut", obj.HoraOut);
cmd.Parameters.AddWithValue("@HoraInMed", obj.HoraInMed);
cmd.Parameters.AddWithValue("@HoraOutMed", obj.HoraOutMed);
cmd.Parameters.AddWithValue("@Lunes", obj.Lunes);
cmd.Parameters.AddWithValue("@Martes", obj.Martes);
cmd.Parameters.AddWithValue("@Miercoles", obj.Miercoles);
cmd.Parameters.AddWithValue("@Jueves", obj.Jueves);
cmd.Parameters.AddWithValue("@Viernes", obj.Viernes);
cmd.Parameters.AddWithValue("@Sabado", obj.Sabado);
cmd.Parameters.AddWithValue("@Domingo", obj.Domingo);
con.Open();
if (cmd.ExecuteNonQuery() > 0)
{
con.Close();
return true;
}
else
{
con.Close();
return false;
}
}
public string Create(Horario obj)
{
CreateDAC objDAC = new CreateDAC();
if (objDAC.CreateRecord(obj) == true)
return "Registro almacenado con éxito.";
else
return "No se pudo almacenar el regitro.";
}
public string Update(Horario obj, int idHorario)
{
UpdateDAC objDAC = new UpdateDAC();
if (objDAC.UpdateRecord(obj, idHorario) == true)
return "Registro almacenado con éxito.";
else
return "No se pudo almacenar el regitro.";
}
public SingleHorario(Horario reg)
{
InitializeComponent();
horario = reg;
this.DataContext = horario;
btnActualizar.Visibility = Visibility.Visible;
btnGuardar.Visibility = Visibility.Collapsed;
}
public List<Horario> readHorario()
{
List<Horario> horarioList = new List<Horario>();
using (SqlConnection con = new SqlConnection(Info.sqlSet()))
{
SqlCommand cmd = new SqlCommand("SP_Horario_SelectAll", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
// Loop through each record.
while (reader.Read())
{
Horario tmp = new Horario();
tmp.IdHorario = (reader.GetValue(0) != DBNull.Value) ? Convert.ToInt32(reader.GetValue(0)) : tmp.IdHorario;
tmp.HoraIn = (reader.GetValue(1) != DBNull.Value) ? Convert.ToDateTime(reader.GetValue(1)) : tmp.HoraIn;
tmp.HoraOut = (reader.GetValue(2) != DBNull.Value) ? Convert.ToDateTime(reader.GetValue(2)) : tmp.HoraOut;
tmp.HoraInMed = (reader.GetValue(3) != DBNull.Value) ? Convert.ToDateTime(reader.GetValue(3)) : tmp.HoraInMed;
tmp.HoraOutMed = (reader.GetValue(4) != DBNull.Value) ? Convert.ToDateTime(reader.GetValue(4)) : tmp.HoraOutMed;
tmp.Lunes = (reader.GetValue(5) != DBNull.Value) ? Convert.ToBoolean(reader.GetValue(5)) : tmp.Lunes;
tmp.Martes = (reader.GetValue(6) != DBNull.Value) ? Convert.ToBoolean(reader.GetValue(6)) : tmp.Martes;
tmp.Miercoles = (reader.GetValue(7) != DBNull.Value) ? Convert.ToBoolean(reader.GetValue(7)) : tmp.Miercoles;
tmp.Jueves = (reader.GetValue(8) != DBNull.Value) ? Convert.ToBoolean(reader.GetValue(8)) : tmp.Jueves;
tmp.Viernes = (reader.GetValue(9) != DBNull.Value) ? Convert.ToBoolean(reader.GetValue(9)) : tmp.Viernes;
tmp.Sabado = (reader.GetValue(10) != DBNull.Value) ? Convert.ToBoolean(reader.GetValue(10)) : tmp.Sabado;
tmp.Domingo = (reader.GetValue(11) != DBNull.Value) ? Convert.ToBoolean(reader.GetValue(11)) : tmp.Domingo;
horarioList.Add(tmp);
}
}
con.Close();
}
return horarioList;
}