public OrderedProduct GetOrderedProductInfo(int transactionid) { OrderedProduct op = new OrderedProduct(); try { _conn.Open(); _dataAdapter = new MySqlDataAdapter("SELECT * FROM orderedproducts WHERE ordernum=?ordernum;", _conn); _dataAdapter.SelectCommand.Parameters.AddWithValue("?ordernum", transactionid); _dTable = new DataTable(); _dataAdapter.Fill(_dTable); op.OrderProdId = Int32.Parse(_dTable.Rows[0]["orderprodid"].ToString()); op.TransactionId = Int32.Parse(_dTable.Rows[0]["ordernum"].ToString()); op.ClothType = _dTable.Rows[0]["clothtype"].ToString(); op.Details = _dTable.Rows[0]["details"].ToString(); op.Chest = Double.Parse(_dTable.Rows[0]["chest"].ToString()); op.Waist = Double.Parse(_dTable.Rows[0]["waist"].ToString()); op.Length = Double.Parse(_dTable.Rows[0]["overall_length"].ToString()); } catch (Exception e) { //MessageBox.Show("Product does not exist."); //Trace.WriteLine("Error:" + e.Message); } finally { _conn.Close(); } return(op); }
public OrderedProduct GetProductOfTransId(int transactionid) { OrderedProduct op = new OrderedProduct(); try { _conn.Open(); string stmt = "SELECT clothtype as 'Cloth', details as 'Details', chest as 'Chest', waist as 'Waist', overall_length as 'Length' "; stmt += "FROM orderedproducts WHERE ordernum=?ordernum;"; _dataAdapter = new MySqlDataAdapter(stmt, _conn); _dataAdapter.SelectCommand.Parameters.AddWithValue("?ordernum", transactionid); _dTable = new DataTable(); _dataAdapter.Fill(_dTable); op.ClothType = _dTable.Rows[0]["Cloth"].ToString(); op.Details = _dTable.Rows[0]["Details"].ToString(); op.Chest = Double.Parse(_dTable.Rows[0]["Chest"].ToString()); op.Waist = Double.Parse(_dTable.Rows[0]["Waist"].ToString()); op.Length = Double.Parse(_dTable.Rows[0]["Length"].ToString()); } catch (Exception e) { //MessageBox.Show("Order Transaction not found."); //Trace.WriteLine("Error:" + e.Message); } finally { _conn.Close(); } return(op); }
public bool UpdateOrderedProductInfo(OrderedProduct op) { bool success = false; try { _conn.Open(); //preparing statement MySqlCommand cmd = new MySqlCommand(); cmd.Connection = _conn; string stmt = "UPDATE orderedproducts SET "; stmt += "clothtype=?clothtype,"; stmt += "details=?details,"; stmt += "chest=?chest,"; stmt += "waist=?waist,"; stmt += "overall_length=?length "; stmt += "WHERE ordernum=?ordernum;"; cmd.CommandText = stmt; cmd.Prepare(); //binding parameters cmd.Parameters.AddWithValue("?ordernum", op.TransactionId); cmd.Parameters.AddWithValue("?clothtype", op.ClothType); cmd.Parameters.AddWithValue("?details", op.Details); cmd.Parameters.AddWithValue("?chest", op.Chest); cmd.Parameters.AddWithValue("?waist", op.Waist); cmd.Parameters.AddWithValue("?length", op.Length); cmd.ExecuteNonQuery(); success = true; //MessageBox.Show("Updated Successfully!"); } catch (MySqlException ex) { //Trace.WriteLine("Error: {0}", ex.ToString()); //MessageBox.Show("Error occurred in updating the product."); } finally { _conn.Close(); } return(success); }
public bool SaveOrderedProductInfo(OrderedProduct op) { bool success = false; try { _conn.Open(); //preparing statement MySqlCommand cmd = new MySqlCommand(); cmd.Connection = _conn; string stmt = "INSERT INTO orderedproducts(ordernum,clothtype,details,chest,waist,overall_length) "; stmt += "VALUES(?ordernum,?clothtype,?details,?chest,?waist,?length);"; cmd.CommandText = stmt; cmd.Prepare(); //binding parameters cmd.Parameters.AddWithValue("?ordernum", op.TransactionId); cmd.Parameters.AddWithValue("?clothtype", op.ClothType); cmd.Parameters.AddWithValue("?details", op.Details); cmd.Parameters.AddWithValue("?chest", op.Chest); cmd.Parameters.AddWithValue("?waist", op.Waist); cmd.Parameters.AddWithValue("?length", op.Length); cmd.ExecuteNonQuery(); success = true; //MessageBox.Show("Product Added!"); } catch (MySqlException ex) { //Trace.WriteLine("Error: {0}", ex.ToString()); //MessageBox.Show("Error occurred in processing the order."); } finally { _conn.Close(); } return(success); }