public suppliers[] GetSupplierNameOnly() //returns supplier names
{
DataSet ds = new DataSet();
ArrayList sup = new ArrayList();
string cmdStr = "Select Name From [suppliers]";
using (OleDbCommand command = new OleDbCommand(cmdStr))
{
ds = GetMultipleQuery(command);
}
DataTable dt = new DataTable();
try
{
dt = ds.Tables[0];
}
catch { }
foreach (DataRow tType in dt.Rows)
{
suppliers Name = new suppliers();
Name.Sup_name = tType[0].ToString();
sup.Add(Name);
}
return((suppliers[])sup.ToArray(typeof(suppliers)));
}
public suppliers[] getAllsuppliers() //returns all the suppliers in the table
{
DataSet ds = new DataSet();
ArrayList supparr = new ArrayList();
string cmdStr = "SELECT * FROM suppliers";
using (OleDbCommand command = new OleDbCommand(cmdStr))
{
ds = GetMultipleQuery(command);
}
DataTable dt = new DataTable();
try
{
dt = ds.Tables[0];
}
catch
{
}
foreach (DataRow tType in dt.Rows)
{
suppliers supp = new suppliers();
supp.Supplier_id = int.Parse(tType[0].ToString());
supp.Sup_name = tType[1].ToString();
supp.Address = tType[2].ToString();
supp.Phone = int.Parse(tType[3].ToString());
supp.Email = tType[4].ToString();
supparr.Add(supp);
}
return((suppliers[])supparr.ToArray(typeof(suppliers)));
}
private void btnUpdateSupplier_Click(object sender, EventArgs e) //button to update supplier
{
if (!string.IsNullOrEmpty(txtUpdateSupplierId.Text))
{
suppliers sup = new suppliers();
sup.Sup_name = UpdateSupplierNametxt.Text;
sup.Address = txtUpdateSupplierAddr.Text;
sup.Phone = int.Parse(txtUpdateSupplierPhone.Text);
sup.Supplier_id = int.Parse(txtUpdateSupplierId.Text);
sup.Email = txtUpdateSupplierEmail.Text;
try
{
dataB.UpdateSupplier(sup);
MessageBox.Show("Success the SUPPLIER is Updated");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Supplier ID is empty!! make sure to fill it.");
}
}
public void UpdateSupplier(suppliers sup) //updates supplier in the table
{
string cmdStr = "UPDATE [suppliers] SET name=@Sup_name,address=@Address,phone=@Phone,email=@Email WHERE supplier_id =" + sup.Supplier_id;
using (OleDbCommand command = new OleDbCommand(cmdStr))
{
command.Parameters.AddWithValue("@name", sup.Sup_name);
command.Parameters.AddWithValue("@address", sup.Address);
command.Parameters.AddWithValue("@phone", sup.Phone);
command.Parameters.AddWithValue("@email", sup.Email);
base.ExecuteSimpleQuery(command);
}
}
// ****** SUPPLIERS ******
public void InsertSupplier(suppliers sup) //insert Supplier to the table
{
string cmdStr = "INSERT INTO [suppliers] (name,Address,phone,email) VALUES(@Name,@Address,@phone,@email)";
using (OleDbCommand command = new OleDbCommand(cmdStr))
{
command.Parameters.AddWithValue("@Name", sup.Sup_name);
command.Parameters.AddWithValue("@Address", sup.Address);
command.Parameters.AddWithValue("@phone", sup.Phone);
command.Parameters.AddWithValue("@email", sup.Email);
base.ExecuteSimpleQuery(command);
}
}
private void btnAddSupplier_Click(object sender, EventArgs e) //button to add supplier
{
if (!string.IsNullOrWhiteSpace(AddSupplierAddresstxt.Text) && !string.IsNullOrWhiteSpace(AddSupplierNametxt.Text) && !string.IsNullOrWhiteSpace(supplierphonetxt.Text) && !string.IsNullOrWhiteSpace(supplieremailtxt.Text))
{
suppliers sup = new suppliers();
sup.Address = AddSupplierAddresstxt.Text;
sup.Sup_name = AddSupplierNametxt.Text;
sup.Email = supplieremailtxt.Text;
sup.Phone = int.Parse(supplierphonetxt.Text);
try
{
dataB.InsertSupplier(sup);
MessageBox.Show("The Supplier Have Been Sucessfully Inserted");
}
catch (Exception)
{
MessageBox.Show("Supplier Name Already Exists");
}
}
else
{
MessageBox.Show("One Or More Field Is Empty");
}
}
