public void testCustomerSvc()
        {
            try {
                //week 3
                //ICustomerSvc ics = factory.getCustomerSvc();

                //week 4
                ICustomerSvc ics = (ICustomerSvc) factory.getService("ICustomerSvc");

                // First let's store the Customer
                Assert.True(ics.storeCustomer(c));

                // Then let's read it back in
                c = ics.getCustomer(c.id);
                Assert.True(c.validate());

                // Update customer
                c.emailAddress = "*****@*****.**";
                Assert.True(ics.storeCustomer(c));

                // Finally, let's cleanup the file that was created
                Assert.True(ics.deleteCustomer(c.id));
            }
            catch(Exception e) {
                Console.WriteLine("Exception in testStoreCustomer: " + e.Message + "\n" + e.StackTrace);
                Assert.Fail(e.Message + "\n" + e.StackTrace);
            }
        }
예제 #2
0
        public void testInvalidCustomer()
        {
            try {
                Customer c = new Customer();

                Assert.False(c.validate());
            }
            catch(Exception e) {
                Console.WriteLine("Exception in testInvalidCustomer: " + e.Message + "\n" + e.StackTrace);
                Assert.Fail(e.Message + "\n" + e.StackTrace);
            }
        }
예제 #3
0
        public void testNotEqualsCustomer()
        {
            try {
                Customer c = new Customer(1, "Jim", "Bloom", "*****@*****.**");
                Customer d = new Customer();

                Assert.False(c.Equals(d));
            }
            catch(Exception e) {
                Console.WriteLine("Exception in testNotEqualsCustomer: " + e.Message + "\n" + e.StackTrace);
                Assert.Fail(e.Message + "\n" + e.StackTrace);
            }
        }
예제 #4
0
        public void testValidate()
        {
            try {
                Customer c = new Customer();
                c.id = 1;
                c.emailAddress = "*****@*****.**";
                c.firstName = "Jim";
                c.lastName = "Bloom";

                Assert.True(c.validate());
            }
            catch(Exception e) {
                Console.WriteLine("Exception in testValidate: " + e.Message + "\n" + e.StackTrace);
                Assert.Fail(e.Message + "\n" + e.StackTrace);
            }
        }
        public void testInvalidGetCustomer()
        {
            try {
                //week 3
                //ICustomerSvc ics = factory.getCustomerSvc();

                //week 4
                ICustomerSvc ics = (ICustomerSvc) factory.getService("ICustomerSvc");
                c = ics.getCustomer(1234);

                if(c != null)
                    Assert.False(c.validate());
            }
            catch(Exception e) {
                Console.WriteLine("Exception in testInvalidGetCustomer: " + e.Message + "\n" + e.StackTrace);
                Assert.Fail(e.Message + "\n" + e.StackTrace);
            }
        }
        /// <summary>
        /// This method retrieves a customer.
        /// </summary>
        /// <param name="id">Unique ID of customer to retrieve</param>
        /// <returns>customer object</returns>
        public Customer getCustomer(Int32 id)
        {
            dLog.Info("Entering method getCustomer | ID: " + id);
            Customer c = new Customer();
            ISession session = null;

            try {
                using (session = getSession()) {
                    using (ITransaction transaction = session.BeginTransaction())
                    {
                        IQuery query = session.CreateQuery(@"FROM Customer WHERE id = :id");
                        query.SetParameter("id", id);

                        c = query.List<Customer>()[0];
                    }

                }
            }
            catch (Exception e2)
            {
                dLog.Error("Exception in getCustomer: " + e2.Message + "\n" + e2.StackTrace);
                c = new Customer();
            }
            finally
            {
                //ensure that session is close regardless of the errors in try/catch
                if (session != null && session.IsOpen)
                    session.Close();
            }

            return c;
        }
        /// <summary>
        /// This method stores a customer.
        /// </summary>
        /// <param name="c">The customer object to store</param>
        /// <returns>Success/Failure</returns>
        public Boolean storeCustomer(Customer c)
        {
            dLog.Info("Entering method storeCustomer | ID: " + c.id);
            Boolean result = false;
            ISession session = null;

            try
            {
                using (session = getSession())
                {
                    using (ITransaction transaction = session.BeginTransaction())
                    {
                        session.Save(c);
                        transaction.Commit();

                        if (transaction.WasCommitted)
                            result = true;
                    }
                }
            }
            catch (Exception e2)
            {
                dLog.Error("Exception in storeCustomer: " + e2.Message);
            }
            finally
            {
                //ensure that session is close regardless of the errors in try/catch
                if (session != null && session.IsOpen)
                    session.Close();
            }

            return result;
        }
        /// <summary>
        /// This method stores a customer.
        /// </summary>
        /// <param name="c">The customer object to store</param>
        /// <returns>Success/Failure</returns>
        public Boolean storeCustomer(Customer c)
        {
            dLog.Info("Entering method storeCustomer | ID: " + c.id);
            Stream output = null;
            Boolean result = false;

            try
            {
                //ensure we were passed a valid object before attempting to write
                if (c.validate())
                {
                    output = File.Open("Customer_" + c.id + ".txt", FileMode.Create);
                    BinaryFormatter bFormatter = new BinaryFormatter();
                    bFormatter.Serialize(output, c);
                    result = true;
                }
            }
            catch (IOException e1)
            {
                dLog.Error("IOException in storeCustomer: " + e1.Message);
                result = false;
            }
            catch (Exception e2)
            {
                dLog.Error("Exception in storeCustomer: " + e2.Message);
                result = false;
            }
            finally
            {
                //ensure that output is close regardless of the errors in try/catch
                if (output != null)
                {
                    output.Close();
                }
            }

            return result;
        }
        /// <summary>
        /// This method retrieves a customer.
        /// </summary>
        /// <param name="id">Unique ID of customer to retrieve</param>
        /// <returns>customer object</returns>
        public Customer getCustomer(Int32 id)
        {
            dLog.Info("Entering method getCustomer | ID: " + id);
            Customer c = new Customer();
            SqlDataReader rs = null;
            SqlConnection conn = null;
            SqlCommand stmt = null;

            try
            {
                String sqlStr = "SELECT EmailAddress, FirstName, LastName FROM Customer WHERE id = @id";

                conn = new SqlConnection(connString);
                conn.Open();
                stmt = new SqlCommand(sqlStr, conn);
                stmt.Parameters.Add(new SqlParameter("@id", id));
                rs = stmt.ExecuteReader();

                while (rs.Read())
                {
                    dLog.Info("Got the " + rs.FieldCount + " fields of the record");
                    c.id = id;

                    #region Read Fields
                    if (!rs.IsDBNull(0))
                        c.emailAddress = rs.GetString(0);
                    if(!rs.IsDBNull(1))
                        c.firstName = rs.GetString(1);
                    if(!rs.IsDBNull(2))
                        c.lastName = rs.GetString(2);
                    #endregion
                }
            }
            catch (SqlException e1)
            {
                dLog.Error("SqlException in getCustomer: " + e1.Message + "\n" + e1.StackTrace);
                c = new Customer();
            }
            catch (Exception e2)
            {
                dLog.Error("Exception in getCustomer: " + e2.Message + "\n" + e2.StackTrace);
                c = new Customer();
            }
            finally
            {
                if (rs != null && !rs.IsClosed)
                    rs.Close();
                if (conn != null && conn.State == System.Data.ConnectionState.Open)
                    conn.Close();
            }

            return c;
        }
예제 #10
0
        /// <summary>
        /// This method stores a customer.
        /// </summary>
        /// <param name="c">The customer object to store</param>
        /// <returns>Success/Failure</returns>
        public Boolean storeCustomer(Customer c)
        {
            dLog.Info("Entering method storeCustomer | ID: " + c.id);
            Boolean result = false;
            SqlConnection conn = null;
            SqlCommand stmt = null;

            try
            {
                String sqlStr = "SELECT COUNT(1) FROM Customer WHERE id = @id";

                conn = new SqlConnection(connString);
                conn.Open();
                stmt = new SqlCommand(sqlStr, conn);
                stmt.Parameters.Add(new SqlParameter("@id", c.id));

                if (Int32.Parse(stmt.ExecuteScalar().ToString()) > 0)
                {
                    //if first is a valid row, then we need to do an update
                    dLog.Info("Updating customer in database");

                    sqlStr = "UPDATE Customer SET EmailAddress=@EmailAddress, FirstName=@FirstName, LastName=@LastName WHERE id=@id";
                }
                else
                {
                    //if first is null, then we need to do an insert
                    dLog.Info("Inserting customer into database");

                    sqlStr = "INSERT INTO Customer (EmailAddress, FirstName, LastName, id) ";
                    sqlStr += "VALUES (@EmailAddress, @FirstName, @LastName, @id)";
                }

                dLog.Info("SQL Statement: " + sqlStr);
                stmt = new SqlCommand(sqlStr, conn);

                #region Add SQL Parameters
                stmt.Parameters.Add(new SqlParameter("@id", c.id));
                stmt.Parameters.Add(new SqlParameter("@EmailAddress", c.emailAddress));
                stmt.Parameters.Add(new SqlParameter("@FirstName", c.firstName));
                stmt.Parameters.Add(new SqlParameter("@LastName", c.lastName));
                #endregion

                if (stmt.ExecuteNonQuery() > 0)
                    result = true;
            }
            catch (SqlException e1)
            {
                dLog.Error("SqlException in storeCustomer: " + e1.Message);
            }
            catch (Exception e2)
            {
                dLog.Error("Exception in storeCustomer: " + e2.Message);
            }
            finally
            {
                if (conn.State == System.Data.ConnectionState.Open)
                    conn.Close();
            }

            return result;
        }
        /// <summary>
        /// This method stores a customer.
        /// </summary>
        /// <param name="c">The customer object to store</param>
        /// <returns>Success/Failure</returns>
        public Boolean storeCustomer(Customer c)
        {
            dLog.Info("Entering method storeCustomer | ID: " + c.id);
            Boolean result = false;

            try
            {
                MongoServer server = MongoServer.Create();
                MongoDatabase db = server.GetDatabase("neatoBurrito");
                //MongoCredentials credentials = new MongoCredentials("username", "password");
                //MongoDatabase salaries = server.GetDatabase("salaries", credentials);

                using (server.RequestStart(db))
                {
                    MongoCollection<BsonDocument> coll = db.GetCollection("customer");
                    var query = new QueryDocument("id", c.id);

                    dLog.Debug("Finding if customer exists");
                    BsonDocument myDoc = coll.FindOne(query);

                    query.Add("emailAddress", c.emailAddress);
                    query.Add("lastName", c.lastName);
                    query.Add("firstName", c.firstName);

                    //ensure we were passed a valid object before attempting to write
                    if (myDoc == null)
                    {
                        dLog.Debug("Inserting customer");
                        coll.Insert(query);

                        result = true;
                    }
                    else
                    {
                        var update = new UpdateDocument();
                        update.Add(query.ToBsonDocument());
                        dLog.Debug("Updating customer");
                        dLog.Debug("myDoc: " + myDoc.ToString());
                        dLog.Debug("update Query: " + update.ToString());

                        SafeModeResult wr = coll.Update(new QueryDocument("id", c.id), update, SafeMode.True);

                        dLog.Debug("SafeModeResult: " + wr.Ok);
                        if (wr.LastErrorMessage == null && wr.Ok)
                        {
                            result = true;
                        }
                        else
                        {
                            dLog.Debug("SafeModeResult: " + wr.LastErrorMessage);
                        }
                    }
                }
            }
            catch (Exception e2)
            {
                dLog.Error("Exception in storeCustomer: " + e2.Message);
            }
            finally
            {
                //using statement above already calls RequestDone()
            }

            return result;
        }
        /// <summary>
        /// This method retrieves a customer.
        /// </summary>
        /// <param name="id">Unique ID of customer to retrieve</param>
        /// <returns>customer object</returns>
        public Customer getCustomer(Int32 id)
        {
            dLog.Info("Entering method getCustomer | ID: " + id);
            Customer c = new Customer();

            try
            {
                MongoServer server = MongoServer.Create();
                MongoDatabase db = server.GetDatabase("neatoBurrito");
                //MongoCredentials credentials = new MongoCredentials("username", "password");
                //MongoDatabase salaries = server.GetDatabase("salaries", credentials);

                using (server.RequestStart(db))
                {
                    MongoCollection<BsonDocument> coll = db.GetCollection("customer");
                    var query = new QueryDocument("id", id);

                    BsonDocument myDoc = coll.FindOne(query);

                    //ensure we were passed a valid object before attempting to read
                    if (myDoc != null)
                    {
                        dLog.Debug("myDoc: " + myDoc.ToString());

                        #region Read Fields
                        c.id = id;
                        c.emailAddress = myDoc["emailAddress"].AsString;
                        c.firstName = myDoc["firstName"].AsString;
                        c.lastName = myDoc["lastName"].AsString;
                        #endregion
                    }
                    dLog.Debug("Finishing setting customer");
                }
            }
            catch (Exception e2)
            {
                dLog.Error("Exception in getCustomer: " + e2.Message + "\n" + e2.StackTrace);
                c = new Customer();
            }
            finally
            {
                //using statement above already calls RequestDone()
            }

            return c;
        }
 protected void SetUp()
 {
     factory = Factory.getInstance();
     c = new Customer(1, "Jim", "Bloom", "*****@*****.**");
 }