public Costumer CostumerObject(Costumer phoneNo, Costumer cosFname, Costumer cosLname, Costumer email)
{
Costumer cost = new Costumer(phoneNo);
cost.cosFname = cosFname;
cost.cosLname = cosLname;
cost.cosEmail = email;
return cost;
}
public Order(int p1, string p2, int p3, Screen screen, int p4, double p5, Person person, Costumer costumer1, Costumer costumer2)
{
// TODO: Complete member initialization
this.p1 = p1;
this.p2 = p2;
this.p3 = p3;
this.screen = screen;
this.p4 = p4;
this.p5 = p5;
this.person = person;
this.costumer1 = costumer1;
this.costumer2 = costumer2;
}
public Order(Movie title, String date, int time, Screen screenNo, int seatAmount, double price, int orderId, Person empId, Costumer cosId, Costumer phoneNo)
{
this.title = title;
this.date = date;
this.time = time;
this.screenNo = screenNo;
this.seatAmount = seatAmount;
this.price = price;
this.orderId = orderId;
this.empId = empId;
this.cosId = cosId;
this.phoneNo = phoneNo;
}
//Method to delete a Costumer.
//same lazy errorhandling as InsertCos
public int DeleteCos(Costumer cost)
{
int result = 0;
try
{
dbConn.Open();
SqlCommand command = new SqlCommand("DELETE FROM CinemaCostumer WHERE VALUES (@cosPhoneNo)", dbConn);
command.Parameters.Add("@cosPhoneNo", SqlDbType.VarChar).Value = cost.cosPhoneNo;
result = command.ExecuteNonQuery();
}
catch (SqlException)
{
result = -1;
}
finally
{
if (dbConn != null) { dbConn.Close(); }
}
return result;
}
//Method to insert Costumer. Takes phoneNo, fname, lname and email as patameters - though only a phonenumber is needed.
// 0 = default state. 1 = success. -1 = error. Perhaps should implement more usefull errorhandling.
//(See SQLException class on msdn)
public int InsertCos(Costumer cost)
{
int result = 0;
try
{
dbConn.Open();
SqlCommand command = new SqlCommand("INSERT INTO CinemaCostumer VALUES (@cosPhoneNo, @cosFname, @cosLname, @cosEmail)", dbConn);
command.CommandType = CommandType.Text;
command.Parameters.Add("@CosPhoneNo", SqlDbType.VarChar).Value = cost.cosPhoneNo;
command.Parameters.Add("@cosFname", SqlDbType.Text).Value = cost.cosFname;
command.Parameters.Add("@cosLname", SqlDbType.Text).Value = cost.cosLname;
command.Parameters.Add("@CosEmail", SqlDbType.Text).Value = cost.cosEmail;
result = command.ExecuteNonQuery();
}
catch (SqlException)
{
result = -1;
}
finally
{
if (dbConn != null) { dbConn.Close(); }
}
return result;
}
//Method to insert Costumer. Takes phoneNo, fname, lname and email as patameters - though only a phonenumber is needed.
// 0 = default state. 1 = success. -1 = error. Perhaps should implement more usefull errorhandling.
//(See SQLException class on msdn)
public int InsertCos(Costumer cost)
{
int result = 0;
try
{
dbConn.Open();
SqlCommand command = new SqlCommand("INSERT INTO CinemaCostumer (cosPhoneNo, cosFname, cosLname, cosEmal) VALUES ((@cosPhoneNo), (@cosFname), (@cosLname), (@cosEmail))", dbConn);
command.Parameters.Add("@CosPhoneNo", SqlDbType.Int).Value = cost.cosPhoneNo;
command.Parameters.Add("@cosFname", SqlDbType.VarChar).Value = cost.cosFname;
command.Parameters.Add("@cosLname", SqlDbType.VarChar).Value = cost.cosLname;
command.Parameters.Add("@CosEmail", SqlDbType.VarChar).Value = cost.cosEmail;
result = command.ExecuteNonQuery();
}
catch (SqlException)
{
throw;
}
finally
{
dbConn.Close();
}
return result;
}
//private string selectEmp = "SELECT empFname, empLname, empId FROM CinemaEmployee";
//private string deleteCos = "DELETE FROM CinemaCostumer";
//private string deleteEmp = "DELETE FROM CinemaEmployee";
//Method to return costumer by phonenumber as input.
public List<Costumer> ReadCos(int phoneNo)
{
Costumer cost;
SqlDataReader reader = null;
List<Costumer> cosList = new List<Costumer>();
try
{
dbConn.Open();
SqlCommand command = new SqlCommand(("SELECT (@phoneNo) FROM CinemaPerson"), dbConn);
command.Parameters.Add("@phoneNo", SqlDbType.VarChar).Value = "%" + phoneNo + "%";
reader = command.ExecuteReader();
while (reader.Read())
{
cost = new Costumer((Costumer)reader["phoneNo"]);
//if (reader["fname" + "lname"] != null)
//{
// cost.fname = (Costumer)reader["fname"];
// cost.lname = (Costumer)reader["lname"];
//}
//if (reader["email"] != null)
//{
// cost.cosEmail = (Costumer)reader["email"];
//}
cosList.Add(cost);
}
}
catch (Exception)
{
throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
if (dbConn != null)
{
dbConn.Close();
}
}
return cosList;
}
//Method to return all Costumers.
public List<Costumer> ReadAllCos()
{
Costumer cost;
SqlDataReader reader = null;
List<Costumer> allCosList = new List<Costumer>();
try
{
dbConn.Open();
SqlCommand command = new SqlCommand(selectCos, dbConn);
reader = command.ExecuteReader();
while (reader.Read())
{
cost = new Costumer((Costumer)reader["phoneNo"]);
//if (reader["fname" + "lname"] != null)
//{
// cost.fname = (Costumer)reader["fname"];
// cost.lname = (Costumer)reader["lname"];
//}
//if (reader["email"] != null)
//{
// cost.cosEmail = (Costumer)reader["email"];
//}
allCosList.Add(cost);
}
}
catch (Exception)
{
throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
if (dbConn != null)
{
dbConn.Close();
}
}
return allCosList;
}
public int InsertCostumer(Costumer cost)
{
return pctrlh.InsertCos(cost);
}
public int InsertCos(Costumer cost)
{
// insert costumer not made in PersonDB yet
return pDB.InsertCos(cost);
}
//Method to return costumer by phonenumber as input.
public List<Costumer> ReadCos(int phoneNo)
{
Costumer cost = null;
SqlDataReader reader = null;
List<Costumer> cosList = new List<Costumer>();
try
{
dbConn.Open();
SqlCommand command = new SqlCommand(("SELECT * FROM CinemaCostumer WHERE (@cosPhoneNo) = (cosPhoneNo)"), dbConn);
command.Parameters.Add("@phoneNo", SqlDbType.VarChar).Value = cost.cosPhoneNo;
reader = command.ExecuteReader();
while (reader.Read())
{
cost = new Costumer((int)reader["CosPhoneNo"], (string)reader["CosFname"], (string)reader["CosLname"], (string)reader["CosEmail"]);
cosList.Add(cost);
}
}
catch (Exception)
{
throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
if (dbConn != null)
{
dbConn.Close();
}
}
return cosList;
}
//Method to return all Costumers.
public List<Costumer> ReadAllCos()
{
Costumer cost;
SqlDataReader reader = null;
List<Costumer> allCosList = new List<Costumer>();
try
{
dbConn.Open();
SqlCommand command = new SqlCommand(("SELECT * FROM CinemaCostumer"), dbConn);
reader = command.ExecuteReader();
while (reader.Read())
{
cost = new Costumer((int)reader["CosPhoneNo"], (string)reader["CosFname"], (string)reader["CosLname"], (string)reader["CosEmail"]);
allCosList.Add(cost);
}
}
catch (Exception)
{
throw;
}
finally
{
reader.Close();
dbConn.Close();
}
return allCosList;
}
public int DeleteCos(Costumer cost)
{
//delete a costumer, not made in personDB yet
return pDB.DeleteCos(cost);
}
