public IHttpActionResult PutNews(int id, News news)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != news.ID)
{
return(BadRequest());
}
News queryNews = db.News.Where(n => n.ID == news.ID).FirstOrDefault();
db.Entry(queryNews).CurrentValues.SetValues(news);
db.Entry(queryNews).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!NewsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutOrganizationMember(int id, OrganizationMember organizationMember)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != organizationMember.ID)
{
return(BadRequest());
}
db.Entry(organizationMember).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!OrganizationMemberExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutEventComment(int id, EventComment eventComment)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != eventComment.ID)
{
return(BadRequest());
}
db.Entry(eventComment).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EventCommentExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutEvent(int id, Event @event)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != @event.ID)
{
return(BadRequest());
}
db.EventVolunteerTypes.RemoveRange(db.EventVolunteerTypes.Where(e => e.EventID == @event.ID));
db.EventVolunteerTypes.AddRange(@event.EventVolunteerTypes);
db.Entry(@event).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EventExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutConfiguaration(int id, Configuration configuaration)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != configuaration.ID)
{
return(BadRequest());
}
db.Entry(configuaration).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ConfiguarationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ServiceResult <TR01A> Update(TR01A entity)
{
var errMsg = "";
using (var trans = _Entity.Database.BeginTransaction(IsolationLevel.Snapshot))
{
try
{
if (entity.TR01A_ID == 0)
{
_Entity.Entry(entity).State = EntityState.Added;
}
else
{
_Entity.Entry(entity).State = EntityState.Modified;
}
var result = _Entity.SaveChanges();
trans.Commit();
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
foreach (var eve in ex.EntityValidationErrors)
{
errMsg = string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
errMsg += "<br />" + string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
}
catch (Exception ex)
{
errMsg = new MSSQL().GetSQLMessage(ex);
}
}
return(new ServiceResult <TR01A>()
{
Data = entity, Message = errMsg
});
}
