private void LoadFile()
{
Cursor.Current = Cursors.WaitCursor;
string invfile = "invfiles/" + mclsBranchDetails.BranchCode + ".inv"; //mclsInvLog.LogFile;
if (!System.IO.File.Exists(invfile))
{
Data.BranchDetails clsBranchDetails = mclsBranchDetails;
mclsInvLog = new InvLog();
LoadOptions();
mclsBranchDetails = clsBranchDetails;
cmdBranchSelect.Text = mclsBranchDetails.BranchCode;
}
else if (System.IO.File.Exists(invfile))
{
mdtItems = new System.Data.DataTable("tblInvItems");
mdtItems.Columns.Add("BarCode");
mdtItems.Columns.Add("Quantity");
mdtItems.Columns.Add("Unit");
mdtItems.Columns.Add("Description");
using (var reader = new StreamReader(invfile))
{
string line; int iCtr = 0;
while ((line = reader.ReadLine()) != null)
{
if (iCtr >= 4)
{
string[] item = line.Split('|');
mdtItems.Rows.Add(item[0], item[1], item[2], item[3]);
}
iCtr++;
}
}
dgvItems.MultiSelect = false;
dgvItems.AutoGenerateColumns = true;
dgvItems.AutoSize = true;
dgvItems.ScrollBars = ScrollBars.Vertical;
dgvItems.DataSource = mdtItems.TableName;
dgvItems.DataSource = mdtItems;
dgvItems.Columns["BarCode"].Visible = true;
dgvItems.Columns["Quantity"].Visible = true;
dgvItems.Columns["Unit"].Visible = true;
dgvItems.Columns["Description"].Visible = true;
dgvItems.Columns["BarCode"].HeaderText = "BarCode";
dgvItems.Columns["Quantity"].HeaderText = "Quantity";
dgvItems.Columns["Unit"].HeaderText = "Unit";
dgvItems.Columns["Description"].HeaderText = "Description";
dgvItems.Columns["BarCode"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvItems.Columns["Quantity"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Unit"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvItems.Columns["Description"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvItems.Columns["BarCode"].Width = 230;
dgvItems.Columns["Quantity"].Width = 100;
dgvItems.Columns["Unit"].Width = 100;
dgvItems.Columns["Description"].Width = dgvItems.Width - 450;
dgvItems.Rows[dgvItems.Rows.Count-1].Selected = true;
dgvItems.FirstDisplayedScrollingRowIndex = dgvItems.Rows.Count - 1;
mclsInvLog.LogFile = invfile;
}
Cursor.Current = Cursors.Default;
}
private void LoadFile()
{
Cursor.Current = Cursors.WaitCursor;
string invfile = "invfiles/" + mclsBranchDetails.BranchCode + ".inv"; //mclsInvLog.LogFile;
if (!System.IO.File.Exists(invfile))
{
Data.BranchDetails clsBranchDetails = mclsBranchDetails;
mclsInvLog = new InvLog();
LoadOptions();
mclsBranchDetails = clsBranchDetails;
cmdBranchSelect.Text = mclsBranchDetails.BranchCode;
}
else if (System.IO.File.Exists(invfile))
{
mdtItems = new System.Data.DataTable("tblInvItems");
mdtItems.Columns.Add("BarCode");
mdtItems.Columns.Add("Quantity");
mdtItems.Columns.Add("Unit");
mdtItems.Columns.Add("Description");
using (var reader = new StreamReader(invfile))
{
string line; int iCtr = 0;
while ((line = reader.ReadLine()) != null)
{
if (iCtr >= 4)
{
string[] item = line.Split('|');
mdtItems.Rows.Add(item[0], item[1], item[2], item[3]);
}
iCtr++;
}
}
dgvItems.MultiSelect = false;
dgvItems.AutoGenerateColumns = true;
dgvItems.AutoSize = true;
dgvItems.ScrollBars = ScrollBars.Vertical;
dgvItems.DataSource = mdtItems.TableName;
dgvItems.DataSource = mdtItems;
dgvItems.Columns["BarCode"].Visible = true;
dgvItems.Columns["Quantity"].Visible = true;
dgvItems.Columns["Unit"].Visible = true;
dgvItems.Columns["Description"].Visible = true;
dgvItems.Columns["BarCode"].HeaderText = "BarCode";
dgvItems.Columns["Quantity"].HeaderText = "Quantity";
dgvItems.Columns["Unit"].HeaderText = "Unit";
dgvItems.Columns["Description"].HeaderText = "Description";
dgvItems.Columns["BarCode"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvItems.Columns["Quantity"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Unit"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvItems.Columns["Description"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvItems.Columns["BarCode"].Width = 230;
dgvItems.Columns["Quantity"].Width = 100;
dgvItems.Columns["Unit"].Width = 100;
dgvItems.Columns["Description"].Width = dgvItems.Width - 450;
dgvItems.Rows[dgvItems.Rows.Count - 1].Selected = true;
dgvItems.FirstDisplayedScrollingRowIndex = dgvItems.Rows.Count - 1;
mclsInvLog.LogFile = invfile;
}
Cursor.Current = Cursors.Default;
}
private void Main_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{
switch (e.KeyData)
{
case Keys.F2: // clear inventory file
if (mclsBranchDetails.BranchID == 0)
{
MessageBox.Show("Please select the branch to clear the inventory file.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdBranchSelect.Focus();
return;
}
if (MessageBox.Show("Are you sure you want to clear the inventory file of branch " + mclsBranchDetails.BranchCode + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
Data.BranchDetails clsBranchDetails = mclsBranchDetails;
if (!Directory.Exists("invfiles/backups/")) Directory.CreateDirectory("invfiles/backups/");
System.IO.File.Copy(mclsInvLog.LogFile, "invfiles/backups/" + mclsBranchDetails.BranchCode + "_" + DateTime.Now.ToString("yyyyddMMhhmmss") + ".inv");
System.IO.File.Delete(mclsInvLog.LogFile);
mclsInvLog = new InvLog();
LoadOptions();
LoadFile();
mclsBranchDetails = clsBranchDetails;
cmdBranchSelect.Text = mclsBranchDetails.BranchCode;
}
break;
case Keys.F3:
LogInWnd login = new LogInWnd();
login.AccessType = AccessTypes.ZeroOutBranchInventory;
login.Header = "Zero Out Inventory of Branch: access validation";
login.ShowDialog(this);
DialogResult loginresult = login.Result;
login.Close();
login.Dispose();
if (loginresult == DialogResult.OK)
{
grpSaveToDB.Visible = false;
if (mclsBranchDetails.BranchID == 0)
{
MessageBox.Show("Please select the branch to zero out the inventory.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdBranchSelect.Focus();
return;
}
if (MessageBox.Show("Are you sure you want to ZERO out the inventory of branch " + mclsBranchDetails.BranchCode + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
grpSaveToDB.Visible = true;
Cursor.Current = Cursors.WaitCursor;
this.bgwZeroOutInv.RunWorkerAsync();
// Wait for the BackgroundWorker to finish the download.
while (this.bgwZeroOutInv.IsBusy)
{
//prgBar.Increment(1);
// Keep UI messages moving, so the form remains
// responsive during the asynchronous operation.
Application.DoEvents();
}
}
}
break;
case Keys.F4:
grpSaveToDB.Visible = false;
if (mclsBranchDetails.BranchID == 0)
{
MessageBox.Show("Please select the branch to upload the inventory.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdBranchSelect.Focus();
return;
}
if (mdtItems == null || mdtItems.Rows.Count == 0)
{
MessageBox.Show("No rows to upload, please make sure the inventory file is loaded.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show("Are you sure you want to UPLOAD the inventory of branch " + mclsBranchDetails.BranchCode + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
grpSaveToDB.Visible = true;
Cursor.Current = Cursors.WaitCursor;
this.bgwSavetoDB.RunWorkerAsync();
// Wait for the BackgroundWorker to finish the download.
while (this.bgwSavetoDB.IsBusy)
{
//prgBar.Increment(1);
// Keep UI messages moving, so the form remains
// responsive during the asynchronous operation.
Application.DoEvents();
}
}
break;
case Keys.F5:
isLoadInReverse = false;
grpSaveToDB.Visible = false;
if (mclsBranchDetails.BranchID == 0)
{
MessageBox.Show("Please select the branch to zero out the NEGATIVE inventory.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdBranchSelect.Focus();
return;
}
if (MessageBox.Show("Are you sure you want to ZERO out the NEGATIVE inventory of branch " + mclsBranchDetails.BranchCode + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
grpSaveToDB.Visible = true;
Cursor.Current = Cursors.WaitCursor;
this.bgwZeroOutInvNeg.RunWorkerAsync();
// Wait for the BackgroundWorker to finish the download.
while (this.bgwZeroOutInvNeg.IsBusy)
{
//prgBar.Increment(1);
// Keep UI messages moving, so the form remains
// responsive during the asynchronous operation.
Application.DoEvents();
}
}
break;
case Keys.F7:
isLoadInReverse = true;
grpSaveToDB.Visible = false;
if (mclsBranchDetails.BranchID == 0)
{
MessageBox.Show("Please select the branch to upload the inventory.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdBranchSelect.Focus();
return;
}
if (mdtItems == null || mdtItems.Rows.Count == 0)
{
MessageBox.Show("No rows to upload, please make sure the inventory file is loaded.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show("Are you sure you want to UPLOAD the inventory of branch " + mclsBranchDetails.BranchCode + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
grpSaveToDB.Visible = true;
Cursor.Current = Cursors.WaitCursor;
this.bgwSavetoDB.RunWorkerAsync();
// Wait for the BackgroundWorker to finish the download.
while (this.bgwSavetoDB.IsBusy)
{
//prgBar.Increment(1);
// Keep UI messages moving, so the form remains
// responsive during the asynchronous operation.
Application.DoEvents();
}
}
break;
case Keys.Escape:
if (MessageBox.Show("Are you sure you want to exit?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
Application.Exit();
}
break;
}
}
private void Main_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{
switch (e.KeyData)
{
case Keys.F2: // clear inventory file
if (mclsBranchDetails.BranchID == 0)
{
MessageBox.Show("Please select the branch to clear the inventory file.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdBranchSelect.Focus();
return;
}
if (MessageBox.Show("Are you sure you want to clear the inventory file of branch " + mclsBranchDetails.BranchCode + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
Data.BranchDetails clsBranchDetails = mclsBranchDetails;
if (!Directory.Exists("invfiles/backups/"))
{
Directory.CreateDirectory("invfiles/backups/");
}
System.IO.File.Copy(mclsInvLog.LogFile, "invfiles/backups/" + mclsBranchDetails.BranchCode + "_" + DateTime.Now.ToString("yyyyddMMhhmmss") + ".inv");
System.IO.File.Delete(mclsInvLog.LogFile);
mclsInvLog = new InvLog();
LoadOptions();
LoadFile();
mclsBranchDetails = clsBranchDetails;
cmdBranchSelect.Text = mclsBranchDetails.BranchCode;
}
break;
case Keys.F3:
LogInWnd login = new LogInWnd();
login.AccessType = AccessTypes.ZeroOutBranchInventory;
login.Header = "Zero Out Inventory of Branch: access validation";
login.ShowDialog(this);
DialogResult loginresult = login.Result;
login.Close();
login.Dispose();
if (loginresult == DialogResult.OK)
{
grpSaveToDB.Visible = false;
if (mclsBranchDetails.BranchID == 0)
{
MessageBox.Show("Please select the branch to zero out the inventory.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdBranchSelect.Focus();
return;
}
if (MessageBox.Show("Are you sure you want to ZERO out the inventory of branch " + mclsBranchDetails.BranchCode + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
grpSaveToDB.Visible = true;
Cursor.Current = Cursors.WaitCursor;
this.bgwZeroOutInv.RunWorkerAsync();
// Wait for the BackgroundWorker to finish the download.
while (this.bgwZeroOutInv.IsBusy)
{
//prgBar.Increment(1);
// Keep UI messages moving, so the form remains
// responsive during the asynchronous operation.
Application.DoEvents();
}
}
}
break;
case Keys.F4:
grpSaveToDB.Visible = false;
if (mclsBranchDetails.BranchID == 0)
{
MessageBox.Show("Please select the branch to upload the inventory.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdBranchSelect.Focus();
return;
}
if (mdtItems == null || mdtItems.Rows.Count == 0)
{
MessageBox.Show("No rows to upload, please make sure the inventory file is loaded.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show("Are you sure you want to UPLOAD the inventory of branch " + mclsBranchDetails.BranchCode + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
grpSaveToDB.Visible = true;
Cursor.Current = Cursors.WaitCursor;
this.bgwSavetoDB.RunWorkerAsync();
// Wait for the BackgroundWorker to finish the download.
while (this.bgwSavetoDB.IsBusy)
{
//prgBar.Increment(1);
// Keep UI messages moving, so the form remains
// responsive during the asynchronous operation.
Application.DoEvents();
}
}
break;
case Keys.F5:
isLoadInReverse = false;
grpSaveToDB.Visible = false;
if (mclsBranchDetails.BranchID == 0)
{
MessageBox.Show("Please select the branch to zero out the NEGATIVE inventory.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdBranchSelect.Focus();
return;
}
if (MessageBox.Show("Are you sure you want to ZERO out the NEGATIVE inventory of branch " + mclsBranchDetails.BranchCode + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
grpSaveToDB.Visible = true;
Cursor.Current = Cursors.WaitCursor;
this.bgwZeroOutInvNeg.RunWorkerAsync();
// Wait for the BackgroundWorker to finish the download.
while (this.bgwZeroOutInvNeg.IsBusy)
{
//prgBar.Increment(1);
// Keep UI messages moving, so the form remains
// responsive during the asynchronous operation.
Application.DoEvents();
}
}
break;
case Keys.F7:
isLoadInReverse = true;
grpSaveToDB.Visible = false;
if (mclsBranchDetails.BranchID == 0)
{
MessageBox.Show("Please select the branch to upload the inventory.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdBranchSelect.Focus();
return;
}
if (mdtItems == null || mdtItems.Rows.Count == 0)
{
MessageBox.Show("No rows to upload, please make sure the inventory file is loaded.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show("Are you sure you want to UPLOAD the inventory of branch " + mclsBranchDetails.BranchCode + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
grpSaveToDB.Visible = true;
Cursor.Current = Cursors.WaitCursor;
this.bgwSavetoDB.RunWorkerAsync();
// Wait for the BackgroundWorker to finish the download.
while (this.bgwSavetoDB.IsBusy)
{
//prgBar.Increment(1);
// Keep UI messages moving, so the form remains
// responsive during the asynchronous operation.
Application.DoEvents();
}
}
break;
case Keys.Escape:
if (MessageBox.Show("Are you sure you want to exit?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
Application.Exit();
}
break;
}
}