//read an order in DB public List<Order> ReadOrder(int phoneNo) { Order ord = null; SqlDataReader reader = null; List<Order> ordList = new List<Order>(); try { dbConn.Open(); SqlCommand command = new SqlCommand(("SELECT * FROM CinemaOrder WHERE (@CosPhoneNo) = (CosPhoneNo)"), dbConn); command.Parameters.Add("@CosPhoneNo", SqlDbType.Int).Value = ord.phoneNo; reader = command.ExecuteReader(); while (reader.Read()) { ord = new Order((int)reader["CosPhoneNo"], (string)reader["date"], (int)reader["time"], (Screen)reader["screenNo"], (int)reader["seatAmount"], (double)reader["price"], (Person)reader["empId"], (Costumer)reader["cosId"], (Costumer)reader["phoneNo"]); ordList.Add(ord); } } catch (Exception) { throw; } finally { reader.Close(); dbConn.Close(); } return ordList; }
//method to create order in db internal int InsertOrder(Order ord) { int result = 0; try { dbConn.Open(); SqlCommand command = new SqlCommand(("INSERT INTO CinemaOrder (movTitle, movDate, movTime, ScreenNo, SeatAmount, movPrice, EmpId, CosId, SeatNo, RowNo, CosPhoneNo) VALUES ((@movTitle), (@movDate), (@movTime), (@ScreenNo), (@SeatAmount), (@movPrice), (@EmpId), (@SeatNo), (@RowNo), (@CosPhoneNo))"), dbConn); command.Parameters.Add("@movTitle", SqlDbType.VarChar).Value = ord.title; command.Parameters.Add("@movDate", SqlDbType.Int).Value = ord.date; command.Parameters.Add("@movTime", SqlDbType.Int).Value = ord.time; command.Parameters.Add("@ScreenNo", SqlDbType.Int).Value = ord.screenNo; command.Parameters.Add("@SeatAmount", SqlDbType.Int).Value = ord.seatAmount; command.Parameters.Add("@movPrice", SqlDbType.Int).Value = ord.price; command.Parameters.Add("@EmpId", SqlDbType.Int).Value = ord.empId; command.Parameters.Add("@CosId", SqlDbType.Int).Value = ord.cosId; command.Parameters.Add("@SeatNo", SqlDbType.Int).Value = ord.seatNo; command.Parameters.Add("@RowNo", SqlDbType.Int).Value = ord.rowNo; command.Parameters.Add("@CosPhoneNo", SqlDbType.Int).Value = ord.phoneNo; result = command.ExecuteNonQuery(); } catch (SqlException) { throw; } finally { dbConn.Close(); } return result; }
//private string insertOrder = "INSERT INTO CinemaOrder VALUES (@)"; //method to create order in db internal int InsertOrder(Order ord) { int result = 0; try { dbConn.Open(); SqlCommand command = new SqlCommand("INSERT INTO CinemaOrder VALUES (@title, @date, @time, @screenNo, @seatAmount, @price, @orderId, @empId, @seatNo, @rowNo, @phoneNo)", dbConn); command.CommandType = CommandType.Text; command.Parameters.Add("@title", SqlDbType.VarChar).Value = ord.title; command.Parameters.Add("@date", SqlDbType.Text).Value = ord.date; command.Parameters.Add("@time", SqlDbType.Text).Value = ord.time; command.Parameters.Add("@screenNo", SqlDbType.Text).Value = ord.screenNo; command.Parameters.Add("@seatAmount", SqlDbType.Text).Value = ord.seatAmount; command.Parameters.Add("@price", SqlDbType.VarChar).Value = ord.price; command.Parameters.Add("@orderId", SqlDbType.VarChar).Value = ord.orderId; command.Parameters.Add("@empId", SqlDbType.VarChar).Value = ord.empId; command.Parameters.Add("@cosId", SqlDbType.VarChar).Value = ord.cosId; command.Parameters.Add("@seatNo", SqlDbType.VarChar).Value = ord.seatNo; command.Parameters.Add("@rowNo", SqlDbType.VarChar).Value = ord.rowNo; command.Parameters.Add("@phoneNo", SqlDbType.VarChar).Value = ord.phoneNo; result = command.ExecuteNonQuery(); } catch (SqlException) { result = -1; } finally { if (dbConn != null) { dbConn.Close(); } } return result; }
public Order(Order ord) { this.title = title; this.date = date; this.time = time; this.screenNo = screenNo; this.seatAmount = seatAmount; this.price = price; this.orderId = orderId; this.cosId = cosId; this.phoneNo = phoneNo; }
//method to delete an order public int DeleteOrder(Order ord) { int result = 0; try { dbConn.Open(); SqlCommand command = new SqlCommand("DELETE FROM CinemaOrder WHERE VALUES (@CosPhoneNo)", dbConn); command.Parameters.Add("@CosPhoneNo", SqlDbType.VarChar).Value = ord.phoneNo; result = command.ExecuteNonQuery(); } catch (SqlException) { result = -1; } finally { if (dbConn != null) { dbConn.Close(); } } return result; }
//read an order in DB public List<Order> ReadOrder(Order phoneNo) { Order ord; SqlDataReader reader = null; List<Order> ordList = new List<Order>(); try { dbConn.Open(); SqlCommand command = new SqlCommand(("SELECT (@CosPhoneNo) FROM CinemaOrder"), dbConn); command.Parameters.Add("@CosPhoneNo", SqlDbType.VarChar).Value = "%" + phoneNo + "%"; reader = command.ExecuteReader(); while (reader.Read()) { ord = new Order((Order)reader["CosPhoneNo"]); ordList.Add(ord); } } catch (Exception) { throw; } finally { if (reader != null) { reader.Close(); } if (dbConn != null) { dbConn.Close(); } } return ordList; }
//order public int InsertOrder(Order ord) { return orctrlh.InsertOrder(ord); }
internal string ToString(Order price) { throw new NotImplementedException(); }
public int InsertOrder(Order ord) { // insert orderobject into orderdb return oDB.InsertOrder(ord); }
//get an order from db public List<Order> ReadOrder(Order phoneNo) { return oDB.ReadOrder(phoneNo); }
public int DeleteOrder(Order phoneNo) { return oDB.DeleteOrder(phoneNo); }