//este metodo obtiene el ultimo id ingresado de un cliente
private int maxId()
{
//se declara el entero que sera el id del cliente
int id = 1;
try
{
//se abre conexion
Connection.OpenConnection();
//se declara un reader que tendra el id del cliente
MySqlDataReader reader = Class.Client.clientMaxId(Connection.myConnection);
//mientras se haga la consulta
if (reader.Read())
{
//se valida si la db esta vacia
if (!reader.IsDBNull(0))
{
//se establece el id del cliente a la variable
id = reader.GetInt32(0);
}
}
//se cierra conexion
Connection.CloseConnection();
}
catch (Exception)
{
MessageBox.Show("No se pudo obtener el id");
}
//retornamos el id del cliente
return(id);
}
private void ModifyEmployee_Load(object sender, EventArgs e)
{
Connection.OpenConnection();
int id = Int32.Parse(idEmployee);
Class.Employee employee = Class.Employee.searchEmployee(Connection.myConnection, id);
Connection.CloseConnection();
idTextBox.Text = employee.IdEmployee.ToString();
firstNameTextBox.Text = employee.FirstName;
lastNameTextBox.Text = employee.LastName;
phoneTextBox.Text = employee.Phone;
emailTextBox.Text = employee.Email;
addressTextBox.Text = employee.Address;
passwordTextBox.Text = employee.Password;
if (employee.EmployeeType == 0)
{
positionComboBox.Text = "Gerente";
}
else
{
positionComboBox.Text = "Cajero";
}
}
//metodo cargar de la pagina
private void ModifyAccount_Load(object sender, EventArgs e)
{
//se abre conexion a la db
Connection.OpenConnection();
//metodo que busca la cuenta por id
Class.Account account = Class.Account.searchAccount(Connection.myConnection, idAccount);
//establecemos los datos en sus respectivos campos para su modificacion
idAccountTextBox.Text = Convert.ToString(account.IdAccount);
idClientTextBox.Text = Convert.ToString(account.Client_IdClient);
nipTextBox.Text = account.Nip;
balancetextBox.Text = Convert.ToString(account.Balance);
maximumCreditTextBox.Text = Convert.ToString(account.MaximumCredit);
cutOffDayDateTimePicker.Text = Convert.ToString(account.CutOffDay);
if (account.AccountType == 0)
{
accountTypeComboBox.SelectedItem = "Credito";
}
else
{
accountTypeComboBox.SelectedItem = "Debito";
}
//cierra conexion a la db
Connection.CloseConnection();
}
private void ModifyClient_Load(object sender, EventArgs e)
{
Connection.OpenConnection();
Class.Client client = Class.Client.searchClient(Connection.myConnection, idClient);
idTextBox.Text = Convert.ToString(client.IdClient);
firstNameTextBox.Text = client.FirstName;
lastNameTextBox.Text = client.LastName;
phoneTextBox.Text = client.Phone;
emailtextBox.Text = client.Email;
addressTextBox.Text = client.Address;
Connection.CloseConnection();
}
public void loadData()
{
Connection.OpenConnection();
clientsGridView.DataSource = Class.Client.showDeletedClients(Connection.myConnection);
this.clientsGridView.Columns[0].HeaderCell.Value = "ID";
this.clientsGridView.Columns[1].HeaderCell.Value = "Nombre";
this.clientsGridView.Columns[2].HeaderCell.Value = "Apellido";
this.clientsGridView.Columns[3].HeaderCell.Value = "Teléfono";
this.clientsGridView.Columns[4].HeaderCell.Value = "Correo";
this.clientsGridView.Columns[5].HeaderCell.Value = "Dirección";
this.clientsGridView.Columns[6].Visible = false;
Connection.CloseConnection();
}
//metodo cargar todo en la tabla
public void loadData()
{
Connection.OpenConnection();
transactionGridView.DataSource = Class.Transaction.showAllTransactions(Connection.myConnection);
this.transactionGridView.Columns[0].HeaderCell.Value = "ID";
this.transactionGridView.Columns[1].HeaderCell.Value = "Cuenta Origen";
this.transactionGridView.Columns[2].HeaderCell.Value = "Cuenta Destino";
this.transactionGridView.Columns[3].HeaderCell.Value = "Id Empleado";
this.transactionGridView.Columns[4].HeaderCell.Value = "Fecha";
this.transactionGridView.Columns[5].HeaderCell.Value = "Cantidad";
this.transactionGridView.Columns[6].HeaderCell.Value = "Tipo de cuenta";
this.transactionGridView.Columns[7].Visible = false;
Connection.CloseConnection();
}
public void loadData()
{
Connection.OpenConnection();
employesGridview.DataSource = Class.Employee.showAllEmployees(Connection.myConnection);
this.employesGridview.Columns[0].HeaderCell.Value = "ID";
this.employesGridview.Columns[1].HeaderCell.Value = "Nombre";
this.employesGridview.Columns[2].HeaderCell.Value = "Apellido";
this.employesGridview.Columns[3].HeaderCell.Value = "Teléfono";
this.employesGridview.Columns[4].HeaderCell.Value = "Correo";
this.employesGridview.Columns[5].HeaderCell.Value = "Direccion";
this.employesGridview.Columns[6].HeaderCell.Value = "Contraseña";
this.employesGridview.Columns[7].HeaderCell.Value = "Tipo Empleado";
this.employesGridview.Columns[8].Visible = false;
Connection.CloseConnection();
}
private void loadData()
{
Connection.OpenConnection();
//se genera una lista con todos los clientes activos
destinationDataGridView.DataSource = Class.Client.showAllClients(Connection.myConnection);
//se establecen los nombres de cabecera para las columnas
this.destinationDataGridView.Columns[0].HeaderCell.Value = "ID";
this.destinationDataGridView.Columns[1].HeaderCell.Value = "Nombre";
this.destinationDataGridView.Columns[2].HeaderCell.Value = "Apellido";
this.destinationDataGridView.Columns[3].Visible = false;
this.destinationDataGridView.Columns[4].Visible = false;
this.destinationDataGridView.Columns[5].Visible = false;
this.destinationDataGridView.Columns[6].Visible = false;
Connection.CloseConnection();
}
private void loadData()
{
Connection.OpenConnection();
//se genera una lista con todos los clientes activos
cancelDepositDataGridView.DataSource = Class.DepositWithoutAccount.showAllDeposits(Connection.myConnection);
//se establecen los nombres de cabecera para las columnas
this.cancelDepositDataGridView.Columns[0].HeaderCell.Value = "ID Deposito";
this.cancelDepositDataGridView.Columns[1].HeaderCell.Value = "Id Empleado";
this.cancelDepositDataGridView.Columns[2].HeaderCell.Value = "Cuenta Destino";
this.cancelDepositDataGridView.Columns[3].HeaderCell.Value = "Fecha de deposito";
this.cancelDepositDataGridView.Columns[4].HeaderCell.Value = "Cantidad";
this.cancelDepositDataGridView.Columns[5].HeaderCell.Value = "Nombre";
this.cancelDepositDataGridView.Columns[6].Visible = false;
Connection.CloseConnection();
}
//metodo para cargar todos los datos a la tabla
public void loadClientsData()
{
Connection.OpenConnection();
//se genera una lista con todos los clientes activos
clientsGridView.DataSource = Class.Client.showAllClients(Connection.myConnection);
//se establecen los nombres de cabecera para las columnas
this.clientsGridView.Columns[0].HeaderCell.Value = "ID";
this.clientsGridView.Columns[1].HeaderCell.Value = "Nombre";
this.clientsGridView.Columns[2].HeaderCell.Value = "Apellido";
this.clientsGridView.Columns[3].HeaderCell.Value = "Teléfono";
this.clientsGridView.Columns[4].HeaderCell.Value = "Correo";
this.clientsGridView.Columns[5].HeaderCell.Value = "Dirección";
this.clientsGridView.Columns[6].Visible = false;
Connection.CloseConnection();
}
private void loadData()
{
Connection.OpenConnection();
//se genera una lista con todos los clientes activos
canceledDataGriedView.DataSource = Class.Transaction.showAllCanceled(Connection.myConnection);
//se establecen los nombres de cabecera para las columnas
this.canceledDataGriedView.Columns[0].HeaderCell.Value = "ID";
this.canceledDataGriedView.Columns[1].HeaderCell.Value = "Cuenta origen";
this.canceledDataGriedView.Columns[2].HeaderCell.Value = "Cuenta destino";
this.canceledDataGriedView.Columns[3].HeaderCell.Value = "ID empleado";
this.canceledDataGriedView.Columns[4].HeaderCell.Value = "Fecha";
this.canceledDataGriedView.Columns[5].HeaderCell.Value = "Cantidad";
this.canceledDataGriedView.Columns[6].HeaderCell.Value = "Tipo de cuenta";
this.canceledDataGriedView.Columns[7].Visible = false;
Connection.CloseConnection();
}
private void addButton_Click(object sender, EventArgs e)
{
if (niptextBox.Text == "" || balanceTextBox.Text == "" || maximumCreditTextBox.Text == "" ||
accountTypeComboBox.SelectedItem == null)
{
MessageBox.Show("Favor de llenar todos los campos");
}
else
{
//abrir conexion de la db
Connection.OpenConnection();
//establecemos la fecha de corte
DateTime today = DateTime.Today;
DateTime cutOffDay = today.AddDays(15);
string date = today.ToString("yyyyMMdd");
//establemos el tipo de cliente que sera
int accountType;
if (accountTypeComboBox.SelectedIndex == 0)
{
//0 = Credito
accountType = 0;
}
else
{
//1 = debito
accountType = 1;
}
Class.Account account = new Class.Account(1, Int32.Parse(idClient), niptextBox.Text, float.Parse(balanceTextBox.Text), float.Parse(maximumCreditTextBox.Text), date, accountType, true);
if (Class.Account.addAccount(Connection.myConnection, account) == 1)
{
//Cerrar conexion con db
Connection.CloseConnection();
//Mensaje de exito
MessageBox.Show("Cuenta registrada con exito");
this.Close();
}
}
}
private void addButton_Click(object sender, EventArgs e)
{
if (firstNameTextBox.Text == "" || lastNameTextBox.Text == "" || phoneTextBox.Text == "" ||
emailTextBox.Text == "" || addressTextBox.Text == "" || positionComboBox.SelectedItem == null)
{
MessageBox.Show("Favor de llenar todos los campos");
}
else
{
if (IsValidEmail(emailTextBox.Text) == true)
{
Connection.OpenConnection();
int position;
if (positionComboBox.SelectedIndex == 0)
{
// 0 = gerente
position = 0;
}
else
{
//1 = empleado
position = 1;
}
Class.Employee newEmploye = new Class.Employee(1, firstNameTextBox.Text, lastNameTextBox.Text, phoneTextBox.Text, emailTextBox.Text, addressTextBox.Text, passwordTextBox.Text, position, true);
Class.Employee.addEmployee(Connection.myConnection, newEmploye);
Connection.CloseConnection();
MessageBox.Show("Empleado registrado\nExitosamente");
this.Close();
}
else
{
MessageBox.Show("El formato del correo no es correcto");
}
}
}