private void FrmAMarca_FormClosed(object sender, FormClosedEventArgs e)
{
FrmMenu fmmenu = new FrmMenu();
FrmMarca fmMarca = new FrmMarca();
fmmenu.abrirForm(fmMarca);
}
private void btnAgregar_Click(object sender, EventArgs e)
{
FrmAUbicacion fmAUbicacion = new FrmAUbicacion();
FrmMenu menu = new FrmMenu();
menu.abrirForm(fmAUbicacion);
}
private void FrmAUbicacion_FormClosed(object sender, FormClosedEventArgs e)
{
FrmUbicacion fmUbicacion = new FrmUbicacion();
FrmMenu menu = new FrmMenu();
menu.abrirForm(fmUbicacion);
}
private void FrmATF_FormClosed(object sender, FormClosedEventArgs e)
{
FrmTipoFarmaco fmTipoFarmaco = new FrmTipoFarmaco();
FrmMenu menu = new FrmMenu();
menu.abrirForm(fmTipoFarmaco);
}
private void FrmAVisita_FormClosed(object sender, FormClosedEventArgs e)
{
FrmVisitas fmvisitas = new FrmVisitas();
FrmMenu menu = new FrmMenu();
menu.abrirForm(fmvisitas);
}
private void btnAgregar_Click(object sender, EventArgs e)
{
FrmATF fmATF = new FrmATF();
FrmMenu menu = new FrmMenu();
menu.abrirForm(fmATF);
}
private void button1_Click(object sender, EventArgs e)
{
FrmRegistro fmregistro = new FrmRegistro();
FrmMenu menu = new FrmMenu();
menu.abrirForm(fmregistro);
}
private void FrmAMedicamento_FormClosed(object sender, FormClosedEventArgs e)
{
FrmMedicamento fmmedico = new FrmMedicamento();
FrmMenu fmmenu = new FrmMenu();
fmmenu.abrirForm(fmmedico);
}
private void FrmAPaciente_FormClosed(object sender, FormClosedEventArgs e)
{
FrmPaciente fmPaciente = new FrmPaciente();
FrmMenu menu = new FrmMenu();
menu.abrirForm(fmPaciente);
}
private void btnAgregar_Click(object sender, EventArgs e)
{
FrmAVisita fmAVisita = new FrmAVisita();
FrmMenu menu = new FrmMenu();
menu.abrirForm(fmAVisita);
}
private void btnAgregar_Click(object sender, EventArgs e)
{
FrmAPaciente frmAPaciente = new FrmAPaciente();
FrmMenu menu = new FrmMenu();
menu.abrirForm(frmAPaciente);
}
private void btnAgregar_Click(object sender, EventArgs e)
{
FrmAMedico frmAMedico = new FrmAMedico();
FrmMenu fmmenu = new FrmMenu();
fmmenu.abrirForm(frmAMedico);
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
FrmAMedicamento frmAM = new FrmAMedicamento();
FrmMenu fmmenu = new FrmMenu();
fmmenu.abrirForm(frmAM);
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
FrmAMarca fmAMarca = new FrmAMarca();
this.Close();
FrmMenu fmmenu = new FrmMenu();
fmmenu.abrirForm(fmAMarca);
}
private void FrmRegistro_FormClosed(object sender, FormClosedEventArgs e)
{
if (Program.tipo != "")
{
FrmMenu menu = new FrmMenu();
FrmUsuario usuario = new FrmUsuario();
menu.abrirForm(usuario);
}
else
{
FrmLogin fmLogin = new FrmLogin();
fmLogin.Show();
this.Hide();
}
}
public void abrirForm(Form form)
{
FrmMenu fmMenu = new FrmMenu();
int formCount = this.MdiChildren.Count();
if (formCount != 0)
{
foreach (Form c in this.MdiChildren)
{
c.Close();
}
}
form.MdiParent = FrmMenu.ActiveForm;
form.WindowState = FormWindowState.Maximized;
form.ControlBox = false;
form.Show();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con = new SqlConnection("Data Source=GEORGEDESK\\SQLEXPRESS;Initial Catalog=PARCIALJP;Integrated Security=True");
con.Open();
if (txtusername.Text != "" || txtpassword.Text != "")
{
string username = Helper.GetSha3Hash((txtusername.Text).ToString());
string password = Helper.GetSha3Hash((txtpassword.Text).ToString());
try
{
string query = $"SELECT COUNT(*) FROM USUARIO WHERE USERNAME = '******' AND PASSWORD = '******' AND ESTADO = 'A'";
SqlCommand cmd = new SqlCommand(query, con);
Int32 count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
// MessageBox.Show("Bienvenido " + txtusername.Text);
//seteando variable de sesion
query = $"SELECT TIPO FROM USUARIO WHERE USERNAME = '******'";
Program.tipo = Helper.soloFila(query);
FrmMenu fmMenu = new FrmMenu();
fmMenu.Show();
this.Hide();
}
else
{
MessageBox.Show("Datos incorrectos");
}
}
catch (Exception er)
{
MessageBox.Show("No se pudo ingresar al sistema " + er);
}
finally
{
con.Close();
}
}
else
{
MessageBox.Show("Datos incompletos");
}
}
private void FrmMarca_FormClosed(object sender, FormClosedEventArgs e)
{
FrmMenu fmMenu = new FrmMenu();
fmMenu.abrirMenu();
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con = new SqlConnection("Data Source=GEORGEDESK\\SQLEXPRESS;Initial Catalog=PARCIALJP;Integrated Security=True");
con.Open();
if (txtusername.Text != "" && txtpassword.Text != "" && txtpassword2.Text != "" && txtnombre.Text != "")
{
if (txtpassword2.Text != txtpassword.Text)
{
MessageBox.Show("Las Contraseñas no coinciden");
}
else
{
string username = Helper.GetSha3Hash((txtusername.Text).ToString());
string password = Helper.GetSha3Hash((txtpassword.Text).ToString());
try
{
string query = $"SELECT COUNT(*) FROM USUARIO WHERE USERNAME = '******'";
SqlCommand cmd = new SqlCommand(query, con);
Int32 count = Convert.ToInt32(cmd.ExecuteScalar());
if (count == 0)
{
try
{
string sql = $"INSERT INTO USUARIO VALUES ('{username}', '{password}', @tipo, @estado, @nombre)";
SqlCommand command = new SqlCommand(sql);
command.Parameters.AddWithValue("@nombre", txtnombre.Text);
command.Parameters.AddWithValue("@tipo", cbxtipo.SelectedValue.ToString());
command.Parameters.AddWithValue("@estado", cbxestado.SelectedValue.ToString());
Helper.DoQueryExecuterLimpio(command);
if (Program.tipo != "")
{
FrmUsuario fmusuario = new FrmUsuario();
MessageBox.Show("Usuario registrado con exito ");
this.Close();
}
else
{
MessageBox.Show("Bienvenido " + txtusername.Text);
FrmMenu fmMenu = new FrmMenu();
fmMenu.Show();
this.Hide();
}
}
catch (Exception er)
{
MessageBox.Show("No se pudo registrar " + er);
}
}
else
{
MessageBox.Show("Usuario no Disponible");
}
}
catch (Exception er)
{
MessageBox.Show("No se pudo ingresar al sistema " + er);
}
finally
{
con.Close();
}
}
}
else
{
MessageBox.Show("Datos incompletos");
}
}
