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));
}
