private void savebuttonstrip_Click(object sender, EventArgs e) { carga man = new carga(); if (savebuttonstrip.Text == "GUARDAR") { man.WindowState = FormWindowState.Normal; if (gottendegree.Text == "" || nameEmployeeBox.Text == "" || idBox.Text == "" || telephoneNumberBox.Text == "" || schedule.Text == "" || cargobox.Text == "" || comboNacionalidad.Text == "" || ageBox.Text == "" || mensualitybox.Text == "" || personalReferenceBox.Text == "" || telephoneReferenceBox.Text == "" || relationReferenceBox.Text == "" || AlergyNmaeBox.Text == "" || DolenciaNameBox.Text == "" || nameMedicineBox.Text == "" || MotivoMedicineBox.Text == "") { MessageBox.Show("Hay datos importantes vacios, termine el formulario."); if (gottendegree.Text == "") { gottendegree.BackColor = Color.Red; } else { gottendegree.BackColor = Color.Green; } if (nameEmployeeBox.Text == "") { nameEmployeeBox.BackColor = Color.Red; } else { nameEmployeeBox.BackColor = Color.Green; } if (idBox.Text == "") { idBox.BackColor = Color.Red; } else { idBox.BackColor = Color.Green; } if (telephoneNumberBox.Text == "") { telephoneNumberBox.BackColor = Color.Red; } else { telephoneNumberBox.BackColor = Color.Green; } if (schedule.Text == "") { schedule.BackColor = Color.Red; } else { schedule.BackColor = Color.Green; } if (cargobox.Text == "") { cargobox.BackColor = Color.Red; } else { cargobox.BackColor = Color.Green; } if (comboNacionalidad.Text == "") { comboNacionalidad.BackColor = Color.Red; } else { comboNacionalidad.BackColor = Color.Green; } if (ageBox.Text == "") { ageBox.BackColor = Color.Red; } else { ageBox.BackColor = Color.Green; } if (mensualitybox.Text == "") { mensualitybox.BackColor = Color.Red; } else { mensualitybox.BackColor = Color.Green; } if (personalReferenceBox.Text == "") { personalReferenceBox.BackColor = Color.Red; } else { personalReferenceBox.BackColor = Color.Green; } if (telephoneReferenceBox.Text == "") { telephoneReferenceBox.BackColor = Color.Red; } else { telephoneReferenceBox.BackColor = Color.Green; } if (relationReferenceBox.Text == "") { relationReferenceBox.BackColor = Color.Red; } else { relationReferenceBox.BackColor = Color.Green; } if (AlergyNmaeBox.Text == "") { AlergyNmaeBox.BackColor = Color.Red; } else { AlergyNmaeBox.BackColor = Color.Green; } if (DolenciaNameBox.Text == "") { DolenciaNameBox.BackColor = Color.Red; } else { DolenciaNameBox.BackColor = Color.Green; } if (nameMedicineBox.Text == "") { nameMedicineBox.BackColor = Color.Red; } else { nameMedicineBox.BackColor = Color.Green; } if (MotivoMedicineBox.Text == "") { MotivoMedicineBox.BackColor = Color.Red; } else { MotivoMedicineBox.BackColor = Color.Green; } } else { try { string userDataName = UserAccessForm.getusername() + "_employee_table"; EmployeeClass employee = new EmployeeClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); employee.NameNoCopied(nameEmployeeBox.Text, userDataName); int age = int.Parse(ageBox.Text); double mensuality = double.Parse(mensualitybox.Text); DateTime birthdate = Convert.ToDateTime(birthDateBox.Value.Date); DateTime timegetin = Convert.ToDateTime(dategetin.Value.ToShortTimeString()); string access = userDataName; if (mensualitybox.BackColor == Color.Red) { MessageBox.Show("Arregle el campo no valido"); } else { if (employee.NameNoCopied(nameEmployeeBox.Text, userDataName) == true) { man.Close(); MessageBox.Show("El Empleado " + nameEmployeeBox.Text + " ya existe."); if (MessageBox.Show("Agregar a otro empleado?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { employee = new EmployeeClass(); DireccionGestor menu = new DireccionGestor(); menu.WindowState = FormWindowState.Normal; menu.Show(); this.Close(); } else { employee = new EmployeeClass(); EmployeeForm menu = new EmployeeForm(); menu.WindowState = FormWindowState.Normal; menu.Show(); this.Close(); } } else if (employee.NameNoCopied(nameEmployeeBox.Text, userDataName) == false) { if (gottendegree.Text == "" || nameEmployeeBox.Text == "" || idBox.Text == "" || telephoneNumberBox.Text == "" || schedule.Text == "" || cargobox.Text == "" || comboNacionalidad.Text == "" || ageBox.Text == "" || mensualitybox.Text == "" || personalReferenceBox.Text == "" || telephoneReferenceBox.Text == "" || relationReferenceBox.Text == "" || AlergyNmaeBox.Text == "" || DolenciaNameBox.Text == "" || nameMedicineBox.Text == "" || MotivoMedicineBox.Text == "") { MessageBox.Show("Hay datos importantes vacios, termine el formulario."); } else { string date = birthDateBox.Value.Day.ToString() + "/" + birthDateBox.Value.Month.ToString() + "/" + birthDateBox.Value.Year.ToString(); string evento = birthDateBox.Value.Day.ToString() + "/" + birthDateBox.Value.Month.ToString(); string eventoname = "CUMPLEAÑOS DE " + nameEmployeeBox.Text; AgendaClass addevent = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); addevent.saveData(UserAccessForm.getusername(), eventoname, 1, date, "7:20:0", "NO", "NO", "NO", "NO", "NO", "NO", "NO", evento, "SI", ""); LoginClass add = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); add.AddContact(nameEmployeeBox.Text, telephoneNumberBox.Text, direccionbox.Text, emailcombo.Text, UserAccessForm.getusername().ToString()); if (employee.SaveData(userDataName, dategetin, gottendegree.Text, nameEmployeeBox.Text, idBox.Text, birthDateBox, telephoneNumberBox.Text, schedule.Text, cargobox.Text, comboNacionalidad.Text, age, mensuality, personalReferenceBox.Text, telephoneReferenceBox.Text, relationReferenceBox.Text, AlergyNmaeBox.Text, DolenciaNameBox.Text, nameMedicineBox.Text, MotivoMedicineBox.Text, picturetextbox.Text, monedatipo.Text, sexobox.Text, direccionbox.Text, emailcombo.Text)) { man.Close(); employee.NameNoCopied(nameEmployeeBox.Text, userDataName); employee.OrderID(userDataName); MessageBox.Show("NUEVO EMPLEADO " + nameEmployeeBox.Text + " HA SIDO AGREGADO."); if (MessageBox.Show("Agregar a otro empleado?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { employee = new EmployeeClass(); DireccionGestor menu = new DireccionGestor(); menu.WindowState = FormWindowState.Normal; menu.Show(); this.Close(); } else { employee = new EmployeeClass(); EmployeeForm menu = new EmployeeForm(); menu.WindowState = FormWindowState.Normal; menu.Show(); this.Close(); } } else { man.Close(); MessageBox.Show("NUEVO EMPLEADO " + nameEmployeeBox.Text + "HA SIDO AGREGADO."); if (MessageBox.Show("Agregar a otro empleado?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { employee = new EmployeeClass(); DireccionGestor menu = new DireccionGestor(); menu.WindowState = FormWindowState.Normal; menu.Show(); this.Close(); } else { employee = new EmployeeClass(); EmployeeForm menu = new EmployeeForm(); menu.WindowState = FormWindowState.Normal; menu.Show(); this.Close(); } } } } } } catch (FormatException datethis) { datethis.ToString(); } } } else if (savebuttonstrip.Text == "MODIFICAR") { man.WindowState = FormWindowState.Normal; if (referenciaopcionbox.Text == "NO") { man.Close(); telephoneNumberBox.Text = "NINGUNA"; relationReferenceBox.Text = "NINGUNA"; personalReferenceBox.Text = "NINGUNA"; } try { man.Close(); string userDataName = UserAccessForm.getusername() + "_employee_table"; EmployeeClass save = new EmployeeClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); AgendaClass addevent = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); double mensuality = double.Parse(mensualitybox.Text); string nameevent = "CUMPLEAÑOS DE " + nameEmployeeBox.Text; string date = birthDateBox.Value.Day.ToString() + "/" + birthDateBox.Value.Month.ToString() + "/" + birthDateBox.Value.Year.ToString(); string momentdate = birthDateBox.Value.Day.ToString() + "/" + birthDateBox.Value.Month.ToString(); save.ModifyData(DireccionGestor.getnombrestatic(), trabajando.Text, userDataName, dategetin, salidapicker, gottendegree.Text, nameEmployeeBox.Text, idBox.Text, birthDateBox, telephoneNumberBox.Text, schedule.Text, cargobox.Text, comboNacionalidad.Text, int.Parse(ageBox.Text), mensuality, personalReferenceBox.Text, telephoneNumberBox.Text, relationReferenceBox.Text, AlergyNmaeBox.Text, DolenciaNameBox.Text, nameMedicineBox.Text, MotivoMedicineBox.Text, picturetextbox.Text, monedatipo.Text, sexobox.Text, direccionbox.Text, emailcombo.Text, EmployeeClass.getids()); addevent.modifydata(UserAccessForm.getusername(), DireccionGestor.getnombrestatic(), nameevent, 1, date, "7:20:0", "NO", "NO", "NO", "NO", "NO", "NO", "NO", momentdate, "SI"); LoginClass add = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); add.editContact(nameEmployeeBox.Text, telephoneNumberBox.Text, direccionbox.Text, emailcombo.Text, DireccionGestor.getnombrestatic(), UserAccessForm.getusername().ToString()); MessageBox.Show("EL EMPLEADO " + nameEmployeeBox.Text + " HA SIDO MODIFICADO"); EmployeeClass studentobject = new EmployeeClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); EmployeeFormSearch buscar = new EmployeeFormSearch(); buscar.WindowState = FormWindowState.Maximized; buscar.Show(); this.Close(); } catch (FormatException datethis) { datethis.ToString(); } } }
private void dataGrid_DoubleClick(object sender, EventArgs e) { try { dataout = new string[5]; LoginClass ver = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string dato = this.dataGrid.CurrentCell.Value.ToString(); string orden = "SELECT * FROM " + UserAccessForm.getusername() + "_contacts_table WHERE NOMBRE='" + dato + "';"; if (ver.fillcombos(namecombo, telefonocombo, orden)) { editbutton.Enabled = true; quitarbutton.Enabled = true; try { dataout[0] = namecombo.Text; dataout[1] = telefonocombo.Text; dataout[2] = LoginClass.getdata()[0]; dataout[3] = LoginClass.getdata()[1]; dataout[4] = LoginClass.getdata()[2]; DireccionGestor.setorigen("editor"); addContact add = new addContact(); add.WindowState = FormWindowState.Normal; add.Show(); } catch (IndexOutOfRangeException por) { por.ToString(); } this.Close(); } else { editbutton.Enabled = false; quitarbutton.Enabled = false; } } catch (NullReferenceException pafh) { pafh.ToString(); } }
private void quitarbutton_Click(object sender, EventArgs e) { LoginClass ver = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string orden = "DELETE FROM " + UserAccessForm.getusername() + "_contacts_table WHERE ID='" + dataout[4] + "';"; ver.ordensql(orden); editbutton.Enabled = false; quitarbutton.Enabled = false; orden = "SELECT NOMBRE,TELEFONO,DIRECCION,EMAIL FROM " + UserAccessForm.getusername() + "_contacts_table;"; ver.ShowDataGridFound(dataGrid, orden); cuentalabel.Text = ver.getcuenta().ToString(); namecombo.Text = ""; telefonocombo.Text = ""; MessageBox.Show("CONTACTO ELIMINADO"); }
private void savebuttonstrip_Click(object sender, EventArgs e) { if (passwordbox.Text == "" || answerbox1.Text == "" || answerbox2.Text == "" || answerbox3.Text == "" || answerbox4.Text == "" || answerbox5.Text == "") { if (passwordbox.Text == "") { passwordbox.BackColor = Color.Red; } else { passwordbox.BackColor = Color.Green; } if (answerbox1.Text == "") { answerbox1.BackColor = Color.Red; } else { answerbox1.BackColor = Color.Green; } if (answerbox2.Text == "") { answerbox2.BackColor = Color.Red; } else { answerbox2.BackColor = Color.Green; } if (answerbox3.Text == "") { answerbox3.BackColor = Color.Red; } else { answerbox3.BackColor = Color.Green; } if (answerbox4.Text == "") { answerbox4.BackColor = Color.Red; } else { answerbox4.BackColor = Color.Green; } if (answerbox5.Text == "") { answerbox5.BackColor = Color.Red; } else { answerbox5.BackColor = Color.Green; } } else { LoginClass log = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); if (log.setConectionsecurity(userlabel.Text, passwordbox.Text, answerbox1.Text, answerbox2.Text, answerbox3.Text, answerbox4.Text, answerbox5.Text) == true) { count = 0; UsersShowForm begin = new UsersShowForm(); begin.WindowState = FormWindowState.Normal; begin.Show(); this.Close(); } else { problempanel.Show(); MessageBox.Show("ERROR AL INTRODUCIR DATOS"); if (count == 5) { MessageBox.Show("POR MOTIVOS DE SEGURIDAD SE CERRARA LA APLICACION"); this.Dispose(); Application.Exit(); } count++; } } }
private void buscarbutton_Click(object sender, EventArgs e) { string orden = ""; if (namecombo.Text == "") { orden = "SELECT NOMBRE,TELEFONO,DIRECCION,EMAIL FROM " + UserAccessForm.getusername() + "_contacts_table WHERE TELEFONO='" + telefonocombo.Text + "';"; } else if (telefonocombo.Text == "") { orden = "SELECT NOMBRE,TELEFONO,DIRECCION,EMAIL FROM " + UserAccessForm.getusername() + "_contacts_table WHERE NOMBRE='" + namecombo.Text + "';"; } else { orden = "SELECT NOMBRE,TELEFONO,DIRECCION,EMAIL FROM " + UserAccessForm.getusername() + "_contacts_table WHERE NOMBRE='" + namecombo.Text + "' AND TELEFONO='" + telefonocombo.Text + "';"; } LoginClass ver = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); ver.ShowDataGridFound(dataGrid, orden); cuentalabel.Text = ver.getcuenta().ToString(); }
private void AddSubject_Load(object sender, EventArgs e) { OKbutton.BackColor = Color.Green; cancelbutton.BackColor = Color.Red; subjectverbutton.BackColor = Color.Blue; EmployeeClass ver = new EmployeeClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string orden = "SELECT `NOMBRE COMPLETO` FROM " + UserAccessForm.getusername() + "_employee_table;"; ver.FillNameBox(comboasignado, orden); if (DireccionGestor.getorigen() == "inicio") { titlelabel.Text = "AGREGAR ASIGNATURA"; } else if (DireccionGestor.getorigen() == "editor") { titlelabel.Text = "MODIFICAR ASIGNATURA"; try { asignaturatextbox.Text = ShowSubjects.getinfo()[0]; comboasignado.Text = ShowSubjects.getinfo()[1]; descripcionbox.Text = ShowSubjects.getinfo()[2]; subjectverbutton.Enabled = false; } catch (NullReferenceException epd) { epd.ToString(); } } else if (DireccionGestor.getorigen() == "buscador") { titlelabel.Text = "AGREGAR ASIGNATURA"; subjectverbutton.Enabled = false; } ver.FillNameBox(comboasignado, orden); }
private void OKbutton_Click(object sender, EventArgs e) { cuenta = 0; carga ca = new carga(); ca.WindowState = FormWindowState.Normal; ca.Show(); if (DireccionGestor.getorigen() == "inicio") { if (nombrebox.Text == "" || telefonobox.Text == "") { if (nombrebox.Text == "") { nombrebox.BackColor = Color.Red; } else { nombrebox.BackColor = Color.Green; } if (telefonobox.Text == "") { telefonobox.BackColor = Color.Red; } else { telefonobox.BackColor = Color.Green; } MessageBox.Show("HAY CAMPOS CLAVES VACIOS"); } else { if (direccionbox.Text == "") { direccionbox.Text = "NINGUNA"; } if (emailbox.Text == "") { emailbox.Text = "NINGUNA"; } try { LoginClass add = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); add.AddContact(nombrebox.Text, telefonobox.Text, direccionbox.Text, emailbox.Text, UserAccessForm.getusername().ToString()); MessageBox.Show("NUEVO CONTACTO " + nombrebox.Text + " AGREGADO"); if (MessageBox.Show("Agregar a otro empleado?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { add = new LoginClass(); this.Close(); } else { add = new LoginClass(); addContact menu = new addContact(); menu.WindowState = FormWindowState.Normal; menu.Show(); this.Close(); } } catch (FormatException datethis) { datethis.ToString(); } } } else if (DireccionGestor.getorigen() == "editor") { try { LoginClass add = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); add.ordensql("UPDATE " + UserAccessForm.getusername() + "_contacts_table SET NOMBRE='" + nombrebox.Text + "', TELEFONO='" + telefonobox.Text + "', DIRECCION='" + direccionbox.Text + "', EMAIL='" + emailbox.Text + "' WHERE ID='" + ShowContacts.getdataout()[4] + "';"); MessageBox.Show("CONTACTO " + DireccionGestor.getnombrestatic() + " EDITADO"); ShowContacts show = new ShowContacts(); show.WindowState = FormWindowState.Normal; show.Show(); this.Close(); } catch (FormatException datethis) { datethis.ToString(); } catch (IndexOutOfRangeException oper) { oper.ToString(); } } else if (DireccionGestor.getorigen() == "buscador") { if (nombrebox.Text == "" || telefonobox.Text == "") { if (nombrebox.Text == "") { nombrebox.BackColor = Color.Red; } else { nombrebox.BackColor = Color.Green; } if (telefonobox.Text == "") { telefonobox.BackColor = Color.Red; } else { telefonobox.BackColor = Color.Green; } MessageBox.Show("HAY CAMPOS CLAVES VACIOS"); } else { if (direccionbox.Text == "") { direccionbox.Text = "NINGUNA"; } if (emailbox.Text == "") { emailbox.Text = "NINGUNA"; } try { LoginClass add = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); add.AddContact(nombrebox.Text, telefonobox.Text, direccionbox.Text, emailbox.Text, UserAccessForm.getusername().ToString()); MessageBox.Show("NUEVO CONTACTO " + nombrebox.Text + " AGREGADO"); if (MessageBox.Show("Agregar a otro empleado?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { add = new LoginClass(); ShowContacts ad = new ShowContacts(); ad.WindowState = FormWindowState.Normal; ad.Show(); this.Close(); } else { add = new LoginClass(); addContact menu = new addContact(); menu.WindowState = FormWindowState.Normal; menu.Show(); this.Close(); } } catch (FormatException datethis) { datethis.ToString(); } } } ca.Close(); }
private void quitarbutton_Click(object sender, EventArgs e) { LoginClass AP = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); MovementsClass show = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); if (DireccionGestor.getorigen() == "_payfor_table") { string userDataName = UserAccessForm.getusername() + "_payfor_table"; string orden = "DELETE from " + userDataName + " where ID='" + id + "' ;"; if (show.ordensql(orden)) { MessageBox.Show("CUENTA POR PAGAR A " + MovementsClass.getdato()[1] + " HA SIDO SALDADA"); } else { MessageBox.Show("CUENTA POR PAGAR A " + MovementsClass.getdato()[1] + " SALDADA"); } limpiarbutton.PerformClick(); } else if (DireccionGestor.getorigen() == "_askfor_table") { string userDataName = UserAccessForm.getusername() + "_askfor_table"; string orden = "DELETE from " + userDataName + " where ID='" + id + "' ;"; if (show.ordensql(orden)) { MessageBox.Show("CUENTA POR COBRAR A " + MovementsClass.getdato()[1] + " HA SIDO SALDADA"); } else { MessageBox.Show("CUENTA POR COBRAR A " + MovementsClass.getdato()[1] + " SALDADA"); } limpiarbutton.PerformClick(); } }
private void buscarbutton_Click(object sender, EventArgs e) { LoginClass AP = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string orden; MovementsClass show = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); if (DireccionGestor.getorigen() == "_payfor_table") { string userDataName = UserAccessForm.getusername() + "_payfor_table"; if (namecombo.Text == "" || cantidadbox.Text == "") { limpiarbutton.PerformClick(); } else if (namecombo.Text == "" || cantidadbox.Text != "") { orden = "SELECT COBRADOR,FECHA,CANTIDAD FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "' AND COBRADOR='" + namecombo.Text + "';"; AP.ShowDataGridfound(datagrid, orden); AP.getcuenta(); encontradolabel.Text = AP.getcuenta().ToString(); titlepanel.Text = "AGREGAR COBRADOR"; orden = "SELECT SUM(CANTIDAD) FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "' AND COBRADOR='" + namecombo.Text + "';"; show.getsuma(totalalbel, tipobox.Text, orden, "CANTIDAD"); } else if (namecombo.Text != "" || cantidadbox.Text == "") { orden = "SELECT COBRADOR,FECHA,CANTIDAD FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "' AND CANTIDAD='" + cantidadbox.Text + "';"; AP.ShowDataGridfound(datagrid, orden); AP.getcuenta(); encontradolabel.Text = AP.getcuenta().ToString(); titlepanel.Text = "AGREGAR COBRADOR"; orden = "SELECT SUM(CANTIDAD) FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "' AND CANTIDAD='" + cantidadbox.Text + "';"; show.getsuma(totalalbel, tipobox.Text, orden, "CANTIDAD"); } else if (namecombo.Text != "" || cantidadbox.Text != "") { orden = "SELECT COBRADOR,FECHA,CANTIDAD FROM " + UserAccessForm.getusername() + "_payfor_table WHERE (`TIPO MONEDA`='" + tipobox.Text + "' AND CANTIDAD='" + cantidadbox.Text + "') or COBRADOR='" + namecombo.Text + "';"; AP.ShowDataGridfound(datagrid, orden); AP.getcuenta(); encontradolabel.Text = AP.getcuenta().ToString(); titlepanel.Text = "AGREGAR COBRADOR"; orden = "SELECT SUM(CANTIDAD) FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "' AND CANTIDAD='" + cantidadbox.Text + "' AND COBRADOR='" + namecombo.Text + "';"; show.getsuma(totalalbel, tipobox.Text, orden, "CANTIDAD"); } } else if (DireccionGestor.getorigen() == "_askfor_table") { string userDataName = UserAccessForm.getusername() + "_askfor_table"; if (namecombo.Text == "" || cantidadbox.Text == "") { limpiarbutton.PerformClick(); } else if (namecombo.Text == "" || cantidadbox.Text != "") { orden = ""; } else if (namecombo.Text != "" || cantidadbox.Text == "") { orden = ""; } else if (namecombo.Text != "" || cantidadbox.Text != "") { orden = ""; } } }
private void datagrid_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { try { MovementsClass show = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string dato = this.datagrid.CurrentCell.Value.ToString(); namecombo.Text = dato; if (DireccionGestor.getorigen() == "_payfor_table") { string userDataName = UserAccessForm.getusername() + "_payfor_table"; string orden = "select * from " + userDataName + " where COBRADOR='" + dato + "' ;"; if (show.Fillbuscadorpagador(orden)) { id = MovementsClass.getdato()[0]; namecombo.Text = MovementsClass.getdato()[1]; fechabox.Text = MovementsClass.getdato()[2]; cantidadbox.Text = MovementsClass.getdato()[3]; tipobox.Text = MovementsClass.getdato()[4]; name.Text = MovementsClass.getdato()[1]; fecha.Text = MovementsClass.getdato()[2]; monto.Text = MovementsClass.getdato()[3]; tipo.Text = MovementsClass.getdato()[4]; editbutton.PerformClick(); } else { editbutton.Enabled = false; quitarbutton.Enabled = false; namecombo.Text = ""; tipobox.Text = "DOP"; cantidadbox.Text = ""; fechabox.Text = DateTime.Now.ToString(); } } else if (DireccionGestor.getorigen() == "_askfor_table") { string userDataName = UserAccessForm.getusername() + "_askfor_table"; namecombo.Text = dato; string orden = "select * from " + userDataName + " where DEUDOR='" + dato + "' ; "; if (show.Fillbuscadorcobrador(orden)) { entrada = "editar"; id = MovementsClass.getdato()[0]; namecombo.Text = MovementsClass.getdato()[1]; fechabox.Text = MovementsClass.getdato()[2]; cantidadbox.Text = MovementsClass.getdato()[3]; tipobox.Text = MovementsClass.getdato()[4]; name.Text = MovementsClass.getdato()[1]; fecha.Text = MovementsClass.getdato()[2]; monto.Text = MovementsClass.getdato()[3]; tipo.Text = MovementsClass.getdato()[4]; editbutton.PerformClick(); } else { editbutton.Enabled = false; quitarbutton.Enabled = false; namecombo.Text = ""; tipobox.Text = "DOP"; cantidadbox.Text = ""; fechabox.Text = DateTime.Now.ToString(); } } } catch (NullReferenceException pafh) { pafh.ToString(); } }
private void namecombo_SelectedIndexChanged(object sender, EventArgs e) { LoginClass AP = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); MovementsClass P = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); if (DireccionGestor.getorigen() == "_payfor_table") { string orden = "SELECT COBRADOR,FECHA,CANTIDAD FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "' AND COBRADOR='" + namecombo.Text + "';"; AP.ShowDataGridfound(datagrid, orden); AP.getcuenta(); encontradolabel.Text = AP.getcuenta().ToString(); titlepanel.Text = "AGREGAR COBRADOR"; orden = "SELECT SUM(CANTIDAD) FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "' AND COBRADOR='" + namecombo.Text + "';"; P.getsuma(totalalbel, tipobox.Text, orden, "CANTIDAD"); } else if (DireccionGestor.getorigen() == "_askfor_table") { string orden = "SELECT DEUDOR,FECHA,CANTIDAD FROM " + UserAccessForm.getusername() + "_askfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "' AND DEUDOR='" + namecombo.Text + "';"; AP.ShowDataGridfound(datagrid, orden); AP.getcuenta(); encontradolabel.Text = AP.getcuenta().ToString(); titlepanel.Text = "AGREGAR COBRADOR"; orden = "SELECT SUM(CANTIDAD) FROM " + UserAccessForm.getusername() + "_askfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "' AND DEUDOR='" + namecombo.Text + "';"; P.getsuma(totalalbel, tipobox.Text, orden, "CANTIDAD"); //////////////////////////////////////////////////////////// } }
private void palpad_Click(object sender, EventArgs e) { panelpad.Hide(); tipobox.Text = "DOP"; tipo.Text = "DOP"; LoginClass AP = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); editbutton.Enabled = false; quitarbutton.Enabled = false; if (DireccionGestor.getorigen() == "_payfor_table") { palpad.BackColor = Color.Red; DireccionGestor.setorigen("_askfor_table"); titlelabel.Text = "CUENTAS POR COBRAR"; string orden = "SELECT DEUDOR,FECHA,CANTIDAD FROM " + UserAccessForm.getusername() + "_askfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "';"; AP.ShowDataGridfound(datagrid, orden); encontradolabel.Text = AP.getcuenta().ToString(); titlepanel.Text = "AGREGAR DEUDOR"; panelpad.BackColor = Color.DarkRed; changelabel.Text = "CUENTAS POR PAGAR"; orden = "SELECT SUM(CANTIDAD) FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "';"; MovementsClass Ad = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); Ad.getsuma(totalalbel, tipobox.Text, orden, "CANTIDAD"); } else if (DireccionGestor.getorigen() == "_askfor_table") { palpad.BackColor = Color.Blue; DireccionGestor.setorigen("_payfor_table"); titlelabel.Text = "CUENTAS POR PAGAR"; string orden = "SELECT COBRADOR,FECHA,CANTIDAD FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "';"; AP.ShowDataGridfound(datagrid, orden); encontradolabel.Text = AP.getcuenta().ToString(); titlepanel.Text = "AGREGAR COBRADOR"; panelpad.BackColor = Color.MidnightBlue; changelabel.Text = "CUENTAS POR COBRAR"; orden = "SELECT SUM(CANTIDAD) FROM " + UserAccessForm.getusername() + "_askfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "';"; MovementsClass Ad = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); Ad.getsuma(totalalbel, tipobox.Text, orden, "CANTIDAD"); } }
private void OKbutton_Click(object sender, EventArgs e) { string date = fecha.Value.Day.ToString() + "/" + fecha.Value.Month.ToString() + "/" + fecha.Value.Year.ToString(); openpad = false; panelpad.Show(); LoginClass AP = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); if (DireccionGestor.getorigen() == "_payfor_table") { titlelabel.Text = "CUENTAS POR PAGAR"; string orden = "SELECT COBRADOR,FECHA,CANTIDAD FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox + "';"; AP.ShowDataGridfound(datagrid, orden); encontradolabel.Text = AP.getcuenta().ToString(); //////////////////////////////////////////////////////////// if (entrada == "agregar") { if (name.Text == "" || monto.Text == "") { MessageBox.Show("Hay datos importantes vacios, termine el formulario."); if (name.Text == "") { name.BackColor = Color.Red; } else { name.BackColor = Color.Green; } if (monto.Text == "") { monto.BackColor = Color.Red; } else { monto.BackColor = Color.Green; } } else { try { MovementsClass ad = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); date = fecha.Value.Day.ToString() + "/" + fecha.Value.Month.ToString() + "/" + fecha.Value.Year.ToString(); double montos = double.Parse(monto.Text); if (ad.AddCountPayFor(name.Text, date, montos, tipobox.Text, UserAccessForm.getusername())) { MessageBox.Show("NUEVO CUENTA POR PAGAR EL " + date + " AGREGADA."); if (MessageBox.Show("Agregar otra cuenta por pagar?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { ad = new MovementsClass(); panelpad.Hide(); } else { ad = new MovementsClass(); name.Text = ""; tipo.Text = "DOP"; monto.Text = ""; fecha.Text = DateTime.Now.ToString(); } } else { MessageBox.Show("NUEVO CUENTA POR PAGAR EL " + date + " AGREGADA."); if (MessageBox.Show("Agregar otra cuenta por pagar?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { ad = new MovementsClass(); panelpad.Hide(); } else { ad = new MovementsClass(); name.Text = ""; tipo.Text = "DOP"; monto.Text = ""; fecha.Text = DateTime.Now.ToString(); } } orden = "SELECT SUM(CANTIDAD) FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "';"; MovementsClass Ad = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); Ad.getsuma(totalalbel, tipobox.Text, orden, "CANTIDAD"); } catch (FormatException datethis) { datethis.ToString(); } } limpiarbutton.PerformClick(); } else if (entrada == "editar") { MovementsClass mc = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); orden = "UPDATE " + UserAccessForm.getusername() + "_payfor_table SET COBRADOR='" + name.Text + "', FECHA='" + date + "', CANTIDAD='" + monto.Text + "', `TIPO MONEDA`='" + tipo.Text + "' WHERE ID = '" + id + "'"; mc.ordensql(orden); panelpad.Hide(); orden = "SELECT COBRADOR,FECHA,CANTIDAD FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox + "';"; AP.ShowDataGridfound(datagrid, orden); encontradolabel.Text = AP.getcuenta().ToString(); MessageBox.Show("COBRADOR " + MovementsClass.getdato()[1] + " EDITADO"); } //////////////////////////////////////////////////////////// } else if (DireccionGestor.getorigen() == "_askfor_table") { titlelabel.Text = "CUENTAS POR COBRAR"; string orden = "SELECT DEUDOR,FECHA,CANTIDAD FROM " + UserAccessForm.getusername() + "_askfor_table WHERE `TIPO MONEDA`='" + tipobox + "';"; AP.ShowDataGridfound(datagrid, orden); encontradolabel.Text = AP.getcuenta().ToString(); //////////////////////////////////////////////////////////// if (entrada == "agregar") { if (name.Text == "" || monto.Text == "") { MessageBox.Show("Hay datos importantes vacios, termine el formulario."); if (name.Text == "") { name.BackColor = Color.Red; } else { name.BackColor = Color.Green; } if (monto.Text == "") { monto.BackColor = Color.Red; } else { monto.BackColor = Color.Green; } } else { try { MovementsClass ad = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); date = fecha.Value.Day.ToString() + "/" + fecha.Value.Month.ToString() + "/" + fecha.Value.Year.ToString(); double montos = double.Parse(monto.Text); if (ad.AddCountAskFor(name.Text, date, montos, tipobox.Text, UserAccessForm.getusername())) { MessageBox.Show("NUEVA CUENTA POR COBRAR EL " + date + " AGREGADA."); if (MessageBox.Show("Agregar otra cuenta por cobrar?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { ad = new MovementsClass(); panelpad.Hide(); } else { ad = new MovementsClass(); name.Text = ""; tipo.Text = "DOP"; monto.Text = ""; fecha.Text = DateTime.Now.ToString(); } } else { MessageBox.Show("NUEVO CUENTA POR COBRAR EL " + date + " AGREGADA."); if (MessageBox.Show("Agregar otra cuenta por cobrar?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { ad = new MovementsClass(); panelpad.Hide(); } else { ad = new MovementsClass(); name.Text = ""; tipo.Text = "DOP"; monto.Text = ""; fecha.Text = DateTime.Now.ToString(); } } orden = "SELECT SUM(CANTIDAD) FROM " + UserAccessForm.getusername() + "_askfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "';"; MovementsClass Ad = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); Ad.getsuma(totalalbel, tipobox.Text, orden, "CANTIDAD"); } catch (FormatException datethis) { datethis.ToString(); } } limpiarbutton.PerformClick(); } else if (entrada == "editar") { MovementsClass mc = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); orden = "UPDATE " + UserAccessForm.getusername() + "_askfor_table SET DEUDOR='" + name.Text + "', FECHA='" + date + "', CANTIDAD='" + monto.Text + "', `TIPO MONEDA`='" + tipo.Text + "' WHERE ID = '" + id + "'"; mc.ordensql(orden); panelpad.Hide(); orden = "SELECT DEUDOR,FECHA,CANTIDAD FROM " + UserAccessForm.getusername() + "_askfor_table WHERE `TIPO MONEDA`='" + tipobox + "';"; AP.ShowDataGridfound(datagrid, orden); encontradolabel.Text = AP.getcuenta().ToString(); MessageBox.Show("DEUDOR " + MovementsClass.getdato()[1] + " EDITADO"); } //////////////////////////////////////////////////////////// } limpiarbutton.PerformClick(); }
private void timer_Tick(object sender, EventArgs e) { TimeClass timeobject = new TimeClass(); hourlabelstrip.Text = timeobject.clockshape(); datelabelstrip.Text = timeobject.dateshape(); AgendaClass ev = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string hora = DateTime.Now.Hour.ToString() + ":" + DateTime.Now.Minute.ToString() + ":" + DateTime.Now.Second.ToString(); string fechal = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString();; string fechashort = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString(); string orden = "SELECT DESCRIPCION, HORA, PRIORIDAD FROM " + UserAccessForm.getusername() + "_events_table WHERE (HORA='" + hora + "' AND ( FECHA='" + fechal + "' or `FECHA DE RECORDATORIO`='" + fechashort + "'))AND ACTIVO='SI';"; if (ev.getnametarea(orden)) { DireccionGestor.setsombrestatic(ev.getname()); DireccionGestor.setotrostatic(ev.gettime()); DireccionGestor.setprioridadstatic(ev.getprioridad()); DireccionGestor.setestadostatic(true); SystemSounds.Hand.Play(); MessageBox.Show("SON LAS " + ev.gettime() + " ES HORA DE " + ev.getname()); MessageBox.Show(DireccionGestor.getnombrestatic().ToString()); } cuenta++; if (cuenta == 4000) { cuenta = 0; backbuttonstrip.PerformClick(); } }
private void OKbutton_Click(object sender, EventArgs e) { if (passwordbox.Text == "" || repettextbox.Text == "") { MessageBox.Show("HAY DATOS CLAVES VACIOS, RECTIFIQUE"); if (passwordbox.Text == "") { passwordbox.BackColor = Color.Red; } else { passwordbox.BackColor = Color.Green; } if (repettextbox.Text == "") { repettextbox.BackColor = Color.Red; } else { repettextbox.BackColor = Color.Green; } } else if (passwordbox.Text != repettextbox.Text) { repettextbox.BackColor = Color.Red; MessageBox.Show("LOS CAMPOS SON DIFERENTES, DEBERIAN SER IGUALES PARA VALIDARLOS "); } else { LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); try { if (show.setConection(userlabel.Text, passwordbox.Text)) { string complete = "`" + UserAccessForm.getusername() + "_subject_table`"; MessageBox.Show("LA ASIGNATURA " + asignaturabox.Text + " DE " + asignadobox.Text + " HA SIDO ELIMINADA"); repettextbox.Text = ""; passwordbox.Text = ""; repettextbox.BackColor = Color.White; passwordbox.BackColor = Color.White; limpiarbutton.PerformClick(); seguridadpanel.Hide(); } else { MessageBox.Show("ERROR AL INTRODUCIR LAS CONTRASEÑAS"); repettextbox.Text = ""; passwordbox.Text = ""; repettextbox.BackColor = Color.White; passwordbox.BackColor = Color.White; limpiarbutton.PerformClick(); seguridadpanel.Hide(); } } catch (NullReferenceException OPR) { OPR.ToString(); limpiarbutton.PerformClick(); } } }
private void editbutton_Click(object sender, EventArgs e) { entrada = "editar"; string date = fechabox.Value.Day.ToString() + "/" + fechabox.Value.Month.ToString() + "/" + fechabox.Value.Year.ToString(); LoginClass AP = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); MovementsClass Ad = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); if (DireccionGestor.getorigen() == "_payfor_table") { titlepanel.Text = "EDITAR CUENTA POR PAGAR"; string orden = "SELECT * FROM " + UserAccessForm.getusername() + "_payfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "' AND COBRADOR='" + namecombo.Text + "' AND MONTO='" + cantidadbox.Text + "' AND FECHA='" + date + "';"; AP.ShowDataGridfound(datagrid, orden); id = MovementsClass.getdato()[0]; name.Text = MovementsClass.getdato()[1]; fecha.Text = MovementsClass.getdato()[2]; monto.Text = MovementsClass.getdato()[3]; tipo.Text = MovementsClass.getdato()[4]; panelpad.Show(); entrada = "editar"; openpad = true; } else if (DireccionGestor.getorigen() == "_askfor_table") { titlepanel.Text = "EDITAR CUENTA POR COBRAR"; string orden = "SELECT * FROM " + UserAccessForm.getusername() + "_askfor_table WHERE `TIPO MONEDA`='" + tipobox.Text + "' AND COBRADOR='" + namecombo.Text + "' AND MONTO='" + cantidadbox.Text + "' AND FECHA='" + date + "';"; AP.ShowDataGridfound(datagrid, orden); id = MovementsClass.getdato()[0]; name.Text = MovementsClass.getdato()[1]; fecha.Text = MovementsClass.getdato()[2]; monto.Text = MovementsClass.getdato()[3]; tipo.Text = MovementsClass.getdato()[4]; panelpad.Show(); entrada = "editar"; openpad = true; } }
private void ShowSubjects_Load(object sender, EventArgs e) { texta.Hide(); OKbutton.BackColor = Color.Green; cancelbutton.BackColor = Color.Red; seguridadpanel.Hide(); LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string orden = "SELECT ASIGNATURA,ASIGNADO,DESCRIPCION FROM " + UserAccessForm.getusername() + "_subject_table"; show.ShowDataGridFound(dataGrid, orden); cuentalabel.Text = show.getcuenta().ToString(); ///////////////////////// userlabel.Text = UserAccessForm.getusername(); orden = "select * from USERS_TABLE where USER_NAME = '" + userlabel.Text + "';"; show.fillpic(texta, orden); if (texta.Text != "") { string path = Environment.GetFolderPath(Environment.SpecialFolder.MyPictures); string combinacion = System.IO.Path.Combine(path, "users"); string fotopath = System.IO.Path.Combine(combinacion, texta.Text); picture.ImageLocation = fotopath; } //////////////////////// orden = "SELECT DISTINCT ASIGNATURA FROM " + UserAccessForm.getusername() + "_subject_table"; show.Fillcombo(asignaturabox, orden); orden = "SELECT DISTINCT ASIGNADO FROM " + UserAccessForm.getusername() + "_subject_table"; show.Fillcombo(asignadobox, orden); editbutton.Enabled = false; eliminarbutton.Enabled = false; }
private void userPasswordForm_Load(object sender, EventArgs e) { try { picturetext.Hide(); OKbutton.BackColor = Color.Green; cancelbutton.BackColor = Color.Red; userlabel.Text = UsersShowForm.getdatum()[0]; tipolabel.Text = UsersShowForm.getdatum()[1]; LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string orden = "select * from USERS_TABLE where USER_NAME = '" + userlabel.Text + "';"; show.fillpic(picturetext, orden); if (picturetext.Text != "") { string path = Environment.GetFolderPath(Environment.SpecialFolder.MyPictures); string combinacion = System.IO.Path.Combine(path, "users"); string fotopath = System.IO.Path.Combine(combinacion, picturetext.Text); pictureBox.ImageLocation = fotopath; } if (UsersShowForm.getstate() == "change") { seguridadlabel.Text = "CAMBIAR CONTRASEÑA"; } else { seguridadlabel.Text = "CONTROL DE SEGURIDAD"; newlabel.Hide(); newpasstextbox.Hide(); } } catch (ArgumentNullException pap) { pap.ToString(); MessageBox.Show("TIENE QUE SELECCIONAR UN USUARIO PARA EJECUTAR LAS FUNCIONES DEL MENU"); } catch (NullReferenceException pap) { pap.ToString(); MessageBox.Show("TIENE QUE SELECCIONAR UN USUARIO PARA EJECUTAR LAS FUNCIONES DEL MENU"); } }
private void OKbutton_Click(object sender, EventArgs e) { LoginClass ver; string asign; string orden; string teach; if (asignaturatextbox.Text == "" || comboasignado.Text == "" || descripcionbox.Text == "") { if (asignaturatextbox.Text == "") { asignaturatextbox.BackColor = Color.Red; } else { asignaturatextbox.BackColor = Color.Green; } if (comboasignado.Text == "") { comboasignado.BackColor = Color.Red; } else { comboasignado.BackColor = Color.Green; } if (descripcionbox.Text == "") { descripcionbox.BackColor = Color.Red; } else { descripcionbox.BackColor = Color.Green; } } else if (DireccionGestor.getorigen() == "inicio") { carga pap = new carga(); pap.WindowState = FormWindowState.Normal; pap.Show(); ver = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string complete = UserAccessForm.getusername() + "_subject_table"; orden = "SELECT ASIGNATURA FROM " + complete + " WHERE ASIGNATURA='" + asignaturatextbox.Text + "' and ASIGNADO='" + comboasignado.Text + "';"; asign = ver.takedatatable(orden, "ASIGNATURA"); orden = "SELECT ASIGNADO FROM " + complete + " WHERE ASIGNATURA='" + asignaturatextbox.Text + "' and ASIGNADO='" + comboasignado.Text + "';"; teach = ver.takedatatable(orden, "ASIGNADO"); try { if ((asign == asignaturatextbox.Text) && (teach == comboasignado.Text)) { MessageBox.Show("LA ASIGNATURA " + asignaturatextbox.Text + " FUE ASIGNADA A " + comboasignado.Text); pap.Close(); } else { ver.AddSubject(asignaturatextbox.Text, comboasignado.Text, descripcionbox.Text, UserAccessForm.getusername()); pap.Close(); MessageBox.Show("ASIGNATURA " + asignaturatextbox.Text + " HA SIDO CREADA"); ShowSubjects.setchange("modify"); this.Close(); } } catch (NullReferenceException PAP) { PAP.ToString(); pap.Close(); MessageBox.Show("ASIGNATURA " + asignaturatextbox.Text + " HA SIDO CREADA"); ShowSubjects.setchange("modify"); this.Close(); } } else if (DireccionGestor.getorigen() == "editor") { carga pap = new carga(); pap.WindowState = FormWindowState.Normal; pap.Show(); ver = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string complete = UserAccessForm.getusername() + "_subject_table"; orden = "SELECT * FROM " + complete + " WHERE ASIGNATURA='" + asignaturatextbox.Text + "' and ASIGNADO='" + comboasignado.Text + "';"; orden = "SELECT ASIGNATURA FROM " + complete + " WHERE ASIGNATURA='" + asignaturatextbox.Text + "' and ASIGNADO='" + comboasignado.Text + "';"; asign = ver.takedatatable(orden, "ASIGNATURA"); orden = "SELECT ASIGNADO FROM " + complete + " WHERE ASIGNATURA='" + asignaturatextbox.Text + "' and ASIGNADO='" + comboasignado.Text + "';"; teach = ver.takedatatable(orden, "ASIGNADO"); if ((asign == asignaturatextbox.Text) && (teach == comboasignado.Text)) { pap.Close(); MessageBox.Show("LA ASIGNATURA " + asignaturatextbox.Text + " FUE ASIGNADA A " + comboasignado.Text); } else { orden = "RENAME TABLE `" + LoginClass.getdata()[1] + "_" + UserAccessForm.getusername() + "_evaluation_student_table` TO `" + asignaturatextbox.Text + "_" + UserAccessForm.getusername() + "_evaluation_student_table`;"; ver.ordensql(orden); orden = "RENAME TABLE `" + LoginClass.getdata()[1] + "_" + UserAccessForm.getusername() + "_calification_student_table` TO `" + asignaturatextbox.Text + "_" + UserAccessForm.getusername() + "_calification_student_table`;"; ver.ordensql(orden); complete = UserAccessForm.getusername() + "_subject_table"; ver.editSubject(asignaturatextbox.Text, comboasignado.Text, descripcionbox.Text, LoginClass.getdata()[1], LoginClass.getdata()[2], UserAccessForm.getusername()); pap.Close(); MessageBox.Show("ASIGNATURA " + LoginClass.getdata()[1] + " HA SIDO EDITADA"); ShowSubjects.setchange("modify"); this.Close(); } } else if (DireccionGestor.getorigen() == "buscador") { carga pap = new carga(); pap.WindowState = FormWindowState.Normal; pap.Show(); ver = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string complete = UserAccessForm.getusername() + "_subject_table"; orden = "SELECT ASIGNATURA FROM " + complete + " WHERE ASIGNATURA='" + asignaturatextbox.Text + "' and ASIGNADO='" + comboasignado.Text + "';"; asign = ver.takedatatable(orden, "ASIGNATURA"); orden = "SELECT ASIGNADO FROM " + complete + " WHERE ASIGNATURA='" + asignaturatextbox.Text + "' and ASIGNADO='" + comboasignado.Text + "';"; teach = ver.takedatatable(orden, "ASIGNADO"); try { if ((asign == asignaturatextbox.Text) && (teach == comboasignado.Text)) { MessageBox.Show("LA ASIGNATURA " + asignaturatextbox.Text + " FUE ASIGNADA A " + comboasignado.Text); pap.Close(); } else { ver.AddSubject(asignaturatextbox.Text, comboasignado.Text, descripcionbox.Text, UserAccessForm.getusername()); MessageBox.Show("ASIGNATURA " + asignaturatextbox.Text + " HA SIDO CREADA"); ShowSubjects.setchange("modify"); this.Close(); } } catch (NullReferenceException PAP) { PAP.ToString(); pap.Close(); MessageBox.Show("ASIGNATURA " + asignaturatextbox.Text + " HA SIDO CREADA"); ShowSubjects.setchange("modify"); this.Close(); } } }
private void OKbutton_Click(object sender, EventArgs e) { string orden; if (UsersShowForm.getstate() == "change") { if (passwordbox.Text == "" || newpasstextbox.Text == "" || repettextbox.Text == "") { if (passwordbox.Text == "") { passwordbox.BackColor = Color.Red; } else { passwordbox.BackColor = Color.Green; } if (newpasstextbox.Text == "") { newpasstextbox.BackColor = Color.Red; } else { newpasstextbox.BackColor = Color.Green; } if (repettextbox.Text == "") { repettextbox.BackColor = Color.Red; } else { repettextbox.BackColor = Color.Green; } MessageBox.Show("HAY DATAOS IMPORTANTES VACIOS"); } else if (newpasstextbox.Text != repettextbox.Text) { repettextbox.BackColor = Color.Red; MessageBox.Show("LOS CAMPOS PARA CAMBIAR LAS CONTRASEÑA DEBEN DE SER IGUALES"); } else { LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); if (show.setConection(userlabel.Text, passwordbox.Text)) { cuenta = 0; orden = "UPDATE users_table SET USER_PASSWORD='******' WHERE USER_NAME='" + UsersShowForm.getdatum()[0] + "' AND USERTIPO='" + UsersShowForm.getdatum()[1] + "' AND ID='" + UsersShowForm.getdatum()[2] + "' AND FECHA_CREACION='" + UsersShowForm.getdatum()[3] + "';"; if (show.ordensql(orden) == true) { MessageBox.Show("CONTRASEÑA CAMBIADA CON EXITO"); show = new LoginClass(); this.Close(); } else { MessageBox.Show("CONTRASEÑA CAMBIADA"); show = new LoginClass(); this.Close(); } } else { MessageBox.Show("CONTRASEÑA EQUIVOCADA, POR FAVOR RECTIFIQUE"); passwordbox.BackColor = Color.Red; newpasstextbox.Text = ""; repettextbox.Text = ""; cuenta++; if (cuenta == 3) { MessageBox.Show("POR MOTIVOS DE SEGURIDAD SE EMPEZARA UNA RECTIFICACION DE DATOS"); UserSecurityForm begin = new UserSecurityForm(); begin.WindowState = FormWindowState.Maximized; begin.Show(); this.Close(); } } } } else if (UsersShowForm.getstate() == "edit") { if (passwordbox.Text == "" || repettextbox.Text == "") { if (passwordbox.Text == "") { passwordbox.BackColor = Color.Red; } else { passwordbox.BackColor = Color.Green; } if (repettextbox.Text == "") { repettextbox.BackColor = Color.Red; } else { repettextbox.BackColor = Color.Green; } MessageBox.Show("HAY DATAOS IMPORTANTES VACIOS"); } else if (passwordbox.Text != repettextbox.Text) { repettextbox.BackColor = Color.Red; MessageBox.Show("LAS CONTRASEÑAS DEBEN DE SER IGUALES"); } else { LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); if (show.setConection(userlabel.Text, passwordbox.Text)) { cuenta = 0; UserAddForm add = new UserAddForm(); add.WindowState = FormWindowState.Maximized; add.Show(); DireccionGestor.setcloseshowuser(); this.Close(); } else { MessageBox.Show("CONTRASEÑA EQUIVOCADA, POR FAVOR RECTIIQUE"); passwordbox.BackColor = Color.Red; newpasstextbox.Text = ""; repettextbox.Text = ""; cuenta++; if (cuenta == 3) { MessageBox.Show("POR MOTIVOS DE SEGURIDAD SE EMPEZARA UNA RECTIFICACION DE DATOS"); UserSecurityForm begin = new UserSecurityForm(); begin.WindowState = FormWindowState.Normal; begin.Show(); this.Close(); } } } } else if (UsersShowForm.getstate() == "delete") { if (passwordbox.Text == "" || repettextbox.Text == "") { if (passwordbox.Text == "") { passwordbox.BackColor = Color.Red; } else { passwordbox.BackColor = Color.Green; } if (repettextbox.Text == "") { repettextbox.BackColor = Color.Red; } else { repettextbox.BackColor = Color.Green; } MessageBox.Show("HAY DATAOS IMPORTANTES VACIOS"); } else { LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); if (show.setConection(userlabel.Text, passwordbox.Text)) { cuenta = 0; orden = "DROP TABLE IF EXISTS `" + UsersShowForm.getdatum()[0] + "_employee_table;`"; show.ordensql(orden); orden = "DROP TABLE IF EXISTS `" + UsersShowForm.getdatum()[0] + "_student_table;`"; show.ordensql(orden); orden = "DROP TABLE IF EXISTS `" + UsersShowForm.getdatum()[0] + "_events_table;`"; show.ordensql(orden); orden = "DROP TABLE IF EXISTS `" + UsersShowForm.getdatum()[0] + "_movements_table`;"; show.ordensql(orden); orden = "delete from users.users_table WHERE USER_NAME= '" + UsersShowForm.getdatum()[0] + "' AND USERTIPO='" + UsersShowForm.getdatum()[1] + "' AND ID='" + UsersShowForm.getdatum()[2] + "' AND FECHA_CREACION='" + UsersShowForm.getdatum()[3] + "';"; show.ordensql(orden); MessageBox.Show("USUARIO " + UsersShowForm.getdatum()[0] + " ELIMINADO"); if (UserAccessForm.getusername() == UsersShowForm.getdatum()[0]) { DireccionGestor.setcloseshowuser(); UserAccessForm begin = new UserAccessForm(); begin.WindowState = FormWindowState.Normal; begin.Show(); this.Close(); } else { show = new LoginClass(); UsersShowForm.setrefresh("refresh"); this.Close(); } } else { MessageBox.Show("CONTRASEÑA EQUIVOCADA, POR FAVOR RECTIIQUE"); cuenta++; if (cuenta == 3) { MessageBox.Show("POR MOTIVOS DE SEGURIDAD SE EMPEZARA UNA RECTIFICACION DE DATOS"); UserSecurityForm begin = new UserSecurityForm(); begin.WindowState = FormWindowState.Normal; begin.Show(); this.Close(); } } } } else if (UsersShowForm.getstate() == "save") { if (passwordbox.Text == "" || repettextbox.Text == "") { if (passwordbox.Text == "") { passwordbox.BackColor = Color.Red; } else { passwordbox.BackColor = Color.Green; } if (repettextbox.Text == "") { repettextbox.BackColor = Color.Red; } else { repettextbox.BackColor = Color.Green; } MessageBox.Show("HAY DATAOS IMPORTANTES VACIOS"); } else { LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); if (show.setConection(userlabel.Text, passwordbox.Text)) { cuenta = 0; //some codde heereeee } else { MessageBox.Show("CONTRASEÑA EQUIVOCADA, POR FAVOR RECTIIQUE"); cuenta++; if (cuenta == 3) { MessageBox.Show("POR MOTIVOS DE SEGURIDAD SE EMPEZARA UNA RECTIFICACION DE DATOS"); UserSecurityForm begin = new UserSecurityForm(); begin.WindowState = FormWindowState.Normal; begin.Show(); this.Close(); } } } } else if (UsersShowForm.getstate() == "cargar") { if (passwordbox.Text == "" || repettextbox.Text == "") { if (passwordbox.Text == "") { passwordbox.BackColor = Color.Red; } else { passwordbox.BackColor = Color.Green; } if (repettextbox.Text == "") { repettextbox.BackColor = Color.Red; } else { repettextbox.BackColor = Color.Green; } MessageBox.Show("HAY DATAOS IMPORTANTES VACIOS"); } else { LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); if (show.setConection(userlabel.Text, passwordbox.Text)) { cuenta = 0; //some codde heereeee } else { MessageBox.Show("CONTRASEÑA EQUIVOCADA, POR FAVOR RECTIIQUE"); cuenta++; if (cuenta == 3) { MessageBox.Show("POR MOTIVOS DE SEGURIDAD SE EMPEZARA UNA RECTIFICACION DE DATOS"); UserSecurityForm begin = new UserSecurityForm(); begin.WindowState = FormWindowState.Normal; begin.Show(); this.Close(); } } } } else if (UsersShowForm.getstate() == "comprobar") { if (passwordbox.Text == "" || repettextbox.Text == "") { if (passwordbox.Text == "") { passwordbox.BackColor = Color.Red; } else { passwordbox.BackColor = Color.Green; } if (repettextbox.Text == "") { repettextbox.BackColor = Color.Red; } else { repettextbox.BackColor = Color.Green; } MessageBox.Show("HAY DATAOS IMPORTANTES VACIOS"); } else { LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); if (show.setConection(userlabel.Text, passwordbox.Text)) { cuenta = 0; ShowSubjects.setpaso(true); } else { MessageBox.Show("CONTRASEÑA EQUIVOCADA, POR FAVOR RECTIIQUE"); cuenta++; if (cuenta == 3) { ShowSubjects.setpaso(false); MessageBox.Show("POR MOTIVOS DE SEGURIDAD SE EMPEZARA UNA RECTIFICACION DE DATOS"); UserSecurityForm begin = new UserSecurityForm(); begin.WindowState = FormWindowState.Normal; begin.Show(); this.Close(); } } } /////////////////////////////////// } else { MessageBox.Show("HA OCURRIDO ALGO DURANTE EL PROCESO"); } }
private void addbuttonstrip_Click(object sender, EventArgs e) { if (DireccionGestor.getorigen() == "inicio") { if (reasonbox.Text == "" || cuantitybox.Text == "" || explanationbox.Text == "") { MessageBox.Show("Hay datos importantes vacios, termine el formulario."); if (reasonbox.Text == "") { reasonbox.BackColor = Color.Red; } else { reasonbox.BackColor = Color.Green; } if (cuantitybox.Text == "") { cuantitybox.BackColor = Color.Red; } else { cuantitybox.BackColor = Color.Green; } if (explanationbox.Text == "") { explanationbox.BackColor = Color.Red; } else { explanationbox.BackColor = Color.Green; } } else { DireccionGestor.setotrostatic("refresh"); try { string userDataName = UserAccessForm.getusername() + "_movements_table"; MovementsClass save = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); double cuantity = double.Parse(cuantitybox.Text); string date = datebox.Value.Day.ToString() + "/" + datebox.Value.Month.ToString() + "/" + datebox.Value.Year.ToString(); string hour = horabox.Value.Hour.ToString() + ":" + horabox.Value.Minute.ToString() + ":" + horabox.Value.Second.ToString(); if (save.setExpense(date, hour, reasonbox.Text, cuantity, monedatipo.Text, datebox.Value.Day.ToString(), datebox.Value.Month.ToString() , datebox.Value.Year.ToString(), horabox.Value.Hour.ToString(), horabox.Value.Minute.ToString(), horabox.Value.Second.ToString(), explanationbox.Text, fondoorigen.Text, userDataName)) { save.OrderID(userDataName); MessageBox.Show("NUEVO GASTO DE DINERO A LAS " + hour + " HA SIDO REGISTRADO"); if (MessageBox.Show("REGISTRAR OTRO GASTO DE DINERO?", "REGISTRAR", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { save = new MovementsClass(); this.Close(); GastosForm menu = new GastosForm(); menu.WindowState = FormWindowState.Normal; menu.Show(); } else { save = new MovementsClass(); this.Close(); } } else { MessageBox.Show("GASTO DE DINERO A LAS " + hour + " HA SIDO REGISTRADO"); if (MessageBox.Show("REGISTRAR OTRO GASTO DE DINERO?", "REGISTRAR", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { save = new MovementsClass(); this.Close(); GastosForm menu = new GastosForm(); menu.WindowState = FormWindowState.Normal; menu.Show(); } else { save = new MovementsClass(); this.Close(); } } } catch (FormatException datethis) { datethis.ToString(); } catch (InvalidCastException datethose) { MessageBox.Show(datethose.ToString()); } } } else if (DireccionGestor.getorigen() == "editor") { if (reasonbox.Text == "" || cuantitybox.Text == "" || explanationbox.Text == "") { MessageBox.Show("Hay datos importantes vacios, termine el formulario."); if (reasonbox.Text == "") { reasonbox.BackColor = Color.Red; } else { reasonbox.BackColor = Color.Green; } if (cuantitybox.Text == "") { cuantitybox.BackColor = Color.Red; } else { cuantitybox.BackColor = Color.Green; } if (explanationbox.Text == "") { explanationbox.BackColor = Color.Red; } else { explanationbox.BackColor = Color.Green; } } else { try { string userDataName = UserAccessForm.getusername() + "_movements_table"; MovementsClass save = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); double cuantity = double.Parse(cuantitybox.Text); string date = datebox.Value.Day.ToString() + "/" + datebox.Value.Month.ToString() + "/" + datebox.Value.Year.ToString(); string hour = horabox.Value.Hour.ToString() + ":" + horabox.Value.Minute.ToString() + ":" + horabox.Value.Second.ToString(); DireccionGestor.setotrostatic("refresh"); string orden = "UPDATE " + userDataName + " SET `FECHA DEL MOVIMIENTO`='" + date + "', `HORA DEL MOVIMIENTO`='" + hour + "', MOTIVO='" + reasonbox.Text + "', GASTO='" + cuantity + "', `TIPO DE MONEDA`='" + monedatipo.Text + "',DIA='" + datebox.Value.Day.ToString() + "', MES='" + datebox.Value.Month.ToString() + "', AÑO='" + datebox.Value.Year.ToString() + "', HORA='" + datebox.Value.Hour.ToString() + "', MINUTO='" + datebox.Value.Minute.ToString() + "', SEGUNDO='" + datebox.Value.Second.ToString() + "', EXPLICACION='" + explanationbox.Text + "', `FORMA DE PAGO`='" + fondoorigen.Text + "' WHERE ID='" + MovementsClass.getdato()[0] + "' AND `FECHA DEL MOVIMIENTO`='" + MovementsClass.getdato()[2] + "' AND `HORA DEL MOVIMIENTO`='" + MovementsClass.getdato()[3] + "';"; save.ordensql(orden); MessageBox.Show("INGRESO DE LAS " + MovementsClass.getdato()[3] + " EL DIA " + MovementsClass.getdato()[2] + " HA SIDO EDITADO"); this.Close(); } catch (FormatException datethis) { MessageBox.Show(datethis.ToString()); } catch (InvalidCastException datethose) { MessageBox.Show(datethose.ToString()); } } } }
private void limpiarbutton_Click(object sender, EventArgs e) { LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string orden = "SELECT ASIGNATURA,ASIGNADO,DESCRIPCION FROM " + UserAccessForm.getusername() + "_subject_table"; show.ShowDataGridFound(dataGrid, orden); cuentalabel.Text = show.getcuenta().ToString(); asignaturabox.Text = "TODOS"; asignadobox.Text = "TODOS"; }
private void UserSecurityForm_Load(object sender, EventArgs e) { picturetext.Hide(); string dbserver = ""; string dbname = ""; string dbuser = ""; string dbpassword = ""; string dbport = ""; string path = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); string targetPath = System.IO.Path.Combine(path, "users"); FuncionClass f = new FuncionClass(); try { dbserver = f.readperfil(targetPath)[0]; dbname = f.readperfil(targetPath)[1]; dbuser = f.readperfil(targetPath)[2]; dbpassword = f.readperfil(targetPath)[3]; dbport = f.readperfil(targetPath)[4]; } catch (NullReferenceException er) { er.ToString(); } f = new FuncionClass(dbserver, dbname, dbuser, dbpassword, dbport); LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); try { string orden = "select * from users_table WHERE USER_NAME = '" + UsersShowForm.getdatum()[0] + "' AND USERTIPO = '" + UsersShowForm.getdatum()[1] + "' AND ID = '" + UsersShowForm.getdatum()[2] + "' AND FECHA_CREACION = '" + UsersShowForm.getdatum()[3] + "'; "; show.fillsecurity(userlabel, asklabel1, asklabel2, asklabel3, asklabel4, asklabel5, picturetext, orden); if (picturetext.Text != "") { path = Environment.GetFolderPath(Environment.SpecialFolder.MyPictures); string combinacion = System.IO.Path.Combine(path, UserAccessForm.getusername()); string fotopath = System.IO.Path.Combine(combinacion, picturetext.Text); pictureBox.ImageLocation = fotopath; } problempanel.Hide(); picturetext.Hide(); } catch (NullReferenceException pad) { problempanel.Hide(); picturetext.Hide(); pad.ToString(); } }
private void asignadobox_SelectedIndexChanged(object sender, EventArgs e) { LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string orden = "SELECT ASIGNATURA,ASIGNADO,DESCRIPCION FROM " + UserAccessForm.getusername() + "_subject_table WHERE ASIGNADO='" + asignadobox.Text + "';"; show.ShowDataGridFound(dataGrid, orden); cuentalabel.Text = show.getcuenta().ToString(); }
private void dataGrid_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { dataout = new string[5]; LoginClass ver = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string dato = this.dataGrid.CurrentCell.Value.ToString(); string orden = "SELECT * FROM " + UserAccessForm.getusername() + "_contacts_table WHERE NOMBRE='" + dato + "';"; if (ver.fillcombos(namecombo, telefonocombo, orden)) { editbutton.Enabled = true; quitarbutton.Enabled = true; dataout[0] = namecombo.Text; dataout[1] = telefonocombo.Text; dataout[2] = LoginClass.getdata()[0]; dataout[3] = LoginClass.getdata()[1]; dataout[4] = LoginClass.getdata()[2]; } else { editbutton.Enabled = false; quitarbutton.Enabled = false; } } catch (NullReferenceException pafh) { pafh.ToString(); } }
private void buscarbutton_Click(object sender, EventArgs e) { LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string orden = "SELECT ASIGNATURA,ASIGNADO,DESCRIPCION FROM " + UserAccessForm.getusername() + "_subject_table;"; if (asignaturabox.Text == "" && asignadobox.Text == "") { orden = "SELECT ASIGNATURA,ASIGNADO,DESCRIPCION FROM " + UserAccessForm.getusername() + "_subject_table;"; } if (asignaturabox.Text != "" && asignadobox.Text == "") { orden = "SELECT ASIGNATURA,ASIGNADO,DESCRIPCION FROM " + UserAccessForm.getusername() + "_subject_table WHERE ASIGNATURA='" + asignaturabox.Text + "';"; } if (asignaturabox.Text == "" && asignadobox.Text != "") { orden = "SELECT ASIGNATURA,ASIGNADO,DESCRIPCION FROM " + UserAccessForm.getusername() + "_subject_table WHERE ASIGNADO='" + asignadobox.Text + "';"; } if (asignaturabox.Text != "" && asignadobox.Text != "") { orden = "SELECT ASIGNATURA,ASIGNADO,DESCRIPCION FROM " + UserAccessForm.getusername() + "_subject_table WHERE ASIGNADO='" + asignadobox.Text + "' AND ASIGNATURA='" + asignaturabox.Text + "';"; } show.ShowDataGridFound(dataGrid, orden); cuentalabel.Text = show.getcuenta().ToString(); }
private void ShowContacts_Load(object sender, EventArgs e) { editbutton.Enabled = false; quitarbutton.Enabled = false; string orden = "SELECT NOMBRE,TELEFONO,DIRECCION,EMAIL FROM " + UserAccessForm.getusername() + "_contacts_table;"; LoginClass ver = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); ver.ShowDataGridFound(dataGrid, orden); cuentalabel.Text = ver.getcuenta().ToString(); orden = "SELECT distinct NOMBRE FROM " + UserAccessForm.getusername() + "_contacts_table;"; ver.Fillcombo(namecombo, orden); orden = "SELECT distinct TELEFONO FROM " + UserAccessForm.getusername() + "_contacts_table;"; ver.Fillcombo(telefonocombo, orden); }
private void dataGrid_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { try { LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string userDataName = UserAccessForm.getusername() + "_subject_table"; string dato = this.dataGrid.CurrentCell.Value.ToString(); string orden = "select ASIGNATURA from " + userDataName + " where ASIGNATURA = '" + dato + "' or ASIGNADO='" + dato + "';"; if (show.takedatatable(orden, "ASIGNATURA") != "") { orden = "select ASIGNATURA from " + userDataName + " where ASIGNATURA = '" + dato + "' or ASIGNADO='" + dato + "';"; asignaturabox.Text = show.takedatatable(orden, "ASIGNATURA"); orden = "select ASIGNADO from " + userDataName + " where ASIGNATURA = '" + dato + "' or ASIGNADO='" + dato + "';"; asignadobox.Text = show.takedatatable(orden, "ASIGNADO"); orden = "SELECT DESCRIPCION FROM " + userDataName + " where ASIGNATURA = '" + asignaturabox.Text + "' AND ASIGNADO='" + asignadobox.Text + "';"; string descripcion = show.takedatatable(orden, "DESCRIPCION"); info = new string[3]; info[0] = asignaturabox.Text; info[1] = asignadobox.Text; info[2] = descripcion; editbutton.PerformClick(); } else { eliminarbutton.Enabled = false; editbutton.Enabled = false; MessageBox.Show("DEBERIA SELECCIONAR EL CAMPO [ASIGNATURA] O ALMENOS EL CAMPO ASIGNADO [ASIGNADO]"); } } catch (NullReferenceException pafh) { pafh.ToString(); } }
private void telefonocombo_SelectedIndexChanged(object sender, EventArgs e) { string orden = "SELECT NOMBRE,TELEFONO,DIRECCION,EMAIL FROM " + UserAccessForm.getusername() + "_contacts_table WHERE TELEFONO='" + telefonocombo.Text + "'; "; LoginClass ver = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); ver.ShowDataGridFound(dataGrid, orden); cuentalabel.Text = ver.getcuenta().ToString(); }
private void picturebutton_Click(object sender, EventArgs e) { string rutafoto; string path = Environment.GetFolderPath(Environment.SpecialFolder.MyPictures); OpenFileDialog getfile = new OpenFileDialog(); getfile.InitialDirectory = "C:\\"; getfile.Filter = "Image Files(*.jpg; *.png)|*.jpg; *.png"; getfile.FilterIndex = 1; if (getfile.ShowDialog() == DialogResult.OK) { string begin = getfile.FileName; string sourcePath = Path.GetDirectoryName(begin); string targetPath = System.IO.Path.Combine(path, UserAccessForm.getusername()); picturetextbox.Text = System.IO.Path.GetFileName(getfile.FileName); string sourcefile = getfile.FileName; string destfile = System.IO.Path.Combine(path, picturetextbox.Text); pictureBox.Image = Image.FromFile(getfile.FileName); rutafoto = picturetextbox.Text; if (!System.IO.Directory.Exists(targetPath)) { System.IO.Directory.CreateDirectory(targetPath); } if (getfile.CheckFileExists) { } try { System.IO.File.Copy(sourcefile, sourcefile, true); } catch (System.IO.IOException getto) { getto.ToString(); } if (System.IO.Directory.Exists(sourcePath)) { string[] files = System.IO.Directory.GetFiles(sourcePath); foreach (string s in files) { picturetextbox.Text = System.IO.Path.GetFileName(s); destfile = System.IO.Path.Combine(targetPath, picturetextbox.Text); try { System.IO.File.Copy(s, destfile, true); } catch (System.IO.IOException exept) { MessageBox.Show("TRATE DE SELECCIONAR OTRA FOTO"); //picturetextbox.Text = System.IO.Path.GetFileName(getfile.FileName); exept.ToString(); } } } } else { MessageBox.Show("No se ha seleccionado ninguna imagen", "Sin Seleccion", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }