public MachineStockAdjust(Database database, StartUp parent, Machine machine)
{
InitializeComponent();
this.database = database;
this.parent = parent;
this.machine = machine;
this.controller = new Controller(database);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
// Prebuild Existing Employee ID list for comparison
List<string> existingIDList = new List<string>();
foreach (Employee employee in database.SelectAllEmployee())
{
existingIDList.Add(employee.EmployeeID);
}
string fName = textBox1.Text;
string lName = textBox2.Text;
string position = textBox3.Text;
string location = textBox4.Text;
string payRateString = textBox5.Text;
string employeeID = textBox6.Text;
string dateTimeString = textBox7.Text;
if (!existingIDList.Contains(employeeID))
{
if (fName != "" & fName != null &
lName != "" & lName != null &
position != "" & position != null &
location != "" & location != null &
employeeID != "" & employeeID != null)
{
float payRate = float.Parse(payRateString);
DateTime dateStarted = DateTime.Parse(dateTimeString);
// Create Record
Controller controller = new Controller(database);
controller.AddEmployee(fName, lName, employeeID, location, position, payRate, dateStarted);
this.parent.LoadEmployeesDataGrid();
this.Close();
}
else
{
MessageBox.Show("Please enter all employee information");
}
}
else
{
MessageBox.Show("That Employee ID already exists. Please select a new ID.");
}
}
catch
{
MessageBox.Show("Invalid Entries - Please enter employee information.");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
// Prebuild Existing Machine ID list for comparison
List<string> existingIDList = new List<string>();
foreach (Machine machine in database.SelectAllMachine())
{
existingIDList.Add(machine.MachineID);
}
string productType = textBox1.Text;
string maxCapacityString = textBox2.Text;
string city = textBox3.Text;
string location = textBox4.Text;
string minimumStockString = textBox5.Text;
string machineID = textBox6.Text;
if (!existingIDList.Contains(machineID))
{
if (productType != "" & productType != null &
maxCapacityString != "" & maxCapacityString != null &
city != "" & city != null &
location != "" & location != null &
minimumStockString != "" & minimumStockString != null &
machineID != "" & machineID != null)
{
int maxCapacity = int.Parse(maxCapacityString);
int minimumStock = int.Parse(minimumStockString);
// Create Record
Controller controller = new Controller(database);
controller.AddMachine(machineID, city, location, maxCapacity, minimumStock, productType);
this.parent.LoadMachineListAllDataGrid();
this.Close();
}
else
{
MessageBox.Show("Please enter all employee information");
}
}
else
{
MessageBox.Show("That Employee ID already exists. Please select a new ID.");
}
}
catch
{
MessageBox.Show("Invalid Entries - Please enter employee information.");
}
}
private void button1_Click_1(object sender, EventArgs e)
{
try
{
string name = textBox8.Text;
string wholeSalePriceString = textBox7.Text;
string quantityString = textBox1.Text;
if (name != "" & name != null &
wholeSalePriceString != "" & wholeSalePriceString != null &
quantityString != "" & quantityString != null )
{
float wholeSalePrice = float.Parse(wholeSalePriceString);
int quantity = int.Parse(quantityString);
if (quantity > 0)
{
DialogResult confirm = MessageBox.Show("You are about to purchase " + quantityString + " " + name + " for a total of $" + Convert.ToString(quantity * wholeSalePrice) + ".\nPlease confirm this is accurate.",
"Confirm Delete",
MessageBoxButtons.YesNo,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button2);
if (confirm == DialogResult.Yes)
{
// Create Record
Controller controller = new Controller(database);
controller.AddProduct(name, wholeSalePrice, quantity);
this.parent.LoadProductWarehouseDataGrid();
this.Close();
}
}
else
{
MessageBox.Show("Please enter quantity larger than 0.");
}
}
else
{
MessageBox.Show("Please enter a product name and purchase price.");
}
}
catch
{
MessageBox.Show("Invalid Entries - Please enter a product name and purchase price.");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
List<string> existingIDList = new List<string>();
foreach (City city in database.SelectAllCity())
{
existingIDList.Add(city.ID);
}
string cityName = textBox8.Text;
string state = textBox7.Text;
string ID = textBox1.Text;
if (!existingIDList.Contains(ID))
{
if (cityName != "" & cityName != null &
state != "" & state != null &
ID != "" & ID != null)
{
// Create Record
Controller controller = new Controller(database);
controller.AddCity(cityName, state, ID);
this.parent.LoadCityMachinesDataGrid();
this.Close();
}
else
{
MessageBox.Show("Please enter a City, State, and a uniquie ID.");
}
}
else
{
MessageBox.Show("ID already exists. Please enter a uniqueID.");
}
}
catch
{
MessageBox.Show("Invalid Entries - Please enter a City, State, and a uniquie ID.");
}
}
private void button5_Click(object sender, EventArgs e)
{
List<string> employeeIdToRemove = new List<string>();
if (EmployeesDataGrid.SelectedRows.Count > 0)
{
foreach (DataGridViewRow row in EmployeesDataGrid.SelectedRows)
{
//MessageBox.Show( row.Cells["EmployeeID"].Value.ToString());
if (!employeeIdToRemove.Contains(row.Cells["EmployeeID"].Value.ToString()))
{
employeeIdToRemove.Add(row.Cells["EmployeeID"].Value.ToString());
}
}
}
else if (EmployeesDataGrid.SelectedCells.Count > 0)
{
foreach (DataGridViewCell cell in EmployeesDataGrid.SelectedCells)
{
DataGridViewRow row = EmployeesDataGrid.Rows[cell.RowIndex];
//MessageBox.Show(row.Cells["EmployeeID"].Value.ToString());
if (!employeeIdToRemove.Contains(row.Cells["EmployeeID"].Value.ToString()))
{
employeeIdToRemove.Add(row.Cells["EmployeeID"].Value.ToString());
}
}
}
foreach (string ID in employeeIdToRemove)
{
DialogResult confirm = MessageBox.Show("Are you sure you want to Delete employee ID# " + ID,
"Confirm Delete",
MessageBoxButtons.YesNo,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button2);
if (confirm == DialogResult.Yes)
{
Controller controller = new Controller(database);
controller.RemoveEmployee(ID);
EmployeesDataGrid.DataSource = null;
EmployeesDataGrid.Update();
EmployeesDataGrid.Refresh();
List<Employee> data;
data = this.database.SelectAllEmployee();
EmployeesDataGrid.DataSource = data;
EmployeesDataGrid.Update();
EmployeesDataGrid.Refresh();
}
}
}
// Remove City Button
private void button9_Click(object sender, EventArgs e)
{
List<string> CityIdToRemove = new List<string>();
if (CityMachinesDataGrid.SelectedRows.Count > 0)
{
foreach (DataGridViewRow row in CityMachinesDataGrid.SelectedRows)
{
if (!CityIdToRemove.Contains(row.Cells["Name"].Value.ToString()))
{
CityIdToRemove.Add(row.Cells["Name"].Value.ToString());
}
}
}
else if (CityMachinesDataGrid.SelectedCells.Count > 0)
{
foreach (DataGridViewCell cell in CityMachinesDataGrid.SelectedCells)
{
DataGridViewRow row = CityMachinesDataGrid.Rows[cell.RowIndex];
if (!CityIdToRemove.Contains(row.Cells["Name"].Value.ToString()))
{
CityIdToRemove.Add(row.Cells["Name"].Value.ToString());
}
}
}
foreach (string ID in CityIdToRemove)
{
DialogResult confirm = MessageBox.Show("Are you sure you want to Delete City ID# " + ID,
"Confirm Delete",
MessageBoxButtons.YesNo,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button2);
if (confirm == DialogResult.Yes)
{
Controller controller = new Controller(database);
controller.RemoveCity(ID);
this.LoadCityMachinesDataGrid();
}
}
}
//
// Remove Button Control Methods
//
// Product Remove Button
private void button3_Click_1(object sender, EventArgs e)
{
List<string> ProductIdToRemove = new List<string>();
List<int> rowsProcessedAlready = new List<int>();
if (ProductWarehouseDataGrid.SelectedRows.Count > 0)
{
foreach (DataGridViewRow row in ProductWarehouseDataGrid.SelectedRows)
{
if (!rowsProcessedAlready.Contains(row.Index))
{
ProductIdToRemove.Add(row.Cells["Product Type"].Value.ToString());
rowsProcessedAlready.Add(row.Index);
}
}
}
else if (ProductWarehouseDataGrid.SelectedCells.Count > 0)
{
foreach (DataGridViewCell cell in ProductWarehouseDataGrid.SelectedCells)
{
DataGridViewRow row = ProductWarehouseDataGrid.Rows[cell.RowIndex];
if (!rowsProcessedAlready.Contains(row.Index))
{
ProductIdToRemove.Add(row.Cells["Product Type"].Value.ToString());
rowsProcessedAlready.Add(row.Index);
}
}
}
foreach (string ID in ProductIdToRemove)
{
//DialogResult confirm = MessageBox.Show("Are you sure you want to Delete product ID " + ID,
// "Confirm Delete",
// MessageBoxButtons.YesNo,
// MessageBoxIcon.Exclamation,
// MessageBoxDefaultButton.Button2);
//if (confirm == DialogResult.Yes)
if (true)
{
Controller controller = new Controller(database);
controller.RemoveProduct(ID);
this.LoadProductWarehouseDataGrid();
}
}
}
