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);
}
