// Create a new State public State Create(State mState) { var result = 0; EDM.State edmState = StateMapper.MapOneDMtoEDM(mState); try { this._dbContext.States.Add(edmState); result = this._dbContext.SaveChanges(); // DbContext sets Id to the new Identity value. mState.Id = edmState.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(mState); }
// GetById public State GetById(int id) { EDM.State edmState = default(EDM.State); edmState = _dbContext.States .Where(edm => edm.Id == id).FirstOrDefault(); return(StateMapper.MapOneEDMtoDM(edmState)); }
public static EDM.State MapOneDMtoEDM(State mState) { EDM.State edmState = new EDM.State(); edmState.Id = mState.Id; edmState.Name = mState.Name; edmState.Code = mState.Code; edmState.ZipCodeRange = mState.ZipCodeRange; edmState.MarkedToDelete = bool.Parse(mState.MarkedToDelete); return edmState; }
public static EDM.State MapOneDMtoEDM(State mState) { EDM.State edmState = new EDM.State(); edmState.Id = mState.Id; edmState.Name = mState.Name; edmState.Code = mState.Code; edmState.ZipCodeRange = mState.ZipCodeRange; edmState.MarkedToDelete = bool.Parse(mState.MarkedToDelete); return(edmState); }
public static State MapOneEDMtoDM(EDM.State edmState) { State mState = new State(); mState.Id = edmState.Id; mState.Name = edmState.Name; mState.Code = edmState.Code; mState.ZipCodeRange = edmState.ZipCodeRange; mState.MarkedToDelete = edmState.MarkedToDelete.ToString(); return(mState); }
// Update an existing State public int Update(State mState) { var result = 0; EDM.State edmLoadedState = null; EDM.State edmState = StateMapper.MapOneDMtoEDM(mState); try { // Load object into context (entity framework) edmLoadedState = _dbContext.States.Where(edm => edm.Id == mState.Id).FirstOrDefault(); if (edmLoadedState == null) //not found? { throw new Exception("State not found to update"); } else { // Update _dbContext.Entry(edmLoadedState).CurrentValues.SetValues(edmState); } // 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 State public int Delete(int id) { var result = 0; EDM.State edmLoadedState = null; try { // Load object into context (entity framework) edmLoadedState = _dbContext.States.Where(edm => edm.Id == id).FirstOrDefault(); // Modify the context if (edmLoadedState == null) //not found? { throw new Exception("State not found to delete"); } else { // Delete this._dbContext.States.Remove(edmLoadedState); } // 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); }