public static PhoneCall MapDalInterfacePhoneCallToDataAccessPhoneCall(DalInterface.Models.PhoneCall iPhoneCall) { PhoneCall daPhoneCall = new PhoneCall(); daPhoneCall.Id = iPhoneCall.Id; daPhoneCall.SSN = iPhoneCall.SSN; daPhoneCall.MarkedToDelete = bool.Parse(iPhoneCall.MarkedToDelete); return daPhoneCall; }
public static Entity MapDalInterfaceEntityToDataAccessEntity(DalInterface.Models.Entity iEntity) { Entity daEntity = new Entity(); daEntity.Id = iEntity.Id; daEntity.FirstName = iEntity.FirstName; daEntity.LastName = iEntity.LastName; daEntity.MarkedToDelete = bool.Parse(iEntity.MarkedToDelete); return daEntity; }
public static DalInterface GetDalInterface() { DalInterface result = null; switch (Config.Instance.DBType) { case Config.DB_TYPE_MYSQL: result = mysqlInterface; break; case Config.DB_TYPE_SQLITE: result = sqliteInterface; break; case Config.DB_TYPE_SQLSERVER: result = sqlserverInterface; break; } return(result); }
// Create a new Entity public DalInterface.Models.Entity Create(DalInterface.Models.Entity iEntity) { var result = 0; Entity daEntity = EntityMapper.MapDalInterfaceEntityToDataAccessEntity(iEntity); try { this._dbContext.Entities.Add(daEntity); result = this._dbContext.SaveChanges(); // DbContext sets Id to the new Identity value. iEntity.Id = daEntity.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 iEntity; }
// Create a new PhoneCall public DalInterface.Models.PhoneCall Create(DalInterface.Models.PhoneCall iPhoneCall) { var result = 0; PhoneCall daPhoneCall = PhoneCallMapper.MapDalInterfacePhoneCallToDataAccessPhoneCall(iPhoneCall); try { this._dbContext.PhoneCalls.Add(daPhoneCall); result = this._dbContext.SaveChanges(); // DbContext sets Id to the new Identity value. iPhoneCall.Id = daPhoneCall.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 iPhoneCall; }
// Update an existing Entity public int Update(DalInterface.Models.Entity iEntity) { var result = 0; Entity daLoadedEntity = null; Entity daEntity = EntityMapper.MapDalInterfaceEntityToDataAccessEntity(iEntity); try { // Load object into context (entity framework) daLoadedEntity = _dbContext.Entities.Where(pc => pc.Id == iEntity.Id).FirstOrDefault(); if (daLoadedEntity == null) { //not found? throw new Exception("Entity not found to update"); } else { // Update _dbContext.Entry(daLoadedEntity).CurrentValues.SetValues(daEntity); } // 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; }
public DeviceDAL() { dh = new DALHelper(); di = DALFactory.GetDalInterface(); }
public DeviceSwitchDAL() { di = DALFactory.GetDalInterface(); }