/// <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); }