private async Task <CompanyContacts> GetCompanyContactsMethod(long id) { var company = await _unitOfWork.CompanyRepository.Query. Include(c => c.Account.Location).SingleAsync(c => c.Id == id); if (company != null) { var companyContacts = new CompanyContacts { Id = company.Id, Title = company.Name, Contacts = company.Account?.Contacts.Select(x => new ContactShortDTO { Id = x.Id, Provider = x.Provider.Name, Type = x.Provider.Type, Value = x.Value }).ToList(), Location = new LocationDTO { Id = company.Account.Location.Id, Adress = company.Account.Location?.Adress ?? "default", City = company.Account.Location?.City ?? "default", Latitude = company.Account.Location?.Latitude ?? 0, Longitude = company.Account.Location?.Longitude ?? 0 } }; return(companyContacts); } return(null); }
private void Child_Insert(Company company, Companies entityCompany) { using (var manager = ObjectContextManager <RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { LoadProperty(CompanyIdProperty, company.CompanyId); RolodexEF.Ranks newRank = GetRank(ReadProperty(RankIdProperty)); var newContact = new CompanyContacts(); newContact.BaseSalary = ReadProperty(BaseSalaryProperty); var birthday = ReadProperty(BirthdayProperty); if (!birthday.IsEmpty) { newContact.Birthday = birthday.Date; } newContact.Companies = entityCompany; newContact.FirstName = ReadProperty(FirstNameProperty); newContact.LastName = ReadProperty(LastNameProperty); newContact.Ranks = newRank; LoadProperty(InitialRankIdProperty, ReadProperty(RankIdProperty)); if (ReadProperty(CompanyContactIdProperty) == 0) { newContact.PropertyChanged += entityContact_PropertyChanged; } DataPortal.UpdateChild(ReadProperty(ContactsPhonesProperty), this, newContact); } }
private void Child_Update(Company company, Companies entityCompany) { using (var manager = ObjectContextManager <RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { RolodexEF.Ranks newRank = GetRank(ReadProperty(RankIdProperty)); RolodexEF.Ranks oldRank = GetRank(ReadProperty(InitialRankIdProperty)); var newContact = new CompanyContacts(); newContact.CompanyContactId = ReadProperty(CompanyContactIdProperty); newContact.EntityKey = new System.Data.EntityKey("RolodexEntities.CompanyContacts", "CompanyContactId", ReadProperty(CompanyContactIdProperty)); manager.ObjectContext.Attach(newContact); entityCompany.CompanyContacts.Attach(newContact); oldRank.CompanyContacts.Attach(newContact); newContact.Ranks = newRank; newContact.BaseSalary = ReadProperty(BaseSalaryProperty); var birthday = ReadProperty(BirthdayProperty); if (!birthday.IsEmpty) { newContact.Birthday = birthday.Date; } else { newContact.Birthday = null; } newContact.FirstName = ReadProperty(FirstNameProperty); newContact.LastName = ReadProperty(LastNameProperty); DataPortal.UpdateChild(ReadProperty(ContactsPhonesProperty), this, newContact); } }
public void DeleteCompanyContact(Contact contact) { if (contact == null) { throw new ArgumentNullException(nameof(contact)); } _context.Contact.Remove(contact); //remove the company assignment CompanyContacts companyContacts = new CompanyContacts(); companyContacts.ContactId = contact.Id; DeleteCompanyContactsAssignment(companyContacts); //remove the site assignment SiteContacts siteContacts = new SiteContacts(); siteContacts.ContactId = contact.Id; DeleteSiteContactsAssignment(siteContacts); //remove the terminal assignment TerminalContacts terminalContacts = new TerminalContacts(); terminalContacts.ContactId = contact.Id; DeleteTerminalContactsAssignment(terminalContacts); }
public void CreateCompanyContactsAssignment(CompanyContacts companyContacts) { if (companyContacts == null) { throw new ArgumentNullException(nameof(companyContacts)); } _context.CompanyContacts.Add(companyContacts); }
private void Child_Fetch(CompanyContacts contact) { RaiseListChangedEvents = false; foreach (var item in contact.CompanyContactPhones) { Add(CompanyContactPhone.GetCompanyContactPhone(item)); } RaiseListChangedEvents = true; }
void entityContact_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e) { CompanyContacts entityContact = sender as CompanyContacts; if (e.PropertyName == CompanyContactIdProperty.Name) { LoadProperty(CompanyContactIdProperty, entityContact.CompanyContactId); entityContact.PropertyChanged -= entityContact_PropertyChanged; } }
private void Child_Fetch(CompanyContacts contact) { LoadProperty(CompanyIdProperty, contact.Companies.CompanyId); LoadProperty(CompanyContactIdProperty, contact.CompanyContactId); LoadProperty(FirstNameProperty, contact.FirstName); LoadProperty(LastNameProperty, contact.LastName); LoadProperty(BirthdayProperty, new SmartDate(contact.Birthday)); LoadProperty(RankIdProperty, contact.Ranks.RankId); LoadProperty(InitialRankIdProperty, contact.Ranks.RankId); LoadProperty(BaseSalaryProperty, contact.BaseSalary); LoadProperty(ContactsPhonesProperty, CompanyContactPhoneList.GetCompanyContactPhoneList(contact)); }
private void toolStripButton12_Click(object sender, EventArgs e) { if (companyContactsBindingSource.Count > 0) { using (var Dbconnection = new MCDEntities()) { using (System.Data.Entity.DbContextTransaction dbTran = Dbconnection.Database.BeginTransaction()) { try { //CRUD Operations CompanyContacts CC = (CompanyContacts)companyContactsBindingSource.Current; Individual CCFromCache = CurrentlySelectedCompany.Individuals.Where(a => a.IndividualID == CC.IndividualID).First(); // return one instance each entity by primary key var C = Dbconnection.Companies.FirstOrDefault(a => a.CompanyID == CurrentlySelectedCompany.CompanyID); var I = Dbconnection.Individuals.FirstOrDefault(a => a.IndividualID == CC.IndividualID); // call Remove method from navigation property for any instance C.Individuals.Remove(I); ////saves all above operations within one transaction Dbconnection.SaveChanges(); //commit transaction dbTran.Commit(); CurrentlySelectedCompany.Individuals.Remove(CCFromCache); this.refreshCompanyContacts(); } catch (Exception ex) { if (ex is DbEntityValidationException) { foreach (DbEntityValidationResult entityErr in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { MessageBox.Show(error.ErrorMessage, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show(ex.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } //Rollback transaction if exception occurs dbTran.Rollback(); } } }; } }
private void btnUpdateContact_Click(object sender, EventArgs e) { if (companyContactsBindingSource.Count > 0) { CompanyContacts CC = (CompanyContacts)companyContactsBindingSource.Current; Individual CCFromCache = CurrentlySelectedCompany.Individuals.Where(a => a.IndividualID == CC.IndividualID).First(); using (frmContactsAddUpdateContacts frm = new frmContactsAddUpdateContacts(CC.IndividualID, CCFromCache)) { frm.ShowDialog(); this.refreshCompanyContacts(); } } }
private void Child_Update(CompanyContact companyContact, CompanyContacts entityContact) { using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { CompanyContactPhones newContactPhone = new CompanyContactPhones(); newContactPhone.CompanyContactPhoneId = ReadProperty(CompanyContactPhoneIdProperty); newContactPhone.EntityKey = new System.Data.EntityKey("RolodexEntities.CompanyContactPhones", "CompanyContactPhoneId", ReadProperty(CompanyContactPhoneIdProperty)); manager.ObjectContext.Attach(newContactPhone); entityContact.CompanyContactPhones.Attach(newContactPhone); newContactPhone.FaxNumber = ReadProperty(FaxNumberProperty); newContactPhone.PhoneNumber = ReadProperty(PhoneNumberProperty); } }
private void Child_DeleteSelf(CompanyContact companyContact, CompanyContacts entityContact) { if (!this.IsNew) { using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { CompanyContactPhones deleted = new CompanyContactPhones(); deleted.CompanyContactPhoneId = ReadProperty(CompanyContactPhoneIdProperty); deleted.EntityKey = new System.Data.EntityKey("RolodexEntities.CompanyContactPhones", "CompanyContactPhoneId", deleted.CompanyContactPhoneId); manager.ObjectContext.Attach(deleted); entityContact.CompanyContactPhones.Attach(deleted); manager.ObjectContext.DeleteObject(deleted); } } }
private void btnRemoveStudentClientInfo_Click(object sender, EventArgs e) { using (var Dbconnection = new MCDEntities()) { using (System.Data.Entity.DbContextTransaction dbTran = Dbconnection.Database.BeginTransaction()) { try { //CRUD Operations CompanyContacts CC = (CompanyContacts)companyContactsBindingSource.Current; Individual CCFromCache = CurrentlySelectedCompany.Individuals.Where(a => a.IndividualID == CC.IndividualID).First(); CompanyContactDetails CD = (CompanyContactDetails)companyContactsDetailsBindingSource.Current; ContactDetail CDFromCache = CCFromCache.ContactDetails.Where(a => a.ContactDetailID == CD.ContactDetailID).First(); Dbconnection.ContactDetails.Attach(CDFromCache); Dbconnection.ContactDetails.Remove(CDFromCache); ////saves all above operations within one transaction Dbconnection.SaveChanges(); //commit transaction dbTran.Commit(); CCFromCache.ContactDetails.Remove(CDFromCache); this.refreshCompanyContactsDetails(); } catch (Exception ex) { if (ex is DbEntityValidationException) { foreach (DbEntityValidationResult entityErr in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { MessageBox.Show(error.ErrorMessage, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show(ex.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } //Rollback transaction if exception occurs dbTran.Rollback(); } } }; }
private void Child_DeleteSelf(Company company, Companies entityCompany) { if (!IsNew) { using (var manager = ObjectContextManager <RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { var deleted = new CompanyContacts(); deleted.CompanyContactId = ReadProperty(CompanyContactIdProperty); deleted.EntityKey = new System.Data.EntityKey("RolodexEntities.CompanyContacts", "CompanyContactId", deleted.CompanyContactId); manager.ObjectContext.Attach(deleted); entityCompany.CompanyContacts.Attach(deleted); manager.ObjectContext.DeleteObject(deleted); } } }
private void Child_Insert(CompanyContact companyContact, CompanyContacts entityContact) { using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { LoadProperty(CompanyContactIdProperty, companyContact.CompanyContactId); CompanyContactPhones newContactPhone = new CompanyContactPhones(); newContactPhone.FaxNumber = ReadProperty(FaxNumberProperty); newContactPhone.PhoneNumber = ReadProperty(PhoneNumberProperty); newContactPhone.CompanyContacts = entityContact; manager.ObjectContext.AddToCompanyContactPhones(newContactPhone); newContactPhone.PropertyChanged += newContactPhone_PropertyChanged; if (ReadProperty(CompanyContactIdProperty) == 0) { entityContact.PropertyChanged += entityContact_PropertyChanged; } } }
private void refreshCompanyContactsDetails() { using (var Dbconnection = new MCDEntities()) { CompanyContacts SelectedConact = (CompanyContacts)companyContactsBindingSource.Current; companyContactsDetailsBindingSource.DataSource = new CustomSortableBindingList <CompanyContactDetails>( (from a in CurrentlySelectedCompany.Individuals from b in a.ContactDetails where a.IndividualID == SelectedConact.IndividualID select new CompanyContactDetails() { ContactDetailID = b.ContactDetailID, ContactDetailValue = b.ContactDetailValue, ContactType = b.LookupContactType.ContactType, ContactTypeID = b.ContactTypeID } ).ToList <CompanyContactDetails>()); }; }
private void btnUpdateContactDetials_Click(object sender, EventArgs e) { if (this.companyContactsBindingSource.Count > 0) { CompanyContacts CC = (CompanyContacts)companyContactsBindingSource.Current; Individual CCFromCache = CurrentlySelectedCompany.Individuals.Where(a => a.IndividualID == CC.IndividualID).First(); CompanyContactDetails CD = (CompanyContactDetails)companyContactsDetailsBindingSource.Current; ContactDetail CDFromCache = CCFromCache.ContactDetails.Where(a => a.ContactDetailID == CD.ContactDetailID).First(); using (frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(CDFromCache.ContactDetailID)) { frm.CurrentDetail = CDFromCache; frm.ShowDialog(); if (frm.CurrentDetail != null) { CDFromCache.ContactDetailValue = frm.CurrentDetail.ContactDetailValue; } refreshCompanyContactsDetails(); } } }
public ActionResult AddEditCompanyContacts(CompanyContacts companyContacts) { if (ProjectSession.AdminRoleID != 3) { SuccessResult <AbstractCompanyContacts> result = null; result = abstractCompanyContactsServices.CompanyContactsUpsert(companyContacts); if (result.Code == 200 && result.Item != null) { TempData["openPopup"] = CommonHelper.ShowAlertMessageToastr(MessageType.success.ToString(), result.Message); } else { TempData["openPopup"] = CommonHelper.ShowAlertMessageToastr(MessageType.warning.ToString(), result.Message); } } else { TempData["openPopup"] = CommonHelper.ShowAlertMessageToastr(MessageType.danger.ToString(), "This user does not have the right to add or edit."); } return(RedirectToAction(Actions.Index, Pages.Controllers.CompanyContacts)); }
public void CreateCompanyContact(Guid companyId, Contact Contact) { if (companyId == Guid.Empty) { throw new ArgumentNullException(nameof(companyId)); } if (Contact == null) { throw new ArgumentNullException(nameof(Contact)); } //Contact.Id = Guid.NewGuid(); Contact.CompanyId = companyId; _context.Contact.Add(Contact); //Add to to CompanyContacts assignments CompanyContacts companyContacts = new CompanyContacts(); companyContacts.CompanyId = Contact.CompanyId; companyContacts.ContactId = Contact.Id; CreateCompanyContactsAssignment(companyContacts); }
public void AttachContacts(string phone, string email) { Contacts = new CompanyContacts(phone, email); }
internal static CompanyContactPhoneList GetCompanyContactPhoneList(CompanyContacts contact) { return(DataPortal.FetchChild <CompanyContactPhoneList>(contact)); }
private void btnAddContactInfo_Click(object sender, EventArgs e) { using (frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(0)) { frm.ShowDialog(); if (frm.CurrentDetail != null) { CompanyContacts CC = (CompanyContacts)companyContactsBindingSource.Current; Individual CCFromCache = CurrentlySelectedCompany.Individuals.Where(a => a.IndividualID == CC.IndividualID).First(); using (var Dbconnection = new MCDEntities()) { using (System.Data.Entity.DbContextTransaction dbTran = Dbconnection.Database.BeginTransaction()) { try { //CRUD Operations /* * this steps follow to both entities * * 1 - create instance of entity with relative primary key * * 2 - add instance to context * * 3 - attach instance to context */ // 1 Individual I = new Individual { IndividualID = CC.IndividualID }; // 2 Dbconnection.Individuals.Add(I); // 3 Dbconnection.Individuals.Attach(I); // 1 ContactDetail cd = new ContactDetail { ContactDetailID = frm.CurrentDetail.ContactDetailID }; // 2 Dbconnection.ContactDetails.Add(cd); // 3 Dbconnection.ContactDetails.Attach(cd); // like previous method add instance to navigation property I.ContactDetails.Add(cd); ////saves all above operations within one transaction Dbconnection.SaveChanges(); //commit transaction dbTran.Commit(); } catch (Exception ex) { if (ex is DbEntityValidationException) { foreach (DbEntityValidationResult entityErr in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { MessageBox.Show(error.ErrorMessage, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show(ex.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } //Rollback transaction if exception occurs dbTran.Rollback(); } } }; using (var Dbconnection = new MCDEntities()) { Dbconnection.ContactDetails.Attach(frm.CurrentDetail); Dbconnection.Entry(frm.CurrentDetail).Reference(a => a.LookupContactType).Load(); }; CCFromCache.ContactDetails.Add(frm.CurrentDetail); refreshCompanyContactsDetails(); } } }
public Organization AttachContacts(CompanyContacts companyContacts) { Contacts = companyContacts; return(this); }