//delete public void DeleteCaracteristiciModel(Guid ID) { //get exising record to delete Models.DbObjects.Caracteristici recordToDelete = dbContext.Caracteristicis.FirstOrDefault(x => x.ID_Caracteristica == ID); if (recordToDelete != null) { dbContext.Caracteristicis.DeleteOnSubmit(recordToDelete); dbContext.SubmitChanges(); } }
//update public void UpdateCaracteristiciModel(CaracteristiciModel caracteristiciModel) { //get existing record to update Models.DbObjects.Caracteristici existingModel = dbContext.Caracteristicis.FirstOrDefault(x => x.ID_Caracteristica == caracteristiciModel.ID_Caracteristica); if (existingModel != null) { //map updated values with keeping the orm reference existingModel.ID_Caracteristica = caracteristiciModel.ID_Caracteristica; existingModel.ID_TipCaracteristica = caracteristiciModel.ID_TipCaracteristica; existingModel.NumeCaracteristica = caracteristiciModel.NumeCaracteristica; dbContext.SubmitChanges(); } }
// map Model to ORM private Models.DbObjects.Caracteristici MapModelsToDbObject(CaracteristiciModel caracteristiciModel) { Models.DbObjects.Caracteristici dbCaracteristiciModel = new Models.DbObjects.Caracteristici(); if (dbCaracteristiciModel != null) { dbCaracteristiciModel.ID_Caracteristica = caracteristiciModel.ID_Caracteristica; dbCaracteristiciModel.ID_TipCaracteristica = caracteristiciModel.ID_TipCaracteristica; dbCaracteristiciModel.NumeCaracteristica = caracteristiciModel.NumeCaracteristica; return(dbCaracteristiciModel); } return(null); }
// map orm to model - mapper method private CaracteristiciModel MapDbObjectToModel(Models.DbObjects.Caracteristici dbCaracteristici) { CaracteristiciModel caracteristiciModel = new CaracteristiciModel(); if (dbCaracteristici != null) { caracteristiciModel.ID_Caracteristica = dbCaracteristici.ID_Caracteristica; caracteristiciModel.ID_TipCaracteristica = dbCaracteristici.ID_TipCaracteristica; caracteristiciModel.NumeCaracteristica = dbCaracteristici.NumeCaracteristica; return(caracteristiciModel); } return(null); }