public void testAfModel() { Cashier c = new Cashier(42, "Morten", 59000m, "51255919"); CashierCollection cc = new CashierCollection(); cc.Add(c); foreach (Cashier tmpc in cc) { } }
public Facade() { dbf = new DBFacadeCashier("Data Source=10.165.150.52;Initial Catalog=nextgenPOS;Persist Security Info=True;User ID=dm122;Password=dm122"); dbf.connectDB(); cashierCollection = new CashierCollection(); Cashier c = new Cashier(42, "Morten", 59000m, "51255919"); cashierCollection.Add(c); // dbf.closeDB(); }
public ICashier CreateCashier(string name, decimal salery, string telephone) { int cashier_id = -42; // Bruges til at lave sql commandoer mod DMBMS'et // "createCashier" - Navn på den gemte procedure i DB'en SqlCommand cmd = new SqlCommand("createCashier", dbconn); cmd.CommandType = CommandType.StoredProcedure; // VIGTIG!!!! SqlParameter parameter; parameter = new SqlParameter("@cashier_id", SqlDbType.Int); //parameter.Value = DBNull.Value; parameter.Direction = ParameterDirection.Output; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@name", SqlDbType.NVarChar, 30); parameter.Value = name; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@salery", SqlDbType.Decimal); parameter.Value = salery; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@telephone", SqlDbType.VarChar, 200); parameter.Value = telephone; cmd.Parameters.Add(parameter); cmd.ExecuteNonQuery(); cashier_id = (int) cmd.Parameters["@cashier_id"].Value; ICashier theCashier = new Cashier(cashier_id, name, salery, telephone); //createCashier return theCashier; }
public List<ICashier> LoadCashiers() { List<ICashier> cashiers = new List<ICashier>(); SqlCommand cmd = new SqlCommand("LoadCashiers", dbconn); cmd.CommandType = CommandType.StoredProcedure; // VIGTIG!!!! SqlDataReader myreader = cmd.ExecuteReader(); while (myreader.Read()) { ICashier c = new Cashier( (int) myreader["cashier_id"], (string) myreader["name"], (decimal) myreader["salery"], (string) myreader["telephone"]); cashiers.Add(c); } myreader.Close(); return cashiers; }