public void AddTrainer()
{
// switch to trainers panel
// create a new trainer
var trainer = new DataLayer.Trainer()
{
FName = "New Trainer",
LName = "New Trainer",
Sex = "Male",
DateOfBirth = DateTime.Now,
Street = String.Empty,
Suburb = String.Empty,
Salary = 0,
HomePhone = String.Empty,
CellPhone = String.Empty,
Notes = String.Empty,
City = String.Empty,
Email = String.Empty
};
// add to db
if (DataLayer.Trainers.NewTrainer(trainer) > 0)
{
SelectedTrainer = DataLayer.Trainers.GetLastInsertedTrainer();
LoadTrainers();
view.lbTrainers.SelectedIndex = view.lbTrainers.Items.Count - 1;
}
else
{
MessageBox.Show("could not add");
}
// set textboxes editable
//EditTrainer();
}
private void btnTrainersSave_Click(object sender, EventArgs e)
{
if (panelTrainers.Visible)
{
if (listBoxTrainers.SelectedIndex != 0)
{
// create a new trainer object
DataLayer.Trainer trainer = new DataLayer.Trainer();
if (!String.IsNullOrEmpty(txtTrainerLName.Text))
{
trainer.TrainerID = this.trainer_id;
trainer.FName = txtTrainerFName.Text.Trim();
trainer.LName = txtTrainerLName.Text.Trim();
trainer.CellPhone = txtTrainerCellPhone.Text.Trim();
trainer.City = txtTrainerCity.Text.Trim();
trainer.DateOfBirth = dtpTrainerDOB.Value;
trainer.Email = txtTrainerEmail.Text.Trim();
trainer.HomePhone = txtTrainerHomePhone.Text.Trim();
if (txtTrainerSalary.Text.Length > 0)
{
trainer.Salary = Decimal.Parse(txtTrainerSalary.Text.ToString());
}
else
{
trainer.Salary = 0;
}
trainer.Street = txtTrainerStreet.Text.Trim();
trainer.Suburb = txtTrainerSuburb.Text.Trim();
if (rbTrainerMale.Checked)
{
trainer.Sex = "Male";
}
else if (rbTrainerFemale.Checked)
{
trainer.Sex = "Female";
}
trainer.Notes = txtTrainerNotes.Text.Trim();
//save data to db
if (DataLayer.Trainers.UpdateTrainer(trainer) > 0)
{
MessageBox.Show("Trainer Updated successfully!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Information);
// refresh Trainers listbox
LoadAllTrainerNames();
}
else
{
MessageBox.Show("Failed to Update Trainer!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Last Name cannot be empty!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
// set textboxes to read only
txtTrainerFName.ReadOnly = true;
txtTrainerLName.ReadOnly = true;
txtTrainerCellPhone.ReadOnly = true;
txtTrainerCity.ReadOnly = true;
txtTrainerEmail.ReadOnly = true;
txtTrainerHomePhone.ReadOnly = true;
txtTrainerNotes.ReadOnly = true;
txtTrainerSalary.ReadOnly = true;
txtTrainerStreet.ReadOnly = true;
txtTrainerSuburb.ReadOnly = true;
//change button text and icon of btnTrainersEdit
btnTrainersEdit.Text = "Edit";
ComponentResourceManager resources = new ComponentResourceManager(typeof(frmMain));
btnTrainersEdit.Icon = ((System.Drawing.Icon)(resources.GetObject("btnTrainersEdit.Icon")));
}
}
}
private void btnTrainersAdd_Click(object sender, EventArgs e)
{
// switch to trainers panel
if (!panelTrainers.Visible)
SwitchToPanel(panelTrainers);
// create a new trainer
DataLayer.Trainer trainer = new DataLayer.Trainer();
trainer.FName = "New Trainer";
trainer.LName = "New Trainer";
trainer.Sex = "Male";
trainer.DateOfBirth = DateTime.Now;
trainer.Street = String.Empty;
trainer.Suburb = String.Empty;
trainer.Salary = 0;
trainer.HomePhone = String.Empty;
trainer.CellPhone = String.Empty;
trainer.Notes = String.Empty;
trainer.City = String.Empty;
trainer.Email = String.Empty;
// add to db
if (DataLayer.Trainers.NewTrainer(trainer) > 0)
{
//MessageBox.Show("success");
trainer_id = DataLayer.Trainers.GetLastInsertedTrainer();
LoadAllTrainerNames();
this.listBoxTrainers.SelectedIndex = this.listBoxTrainers.Items.Count - 1;
}
else
{
MessageBox.Show("could not add");
}
// set textboxes editable
EditTrainer();
}
// loads data for the specified trainer
public void LoadTrainer(int id)
{
DataLayer.Trainer trainer = new DataLayer.Trainer();
try
{
// display trainer details
trainer = DataLayer.Trainers.GetTrainer(id);
SetUpTrainerTextBoxes(trainer);
// display associated members
DataTable membersTable = DataLayer.Trainers.GetAssociatedMembers(id);
amTrainersDataGridViewX.DataSource = membersTable;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void SaveTrainer()
{
if (view.IsPanelVisible)
{
if (view.lbTrainers.SelectedIndex != 0)
{
if (!String.IsNullOrEmpty(view.LastName))
{
var trainer = new DataLayer.Trainer()
{
TrainerID = SelectedTrainer,
FName = view.FirstName,
LName = view.LastName,
CellPhone = view.CellPhone,
City = view.City,
DateOfBirth = view.DateOfBirth,
Email = view.Email,
HomePhone = view.HomePhone,
Salary = view.Salary,
Street = view.Street,
Suburb = view.Suburb,
Sex = view.Male_IsSelected ? "Male" : "Female",
Notes = view.Notes
};
//save to db
if (DataLayer.Trainers.UpdateTrainer(trainer) > 0)
{
MessageBox.Show("Trainer Updated successfully!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Information);
// refresh Trainers listbox
LoadTrainers();
}
else
{
MessageBox.Show("Failed to Update Trainer!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Last Name cannot be empty!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
//// set textboxes to read only
//txtTrainerFName.ReadOnly = true;
//txtTrainerLName.ReadOnly = true;
//txtTrainerCellPhone.ReadOnly = true;
//txtTrainerCity.ReadOnly = true;
//txtTrainerEmail.ReadOnly = true;
//txtTrainerHomePhone.ReadOnly = true;
//txtTrainerNotes.ReadOnly = true;
//txtTrainerSalary.ReadOnly = true;
//txtTrainerStreet.ReadOnly = true;
//txtTrainerSuburb.ReadOnly = true;
////change button text and icon of btnTrainersEdit
//btnTrainersEdit.Text = "Edit";
//ComponentResourceManager resources = new ComponentResourceManager(typeof(frmMain));
//btnTrainersEdit.Icon = ((System.Drawing.Icon)(resources.GetObject("btnTrainersEdit.Icon")));
}
}
}
