public SqlDataReader iniciarsesion(string user, string pass)
{
string sql = "select*from usuarios where NombreUsuario='" + user + "' and Contrasenia='" + pass + "'";
SqlCommand comando = new SqlCommand();
comando.Connection = Conexion.AbrirConexion();
comando.CommandText = sql;
leer = comando.ExecuteReader();
return(leer);
}
public static int Promediomescomp(promediomescomp pPromediomescomp)
{
int retorno3 = 0;
conection a = new conection();
using (SqlConnection conn = a.AbrirConexion())
{
SqlCommand comando = new SqlCommand(String.Format("insert into PromedioMensualComp(IdAlumnoPre,CalificacionComp,NombreMes) values('{0}','{1}','{2}') ",
pPromediomescomp.IdAlumnoPre, pPromediomescomp.CalificacionComp, pPromediomescomp.NombreMes), conn);
retorno3 = comando.ExecuteNonQuery();
//retorno2 = comando.ExecuteNonQuery();
}
return(retorno3);
}
public static int Calificaciongral1(Calificaciongral1 pPromediogeneral)
{
int retorno4 = 0;
conection a = new conection();
using (SqlConnection conn = a.AbrirConexion())
{
SqlCommand comando = new SqlCommand(String.Format("insert into PromedioGeneral(IdAlumnoPre,PromedioGeneral,TotalPuntos,Inasistencias,NombreMes) values('{0}','{1}','{2}','{3}','{4}') ",
pPromediogeneral.IdAlumnoPre, pPromediogeneral.PromedioGeneral, pPromediogeneral.TotalPuntos, pPromediogeneral.Inasistencias, pPromediogeneral.NombreMes), conn);
retorno4 = comando.ExecuteNonQuery();
//retorno2 = comando.ExecuteNonQuery();
}
return(retorno4);
}
public static int Agregarcalif(llenadomes pCalifica)
{
conection a = new conection();
int retorno1 = 0;
using (SqlConnection conn = a.AbrirConexion())
{
// paso 2
// Conexion e insercion de datos en la tabla de calificaciones
SqlCommand comando = new SqlCommand(String.Format("insert into CalificacionMensual(IdAlumnoPre,IdMaterias,Calificacion,NombreMes) values('{0}','{1}','{2}','{3}') ",
pCalifica.IdAlumnoPre, pCalifica.IdMaterias, pCalifica.Calificacion, pCalifica.NombreMes), conn);
retorno1 = comando.ExecuteNonQuery();
}
return(retorno1);
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
comando.Connection = conexion.AbrirConexion();
SqlCommand cmd = new SqlCommand("buscar2", conectar);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Curp", textBox1.Text);
conectar.Close();
conectar.Open();
SqlDataReader reader = cmd.ExecuteReader();
// SqlDataReader leer = comando.ExecuteReader();
if (reader.Read())
{
gradotxt.Text = Convert.ToString(reader["Grado"]);
// if (reader.Read() == true)
{
gradotxt.Text = reader["Grado"].ToString();
if (gradotxt.Text == "6°A")
{
boleta4_6 frm = this.FormInstance;
frm.curp = Convert.ToString(textBox1.Text);
if (frm.WindowState == FormWindowState.Minimized)
{
frm.WindowState = FormWindowState.Normal;
}
AddOwnedForm(frm);
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
//frm.TopLevel = false;
frm.StartPosition = FormStartPosition.CenterScreen;
//frm.Dock = DockStyle.Fill;
//this.Controls.Add(frm);
this.Tag = frm;
frm.BringToFront();
frm.Enabled = true;
frm.Visible = true;
frm.Show();
}
if (gradotxt.Text == "2°A")
{
Boleta1_2 frm = this.FormInstan;
frm.curp = Convert.ToString(textBox1.Text);
if (frm.WindowState == FormWindowState.Minimized)
{
frm.WindowState = FormWindowState.Normal;
}
AddOwnedForm(frm);
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
//frm.TopLevel = false;
frm.StartPosition = FormStartPosition.CenterScreen;
//frm.Dock = DockStyle.Fill;
//this.Controls.Add(frm);
this.Tag = frm;
frm.BringToFront();
frm.Enabled = true;
frm.Visible = true;
frm.Show();
}
if (gradotxt.Text == "3°A")
{
boletas3AS frm = this.FormInstanc;
frm.curp = Convert.ToString(textBox1.Text);
if (frm.WindowState == FormWindowState.Minimized)
{
frm.WindowState = FormWindowState.Normal;
}
AddOwnedForm(frm);
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
//frm.TopLevel = false;
frm.StartPosition = FormStartPosition.CenterScreen;
//frm.Dock = DockStyle.Fill;
//this.Controls.Add(frm);
this.Tag = frm;
frm.BringToFront();
frm.Enabled = true;
frm.Visible = true;
frm.Show();
}
if (gradotxt.Text == "4°A")
{
boleta4_6 frm = this.FormInstance;
frm.curp = Convert.ToString(textBox1.Text);
if (frm.WindowState == FormWindowState.Minimized)
{
frm.WindowState = FormWindowState.Normal;
}
AddOwnedForm(frm);
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
//frm.TopLevel = false;
frm.StartPosition = FormStartPosition.CenterScreen;
//frm.Dock = DockStyle.Fill;
//this.Controls.Add(frm);
this.Tag = frm;
frm.BringToFront();
frm.Enabled = true;
frm.Visible = true;
frm.Show();
}
if (gradotxt.Text == "5°A")
{
boleta4_6 frm = this.FormInstance;
frm.curp = Convert.ToString(textBox1.Text);
if (frm.WindowState == FormWindowState.Minimized)
{
frm.WindowState = FormWindowState.Normal;
}
AddOwnedForm(frm);
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
//frm.TopLevel = false;
frm.StartPosition = FormStartPosition.CenterScreen;
//frm.Dock = DockStyle.Fill;
//this.Controls.Add(frm);
this.Tag = frm;
frm.BringToFront();
frm.Enabled = true;
frm.Visible = true;
frm.Show();
}
if (gradotxt.Text == "1°A")
{
Boleta1_2 frm = this.FormInstan;
frm.curp = Convert.ToString(textBox1.Text);
if (frm.WindowState == FormWindowState.Minimized)
{
frm.WindowState = FormWindowState.Normal;
}
AddOwnedForm(frm);
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
//frm.TopLevel = false;
frm.StartPosition = FormStartPosition.CenterScreen;
//frm.Dock = DockStyle.Fill;
//this.Controls.Add(frm);
this.Tag = frm;
frm.BringToFront();
frm.Enabled = true;
frm.Visible = true;
frm.Show();
}
}
}
}
//public SqlConnection conectar = new SqlConnection("Data Source = DESKTOP-MIH3BF9\\MSSQLSERVER01;Initial Catalog = ControlEscolar;Integrated Security = true");
////public DataSet ds;
//private ConexionBD conexion = new ConexionBD();
//private SqlCommand comando = new SqlCommand();
//private readonly CDUsuarios objDato = new CDUsuarios();
//private SqlDataReader LeerFilas;
public void insertarAlumno(string Curp, string Nombre, string Paterno, string Materno, int Edad, string FechaNacimiento, string Grado, string Sexo, string sangre, string Alergia)
{
Comando.Connection = Conexion.AbrirConexion();
Comando.CommandText = "insertaralumno";
Comando.CommandType = CommandType.StoredProcedure;
Comando.Parameters.AddWithValue("@Curp", Curp);
Comando.Parameters.AddWithValue("@Nombre", Nombre);
Comando.Parameters.AddWithValue("@Paterno", Paterno);
Comando.Parameters.AddWithValue("@Materno", Materno);
Comando.Parameters.AddWithValue("@Edad", Edad);
Comando.Parameters.AddWithValue("@FechaNacimiento", FechaNacimiento);
Comando.Parameters.AddWithValue("@Grado", Grado);
Comando.Parameters.AddWithValue("@Sexo", Sexo);
Comando.Parameters.AddWithValue("@Tipo_Sangre", sangre);
Comando.Parameters.AddWithValue("@Alergia", Alergia);
Comando.ExecuteNonQuery();
Comando.Parameters.Clear();
}