private void AgregarRegistroForm_Load(object sender, EventArgs e)
{
if (Verificar())
{
BtVincular.Enabled = true;
}
else
{
BtVincular.Enabled = false;
}
DataBaseControl DbControl = new DataBaseControl(DataBaseControl.cPath, "ProjectDataBase.mdf");
string[] para = new string[] { "@algo" };
string[] val = new string[] { " " };
List <string[]> alumnos = DbControl.Buscar("Select [ID] from Alumnos where [ID]!=@algo", para, val, 1);
foreach (string[] list in alumnos)
{
foreach (string objeto in list)
{
CBAlumno.Items.Add(objeto);
}
}
para = new string[] { "@algo" };
val = new string[] { " " };
List <string[]> Materias = DbControl.Buscar("Select [Clave] from Materias where [Clave]!=@algo", para, val, 1);
foreach (string[] list in Materias)
{
foreach (string objeto in list)
{
CBMateria.Items.Add(objeto);
}
}
}
private void BtEliminar_Click(object sender, EventArgs e)
{
try
{
DataBaseControl DBControl = new DataBaseControl(DataBaseControl.cPath, "ProjectDataBase.mdf");
string[] para = { "@user" };
string[] ele = { TxtUserName.Text };
if (DBControl.Buscar("Select * from [Registro] where [materia]= @user", para, ele))
{
MessageBox.Show("Esta materia actualmente figura en una seccion, imposible eliminar");
TxtUserName.Clear();
return;
}
else
{
if (DBControl.Eliminar("Delete from [Materias] where [Clave] = @user", para, ele))
{
MessageBox.Show("Materia eliminado con exito");
LVUsuarios.Clear();
}
else
{
MessageBox.Show("Error al eliminar Materia");
}
}
}
catch (Exception) { MessageBox.Show("Por favor, verificar los datos"); }
}
private void BtVincular_Click(object sender, EventArgs e)
{
try
{
bool keep = true;
DataBaseControl DbControl = new DataBaseControl(DataBaseControl.cPath, "ProjectDataBase.mdf");
string[] parameters = { "@word" };
string[] value = { CBAlumno.SelectedItem.ToString() };
keep = DbControl.Buscar("Select * from Alumnos where [ID] = @word", parameters, value);
if (keep)
{
parameters = new string[] { "@word" };
value = new string[] { CBMateria.SelectedItem.ToString() };
keep = DbControl.Buscar("Select * from Materias where [Clave] = @word", parameters, value);
if (!keep)
{
keep = false;
}
}
if (keep == false)
{
MessageBox.Show("Es imposible vincular una materia a un estudiante si uno de los dos no existe");
}
else
{
string[] Parameters = new string[] { "@Alm", "@Mat" };
string[] values = new string[] { CBAlumno.SelectedItem.ToString(), CBMateria.SelectedItem.ToString() };
if (!DbControl.Buscar("Select * from [Registro] where [Alumno] = @Alm and [Materia] = @Mat", Parameters, values))
{
DbControl.Insertar("Insert into [Registro] ([Alumno],[Materia]) values (@Alm,@Mat)", Parameters, values);
MessageBox.Show(string.Format("{0} fue inscrito en {1}", CBMateria.SelectedItem.ToString(), CBMateria.SelectedItem.ToString()));
CBAlumno.SelectedItem = null;
CBMateria.SelectedItem = null;
Verificar();
}
else
{
MessageBox.Show("El alumno ya está inscrito en esta materia");
}
}
}
catch (Exception) { MessageBox.Show("Por favor, verifique los datos"); }
}
private void TxtUserName_TextChanged(object sender, EventArgs e)
{
if (TxtUserName.Text.Length > 0)
{
DataBaseControl DBControl = new DataBaseControl(DataBaseControl.cPath, "ProjectDataBase.mdf");
LVUsuarios.Clear();
string[] _parameters = { "@userN", "@Materia" };
string[] _element = { TxtUserName.Text, TxtMateria.Text };
foreach (string[] item in DBControl.Buscar("Select [Materia] from [Registro] where [Alumno] = @userN ", _parameters, _element, 1))
{
foreach (var it in item)
{
LVUsuarios.Items.Add(new ListViewItem(it));
}
}
}
}
private void TxtUserName_TextChanged(object sender, EventArgs e)
{
if (TxtUserName.Text.Length > 0)
{
DataBaseControl DBControl = new DataBaseControl(DataBaseControl.cPath, "ProjectDataBase.mdf");
LVUsuarios.Clear();
string[] _parameters = { "@userN" };
string[] _element = { TxtUserName.Text };
string[] _returned = { "UserName" };
foreach (string[] item in DBControl.Buscar("Select [ID] from [Maestros] where [ID] like '%' + @userN + '%'", _parameters, _element, 1))
{
foreach (var it in item)
{
LVUsuarios.Items.Add(new ListViewItem(it));
}
}
}
}