private void AddItem()
{
Item item = new Item();
string orderID;
item.ItemDescription = BoxName.Text;
item.Location = BoxLocation.Text;
item.Material = !BoxTool.Checked;
item.QuantityStored = int.Parse(BoxQuantity.Text);
item.UnitValue = float.Parse(BoxValue.Text);
item.SupplierID = (int)comboSuppliers.SelectedValue;
if (BoxOrder.Checked)
{
orderID = BoxOrderNum.Text;
}
else
{
orderID = null;
}
if (newSupplier)
{
Supplier supplier = new Supplier();
supplier.Name = BoxSupplierName.Text;
supplier.Phone = BoxSupplierNumber.Text;
supplier.Website = BoxSupplierWebsite.Text;
DatabaseTools.addItem(item, true, supplier, BoxOrderNum.Text);
}
else
{
DatabaseTools.addItem(item, false, null, BoxOrderNum.Text);
}
instance.Dispose();
MessageBox.Show("ITEM ADDED SUCCESFULLY");
}
private void button1_Click(object sender, EventArgs e)
{
if (BoxName.Text == "")
{
MessageBox.Show("Name/description cannot be empty!");
}
else
{
if (BoxOrder.Checked)
{
int orderValidity = DatabaseTools.AddOrder(BoxOrderNum.Text, dateOrder.Value, jobID);
switch (orderValidity)
{
case 2:
//Order didn't exist but has been added
AddItem();
break;
case 1:
//Order exists but date/job don't match
MessageBox.Show("Order number exists but input date and/or job does not match what is stored!");
break;
case 0:
//Order exists
AddItem();
break;
}
}
else
{
AddItem();
}
}
}
private void MainUserControl_Load(object sender, EventArgs e)
{
isAdmin = bool.Parse(DatabaseTools.GetValueFromKey("Employee", "Is Manager?", Main.userID, "Employee Code"));
if (isAdmin)
{
panelManagers.Show();
}
else
{
panelManagers.Hide();
}
}
public AddItemUserControl()
{
InitializeComponent();
DataTable suppliers = DatabaseTools.GetAllValues("SupplierID, [Supplier Name]", "Supplier");
DataRow other = suppliers.NewRow();
other["SupplierID"] = -1;
other["Supplier Name"] = "Other";
suppliers.Rows.Add(other);
comboSuppliers.DisplayMember = "Supplier Name";
comboSuppliers.ValueMember = "SupplierID";
comboSuppliers.DataSource = suppliers;
}
private void ButtonSubmit_Click(object sender, EventArgs e)
{
if (DatabaseTools.IsInDatabase("Employee", "Employee Code", BoxID.Text))
{
LabelError.Hide();
userID = BoxID.Text;
Main main = new Main(userID);
main.Show();
this.Hide();
BoxID.Clear();
}
else
{
LabelError.Show();
}
}
private void Main_Load(object sender, EventArgs e)
{
PanelContent.Controls.Add(MainUserControl.Instance);
MainUserControl.Instance.Dock = DockStyle.Fill;
MainUserControl.Instance.BringToFront();
name = DatabaseTools.GetValueFromKey("Employee", "Employee Name", userID, "Employee Code");
LabelName.Text = "Welcome, " + name;
MainUserControl.Instance.SearchStarted += new EventHandler(OpenSearchResults);
MainUserControl.Instance.SuppliersView += new EventHandler(ViewSuppliers);
MainUserControl.Instance.EditsView += new EventHandler(ViewEdits);
MainUserControl.Instance.AddOpen += new EventHandler(OpenAdd);
SearchResultsUserControl.Instance.AddOpen += MainUserControl.Instance.AddOpen;
SearchResultsUserControl.Instance.EditOpen += new EventHandler(OpenEdit);
setEvents(this);
actionStack.Push(actions.Main);
}
private static void outputReport()
{
int row = 0, col = 0;
string formatString;
Excel.Application excelApp = new Excel.Application();
if (excelApp == null)
{
MessageBox.Show("WANRNING!\n<< TRIED TO CREATE REPORT BUT EXCEL IS NOT INSTALLED! >>");
}
else
{
Excel.Workbook workbook = excelApp.Workbooks.Open(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\Reports.xlsx");
Excel.Worksheet DataWorksheet = workbook.Worksheets[workbook.Worksheets.Count];
try
{
DataWorksheet.Name = "Data";
DataTable data = DatabaseTools.getReportData();
foreach (DataColumn dataColumn in data.Columns)
{
DataWorksheet.Range["A1"].Offset[0, col].Value = dataColumn.ColumnName;
switch (dataColumn.DataType.ToString())
{
case "System.Decimal":
formatString = "_-[$£-en-GB]* #,##0.00_-;-[$£-en-GB]* #,##0.00_-;_-[$£-en-GB]* \" - \"??_-;_-@_-";
break;
case "System.Int32":
formatString = "0";
break;
case "System.DateTime":
formatString = "dd/mm/yyyy";
break;
default:
formatString = "@";
break;
}
DataWorksheet.Range["A1"].Offset[0, col].EntireColumn.NumberFormat = formatString;
col++;
}
row = 2;
foreach (DataRow dataRow in data.Rows)
{
for (col = 0; col < data.Columns.Count; col++)
{
DataWorksheet.Cells[row, col + 1] = dataRow[col] == DBNull.Value ? string.Empty : dataRow[col].ToString();
}
row++;
}
DataWorksheet.Columns.AutoFit();
Excel.Worksheet PivotSheet = workbook.Worksheets.Add();
PivotSheet.Name = DateTime.Now.ToLongDateString();
Excel.Range dataRange = DataWorksheet.UsedRange;
Excel.PivotCache cache = workbook.PivotCaches().Create(Excel.XlPivotTableSourceType.xlDatabase, dataRange);
Excel.PivotCaches pivotCaches = workbook.PivotCaches();
pivotCaches.Create(Excel.XlPivotTableSourceType.xlDatabase, dataRange).CreatePivotTable(PivotSheet.Cells[1, 1], "Table");
Excel.PivotTable pivotTable = PivotSheet.PivotTables("Table");
Excel.PivotField field = pivotTable.PivotFields("Job Name");
field.Orientation = Excel.XlPivotFieldOrientation.xlRowField;
field.LayoutCompactRow = false;
field.Subtotals = new bool[12] {
false, false, false, false, false, false, false, false, false, false, false, false
};
field = pivotTable.PivotFields("Order Number");
field.Orientation = Excel.XlPivotFieldOrientation.xlRowField;
field.Subtotals = new bool[12] {
false, false, false, false, false, false, false, false, false, false, false, false
};
field = pivotTable.PivotFields("Total Value");
field.Orientation = Excel.XlPivotFieldOrientation.xlDataField;
field.Caption = "Total Values";
field = pivotTable.PivotFields("Average Value");
field.Orientation = Excel.XlPivotFieldOrientation.xlDataField;
field.Caption = "Average Values";
PivotSheet.UsedRange.Columns.AutoFit();
pivotTable.MergeLabels = true;
pivotTable.ShowValuesRow = false;
pivotTable.ColumnGrand = false;
pivotTable.RowGrand = false;
}
catch (Exception e)
{
MessageBox.Show(string.Format(e.Message + "\n" + e.InnerException + "\n" + e.Data));
}
finally
{
workbook.Save();
workbook.Close();
excelApp.Quit();
}
}
}
