public void DeactivateRespondentType(RespondentDTO deactivatedRespondentType) { using (var context = new MSSContext()) { var respondentType = context.respondenttypes.Find(deactivatedRespondentType.respondenttypeid); respondentType.activeyn = false; var existingRespondentType = context.Entry(respondentType); existingRespondentType.State = EntityState.Modified; context.SaveChanges(); } }
public void UpdateRespondentType(RespondentDTO updatedRespondentType) { using (var context = new MSSContext()) { var respondentType = context.respondenttypes.Find(updatedRespondentType.respondenttypeid); respondentType.respondenttypename = updatedRespondentType.respondenttypename; var existingRespondenType = context.Entry(respondentType); existingRespondenType.State = EntityState.Modified; context.SaveChanges(); } }
public void AddRespondentType(RespondentDTO tempRespondentType) { using (var context = new MSSContext()) { respondenttype newRespondentType = new respondenttype(); newRespondentType.respondenttypeid = tempRespondentType.respondenttypeid; newRespondentType.respondenttypename = tempRespondentType.respondenttypename; newRespondentType.activeyn = true; context.respondenttypes.Add(newRespondentType); context.SaveChanges(); } }
public List <RespondentDTO> GetAllRespondentTypes() { using (var context = new MSSContext()) { List <RespondentDTO> types = new List <RespondentDTO>(); var respondentTypes = (from aRespondentType in context.respondenttypes select aRespondentType).ToList(); foreach (var item in respondentTypes) { RespondentDTO temp = new RespondentDTO(); temp.respondenttypeid = item.respondenttypeid; temp.respondenttypename = item.respondenttypename; temp.activeyn = item.activeyn; types.Add(temp); } return(types); } }