public void Activate(int fieldOfWaterId)
{
using (var context = new IdeaPoolEntities())
{
FieldOfWater fieldOfWater = context
.FieldOfWaters
.Where(x => x.Id == fieldOfWaterId)
.Single();
fieldOfWater.IsActive = true;
context.Entry(fieldOfWater).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void Insert(FieldOfWaterDataObject fieldOfWater)
{
using (var context = new IdeaPoolEntities())
{
FieldOfWater other = context.FieldOfWaters.Where(x => x.Id == FIELDOFWATER_OTHER_ID).Single();
context
.FieldOfWaters
.Add(new FieldOfWater
{
CreatedByUserId = fieldOfWater.CreatedByUserId,
Name = fieldOfWater.Name,
Description = fieldOfWater.Description,
IsActive = true,
Order = other.Order // set the order to last but one
});
// Increment the order of other field of water to last
other.Order = other.Order + 1;
context.Entry(other).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}