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