/// <summary>
/// Opens an existing mdf file, called by the form constructor with 1 overload
/// </summary>
/// <param name="grid">The datagrid to bind the DB to</param>
public void initalizeDataGrid(DataGridView grid)
{
mainForm = ((Main)MdiParent);
// DB Connection Setup
connString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=" + filepath + "; Integrated Security=True;Connect Timeout=30";
Db = new DatabaseOperations(connString);
Db.OpenDatabase(filepath);
page = new DBPagination(db, dtgrd_manufacturer, "Equipment", itemPerPageUpDown, pageSelector); // relinquish the DB to the page class
page.currPage = 0; // make sure the form shows the first page
Text = Path.GetFileNameWithoutExtension(filepath);
try
{
page.loadPage(); // database binding
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
grid.AllowUserToAddRows = true;
grid.AllowUserToDeleteRows = true;
grid.AllowUserToResizeColumns = true;
grid.ReadOnly = false;
grid.Columns[0].ReadOnly = true;
grid.Columns[0].DefaultCellStyle.SelectionBackColor = Color.LightGray;
grid.Columns[0].DefaultCellStyle.SelectionForeColor = Color.DarkGray;
grid.Columns[2].DefaultCellStyle.SelectionBackColor = Color.LightGray;
grid.Columns[2].DefaultCellStyle.SelectionForeColor = Color.DarkGray;
Db.Dispose(true);
}
/// <summary>
/// Opens an existing mdf file, called by the form constructor with 1 overload
/// </summary>
/// <param name="grid">The datagrid to bind the DB to</param>
public void initalizeDataGrid(DataGridView grid)
{
isSaved = true;
mainForm = ((Main)MdiParent);
// DB Connection Setup
connString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=" + filepath + "; Integrated Security=True;Connect Timeout=30";
Db = new DatabaseOperations(connString);
Db.OpenDatabase(filepath);
equipmentPage = new DBPagination(db, dtgrd_equipment, "Equipment", itemPerPageUpDown, pageSelector); // relinquish the DB to the page class
equipmentPage.currPage = 0; // make sure the form shows the first page
manufacturerPage = new DBPagination(db, dtgrd_manufacturer, "Manufacturer", itemPerPageUpDown, pageSelector);
manufacturerPage.currPage = 0;
// refresh the list
pagedTabs = new List <DBPagination>();
pagedTabs.Add(equipmentPage);
pagedTabs.Add(manufacturerPage);
Text = Path.GetFileNameWithoutExtension(filepath);
DataGridViewComboBoxColumn conditionCol = (DataGridViewComboBoxColumn)grid.Columns[2];
conditionCol.DataSource = condList.conditionList.OrderBy(p => p.Priority).ToList();
conditionCol.DefaultCellStyle.NullValue = condList.conditionList[0].Value;
conditionCol.DisplayMember = "Value";
conditionCol.ValueMember = "Value";
conditionCol.SortMode = DataGridViewColumnSortMode.Automatic;
refreshManufCol();
try
{
manufacturerPage.loadPage(); //database binding for manufacturers
equipmentPage.loadPage(); // database binding
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
grid.AllowUserToAddRows = true;
grid.AllowUserToDeleteRows = true;
grid.AllowUserToResizeColumns = true;
grid.ReadOnly = false;
grid.Columns[0].ReadOnly = true;
grid.Columns[0].DefaultCellStyle.SelectionBackColor = Color.LightGray;
grid.Columns[0].DefaultCellStyle.SelectionForeColor = Color.DarkGray;
grid.Columns[2].DefaultCellStyle.SelectionBackColor = Color.LightGray;
grid.Columns[2].DefaultCellStyle.SelectionForeColor = Color.DarkGray;
colorRowsByCondition();
Db.Dispose(true);
}
/// <summary>
/// Creates a new DB and loads it up to the view
/// </summary>
/// <param name="grid"></param>
public void initializeDefGrid(DataGridView grid)
{
mainForm = ((Main)MdiParent);
//dir = Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + @"\managementapp\";
//filepath = dir + string.Format("temp_{0}.mdf", mainForm.fileCounter);
//Text = string.Format("New Database {0}", mainForm.fileCounter);
//// Create temporary directory and make it hidden
//DirectoryInfo dirInf = Directory.CreateDirectory(dir);
//dirInf.Attributes = FileAttributes.Directory | FileAttributes.Hidden;
// DB Connection Setup
connString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=" + filepath + "; Integrated Security=True;Connect Timeout=30";
Db = new DatabaseOperations(connString);
Db.CreateDatabase(filepath);
page = new DBPagination(db, dtgrd_manufacturer, "Equipment", itemPerPageUpDown, pageSelector); // relinquish the DB to the page class
page.currPage = 0; // make sure the form shows the first page
//Identity allows the 'ID' Attribute to be auto incremented. Its value does not have to specified when inserting to the table.
Db.CreateTable("Manufacturer", "ID", "int IDENTITY(1,1) not null PRIMARY KEY", "Name", "VARCHAR(255)", "Email", "VARCHAR(255)", "Number", "VARCHAR(255)", "Country", "VARCHAR(255)", "City", "VARCHAR(255)", "Zip", "VARCHAR(255)");
try
{
page.loadPage(); // database binding
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
grid.AllowUserToAddRows = true;
grid.AllowUserToDeleteRows = true;
grid.AllowUserToResizeColumns = true;
grid.ReadOnly = false;
grid.Columns[0].ReadOnly = true;
grid.Columns[0].DefaultCellStyle.SelectionBackColor = Color.LightGray;
grid.Columns[0].DefaultCellStyle.SelectionForeColor = Color.DarkGray;
grid.Columns[2].DefaultCellStyle.SelectionBackColor = Color.LightGray;
grid.Columns[2].DefaultCellStyle.SelectionForeColor = Color.DarkGray;
Db.Dispose(true);
}
/// <summary>
/// Creates a new DB and loads it up to the view
/// </summary>
/// <param name="grid"></param>
public void initializeDefGrid(DataGridView grid)
{
isSaved = false;
mainForm = ((Main)MdiParent);
dir = Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + @"\managementapp\";
filepath = dir + string.Format("temp_{0}.mdf", mainForm.fileCounter);
Text = string.Format("New Database {0}", mainForm.fileCounter);
// Create temporary directory and make it hidden
DirectoryInfo dirInf = Directory.CreateDirectory(dir);
dirInf.Attributes = FileAttributes.Directory | FileAttributes.Hidden;
// DB Connection Setup
connString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=" + filepath + "; Integrated Security=True;Connect Timeout=30";
Db = new DatabaseOperations(connString);
Db.CreateDatabase(filepath);
equipmentPage = new DBPagination(db, dtgrd_equipment, "Equipment", itemPerPageUpDown, pageSelector); // relinquish the DB to the page class
equipmentPage.currPage = 0; // make sure the form shows the first page
manufacturerPage = new DBPagination(db, dtgrd_manufacturer, "Manufacturer", itemPerPageUpDown, pageSelector);
manufacturerPage.currPage = 0;
//Identity allows the 'ID' Attribute to be auto incremented. Its value does not have to specified when inserting to the table.
Db.CreateTable("Equipment", "ID", "int IDENTITY(1,1) not null PRIMARY KEY", "Name", "varchar(255)", "Condition", "varchar(255)", "Quantity", "int", "Price", "decimal(19,2)", "Department", "varchar(255)", "Manufacturer", "varchar(255)", "[Date_of_Purchase]", "date");
Db.CreateTable("Manufacturer", "ID", "int IDENTITY(1,1) not null PRIMARY KEY", "Name", "varchar(255)", "[Email_Address]", "varchar(255)", "[Contact_Number]", "varchar(255)", "[Country_of_Origin]", "varchar(255)", "City", "varchar(255)", "[Zip_Code]", "int");
Db.CreateTable("Department", "ID", "int IDENTITY(1,1) not null PRIMARY KEY", "Name", "varchar(255)");
//DataGridViewComboBoxColumn conditionCol = (DataGridViewComboBoxColumn)grid.Columns[2];
DataGridViewComboBoxColumn conditionCol = dtgrd_equipment.Columns[2] as DataGridViewComboBoxColumn;
conditionCol.DataSource = condList.conditionList.OrderBy(p => p.Priority).ToList();
conditionCol.DefaultCellStyle.NullValue = condList.conditionList[0].Value;
conditionCol.DisplayMember = "Value";
conditionCol.ValueMember = "Value";
conditionCol.SortMode = DataGridViewColumnSortMode.Automatic;
try
{
manufacturerPage.loadPage(); //database binding (manufacturer)
equipmentPage.loadPage(); // database binding
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
grid.AllowUserToAddRows = true;
grid.AllowUserToDeleteRows = true;
grid.AllowUserToResizeColumns = true;
grid.ReadOnly = false;
grid.Columns[0].ReadOnly = true;
grid.Columns[0].DefaultCellStyle.SelectionBackColor = Color.LightGray;
grid.Columns[0].DefaultCellStyle.SelectionForeColor = Color.DarkGray;
grid.Columns[2].DefaultCellStyle.SelectionBackColor = Color.LightGray;
grid.Columns[2].DefaultCellStyle.SelectionForeColor = Color.DarkGray;
Db.Dispose(true);
}
