private void frmChooseSupplier_Load(object sender, EventArgs e)
{
ClassLibrary.SupplierPart supplierpart = new ClassLibrary.SupplierPart();
supplierpart.PartId = partId;
dtSuppliers = supplierpart.GetSupplierPartsByPartId().Tables[0];
comboBox1.DataSource = dtSuppliers;
comboBox1.DisplayMember = "SUPPLIER_name";
}
//-----------------------------------------------------------------------------------------------
private void frmAddSupplier_Load(object sender, EventArgs e)
{
//make parts list
parts = new BindingList <PartList>();
//add parts to the combobox
ClassLibrary.Part part = new ClassLibrary.Part();
dtPart = part.GetAll().Tables[0];
if (drSupllier == null)
{
}
else
{
txtName.Text = drSupllier.ItemArray[1].ToString();
txtFailiureRate.Text = drSupllier.ItemArray[2].ToString();
txtPhone.Text = drSupllier.ItemArray[3].ToString();
txtEmail.Text = drSupllier.ItemArray[4].ToString();
txtAddress.Text = drSupllier.ItemArray[5].ToString();
txtPostalCode.Text = drSupllier.ItemArray[6].ToString();
txtProvince.Text = drSupllier.ItemArray[6].ToString();
ClassLibrary.SupplierPart supplierpart = new ClassLibrary.SupplierPart();
supplierpart.SupplierId = Convert.ToInt32(drSupllier.ItemArray[0]);
DataTable thisTable = supplierpart.GetSupplierPartsBySupplierId().Tables[0];
foreach (DataRow row in thisTable.Rows)
{
//add to generic list
parts.Add(new PartList
{
partID = Convert.ToInt32(row.ItemArray[0]),
partName = row.ItemArray[1].ToString(),
price = Convert.ToInt32(row.ItemArray[2]),
});
}
dataGridView1.DataSource = parts;
}
}
//-------------------------------------------------------------------------------------------------
private void frmAddPart_Load(object sender, EventArgs e)
{
supplerlist = new BindingList <SupplierList>();
//add parts to the combobox
ClassLibrary.Supplier supplier = new ClassLibrary.Supplier();
dtSupplier = supplier.GetAll().Tables[0];
cmbSuppliers.DataSource = dtSupplier;
cmbSuppliers.DisplayMember = "SUPPLIER_name";
if (drRow == null)
{
}
else
{
txtName.Text = drRow.ItemArray[1].ToString();
txtColor.Text = drRow.ItemArray[2].ToString();
ClassLibrary.SupplierPart supplierpart = new ClassLibrary.SupplierPart();
supplierpart.PartId = Convert.ToInt32(drRow.ItemArray[0]);
DataTable thisTable = supplierpart.GetSupplierPartsByPartId().Tables[0];
foreach (DataRow row in thisTable.Rows)
{
//add to generic list
supplerlist.Add(new SupplierList
{
SupplierID = Convert.ToInt32(row.ItemArray[0]),
SupplierName = row.ItemArray[1].ToString(),
price = String.Format("{0:c}", row.ItemArray[2]),
});
}
dataGridView1.DataSource = supplerlist;
}
}
//-------------------------------------------------------------------------------------------------
private void btnSaveToDatabase_Click(object sender, EventArgs e)
{
if (
(txtName.Text == "")
)
{
MessageBox.Show("please fill all the empty fields");
}
else
{
try
{
//ADD MODE
if (drRow == null)
{
ClassLibrary.Part part = new ClassLibrary.Part();
part.Name = txtName.Text;
part.Color = txtColor.Text;
int lastInsertedId = part.Add();
//add Suppliers
ClassLibrary.SupplierPart supplierPart = new ClassLibrary.SupplierPart();
supplierPart.PartId = lastInsertedId;
foreach (SupplierList s in supplerlist)
{
supplierPart.SupplierId = s.SupplierID;
supplierPart.Price = Convert.ToDecimal(s.price.Replace("$", ""));
supplierPart.Add();
}
}
//EDIT MODE
else if (drRow != null)
{
ClassLibrary.Part part = new ClassLibrary.Part();
part.Id = Convert.ToInt32(drRow.ItemArray[0]);
part.Name = txtName.Text;
part.Color = txtColor.Text;
part.Update();
//save supplier list to the database
ClassLibrary.SupplierPart supplierPart = new ClassLibrary.SupplierPart();
supplierPart.PartId = part.Id;
supplierPart.DeleteSupplierPartsByPartId();
foreach (SupplierList s in supplerlist)
{
supplierPart.SupplierId = s.SupplierID;
supplierPart.Price = Convert.ToDecimal(s.price.Replace("$", ""));
supplierPart.Add();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
if (formDisSupplierOrder != null)
{
//formDisSupplierOrder.DisplayOrderParts();
}
else
{
frmDisParts.DisplayAllParts();
}
Close();
}
}
