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