public void testStoreManager()
{
try {
//week 3
//IManagerSvc ics = factory.getManagerSvc();
//week 4
IManagerSvc ics = (IManagerSvc) factory.getService("IManagerSvc");
// First let's store the Inventory
Assert.True(ics.storeManager(m));
// Then let's read it back in
m = ics.getManager(m.id);
Assert.True(m.validate());
// Update Manager
m.lastName = "Smith";
Assert.True(ics.storeManager(m));
// Finally, let's cleanup the file that was created
Assert.True(ics.deleteManager(m.id));
}
catch(Exception e) {
Console.WriteLine("Exception in testStoreManager: " + e.Message + "\n" + e.StackTrace);
Assert.Fail(e.Message + "\n" + e.StackTrace);
}
}
public void testInvalidManager()
{
try {
Manager m = new Manager();
Assert.False(m.validate());
}
catch(Exception e) {
Console.WriteLine("Exception in testInvalidManager: " + e.Message + "\n" + e.StackTrace);
Assert.Fail(e.Message + "\n" + e.StackTrace);
}
}
public void testNotEqualsManager()
{
try {
Manager m = new Manager("Jim","Bloom",1);
Manager n = new Manager();
Assert.False(m.Equals(n));
}
catch(Exception e) {
Console.WriteLine("Exception in testNotEqualsManager: " + e.Message + "\n" + e.StackTrace);
Assert.Fail(e.Message + "\n" + e.StackTrace);
}
}
public void testValidateManager()
{
try {
Manager m = new Manager();
m.id = 1;
m.firstName = "Jim";
m.lastName = "Bloom";
Assert.True(m.validate());
}
catch(Exception e) {
Console.WriteLine("Exception in testValidateManager: " + e.Message + "\n" + e.StackTrace);
Assert.Fail(e.Message + "\n" + e.StackTrace);
}
}
/// <summary>
/// This method retrieves a manager.
/// </summary>
/// <param name="id">Unique ID of manager to retrieve</param>
/// <returns>customer object</returns>
public Manager getManager(Int32 id)
{
dLog.Info("Entering method getManager | ID: " + id);
Manager m = new Manager();
SqlDataReader rs = null;
SqlConnection conn = null;
SqlCommand stmt = null;
try
{
String sqlStr = "SELECT FirstName, isManager, LastName FROM Employee 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");
m.id = id;
#region Read Fields
if (!rs.IsDBNull(0))
m.firstName = rs.GetString(0);
if (!rs.IsDBNull(1))
m.isManager = rs.GetBoolean(1);
if (!rs.IsDBNull(2))
m.lastName = rs.GetString(2);
#endregion
}
}
catch (SqlException e1)
{
dLog.Error("SqlException in getManager: " + e1.Message + "\n" + e1.StackTrace);
m = new Manager();
}
catch (Exception e2)
{
dLog.Error("Exception in getManager: " + e2.Message + "\n" + e2.StackTrace);
m = new Manager();
}
finally
{
if (rs != null && !rs.IsClosed)
rs.Close();
if (conn != null && conn.State == System.Data.ConnectionState.Open)
conn.Close();
}
return m;
}
/// <summary>
/// This method stores a manager.
/// </summary>
/// <param name="m">The manager object to store</param>
/// <returns>Success/Failure</returns>
public Boolean storeManager(Manager m)
{
dLog.Info("Entering method storeManager | ID: " + m.id);
Boolean result = false;
SqlConnection conn = null;
SqlCommand stmt = null;
try
{
String sqlStr = "SELECT COUNT(1) FROM Employee WHERE id = @id";
conn = new SqlConnection(connString);
conn.Open();
stmt = new SqlCommand(sqlStr, conn);
stmt.Parameters.Add(new SqlParameter("@id", m.id));
if (Int32.Parse(stmt.ExecuteScalar().ToString()) > 0)
{
//if first is a valid row, then we need to do an update
dLog.Info("Updating manager in database");
sqlStr = "UPDATE Employee SET FirstName=@FirstName, isManager=@isManager, LastName=@LastName WHERE id=@id";
}
else
{
//if first is null, then we need to do an insert
dLog.Info("Inserting manager into database");
sqlStr = "INSERT INTO Employee (FirstName,isManager, LastName, id) ";
sqlStr += "VALUES (@FirstName, @isManager, @LastName, @id)";
}
dLog.Info("SQL Statement: " + sqlStr);
stmt = new SqlCommand(sqlStr, conn);
#region Add SQL Parameters
stmt.Parameters.Add(new SqlParameter("@id", m.id));
stmt.Parameters.Add(new SqlParameter("@FirstName", m.firstName));
stmt.Parameters.Add(new SqlParameter("@isManager", m.isManager));
stmt.Parameters.Add(new SqlParameter("@LastName", m.lastName));
#endregion
if (stmt.ExecuteNonQuery() > 0)
result = true;
}
catch (SqlException e1)
{
dLog.Error("SqlException in storeManager: " + e1.Message);
}
catch (Exception e2)
{
dLog.Error("Exception in storeManager: " + e2.Message);
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
conn.Close();
}
return result;
}
/// <summary>
/// This method stores a manager.
/// </summary>
/// <param name="m">The manager object to store</param>
/// <returns>Success/Failure</returns>
public Boolean storeManager(Manager m)
{
dLog.Info("Entering method storeManager | ID: " + m.id);
Stream output = null;
Boolean result = false;
try
{
//ensure we were passed a valid object before attempting to write
if (m.validate())
{
output = File.Open("Manager_" + m.id + ".txt", FileMode.Create);
BinaryFormatter bFormatter = new BinaryFormatter();
bFormatter.Serialize(output, m);
result = true;
}
}
catch (IOException e1)
{
dLog.Error("IOException in storeManager: " + e1.Message);
result = false;
}
catch (Exception e2)
{
dLog.Error("Exception in storeManager: " + e2.Message);
result = false;
}
finally
{
//ensure that output is close regardless of the errors in try/catch
if (output != null)
{
output.Close();
}
}
return result;
}
protected void SetUp()
{
factory = Factory.getInstance();
m = new Manager("Jim", "Bloom", 1);
}
/// <summary>
/// This method stores a manager.
/// </summary>
/// <param name="m">The manager object to store</param>
/// <returns>Success/Failure</returns>
public Boolean storeManager(Manager m)
{
dLog.Info("Entering method storeManager | ID: " + m.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("employee");
var query = new QueryDocument("id", m.id);
dLog.Debug("Finding if manager exists");
BsonDocument myDoc = coll.FindOne(query);
query.Add("firstName", m.firstName);
query.Add("isManager", m.isManager);
query.Add("lastName", m.lastName);
//ensure we were passed a valid object before attempting to write
if (myDoc == null)
{
dLog.Debug("Inserting manager");
coll.Insert(query);
result = true;
}
else
{
var update = new UpdateDocument();
update.Add(query.ToBsonDocument());
dLog.Debug("Updating manager");
dLog.Debug("myDoc: " + myDoc.ToString());
dLog.Debug("update Query: " + update.ToString());
SafeModeResult wr = coll.Update(new QueryDocument("id", m.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 storeManager: " + e2.Message);
}
finally
{
//using statement above already calls RequestDone()
}
return result;
}
/// <summary>
/// This method retrieves a manager.
/// </summary>
/// <param name="id">Unique ID of manager to retrieve</param>
/// <returns>manager object</returns>
public Manager getManager(Int32 id)
{
dLog.Info("Entering method getManager | ID: " + id);
Manager m = new Manager();
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("employee");
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
m.id = id;
m.firstName = myDoc["firstName"].AsString;
m.isManager = myDoc["isManager"].AsBoolean;
m.lastName = myDoc["lastName"].AsString;
#endregion
}
dLog.Debug("Finishing setting manager");
}
}
catch (Exception e2)
{
dLog.Error("Exception in getManager: " + e2.Message + "\n" + e2.StackTrace);
m = new Manager();
}
finally
{
//using statement above already calls RequestDone()
}
return m;
}
public Boolean login(Manager m, String password)
{
Boolean result = false;
try
{
IPHostEntry ipHostInfo = Dns.GetHostEntry(Dns.GetHostName());
IPEndPoint localEP = new IPEndPoint(ipHostInfo.AddressList[0], 8000);
foreach (IPAddress ip in ipHostInfo.AddressList)
if (ip.AddressFamily == AddressFamily.InterNetwork)
localEP = new IPEndPoint(ip, 8000);
dLog.Debug("Local address and port: " + localEP.Address.ToString() + " | " + localEP.Port.ToString());
client = new Socket(localEP.Address.AddressFamily, SocketType.Stream, ProtocolType.Tcp);
client.Connect(localEP.Address, 8000);
String inputStr = readObject();
writeObject(m.firstName);
inputStr = readObject();
writeObject(password);
inputStr = readObject();
//check out input
if (inputStr.Split(' ')[0].Equals("OK"))
result = true;
writeObject("exit");
}
catch (Exception e1)
{
dLog.Error("Exception in login: " + e1.Message);
}
finally
{
if (client.Connected)
client.Shutdown(SocketShutdown.Both);
if (client.IsBound)
{
client.Close();
client = null;
}
}
return result;
}
/// <summary>
/// This method retrieves a manager.
/// </summary>
/// <param name="id">Unique ID of manager to retrieve</param>
/// <returns>burrito object</returns>
public Manager getManager(Int32 id)
{
dLog.Info("Entering method getManager | ID: " + id);
Manager m = new Manager();
ISession session = null;
try {
using (session = getSession()) {
using (ITransaction transaction = session.BeginTransaction())
{
IQuery query = session.CreateQuery(@"FROM Manager WHERE id = :id");
query.SetParameter("id", id);
m = query.List<Manager>()[0];
}
}
}
catch (Exception e2)
{
dLog.Error("Exception in getManager: " + e2.Message + "\n" + e2.StackTrace);
m = new Manager();
}
finally
{
//ensure that session is close regardless of the errors in try/catch
if (session != null && session.IsOpen)
session.Close();
}
return m;
}
/// <summary>
/// This method stores a manager.
/// </summary>
/// <param name="m">The manager object to store</param>
/// <returns>Success/Failure</returns>
public Boolean storeManager(Manager m)
{
dLog.Info("Entering method storeManager | ID: " + m.id);
Boolean result = false;
ISession session = null;
try
{
using (session = getSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
session.Save(m);
transaction.Commit();
if (transaction.WasCommitted)
result = true;
}
}
}
catch (Exception e2)
{
dLog.Error("Exception in storeManager: " + e2.Message);
}
finally
{
//ensure that session is close regardless of the errors in try/catch
if (session != null && session.IsOpen)
session.Close();
}
return result;
}
