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); }