private void btnAdicionar_Click(object sender, EventArgs e) { if (cboProfessor.SelectedValue == null || (int)cboProfessor.SelectedValue == 0) { Msg.Alert("Selecione o professor antes de continuar..."); return; } using (FrmTurmaDia frmTurmaDia = new FrmTurmaDia(null)) { frmTurmaDia.ShowDialog(); if (frmTurmaDia.Tag != null && frmTurmaDia.Tag is TurmaDia) { List <TurmaDia> LstTd = new TurmaDia().ToListProfessor((int)cboProfessor.SelectedValue); TurmaDia td = (TurmaDia)frmTurmaDia.Tag; if (_LstDias.Where(x => x.Nu_DiaSemana == td.Nu_DiaSemana && x.Tm_Horario == td.Tm_Horario).Count() > 0 || LstTd.Where(x => x.Nu_DiaSemana == td.Nu_DiaSemana && x.Tm_Horario == td.Tm_Horario).Count() > 0) { Msg.Alert("Professor já possui aula marcada para a data/hora selecionado"); return; } _LstDias.Add(td); GridRefresh(); } } }
public int Delete(TurmaDia objDelete) { using (var DBContext = new SQLServer()) { return(DBContext.CommandExecute(_SQLDelete, objParameters(objDelete))); } }
public int Insert(TurmaDia objInsert) { using (var DBContext = new SQLServer()) { return(DBContext.CommandExecute(_SQLInsert, objParameters(objInsert))); } }
private SqlParameter[] objParameters(TurmaDia obj) { List <SqlParameter> LstParameters = new List <SqlParameter>(); LstParameters.Add(new SqlParameter("@Id_TurmaDia", obj.Id_TurmaDia)); LstParameters.Add(new SqlParameter("@Id_Turma", obj.Id_Turma)); LstParameters.Add(new SqlParameter("@Nu_DiaSemana", obj.Nu_DiaSemana)); LstParameters.Add(new SqlParameter("@Tm_Horario", obj.Tm_Horario)); return(LstParameters.ToArray()); }
private void FillForm() { if (_obj == null) { _obj = new TurmaDia(); } else { cboDia.SelectedIndex = _obj.Nu_DiaSemana; dtpHorario.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, _obj.Tm_Horario.Hours, _obj.Tm_Horario.Minutes, _obj.Tm_Horario.Seconds); } }
private void dgvData_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { object Data = dgvData.Rows[e.RowIndex].DataBoundItem; if (Data != null && Data is TurmaDia) { TurmaDia obj = (TurmaDia)Data; switch (dgvData.Columns[e.ColumnIndex].Name) { case "clmEdit": using (FrmTurmaDia frmTurmaDia = new FrmTurmaDia(new TurmaDia { Id_TurmaDia = obj.Id_TurmaDia, Id_Turma = obj.Id_Turma, Nu_DiaSemana = obj.Nu_DiaSemana, Tm_Horario = obj.Tm_Horario })) { frmTurmaDia.ShowDialog(); if (frmTurmaDia.Tag != null && frmTurmaDia.Tag is TurmaDia) { List <TurmaDia> LstTd = new TurmaDia().ToListProfessor((int)cboProfessor.SelectedValue); TurmaDia td = (TurmaDia)frmTurmaDia.Tag; if (_LstDias.Where(x => x.Nu_DiaSemana == td.Nu_DiaSemana && x.Tm_Horario == td.Tm_Horario && x.Id_TurmaDia != td.Id_TurmaDia).Count() > 0 || LstTd.Where(x => x.Nu_DiaSemana == td.Nu_DiaSemana && x.Tm_Horario == td.Tm_Horario && x.Id_TurmaDia != td.Id_TurmaDia).Count() > 0) { Msg.Alert("Professor já possui aula marcada para a data/hora selecionado"); return; } obj.Nu_DiaSemana = td.Nu_DiaSemana; obj.Tm_Horario = td.Tm_Horario; GridRefresh(); } }; break; case "clmDelete": if (obj.Id_TurmaDia == 0 || Msg.Question("Deseja realmente excluir o registro??", "Excluir Registro")) { _LstDias.Remove(obj); _LstDiasRetirados.Add(obj); GridRefresh(); } break; } } } }
private void InitializeForms() { VerticalScroll.Visible = true; _LstDiasRetirados = new List <TurmaDia>(); dgvData.AutoGenerateColumns = false; if (_obj == null) { _obj = new Turma() { St_Concluido = false }; _LstDias = new List <TurmaDia>(); _obj.St_Concluido = false; } else { _LstDias = new TurmaDia().ToList(_obj.Id_Turma); cboCurso.SelectedValue = _obj.Id_Curso; cboProfessor.SelectedValue = _obj.Id_Professor; dtpInicio.Value = _obj.Dt_Inicio; dtpTermino.Value = _obj.Dt_Termino; GridRefresh(); } }
public FrmTurmaDia(TurmaDia obj) { _obj = obj; InitializeComponent(); FillForm(); }
public int Delete(TurmaDia obj) { return(_IDAO.Delete(obj)); }
public int Update(TurmaDia obj) { return(_IDAO.Update(obj)); }
public int Insert(TurmaDia obj) { return(_IDAO.Insert(obj)); }