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