public static List <ORDERDETAILS> Get(int orderNum) { ORDERDETAILS orderdetail = null; List <ORDERDETAILS> orderdetails = new List <ORDERDETAILS>(); try { using (OracleConnection con = new OracleConnection(conlink)) { if (con.State == ConnectionState.Closed) { con.Open(); } string query = "SELECT * FROM ORDERDETAILS WHERE ORDERNUM = " + orderNum; OracleCommand cmd = new OracleCommand(query, con); OracleDataReader reader = cmd.ExecuteReader(); if (reader != null) { if (reader.HasRows) { while (reader.Read()) { orderdetail = new ORDERDETAILS() { ORDERNUM = int.Parse(reader["ORDERNUM"].ToString()), DETAILNO = int.Parse(reader["DETAILNO"].ToString()), PRODUCTNO = int.Parse(reader["PRODUCTNO"].ToString()), PRODUCTTOTAL = int.Parse(reader["PRODUCTTOTAL"].ToString()), QUANTITY = int.Parse(reader["QUANTITY"].ToString()) }; orderdetails.Add(orderdetail); } reader.Close(); } } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw ex; } return(orderdetails); }
public static bool InsertOrderDetails(ORDERDETAILS detail) { bool status = false; try { using (OracleConnection connection = new OracleConnection(conlink)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } string query = "INSERT INTO ORDERDETAILS (ORDERNUM,PRODUCTNO,QUANTITY,PRODUCTTOTAL) " + "VALUES (:email,:password,:fname,:lname)"; OracleCommand cmd = new OracleCommand(query, connection); cmd.Parameters.Add(new OracleParameter(":email", detail.ORDERNUM)); cmd.Parameters.Add(new OracleParameter(":password", detail.PRODUCTNO)); cmd.Parameters.Add(new OracleParameter(":fname", detail.QUANTITY)); cmd.Parameters.Add(new OracleParameter(":lname", detail.PRODUCTTOTAL)); cmd.ExecuteNonQuery(); if (connection.State == ConnectionState.Open) { connection.Close(); } status = true; } } catch (Exception ex) { throw ex; } return(status); }
//4 insert customer public static bool InsertOrderDetails(ORDERDETAILS details) => ORDERDETAILSDAL.InsertOrderDetails(details);
// POST: api/OrderDetails public bool Post([FromBody] ORDERDETAILS details) => OrderDetailsBLL.InsertOrderDetails(details);