private void Button_Guardar_Click(object sender, EventArgs e) { try { TimeSpan LI, LF, MI, MF, MII, MIF, JI, JF, VI, VF, SI, SF, DI, DF; LI = new TimeSpan(dateTimePicker_LunesInicio.Value.Hour, dateTimePicker_LunesInicio.Value.Minute, dateTimePicker_LunesInicio.Value.Second); LF = new TimeSpan(dateTimePicker_LunesFinal.Value.Hour, dateTimePicker_LunesFinal.Value.Minute, dateTimePicker_LunesFinal.Value.Second); MI = new TimeSpan(dateTimePicker_MartesInicio.Value.Hour, dateTimePicker_MartesInicio.Value.Minute, dateTimePicker_MartesInicio.Value.Second); MF = new TimeSpan(dateTimePicker_MartesFinal.Value.Hour, dateTimePicker_MartesFinal.Value.Minute, dateTimePicker_MartesFinal.Value.Second); MII = new TimeSpan(dateTimePicker_MiercolesInicio.Value.Hour, dateTimePicker_MiercolesInicio.Value.Minute, dateTimePicker_MiercolesInicio.Value.Second); MIF = new TimeSpan(dateTimePicker_MiercolesFinal.Value.Hour, dateTimePicker_MiercolesFinal.Value.Minute, dateTimePicker_MiercolesFinal.Value.Second); JI = new TimeSpan(dateTimePicker_JuevesInicio.Value.Hour, dateTimePicker_JuevesInicio.Value.Minute, dateTimePicker_JuevesInicio.Value.Second); JF = new TimeSpan(dateTimePicker_JuevesFinal.Value.Hour, dateTimePicker_JuevesFinal.Value.Minute, dateTimePicker_JuevesFinal.Value.Second); VI = new TimeSpan(dateTimePicker_ViernesInicio.Value.Hour, dateTimePicker_ViernesInicio.Value.Minute, dateTimePicker_ViernesInicio.Value.Second); VF = new TimeSpan(dateTimePicker_ViernesFinal.Value.Hour, dateTimePicker_ViernesFinal.Value.Minute, dateTimePicker_ViernesFinal.Value.Second); SI = new TimeSpan(dateTimePicker_SabadoInicio.Value.Hour, dateTimePicker_SabadoInicio.Value.Minute, dateTimePicker_SabadoInicio.Value.Second); SF = new TimeSpan(dateTimePicker_SabadoFinal.Value.Hour, dateTimePicker_SabadoFinal.Value.Minute, dateTimePicker_SabadoFinal.Value.Second); DI = new TimeSpan(dateTimePicker_DomingoInicio.Value.Hour, dateTimePicker_DomingoInicio.Value.Minute, dateTimePicker_DomingoInicio.Value.Second); DF = new TimeSpan(dateTimePicker_DomingoFinal.Value.Hour, dateTimePicker_DomingoFinal.Value.Minute, dateTimePicker_DomingoFinal.Value.Second); if (db.HorarioOperaciones.Where(x => x.IdCliente == this.IdCliente).Any()) { GetHorarioOperaciones_Result HO = db.GetHorarioOperaciones(this.IdCliente).First(); db.UpdateHorarioOperaciones(HO.Id, HO.IdCliente, DI, DF, LI, LF, MI, MF, MII, MIF, JI, JF, VI, VF, SI, SF); } else { db.InsertHorarioOperaciones(Guid.NewGuid(), this.IdCliente, DI, DF, LI, LF, MI, MF, MII, MIF, JI, JF, VI, VF, SI, SF, true, DateTime.Now, this.IdUsuario); } MetroFramework.MetroMessageBox.Show(this, "Se ha guardado correctamente el horario!.", "Horario", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MetroFramework.MetroMessageBox.Show(this, ex.Message + "\n" + ex.InnerException, "Hubo un error", MessageBoxButtons.OK, MessageBoxIcon.Stop); } }