internal static IEvent GetEventsForCustId(string custId) { IEventCollection eventCollection = new EventCollection(); var query = string.Format(CURDQueries.Events.SelectEvents.ByCustId, custId); var sqlCommand = new SqlCommand(); sqlCommand.CommandText = query; using (var conn = new SqlConnection(connectionString)) { conn.Open(); sqlCommand.Connection = conn; using (var reader = sqlCommand.ExecuteReader()) { while (reader.Read()) { venue = reader["event_venue"].ToString(); date = reader["event_date"].ToString(); custId = reader["customer_id"].ToString(); occassionId = reader["occassion_id"].ToString(); isCanceled = reader["is_canceled"].ToString() == "1"; var date1 = DateTime.ParseExact(date, "yyyyMMdd", CultureInfo.InvariantCulture); var occassion = OccassionDao.GetOccassionByEventId(eventId); var giftE = GiftDao.GetExpectedGiftsForEvent(eventId); var giftR = GiftDao.GetRecievedGiftsForEvent(eventId); eventCollection.AddEvent(new Event(eventId, occassion, venue, date0, giftE, giftR, custId, isCanceled)); } } conn.Close(); } }
public void AddEvent_PositiveTest1() { eventCollection = new EventCollection(); var event1 = GetEvent(); var result = eventCollection.AddEvent(event1); Assert.IsTrue(result, "Failure in adding Event to collection"); }
public void GetEventsByCustId_NegativeTest1() { eventCollection = new EventCollection(); var event1 = GetEvent(); eventCollection.AddEvent(event1); var custList = eventCollection.GetEventsByCustId(Guid.NewGuid().ToString()); Assert.AreEqual(((EventCollection)custList).Count(), 0); }
public void GetEventsByCustId_PositiveTest1() { eventCollection = new EventCollection(); var event1 = GetEvent(); eventCollection.AddEvent(event1); var custList = eventCollection.GetEventsByCustId(dummyCustId); Assert.AreEqual(((EventCollection)custList).Count(), 1); }
public void AddEvent_NegativeTest2() { eventCollection = new EventCollection(); var event1 = GetEvent(); eventCollection.AddEvent(event1); var result = eventCollection.RemoveEvent(event1); Assert.IsTrue(result, "Event remove failed"); }
public void AddEvent_NegativeTest1() { eventCollection = new EventCollection(); var event1 = new Mock <IEvent>(); var result = false; var exceptionType = string.Empty; try { eventCollection.AddEvent(event1.Object); } catch (ArgumentException) { result = true; } catch (Exception e) { exceptionType = e.GetType().ToString(); } Assert.IsTrue(result, string.Format("Expected Exception ArgumentException not found got {0}", exceptionType)); }