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