public void Create(IEntity obj)
{
Blab blab = (Blab)obj;
try
{
DateTime now = DateTime.Now;
string sql = "INSERT INTO blabs (sys_id, message, dttm_created, user_id) VALUES ('"
+ blab.Id + "', '"
+ blab.Message + "', '"
+ now.ToString("yyyy-MM-dd HH:mm:ss") + "', '"
+ blab.User.Email + "')";
MySqlCommand cmd = new MySqlCommand(sql, this.dcBlab);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
/// <summary>
/// Creates a Blab object in the database
/// </summary>
/// <param name="obj"></param>
public void Create(IEntity obj)
{
try
{
Blab blab = (Blab)obj;
DateTime now = DateTime.Now;
//Use Don's SQL, it worked when he did it. Don't change
string sql = "INSERT INTO blabs (sys_id, message, dttm_created, user_id) VALUES ('"
+ blab.Id + "', '"
+ blab.Message + "', '"
+ now.ToString("yyyy-MM-dd HH:mm:ss") + "', '"
+ blab.User.Email + "')";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
public IEntity ReadById(Guid Id)
{
try {
string sql = "SELECT * FROM blabs WHERE blabs.sys_id = '" + Id.ToString() + "'";
MySqlDataAdapter daBlab = new MySqlDataAdapter(sql, this.dcBlab); // To avoid SQL injection.
MySqlCommandBuilder cbBlab = new MySqlCommandBuilder(daBlab);
DataSet dsBlab = new DataSet();
daBlab.Fill(dsBlab, "blabs");
DataRow row = dsBlab.Tables[0].Rows[0];
Blab blab = new Blab();
blab.Id = new Guid(row["sys_id"].ToString());
return(blab);
} catch (Exception ex) {
throw new Exception(ex.ToString());
}
}
public void OnPost()
{
var email = Request.Form["emailaddress"];
var message = Request.Form["message"];
try {
User user = _serviceUser.FindUser(email);
if (user == null)
{
// user didn't exist error
}
else
{
Blab blab = _serviceBlab.CreateBlab(message, user);
_serviceBlab.AddBlab(blab);
}
} catch (Exception ex) {
throw new Exception("FeedModel::OnPost: " + ex.ToString());
}
}
public string GetMoreBlabs(int start, int numResults)
{
var username = GetLoggedInUsername();
var template = "<li><div><div class='commenterImage'>" +
"<img src='" + Url.Content("~/Images/") +"{0}.png'>" +
"</div>" +
"<div class='commentText'>" +
"<p>{1}</p>" +
"<span class='date sub-text'>by {2} on {3}</span><br>" +
"<span class='date sub-text'><a href=\"Blab/Blab?blabid={4}\">{5} Comments</a></span>" +
"</div>" +
"</div></li>";
// Get the Database Connection
var returnTemplate = new StringBuilder();
using (var dbContext = new BlabberDB())
{
dbContext.Database.Connection.Open();
var listeningBlabs = dbContext.Database.Connection.CreateCommand();
listeningBlabs.CommandText = string.Format(sqlBlabsForMe, start, numResults);
listeningBlabs.Parameters.Add(new SqlParameter("@listener", username));
var blabsForMeResults = listeningBlabs.ExecuteReader();
while (blabsForMeResults.Read())
{
var blab = new Blab {PostDate = blabsForMeResults.GetDateTime(3)};
returnTemplate.Append(string.Format(template, blabsForMeResults.GetString(0), // username
blabsForMeResults.GetString(2), // blab content
blabsForMeResults.GetString(1), // blab name
blab.PostDateString, // timestamp
blabsForMeResults.GetInt32(5), // blabID
blabsForMeResults.GetInt32(4) // comment count
));
}
}
return returnTemplate.ToString();
}
//Class for testing the adding of a blab and getting a user by ID
public void Get_All_Blabs_BlabsExist()
{
Blab newBlab = new Blab();
newBlab.Message = "Hello, this is not Chris blabbing for the first time";
newBlab.UserID = "*****@*****.**";
IEnumerable <BaseEntity> allBlabs = _harness.GetAll();
int count = 0;
foreach (var blab in allBlabs)
{
count++;
}
bool hasItems = false;
if (count > 0)
{
hasItems = true;
}
Assert.AreEqual(hasItems, true);
}
public void TestAdd()
{
// Arrange
var harness = new InMemory();
var expected = new Blab {
Id = 1,
CreatedBy = -1,
CreatedDate = DateTime.Now,
LastModifiedBy = null,
LastModifiedDate = null,
Message = "This is a really cool app!",
UserId = 1
};
// Act
harness.Create(expected);
var actual = harness.Read(0);
// Assert
Assert.AreEqual(expected, actual);
}
public void Create(IDatum obj)
{
Blab blab = (Blab)obj;
try
{
DateTime DTTMNow = DateTime.Now;
string sql = "INSERT INTO Blab (SysID, Message, CreatedDTTM, UserID) VALUES('"
+ blab.Id + "', '"
+ blab.Message + "', '"
+ DTTMNow.ToString("yyyy-MM-dd HH:mm:ss") + "', '"
+ blab.user.Email + "')";
MySqlCommand command = new MySqlCommand(sql, connection);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new Exception(ex.ToString());
}
}
public void TestAddAndGetBlab()
{
//Arrange
string email = "*****@*****.**";
User mockUser = new User(email);
Blab blab = new Blab("Now is the time for, blabs...", mockUser);
//Act
_harness.Add(blab);
ArrayList actual = (ArrayList)_harness.GetByUserId(email);
//Assert
if (actual.Count == 1)
{
Assert.AreEqual(1, actual.Count);
}
else
{
Assert.AreNotEqual(1, actual.Count);
}
}
public BlabTest()
{
harness = new Blab();
}
public void TestConstructorWithMessage()
{
Blab blab = new Blab("This is my message");
Assert.AreEqual(blab.Message, "This is my message");
}
public void TestIdFail()
{
Blab newBlab = new Blab();
Assert.AreNotEqual(newBlab.Id, harness.Id);
}
public void Setup()
{
newUser = new User(userEmail);
newBlab = new Blab(blabMessage, newUser);
adapter = new BlabAdapter(new SqlBlab());
}
public void AddBlab(Blab blab)
{
_adapter.Add(blab);
}
public void Remove(Blab blab)
{
this.plugin.Delete(blab);
}
public void Delete(Blab blab)
{
blabPlugin.Delete(blab);
}
public Blab GetById(Blab blab)
{
return((Blab)blabPlugin.GetById(blab.Id));
}
public void Add(Blab blab)
{
blabPlugin.Create(blab);
}
public void TestDTTM()
{
Blab Expected = new Blab();
Blab Actual = new Blab();
Assert.AreEqual(Expected.DTTM.ToString(), Actual.DTTM.ToString());
}
/// <summary>
/// Deletes a blab
/// </summary>
/// <param name="blab">Blab to delete</param>
public void Remove(Blab blab)
{
Plugin.Delete(blab);
}
public void Add(Blab blab)
{
this.plugin.Create(blab);
}
public void AddBlab(Blab blab)
{
_repository.Insert(blab);
}
public void Update(Blab blab)
{
this.plugin.Update(blab);
}
public void Delete(IEntity obj)
{
Blab blab = (Blab)obj;
}
public ActionResult GetFeed()
{
if (IsUserLoggedIn() == false)
{
return(RedirectToLogin(HttpContext.Request.RawUrl));
}
var username = GetLoggedInUsername();
// Find the Blabs that this user listens to
var feedBlabs = new List <Blab>();
using (var dbContext = new BlabberDB())
{
dbContext.Database.Connection.Open();
var listeningBlabs = dbContext.Database.Connection.CreateCommand();
listeningBlabs.CommandText = string.Format(sqlBlabsForMe, 0, 10);
listeningBlabs.Parameters.Add(new SqlParameter("@listener", username));
var blabsForMeResults = listeningBlabs.ExecuteReader();
while (blabsForMeResults.Read())
{
var author = new Blabber
{
UserName = blabsForMeResults.GetString(0),
BlabName = blabsForMeResults.GetString(1)
};
var post = new Blab
{
Id = blabsForMeResults.GetInt32(5),
Content = blabsForMeResults.GetString(2),
PostDate = blabsForMeResults.GetDateTime(3),
CommentCount = blabsForMeResults.GetInt32(4),
Author = author
};
feedBlabs.Add(post);
}
}
// Find Blabs by this user
var myBlabs = new List <Blab>();
using (var dbContext = new BlabberDB())
{
dbContext.Database.Connection.Open();
var listeningBlabs = dbContext.Database.Connection.CreateCommand();
listeningBlabs.CommandText = sqlBlabsByMe;
listeningBlabs.Parameters.Add(new SqlParameter {
ParameterName = "@username", Value = username
});
var blabsByMeResults = listeningBlabs.ExecuteReader();
while (blabsByMeResults.Read())
{
var post = new Blab
{
Id = blabsByMeResults.GetInt32(3),
Content = blabsByMeResults.GetString(0),
PostDate = blabsByMeResults.GetDateTime(1),
CommentCount = blabsByMeResults.GetInt32(2),
};
myBlabs.Add(post);
}
}
return(View(new FeedViewModel
{
BlabsByMe = myBlabs,
BlabsByOthers = feedBlabs,
CurrentUser = username
}
));
}
public BlabTest()
{
blab = new Blab();
}
public void Update(IEntity obj)
{
Blab blab = (Blab)obj;
}
/// <summary>
/// Updates Blab
/// </summary>
/// <param name="blab">Blab to update</param>
public void Update(Blab blab)
{
Plugin.Update(blab);
}
//Constructor
public BlabTest()
{
this.harness = new Blab();
}
public void NewBlab(Blab blab)
{
BlabAdapter.Add(blab);
}
