private void btnAddProductClicked(object sender, EventArgs e)
{
//Initialisation du dateset des produits
DataSetProducts dataSetProducts = new DataSetProducts();
DataSetProductsTableAdapters.EATFAST_PRODUCTTableAdapter productTableAdapter =
new DataSetProductsTableAdapters.EATFAST_PRODUCTTableAdapter();
productTableAdapter.Fill(dataSetProducts.EATFAST_PRODUCT);
try
{
//Insertion dans la bdd
productTableAdapter.AddProduct(textBoxName.Text, textBoxDescription.Text, "null",
(decimal)float.Parse(textBoxPrice.Text),
comboBoxCategory.GetItemText(comboBoxCategory.SelectedItem));
MessageBox.Show("New product added!");
//Mise à jour du dataGridView dans le form
adminHomepage.UpdateProductsDataGridView();
ResetProductInfo();
} catch (Exception o)
{
MessageBox.Show("Something went wrong, please try again");
Console.Write("Exception thrown : ");
Console.Write("{0}", o.GetType(), o.Message);
}
}
private void GetData()
{
var sw = new System.Diagnostics.Stopwatch();
sw.Start();
if (!isNew)
{
CdbcConnection con = UtilCommon.getConnection();
string cmdQuery = "SELECT P.PRODUCT_CODE "
+ " , P.PRODUCT_NAME "
+ " , P.PRODUCT_PRICE "
+ " , P.CURRENCY_CODE "
+ " , P.PRODUCT_SUMMARY "
+ " , P.CATEGORY_CODE "
+ " , P.PRODUCT_IMAGE "
+ " , P.RELEASE_DATE "
+ " FROM PRODUCTS P "
+ " WHERE P.PRODUCT_CODE = :PRODUCT_CODE ";
CdbcCommand cmd = new CdbcCommand(cmdQuery);
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
CdbcParameter para = new CdbcParameter(":PRODUCT_CODE", Cdbc.Common.Data.Type.CdbcOracleDbType.Varchar2);
para.Value = ProductCode;
cmd.Parameters.Add(para);
DataSetProducts dsProduct = new DataSetProducts();
CdbcDataAdapter myDa = new CdbcDataAdapter(cmd);
try
{
myDa.Fill(dsProduct, dsProduct.PRODUCTS.TableName);
if (dsProduct.Tables.Count > 0 && dsProduct.Tables[0].Rows.Count > 0)
{
DataSetProducts.PRODUCTSRow dr = (DataSetProducts.PRODUCTSRow)dsProduct.PRODUCTS.Rows[0];
txtProductName.Text = UtilCommon.NvlStr(dr.PRODUCT_NAME);
txtPrice.Text = UtilCommon.NvlStr(dr.PRODUCT_PRICE);
cbCurrency.SelectedValue = UtilCommon.NvlStr(dr.CURRENCY_CODE);
txtSummary.Text = UtilCommon.NvlStr(dr.PRODUCT_SUMMARY);
cbCategory.SelectedValue = UtilCommon.NvlStr(dr.CATEGORY_CODE);
dtReleaseDate.Value = dr.RELEASE_DATE;
pictureBox1.Image = UtilCommon.ByteArrayToImage(dr.PRODUCT_IMAGE);
}
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message,
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error)
;
}
}
sw.Stop();
this.Text = $"{sw.ElapsedMilliseconds} ms";
}
private void getCategoryCurrencyList()
{
CdbcConnection con = UtilCommon.getConnection();
CdbcDataAdapter dataAdapter = new CdbcDataAdapter();
//CATEGORIES
string cmdQuery = "SELECT C.CATEGORY_CODE "
+ " , C.CATEGORY_NAME "
+ " FROM CATEGORIES C "
+ " ORDER BY C.CATEGORY_CODE";
CdbcCommand cmd = new CdbcCommand(cmdQuery, con);
dataAdapter.AddMultiSelectCommand(cmd, dsCategoriesCurrencies.CATEGORIES.TableName);
//CURRENCIES
cmdQuery = "SELECT C.CURRENCY_CODE "
+ " , C.CURRENCY_SYMBOL "
+ " FROM CURRENCIES C "
+ " ORDER BY C.CURRENCY_CODE";
cmd = new CdbcCommand(cmdQuery, con);
dataAdapter.AddMultiSelectCommand(cmd, dsCategoriesCurrencies.CURRENCIES.TableName);
try
{
dsCategoriesCurrencies = new DataSetProducts();
int[] fillResult = dataAdapter.MultiFill(dsCategoriesCurrencies);
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message,
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error)
;
}
}
