// Create a new Person
        public Person Create(Person mPerson)
        {
            var result = 0;

            EDM.Person edmPerson = PersonMapper.MapOneDMtoEDM(mPerson);

            try {
                this._dbContext.People.Add(edmPerson);
                result = this._dbContext.SaveChanges();

                // DbContext sets Id to the new Identity value.
                mPerson.Id = edmPerson.Id;
            }
            catch (System.Data.UpdateException ex) {
                if (ex.InnerException != null && ex.InnerException is System.Data.SqlClient.SqlException &&
                    ((System.Data.SqlClient.SqlException)ex.InnerException).ErrorCode == 8152)
                {
                    throw ex.InnerException;
                }
                else
                {
                    throw ex;
                }
            }

            return(mPerson);
        }
        // GetById
        public Person GetById(int id)
        {
            EDM.Person edmPerson = default(EDM.Person);

            edmPerson = _dbContext.People
                        .Where(edm => edm.Id == id).FirstOrDefault();

            return(PersonMapper.MapOneEDMtoDM(edmPerson));
        }
        public static EDM.Person MapOneDMtoEDM(Person mPerson) {
            EDM.Person edmPerson = new EDM.Person();

			edmPerson.Id = mPerson.Id;
			edmPerson.SSN = mPerson.SSN;
			edmPerson.BirthDate = DateTime.Parse(mPerson.BirthDate);
			edmPerson.State = mPerson.State;
			edmPerson.ZipCode = mPerson.ZipCode;
			edmPerson.MarkedToDelete = bool.Parse(mPerson.MarkedToDelete);

            return edmPerson;
        }
Ejemplo n.º 4
0
        public static EDM.Person MapOneDMtoEDM(Person mPerson)
        {
            EDM.Person edmPerson = new EDM.Person();

            edmPerson.Id             = mPerson.Id;
            edmPerson.SSN            = mPerson.SSN;
            edmPerson.BirthDate      = DateTime.Parse(mPerson.BirthDate);
            edmPerson.State          = mPerson.State;
            edmPerson.ZipCode        = mPerson.ZipCode;
            edmPerson.MarkedToDelete = bool.Parse(mPerson.MarkedToDelete);

            return(edmPerson);
        }
Ejemplo n.º 5
0
        public static Person MapOneEDMtoDM(EDM.Person edmPerson)
        {
            Person mPerson = new Person();

            mPerson.Id             = edmPerson.Id;
            mPerson.SSN            = edmPerson.SSN;
            mPerson.BirthDate      = edmPerson.BirthDate.ToShortDateString();
            mPerson.State          = edmPerson.State;
            mPerson.ZipCode        = edmPerson.ZipCode;
            mPerson.MarkedToDelete = edmPerson.MarkedToDelete.ToString();

            return(mPerson);
        }
        // Update an existing Person
        public int Update(Person mPerson)
        {
            var result = 0;

            EDM.Person edmLoadedPerson = null;
            EDM.Person edmPerson       = PersonMapper.MapOneDMtoEDM(mPerson);

            try {
                // Load object into context (entity framework)
                edmLoadedPerson = _dbContext.People.Where(edm => edm.Id == mPerson.Id).FirstOrDefault();

                if (edmLoadedPerson == null)   //not found?
                {
                    throw new Exception("Person not found to update");
                }
                else
                {
                    // Update
                    _dbContext.Entry(edmLoadedPerson).CurrentValues.SetValues(edmPerson);
                }

                // Save in data access (entity framework)
                result = this._dbContext.SaveChanges();
            }
            catch (System.Data.UpdateException ex) {
                if (ex.InnerException != null && ex.InnerException is System.Data.SqlClient.SqlException &&
                    ((System.Data.SqlClient.SqlException)ex.InnerException).ErrorCode == 8152)
                {
                    throw ex.InnerException;
                }
                else
                {
                    throw ex;
                }
            }

            return(result);
        }
        // Delete an existing Person
        public int Delete(int id)
        {
            var result = 0;

            EDM.Person edmLoadedPerson = null;

            try {
                // Load object into context (entity framework)
                edmLoadedPerson = _dbContext.People.Where(edm => edm.Id == id).FirstOrDefault();

                // Modify the context
                if (edmLoadedPerson == null)   //not found?
                {
                    throw new Exception("Person not found to delete");
                }
                else
                {
                    // Delete
                    this._dbContext.People.Remove(edmLoadedPerson);
                }

                // Save in data access (entity framework)
                result = this._dbContext.SaveChanges();
            }
            catch (System.Data.UpdateException ex) {
                if (ex.InnerException != null && ex.InnerException is System.Data.SqlClient.SqlException &&
                    ((System.Data.SqlClient.SqlException)ex.InnerException).ErrorCode == 8152)
                {
                    throw ex.InnerException;
                }
                else
                {
                    throw ex;
                }
            }

            return(result);
        }