public static List <product_suppliers> getProduct_Suppliers(string product_name, string supplier_name)
{
List <product_suppliers> product_supplier_info = new List <product_suppliers>();
SqlConnection connection = connectionDB.GetConnection();
string selectstatement = "select p.ProdName,s.SupName from Products_Suppliers ps " +
"inner join Products p on p.ProductId = ps.ProductId " +
"inner join Suppliers s on s.SupplierId = ps.supplierId " +
"where p.ProdName = @ProdName and s.SupName = @Suppliername";
SqlCommand selectCommand = new SqlCommand(selectstatement, connection);
selectCommand.Parameters.AddWithValue("@ProdName", product_name);
selectCommand.Parameters.AddWithValue("@Suppliername", supplier_name);
try
{
connection.Open();
SqlDataReader reader = selectCommand.ExecuteReader();
while (reader.Read())
{
product_suppliers initialize_info = new product_suppliers();
initialize_info.Productname = reader["ProdName"].ToString();
initialize_info.Suppliername = reader["SupName"].ToString();
product_supplier_info.Add(initialize_info);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(product_supplier_info);
}
private void Btl_Insert_Click(object sender, EventArgs e)
{
if (Insert_GridView.SelectedRows.Count > 0)
{
product_suppliers itemToInsert = (product_suppliers)Insert_GridView.SelectedRows[0].DataBoundItem;
foreach (package_product_supplier element in List_info)
{
if (element.Productname == itemToInsert.Productname && element.suppliername == itemToInsert.Suppliername)
{
MessageBox.Show("this information already exists,Please insert a new value");
}
}
if (Package_Product_SupplierDB.insert_info(InsertName, itemToInsert.Productname, itemToInsert.Suppliername))
{
MessageBox.Show("Sucessfully Inserted");
}
else
{
MessageBox.Show("Insert failure Please contact Administrator");
}
/*
* TravelExperts info = new TravelExperts();
* List_info = Package_Product_SupplierDB.getPackageinfo(InsertName);
* info.DisplayBox_info(List_info);
*/
}
else
{
MessageBox.Show("need to choose a row first");
}
}
private void BtlUpdate_Click(object sender, EventArgs e)
{
if (Insert_GridView.SelectedRows.Count > 0)
{
product_suppliers itemToUpdate = (product_suppliers)Insert_GridView.SelectedRows[0].DataBoundItem;
if (Package_Product_SupplierDB.Update_info(InsertName, selected.Productname, selected.suppliername, itemToUpdate.Productname, itemToUpdate.Suppliername))
{
oldSupplier.Text = itemToUpdate.Suppliername.ToString();
oldProduct.Text = itemToUpdate.Productname.ToString();
MessageBox.Show("Row Updated");
}
else
{
MessageBox.Show("Fail to Update please contact Administrator");
}
//TravelExperts info = new TravelExperts();
//List_info = Package_Product_SupplierDB.getPackageinfo(InsertName);
//info.DisplayBox_info(List_info);
}
else
{
MessageBox.Show("No rows selected.");
}
}