public void DeleteContactContext(sp_VendorProjContact_DM InputContact)
{
using (VolTeerEntities context = new VolTeerEntities())
{
var VendorProjContactsToRemove = (from n in context.tblVendorProjContacts where n.VendorID == InputContact.VendorID
&& n.ProjectID == InputContact.ProjectID
&& n.ContactID == InputContact.ContactID select n).FirstOrDefault();
context.tblVendorProjContacts.Remove(VendorProjContactsToRemove);
context.SaveChanges();
}
}
public void TestVendorProjContactInsert()
{
//Test Our Read
sp_VendorProjContact_DM data = new sp_VendorProjContact_DM();
data.VendorID = new Guid();
bool insertPrimaryContact = true;
data.PrimaryContact = insertPrimaryContact;
sp_VendorProjContact_BLL contact = new sp_VendorProjContact_BLL();
contact.InsertContactContext(data);
Assert.AreEqual(insertPrimaryContact, data.PrimaryContact, "Primary Contact Not Set As Expected");
}
public Guid InsertContactContext(sp_VendorProjContact_DM InputContact)
{
using (VolTeerEntities context = new VolTeerEntities())
{
var NewContact = new tblVendorProjContact
{
VendorID = InputContact.VendorID,
ProjectID = InputContact.ProjectID,
ContactID = InputContact.ContactID,
PrimaryContact = InputContact.PrimaryContact
};
context.tblVendorProjContacts.Add(NewContact);
context.SaveChanges();
//Return the id of the newly created record
return NewContact.ContactID;
}
}
public void TestVendorProjContactDelete()
{
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "tblVendorProjContact.xlsx"));
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
Guid VendorID = new Guid(row["VendorID"].ToString());
Guid ProjectID = new Guid(row["ProjectID"].ToString());
Guid ContactID = new Guid(row["ContactID"].ToString());
sp_VendorProjContact_DM data = new sp_VendorProjContact_DM();
sp_VendorProjContact_BLL vend = new sp_VendorProjContact_BLL();
data.VendorID = VendorID;
data.ProjectID = ProjectID;
data.ContactID = ContactID;
vend.DeleteContactContext(data);
data = vend.ListContact(VendorID, ProjectID, ContactID);
Assert.AreEqual(false, data.PrimaryContact, "PrimaryContact not set as expected");
}
}
public void UpdateContactContext(sp_VendorProjContact_DM InputContact)
{
using (VolTeerEntities context = new VolTeerEntities())
{
var existingContact = context.tblVendorProjContacts.Find(InputContact.VendorID,
InputContact.ProjectID,
InputContact.ContactID,
InputContact.PrimaryContact);
if (InputContact != null)
{
existingContact.VendorID = InputContact.VendorID;
existingContact.ProjectID = InputContact.ProjectID;
existingContact.ContactID = InputContact.ContactID;
existingContact.PrimaryContact = InputContact.PrimaryContact;
context.SaveChanges();
}
}
}
public void TestVendorProjContactUpdate()
{
//Test Our Read
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "tblVendorProjContact.xlsx"));
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
bool updatePrimaryContact = Convert.ToBoolean(row["PrimaryContact"]);
string contactID = row["ContactID"].ToString();
string vendorID = row["VendorID"].ToString();
string projectID = row["ProjectID"].ToString();
sp_VendorProjContact_DM data = new sp_VendorProjContact_DM();
data.ContactID = new Guid(contactID);
data.PrimaryContact = updatePrimaryContact;
sp_VendorProjContact_BLL VendorProjContact = new sp_VendorProjContact_BLL();
VendorProjContact.UpdateContactContext(data);
data = VendorProjContact.ListContact(new Guid(vendorID), new Guid(projectID), new Guid(contactID));
Assert.AreEqual(updatePrimaryContact, data.PrimaryContact, "Primary Contact Not Set As Expected");
}
}
public void UpdateContactContext(sp_VendorProjContact_DM InputContact)
{
DAL.UpdateContactContext(InputContact);
}
public Guid InsertContactContext(sp_VendorProjContact_DM InputContact)
{
return DAL.InsertContactContext(InputContact);
}
public void DeleteContactContext(sp_VendorProjContact_DM InputContact)
{
DAL.DeleteContactContext(InputContact);
}
protected void saveForm()
{
sp_Project_DM projectDM = new sp_Project_DM();
sp_VendorProjContact_DM vpContactDM = new sp_VendorProjContact_DM();
vpContactDM.VendorID = (Guid)currentUser.ProviderUserKey;
Guid projectID = Guid.NewGuid();
vpContactDM.ProjectID = projectID;
int contectIndex = rCBContact.SelectedIndex;
if (rCBContact.SelectedIndex != 0)
{
vpContactDM.ContactID = contacts.ElementAt(rCBContact.SelectedIndex - 1).ContactID;
//we can't set a contact as primary if there isn't a contact selected
vpContactDM.PrimaryContact = cbPrimaryContact.Checked;
}
if (rCBAddress.SelectedIndex != 0)
{
projectDM.AddrID = addresses.ElementAt(rCBAddress.SelectedIndex - 1).AddrID;
}
projectDM.ProjectID = projectID;
projectDM.ProjectName = rTBProjName.Text;
projectDM.ProjectDesc = rTBProjDesc.Text;
projectDM.ActiveFlg = false;
sp_Project_BLL projectBLL = new sp_Project_BLL();
sp_VendorProjContact_BLL vpContactBLL = new sp_VendorProjContact_BLL();
//Why is it by ref? That's weird.
projectBLL.InsertProjectContext(ref projectDM);
vpContactBLL.InsertContactContext(vpContactDM);
}