public void DeleteConsultant(ConsultantItem consultantItem)
        {
            var entity = new Consultant
            {
                ConsultantID = consultantItem.ConsultantID
            };

            db.Consultants.Attach(entity);
            db.Consultants.Remove(entity);
            db.SaveChanges();
        }
        public void CreateConsultant(ConsultantItem consultantItem)
        {
            var entity = new Consultant
            {
                FirstName = consultantItem.FirstName,
                LastName  = consultantItem.LastName,
                Id        = consultantItem.Id
            };

            db.Consultants.Add(entity);
            db.SaveChanges();
            consultantItem.ConsultantID = entity.ConsultantID;
        }
        public void UpdateConsultant(ConsultantItem consultantItem)
        {
            var entity = new Consultant
            {
                ConsultantID = consultantItem.ConsultantID,
                FirstName    = consultantItem.FirstName,
                LastName     = consultantItem.LastName,
                Id           = consultantItem.Id
            };

            db.Consultants.Attach(entity);
            db.Entry(entity).State = EntityState.Modified;
            db.SaveChanges();
        }