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);
}
}
