public void DeleteField(int id)
{
IdeaFieldsDao i = _ctx.IdeaFields.First(d => d.FieldId == id);
_ctx.IdeaFields.Remove(i);
_ctx.SaveChanges();
}
private Field ConvertFieldToDomain(IdeaFieldsDao dao)
{
return(new Field {
Id = dao.FieldId,
Idea = new Idea {
Id = dao.IdeaId
},
Text = dao.FieldText
});
}
private ClosedField ConvertClosedFieldToDomain(IdeaFieldsDao dao)
{
return(new ClosedField
{
Id = dao.FieldId,
Idea = new Idea {
Id = dao.IdeaId
},
Options = ExtensionMethods.StringToList(dao.FieldStrings)
});
}
private VideoField ConvertVideoFieldToDomain(IdeaFieldsDao dao)
{
return(new VideoField
{
Id = dao.FieldId,
Idea = new Idea {
Id = dao.IdeaId
},
Url = dao.Url
//UploadedImage = DTO.UploadedImage
});
}
private ImageField ConvertImageFieldToDomain(IdeaFieldsDao dao)
{
return(new ImageField
{
Id = dao.FieldId,
Idea = new Idea {
Id = dao.IdeaId
},
Url = dao.Url
//UploadedVideo= DTO.UploadedVideo
});
}
private MapField ConvertMapFieldToDomain(IdeaFieldsDao dao)
{
return(new MapField
{
Id = dao.FieldId,
Idea = new Idea {
Id = dao.IdeaId
},
LocationX = dao.LocationX,
LocationY = dao.LocationY
});
}
public void Update(Idea obj)
{
IdeasDao newIdea = ConvertToDao(obj);
IdeasDao foundIdea = _ctx.Ideas.First(i => i.IdeaId == obj.Id);
if (foundIdea != null)
{
foundIdea.Title = newIdea.Title;
foundIdea.Reported = newIdea.Reported;
foundIdea.ReviewByAdmin = newIdea.ReviewByAdmin;
foundIdea.Visible = newIdea.Visible;
foundIdea.VoteCount = newIdea.VoteCount;
foundIdea.RetweetCount = newIdea.RetweetCount;
foundIdea.ShareCount = newIdea.ShareCount;
foundIdea.Status = newIdea.Status;
foundIdea.VerifiedUser = newIdea.VerifiedUser;
foundIdea.DeviceId = newIdea.DeviceId;
foundIdea.IsDeleted = newIdea.IsDeleted;
_ctx.Ideas.Update(foundIdea);
}
if (obj.Field != null)
{
IdeaFieldsDao newTextField = ConvertToDao(obj.Field);
IdeaFieldsDao foundTextField = _ctx.IdeaFields.First(f => f.FieldId == obj.Field.Id);
if (foundTextField != null)
{
foundTextField.FieldText = newTextField.FieldText;
_ctx.IdeaFields.Update(foundTextField);
}
}
if (obj.Cfield != null)
{
IdeaFieldsDao newCField = ConvertToDao(obj.Cfield);
IdeaFieldsDao foundCField = _ctx.IdeaFields.First(f => f.FieldId == obj.Cfield.Id);
if (foundCField != null)
{
foundCField.FieldStrings = newCField.FieldStrings;
_ctx.IdeaFields.Update(foundCField);
}
}
if (obj.Mfield != null)
{
IdeaFieldsDao newMField = ConvertToDao(obj.Mfield);
IdeaFieldsDao foundMField = _ctx.IdeaFields.First(f => f.FieldId == obj.Mfield.Id);
if (foundMField != null)
{
foundMField.LocationX = newMField.LocationX;
foundMField.LocationY = newMField.LocationY;
foundMField.Url = newMField.Url;
_ctx.IdeaFields.Update(foundMField);
}
}
if (obj.Ifield != null)
{
IdeaFieldsDao newIField = ConvertToDao(obj.Ifield);
IdeaFieldsDao foundIField = _ctx.IdeaFields.First(f => f.FieldId == obj.Ifield.Id);
if (foundIField != null)
{
foundIField.Url = newIField.Url;
foundIField.UploadedImage = newIField.UploadedImage;
_ctx.IdeaFields.Update(foundIField);
}
}
if (obj.Vfield != null)
{
IdeaFieldsDao newVField = ConvertToDao(obj.Vfield);
IdeaFieldsDao foundVField = _ctx.IdeaFields.First(f => f.FieldId == obj.Vfield.Id);
if (foundVField != null)
{
foundVField.Url = newVField.Url;
foundVField.UploadedMedia = newVField.UploadedMedia;
_ctx.IdeaFields.Update(foundVField);
}
}
_ctx.SaveChanges();
}