public void TestProjectEventContactCreate()
{
bool PrimaryContact = true;
var ProjectEventContact_bll = new sp_ProjectEventContact_BLL();
var ProjectEventContact_dm = new sp_ProjectEventContact_DM();
var ProjectEvent_bll = new sp_ProjectEvent_BLL();
var Contact_bll = new sp_Contact_BLL();
ProjectEventContact_dm.PrimaryContact = PrimaryContact;
var allProjectEvents = ProjectEvent_bll.ListEvents();
Assert.IsTrue(allProjectEvents.Count > 0, "The ListEvents() is broken, or no data in DB");
ProjectEventContact_dm.EventID = allProjectEvents[0].EventID;
var allContacts = Contact_bll.ListContacts();
Assert.IsTrue(allContacts.Count > 0, "The ListContacts() is broken, or no data in DB");
ProjectEventContact_dm.ContactID = allContacts[0].ContactID;
ProjectEventContact_bll.InsertProjectEventContactContext(ProjectEventContact_dm);
var ProjectEventContact_dm_selected = ProjectEventContact_bll.ListEventsContacts(
ProjectEventContact_dm.EventID,
ProjectEventContact_dm.ContactID);
Assert.AreEqual(1, ProjectEventContact_dm_selected.Count);
Assert.IsTrue(Equals(ProjectEventContact_dm, ProjectEventContact_dm_selected[0]));
}
public void DeleteProjectEventContactContext(sp_ProjectEventContact_DM InputProjectEventContact)
{
using (VolTeerEntities context = new VolTeerEntities())
{
var ProjectEventContactToRemove = (from n in context.tblProjectEventContacts
where (n.EventID == InputProjectEventContact.EventID && n.ContactID == InputProjectEventContact.ContactID)
select n).FirstOrDefault();
context.tblProjectEventContacts.Remove(ProjectEventContactToRemove);
context.SaveChanges();
}
}
public void UpdateProjectEventContactContext(sp_ProjectEventContact_DM InputProjectEventContact)
{
using (VolTeerEntities context = new VolTeerEntities())
{
var existingProjectEventContact = context.tblProjectEventContacts.Find(InputProjectEventContact.EventID);
if (InputProjectEventContact != null)
{
existingProjectEventContact.EventID = InputProjectEventContact.EventID;
existingProjectEventContact.ContactID = InputProjectEventContact.ContactID;
existingProjectEventContact.PrimaryContact = InputProjectEventContact.PrimaryContact;
context.SaveChanges();
}
}
}
public Guid InsertProjectEventContactContext(sp_ProjectEventContact_DM InputProjectEventContact)
{
using (VolTeerEntities context = new VolTeerEntities())
{
var NewProjectEventContact = new tblProjectEventContact
{
EventID = InputProjectEventContact.EventID,
ContactID = InputProjectEventContact.ContactID,
PrimaryContact = InputProjectEventContact.PrimaryContact
};
context.tblProjectEventContacts.Add(NewProjectEventContact);
context.SaveChanges();
//Return the id of the newly created record
return NewProjectEventContact.EventID;
}
}
private static bool Equals(sp_ProjectEventContact_DM dm1, sp_ProjectEventContact_DM dm2)
{
return (dm1.ContactID == dm2.ContactID &&
dm1.EventID == dm2.EventID &&
dm1.PrimaryContact == dm2.PrimaryContact
);
}
private static List<sp_ProjectEventContact_DM> DMsFrom(DataTable dataTable)
{
var DMs = new List<sp_ProjectEventContact_DM>();
for (int i = 0; i < dataTable.Rows.Count; i++)
{
var returnProjectEventContact = new sp_ProjectEventContact_DM();
returnProjectEventContact.ContactID = new Guid((string)dataTable.Rows[i]["ContactID"]);
returnProjectEventContact.EventID = new Guid((String)dataTable.Rows[i]["EventID"]);
returnProjectEventContact.PrimaryContact = Convert.ToBoolean(dataTable.Rows[i]["PrimaryContact"]);
DMs.Add(returnProjectEventContact);
}
return DMs;
}
