bool AddAllItems()
{
bool bAllok = true;
int nofItemsOK = 0;
int nOfItems = dGrid.Rows.Count;
for (int i = nOfItems - 1; i >= 0; i -= 1)
{
if (!CheckRow(i))
{
bAllok = false;
}
else
{
nofItemsOK++;
}
}
if (bAllok)
{
frmProgressBar fp = new frmProgressBar("Loading Items");
fp.pb.Maximum = nofItemsOK;
fp.Show();
sEngine.AllowDatabaseSaves = false;
for (int i = 0; i < nofItemsOK; i++)
{
//string[] sNames = { "Barcode", "Description", "Type", "Category", "RRP", "VAT", "Minimum Quantity", "Supplier Code", "Cost", "Product Code" };
bool bExists = false;
for (int x = 0; x < sModifiedCodes.Count; x++)
{
if (sModifiedCodes[x] == dGrid.Rows[i].Cells[0].Value.ToString())
{
bExists = true;
break;
}
}
if (bExists)
{
//string[] sNames = { "Barcode", "Description", "Type", "Category", "RRP", "VAT", "Minimum Quantity", "QIS", "Supplier Code", "Cost", "Product Code", "Parent Code", "Qty/Parent" };
string sAverageCost = sEngine.GetItemAverageCost(dGrid.Rows[i].Cells[0].Value.ToString()).ToString();
AddItem(dGrid.Rows[i].Cells[2].Value.ToString(), dGrid.Rows[i].Cells[0].Value.ToString(), dGrid.Rows[i].Cells[1].Value.ToString(), dGrid.Rows[i].Cells[3].Value.ToString(), dGrid.Rows[i].Cells[4].Value.ToString(), dGrid.Rows[i].Cells[5].Value.ToString(),
dGrid.Rows[i].Cells[6].Value.ToString(), Convert.ToDecimal(dGrid.Rows[i].Cells[9].Value.ToString()), Convert.ToDecimal(dGrid.Rows[i].Cells[7].Value.ToString()), dGrid.Rows[i].Cells[11].Value.ToString(), Convert.ToDecimal(dGrid.Rows[i].Cells[12].Value.ToString()),
dGrid.Rows[i].Cells[8].Value.ToString(), Convert.ToDecimal(dGrid.Rows[i].Cells[9].Value.ToString()), dGrid.Rows[i].Cells[10].Value.ToString(), sAverageCost);
}
fp.pb.Value = i;
if (i == nofItemsOK - 1)
{
sEngine.AllowDatabaseSaves = true;
sEngine.SaveStockDatabases();
}
}
fp.Close();
if (MessageBox.Show("Upload changes to all tills now?", "Upload", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
sEngine.CopyWaitingFilesToTills();
}
}
return(bAllok);
}
public frmListOfSales(ref StockEngine sEngine, string sBarcode)
{
this.sEngine = sEngine;
this.AllowScaling = false;
this.sBarcode = sBarcode;
this.FormBorderStyle = FormBorderStyle.FixedToolWindow;
this.Size = new System.Drawing.Size(275, 420);
this.SurroundListBoxes = true;
AddMessage("INST", "Sales Date - Transaction Number", new System.Drawing.Point(10, 10));
lbSales = new CListBox();
lbSales.Location = new System.Drawing.Point(10, BelowLastControl);
lbSales.Size = new System.Drawing.Size(this.ClientSize.Width - 20, 300);
lbSales.BorderStyle = BorderStyle.None;
this.Controls.Add(lbSales);
AddMessage("NOTE", "Only sales before this week are shown", new System.Drawing.Point(10, 340));
AddMessage("NOTE2", "Press Enter to view the transaction", new System.Drawing.Point(10, 360));
sTranNo = new string[0];
sSalesDate = sEngine.GetWeeksOfItemSold(sBarcode, ref sTranNo);
frmProgressBar fp = new frmProgressBar("Getting Sales Dates");
fp.pb.Maximum = sSalesDate.Length;
fp.Show();
for (int i = 0; i < sSalesDate.Length; i++)
{
fp.pb.Value = i;
string sDay = sEngine.WorkOutDateOfSale(sTranNo[i], sSalesDate[i]);
BackOffice.Database_Engine.Table t = new BackOffice.Database_Engine.Table("Archive\\Weekly\\" + sSalesDate[i] + "\\TILL1\\INGNG\\REPDATA" + sDay + ".DBF");
string sDate = t.GetRecordFrom(0)[1];
lbSales.Items.Add(sDate + " - " + sTranNo[i]);
}
if (lbSales.Items.Count > 0)
{
lbSales.SelectedIndex = 0;
}
fp.Close();
lbSales.KeyDown += new KeyEventHandler(lbSales_KeyDown);
}
/// <summary>
/// Compresses the whole archive
/// </summary>
public static void CompressWholeArchive()
{
frmProgressBar fp = new frmProgressBar("Compressing Archive");
string[] periods = { "Daily", "Weekly", "Monthly", "Yearly" };
fp.Show();
foreach (string period in periods)
{
string[] dirs = Directory.GetDirectories("Archive\\" + period);
fp.pb.Value = 0;
fp.pb.Maximum = dirs.Length;
foreach (string dir in dirs)
{
fp.pb.Value++;
fp.Text = "Compressing " + dir;
CompressArchiveDirectory(dir + "\\");
}
}
fp.Close();
}
private void LoadInData(string[] sDirsToUse)
{
frmProgressBar fp = new frmProgressBar("Loading Data");
fp.pb.Maximum = sDirsToUse.Length;
fp.pb.Value = 0;
Form f = new Form();
f.WindowState = FormWindowState.Maximized;
PictureBox pb = new PictureBox();
f.Controls.Add(pb);
f.Show();
fp.Show();
pb.Size = f.Size;
pb.SizeMode = PictureBoxSizeMode.Zoom;
for (int i = 0; i < sDirsToUse.Length; i++)
{
fp.pb.Value = i;
using (Table tStockSta = new Table(sWorkingDir + "\\" + sDirsToUse[i] + "\\STOCKSTA.DBF"))
{
for (int x = 0; x < gItem.Length; x++)
{
if (gItem[x].ItemType == GraphItem.Type.Barcode || gItem[x].ItemType == GraphItem.Type.Category)
{
gItem[x].ReceiveStockStaTable(tStockSta, sWorkingDir + "\\" + sDirsToUse[i]);
}
}
}
if (i >= 1)
{
CalculateAxesScale();
DrawAxes();
DrawGraph();
SaveImage(i.ToString());
pb.Image = Image.FromFile("GraphImages\\Graph Stage " + i.ToString() + ".bmp");
Application.DoEvents();
}
}
fp.Close();
}
/// <summary>
/// Backs up the current databases to a USB (or otherwise connected) drive
/// </summary>
public static void BackupToUSBPen(string CompanyName)
{
bool bFound = false;
for (int i = 67; i < 84; i++)
{
if (Directory.Exists(((char)i).ToString() + ":\\BACKUP"))
{
frmProgressBar fp = new frmProgressBar("Copying Tables");
fp.pb.Maximum = 24;
fp.pb.Value = 0;
fp.Show();
if (!Directory.Exists(((char)i).ToString() + ":\\BACKUP\\" + CompanyName))
{
Directory.CreateDirectory(((char)i).ToString() + ":\\BACKUP\\" + CompanyName);
}
string sSaveLoc = ((char)i).ToString() + ":\\BACKUP\\" + CompanyName + "\\";
File.Copy("ACCSTAT.DBF", sSaveLoc + "ACCSTAT.DBF", true);
fp.pb.Value = 1;
File.Copy("CATEGORY.DBF", sSaveLoc + "CATEGORY.DBF", true);
fp.pb.Value = 2;
File.Copy("CATGRPDA.DBF", sSaveLoc + "CATGRPDA.DBF", true);
fp.pb.Value = 3;
File.Copy("CATGPHDR.DBF", sSaveLoc + "CATGPHDR.DBF", true);
fp.pb.Value = 4;
File.Copy("COMMPPL.DBF", sSaveLoc + "COMMPPL.DBF", true);
fp.pb.Value = 6;
File.Copy("COMMITEM.DBF", sSaveLoc + "COMMITEM.DBF", true);
fp.pb.Value = 7;
//tCustomer.SaveToFile(sSaveLoc + "CUSTOMER.DBF");
File.Copy("EMAILS.DBF", sSaveLoc + "EMAILS.DBF", true);
fp.pb.Value = 8;
File.Copy("MULTIDAT.DBF", sSaveLoc + "MULTIDAT.DBF", true);
fp.pb.Value = 9;
File.Copy("MULTIHDR.DBF", sSaveLoc + "MULTIHDR.DBF", true);
fp.pb.Value = 10;
File.Copy("ORDER.DBF", sSaveLoc + "ORDER.DBF", true);
fp.pb.Value = 11;
File.Copy("ORDERLIN.DBF", sSaveLoc + "ORDERLIN.DBF", true);
fp.pb.Value = 12;
File.Copy("ORDERSUG.DBF", sSaveLoc + "ORDERSUG.DBF", true);
fp.pb.Value = 13;
File.Copy("SETTINGS.DBF", sSaveLoc + "SETTINGS.DBF", true);
fp.pb.Value = 14;
File.Copy("SHOP.DBF", sSaveLoc + "SHOP.DBF", true);
fp.pb.Value = 15;
File.Copy("STAFF.DBF", sSaveLoc + "STAFF.DBF", true);
fp.pb.Value = 16;
File.Copy("MAINSTOC.DBF", sSaveLoc + "MAINSTOC.DBF", true);
fp.pb.Value = 17;
File.Copy("STOCKSTA.DBF", sSaveLoc + "STOCKSTA.DBF", true);
fp.pb.Value = 18;
File.Copy("SUPPLIER.DBF", sSaveLoc + "SUPPLIER.DBF", true);
fp.pb.Value = 19;
File.Copy("SUPINDEX.DBF", sSaveLoc + "SUPINDEX.DBF", true);
fp.pb.Value = 20;
File.Copy("TILL.DBF", sSaveLoc + "TILL.DBF", true);
fp.pb.Value = 21;
File.Copy("TOTSALES.DBF", sSaveLoc + "TOTSALES.DBF", true);
fp.pb.Value = 22;
File.Copy("VAT.DBF", sSaveLoc + "VAT.DBF", true);
fp.pb.Value = 23;
File.Copy("STOCKLEN.DBF", sSaveLoc + "STOCKLEN.DBF", true);
fp.pb.Value = 24;
bFound = true;
fp.Close();
break;
}
}
if (!bFound)
{
System.Windows.Forms.MessageBox.Show("Could not find the USB pen drive! Please make sure it is inserted and has a folder called BACKUP");
}
else
{
System.Windows.Forms.MessageBox.Show("Backed up OK!");
}
}