private void byOfficeToolStripMenuItem_Click(object sender, EventArgs e)
{
if (ActiveMdiChild.GetType() == typeof(FRM_EquipmentEditing))
{
// get the active mdi child and determine if it is an equipment form
FRM_EquipmentEditing tempForm = (FRM_EquipmentEditing)ActiveMdiChild;
}
}
private void newToolStripMenuItem_Click(object sender, EventArgs e)
{
fileCounter++;
FRM_EquipmentEditing frm = new FRM_EquipmentEditing();
frm.MdiParent = this;
frm.Show();
openFileName = frm.Filepath;
}
private void openToolStripMenuItem_Click(object sender, EventArgs e)
{
OpenFileDialog open = new OpenFileDialog();
open.Filter = "SQL Server Database Files|*.mdf";
open.Title = "Open Inventory File";
if (open.ShowDialog() == DialogResult.OK) // if the user pressed OK on the form then read the file
{
FRM_EquipmentEditing frm = new FRM_EquipmentEditing(open.FileName);
frm.MdiParent = this;
frm.Show();
openFileName = open.FileName;
}
}
private void saveAsToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
// get active MDI Form and determine if it is an EquipmentView Form
if (ActiveMdiChild.GetType() == typeof(FRM_EquipmentEditing))
{
// get the active mdi child and determine if it is an equipment form
FRM_EquipmentEditing tempForm = (FRM_EquipmentEditing)ActiveMdiChild;
if (tempForm.PageEquip.getResultCount() == 0)
{
MessageBox.Show("Database table has no entries!", "Saving Failed", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
SaveFileDialog save = new SaveFileDialog();
save.Filter = "SQL Server Database Files|*.mdf";
save.Title = "Save Inventory File";
save.FileName = "Equipment_Record";
DialogResult result = save.ShowDialog();
if (result == DialogResult.OK && tempForm.IsNewDB == true)
{
try
{
if (File.Exists(save.FileName)) // overwrite the existing file
{
File.Delete(save.FileName);
string str = Path.GetFileNameWithoutExtension(save.FileName);
str += "_log.ldf";
string str2 = Path.GetDirectoryName(save.FileName);
File.Delete(str2 + @"\\" + str); // delete the ldf file
}
tempForm.Db.Dispose(true);
File.Move(tempForm.Db.fileName, save.FileName);
tempForm.IsNewDB = false;
tempForm.Filepath = save.FileName; // load the saved Database and bind it to the DGV
tempForm.initalizeDataGrid(tempForm.getDGV());
tempForm.PageEquip.ReCount();
tempForm.PageEquip.loadPage();
tempForm.PageMnf.ReCount();
tempForm.PageMnf.loadPage();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
else if (result == DialogResult.OK && tempForm.IsNewDB == false)
{
try
{
if (File.Exists(save.FileName)) // overwrite if the file is exisiting
{
File.Delete(save.FileName);
string str = Path.GetFileNameWithoutExtension(save.FileName);
str += "_log.ldf";
string str2 = Path.GetDirectoryName(save.FileName);
File.Delete(str2 + @"\\" + str); // delete the ldf file
}
File.Copy(tempForm.Db.fileName, save.FileName); // copy DB to the new DIR
tempForm.Db.Dispose(true);
tempForm.IsNewDB = false;
tempForm.Filepath = save.FileName; // load the saved Database and bind it to the DGV
tempForm.initalizeDataGrid(tempForm.getDGV());
tempForm.PageEquip.ReCount();
tempForm.PageEquip.loadPage();
}
catch (Exception)
{
MessageBox.Show("Failed to Save file, are you trying to overwrite a locked DB?", "Saving Failed", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
catch (Exception)
{ }
}
