private void LoadPoNumbers()
{
DatabaseController d = new DatabaseController();
mPurchaseOrders = d.GetPurchaseOrders();
for (int i = 0; i < mPurchaseOrders.Count; i++)
{
if (!Fponumber.Items.Contains(mPurchaseOrders[i].OrderNumber))
{
Fponumber.Items.Add(mPurchaseOrders[i].OrderNumber);
}
}
Fponumber.Sorted = true;
}
private void fillColorComboBox()
{
colorcmb.Items.Clear();
DatabaseController dc = new DatabaseController();
List <ColorTable> colors = dc.GetColor();
colors.Sort();
for (int i = 0; i < colors.Count; i++)
{
if (!colorcmb.Items.Contains(colors[i].color))
{
colorcmb.Items.Add(colors[i].color);
}
}
}
private void Fponumber_SelectedIndexChanged(object sender, EventArgs e)
{
Flist.Items.Clear();
for (int i = 0; i < mPurchaseOrders.Count; i++)
{
if (mPurchaseOrders[i].OrderNumber == (string)Fponumber.SelectedItem)
{
Fproject.Text = mPurchaseOrders[i].ProjectName;
Fvendor.Text = mPurchaseOrders[i].Vendor;
Fpurchaser.Text = mPurchaseOrders[i].Purchaser;
Fprojectnumber.Text = mPurchaseOrders[i].JobNumber;
Fdate.Text = mPurchaseOrders[i].OrderDate;
//Fshipto1.Text = mPurchaseOrders[i].ShippingInfo.ShippingName;
//Fshipto2.Text = mPurchaseOrders[i].ShippingInfo.ShippingStreet;
//Fshipto3.Text = mPurchaseOrders[i].ShippingInfo.ShippingLocation;
Fdateeta.Text = mPurchaseOrders[i].DeliveryDate;
Fproject.Text = mPurchaseOrders[i].ProjectName;
Fattn.Text = mPurchaseOrders[i].Attention;
Ftotal.Text = mPurchaseOrders[i].Total.ToString();
Fnote.Text = mPurchaseOrders[i].Note;
DatabaseController d = new DatabaseController();
var ioi = d.GetMaterialItems(mPurchaseOrders[i].OrderNumber);
float total = 0;
for (int j = 0; j < ioi.Count; j++)
{
string s = ioi[j].description;
if (ioi[j].isMaterial)
{
s += "\t|" + ioi[j].quantity + "qty";
s += "\t|" + ioi[j].material;
s += "\t|" + ioi[j].sheetsize;
s += "\t|$" + ioi[j].unit_price + "ea";
s += "\t|" + ioi[j].color;
}
total += ioi[j].total;
Flist.Items.Add(s);
}
Ftotal.Text = "" + total;
//FEditButton.Visible = true;
return;
}
}
}
private void addbtn_Click(object sender, EventArgs e)
{
string type = comboBox1.Text;
string width = TextWidth.Text;
string height = TextHeight.Text;
mDatabaseController = new DatabaseController();
List <MaterialTable> mats = mDatabaseController.GetMaterial();
for (int i = 0; i < mats.Count; i++)
{
if (mats[i].material_type.ToLower() == type.ToLower())
{
MessageBox.Show("The database already contains '" + type + "' and blocked the duplicate entry.", "Duplicate Object Blocked");
return;
}
}
Submit(type, width, height);
this.Close();
}
public AddGaugeForm()
{
InitializeComponent();
connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=N:\Receiving and current inventory\Inventory.mdb; Persist Security Info=False;";
DatabaseController databaseController = new DatabaseController();
// fill colors
List <ThicknessTable> gaugetypes = databaseController.GetThickness();
List <string> TypeList = new List <string>();
for (int i = 0; i < gaugetypes.Count; i++)
{
string type = gaugetypes[i].type;
if (!TypeList.Contains(type))
{
TypeList.Add(type);
labelcmb.Items.Add(type);
}
}
labelcmb.Sorted = true;
}
