//---------CRUD---------//
private void createButton_Click(object sender, EventArgs e)
{
string name = txtNameClient.Text;
string lastname = txtLastnameClient.Text;
string idType = cmbIdentificationType.Text;
string identif = txtIdentification.Text;
string bornDate = datepBornDate.Text;
string email = txtEmailClient.Text;
try
{
if (ClientManagement.InsertClient(name, lastname, identif, idType, email, bornDate))
{
Clear();
WireUpClientsGridView();
FrmMain.Instance.ToolStripLabel.Text = "Se agregó el cliente de manera correcta.";
}
else
{
FrmMain.Instance.ToolStripLabel.Text = "Ha ocurrido un error al agregar el cliente, inténtelo nuevamente.";
}
}
catch (Exception)
{
throw;
}
}
private void AddButton_Click_1(object sender, EventArgs e)
{
if (IdLabel.Text.Equals("none"))
{
if (!string.IsNullOrEmpty(NameTextBox.Text) && !string.IsNullOrEmpty(LastNameTextBox.Text))
{
DateTime fecha = DateTime.Now;
if (ClientManagement.InsertClient(NameTextBox.Text, LastNameTextBox.Text, IdTypeComboBox.SelectedItem.ToString(),
IdentificationTextBox.Text, EmailTextBox.Text, BornDateTimePicker.Value, fecha))
{
FrmMain.Instance.ToolStripLabel.Text = "Se agrego el Cliente correctamente.";
Clear();
ReloadClient();
}
else
{
FrmMain.Instance.ToolStripLabel.Text = "Error! No se pudo agregar el Cliente.";
}
}
else
{
}
}
}
//--------------------Metodos de actualizaciones-------------------------
private void ReloadClient()
{
clientModels = ClientManagement.SelectAllClients();
ClientDataGridView.MultiSelect = false;
ClientDataGridView.DataSource = clientModels;
ClientDataGridView.Columns["Id_Client"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
ClientDataGridView.Columns["Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
ClientDataGridView.Columns["LastName"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
ClientDataGridView.Columns["Identification_Type"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
ClientDataGridView.Columns["Identification"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
ClientDataGridView.Columns["Email"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
ClientDataGridView.Columns["Born_Date"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
ClientDataGridView.Columns["Registration_Date"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
ClientDataGridView.Columns["Id_Client"].HeaderText = "Id";
ClientDataGridView.Columns["Name"].HeaderText = "Nombre";
ClientDataGridView.Columns["LastName"].HeaderText = "Apellidos";
ClientDataGridView.Columns["Identification_Type"].HeaderText = "Tipo de Identificación";
ClientDataGridView.Columns["Identification"].HeaderText = "Identificación";
ClientDataGridView.Columns["Email"].HeaderText = "Correo electronico";
ClientDataGridView.Columns["Born_Date"].HeaderText = "Fecha de Nacimiento";
ClientDataGridView.Columns["Registration_Date"].HeaderText = "Fecha de Registro";
ClientDataGridView.Columns["Id_Client"].Visible = false;
ClientDataGridView.Columns["Born_Date"].DefaultCellStyle.Format = "d";
ClientDataGridView.Columns["Registration_Date"].DefaultCellStyle.Format = "d";
ClientDataGridView.Columns["Born_Date"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
ClientDataGridView.Columns["Registration_Date"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
ClientDataGridView.Columns["Identification"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
private void updateButton_Click(object sender, EventArgs e)
{
string id = clientsGridView.CurrentRow.Cells[0].Value.ToString();
string name = txtNameClient.Text;
string lastname = txtLastnameClient.Text;
string idType = cmbIdentificationType.Text;
string identif = txtIdentification.Text;
string bornDate = datepBornDate.Text;
string email = txtEmailClient.Text;
try
{
if (ClientManagement.UpdateClientById(id, name, lastname, identif, idType, email, bornDate))
{
Clear();
WireUpClientsGridView();
FrmMain.Instance.ToolStripLabel.Text = "Se modificó el cliente de manera correcta.";
}
else
{
FrmMain.Instance.ToolStripLabel.Text = "Ha ocurrido un error al modificar el cliente, inténtelo nuevamente.";
}
}
catch (Exception)
{
throw;
}
}
private void ModifyButton_Click_1(object sender, EventArgs e)
{
if (!IdLabel.Text.Equals("none"))
{
if (!string.IsNullOrEmpty(NameTextBox.Text) && !string.IsNullOrEmpty(LastNameTextBox.Text) &&
ClientDataGridView.CurrentRow.Cells[0].Value.ToString() != null)
{
if (MetroMessageBox.Show(this, $"¿Seguro que desea modificar al cliente: { ClientDataGridView.CurrentRow.Cells[1].Value.ToString() }?", "Modificar cliente", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
if (ClientManagement.UpdateClientById(int.Parse(IdLabel.Text), NameTextBox.Text, LastNameTextBox.Text, IdTypeComboBox.SelectedItem.ToString(),
IdentificationTextBox.Text, EmailTextBox.Text, BornDateTimePicker.Value))
{
FrmMain.Instance.ToolStripLabel.Text = "Se modifico el cliente correctamente.";
Clear();
ReloadClient();
}
else
{
MetroMessageBox.Show(this, $"Ha ocurrido un error al modificar al cliente: { NameTextBox.Text}.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
}
}
}
public ActionResult Index()
{
ClientManagement clients = new ClientManagement();
clients.Clients = unitOfWork.ClientRepository.GetClients((int)Session["UserId"]).ToList();
return(View(clients));
}
public void Sort_shouldReturn_SortedbyBankAccount()
{
ClientManagement sortedList = new ClientManagement();
CreateObjects();
sortedList.ShowClients = clientManagement.Sort(3);
Assert.IsTrue(sortedList.ShowClients[0] == client1 && sortedList.ShowClients[1] == client3 && sortedList.ShowClients[2] == client2);
}
public TestController()
{
_audit = new AuditManagement();
_user = new UserManagement();
_menu = new MenuManagement();
_role = new RoleManagement();
_client = new ClientManagement();
_brand = new BrandManagement();
}
private void UcAparts_Load(object sender, EventArgs e)
{
employeeComboBox.DataSource = EmployeeManagement.SelectAllEmployees();
employeeComboBox.DisplayMember = "Name";
StoreComboBox.DataSource = BusinessManagement.SelectAllBusiness();
StoreComboBox.DisplayMember = "fantasyName";
clientComboBox.DataSource = ClientManagement.SelectAllClients();
clientComboBox.DisplayMember = "Name";
WrapProductsGridView();
}
public DolphinController()
{
_audit = new AuditManagement();
_user = new UserManagement();
_menu = new MenuManagement();
_role = new RoleManagement();
_client = new ClientManagement();
_brand = new BrandManagement();
_terminal = new TerminalManagement();
_incident = new IncidentManagement();
}
private void GrdClientManagement_MouseDown(object sender, MouseButtonEventArgs e)
{
if (cliWindow is null)
{
cliWindow = new ClientManagement()
{
Owner = this
}
}
;
lblContents.Content = cliWindow.Content;
Title = "Client Management Window";
}
private void SearchTextBox_ButtonClick(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(SearchTextBox.Text))
{
ClientDataGridView.DataSource = ClientManagement.SelectMultipleClients(SearchTextBox.Text);
FrmMain.Instance.ToolStripLabel.Text = "Lista de Clientes cargada correctamente.";
Clear();
}
else
{
FrmMain.Instance.ToolStripLabel.Text = "Error! El campo buscar no puede ser vacio.";
}
}
public GuiController()
{
mainMenu = new MainMenu();
administrationMenu = new AdministrationMenu();
vehicleMenuToAddData = new VehicleMenuToAddData();
dataEditingMenu = new DataEditingMenu();
dataDeleteMenu = new DataDeleteMenu();
rentMenu = new RentMenu();
getInfoMenu = new GetInfoMenu();
searchInfoMenu = new SearchInfoMenu();
functionsForSQL = new FunctionsCheckEnteredAndSQLData();
functionsForBike = new BikeManagement();
functionsForCar = new CarManagement();
functionsForMoto = new MotoManagement();
functionsForClient = new ClientManagement();
sqlInsert = new SQLInsert();
sqlEdit = new SQLEdit();
sqlDelete = new SQLDelete();
}
//---------EVENTS---------//
private void txtSearchClient_KeyPress(object sender, KeyPressEventArgs e)
{
string text = txtSearchClient.Text;
try
{
if (text != "")
{
clientsGridView.DataSource = ClientManagement.SelectClientByNameOrLastName(text);
}
else
{
clientsGridView.DataSource = ClientManagement.SelectAllClients();
}
}
catch (Exception)
{
throw;
}
}
private void UcClient_Load(object sender, EventArgs e)
{
try
{
if (ClientManagement.SelectAllClients() != null)
{
clientModels = ClientManagement.SelectAllClients();
WireUpClientsGridView();
FrmMain.Instance.ToolStripLabel.Text = "Los registros de la base de datos fueron cargados.";
}
else
{
FrmMain.Instance.ToolStripLabel.Text = "No se encontraron registros en la base de datos.";
}
}
catch (Exception ex)
{
throw;
}
}
private void deleteButton_Click(object sender, EventArgs e)
{
string idClient = clientsGridView.CurrentRow.Cells[0].Value.ToString();
try
{
if (ClientManagement.DeleteClientById(idClient))
{
Clear();
WireUpClientsGridView();
FrmMain.Instance.ToolStripLabel.Text = "Se eliminó el cliente de manera correcta.";
}
else
{
FrmMain.Instance.ToolStripLabel.Text = "Ha ocurrido un error al eliminar el cliente, inténtelo nuevamente.";
}
}
catch (Exception)
{
throw;
}
}
private void DeleteButton_Click_1(object sender, EventArgs e)
{
if (!IdLabel.Text.Equals("none"))
{
if (!string.IsNullOrEmpty(NameTextBox.Text) && !string.IsNullOrEmpty(LastNameTextBox.Text))
{
int Id = int.Parse(IdLabel.Text);
if (ClientManagement.DeleteClientById(Id))
{
FrmMain.Instance.ToolStripLabel.Text = "Se elimino el Cliente correctamente.";
Clear();
ReloadClient();
}
else
{
FrmMain.Instance.ToolStripLabel.Text = "Error! No se pudo eliminar el Cliente.";
}
}
else
{
}
}
}
private void NewButton_Click_1(object sender, EventArgs e)
{
Clear();
clientModels = ClientManagement.SelectAllClients();
ClientDataGridView.DataSource = clientModels;
}