public async Task <Category> GetAsync(long id)
{
var categories = await _context.Categories
.AsNoTracking()
.FirstOrDefaultAsync(x => x.Id == id);
if (categories == null)
{
return(null);
}
_context.Entry(categories).State = EntityState.Detached;
return(categories);
}
public async Task <News> GetAsync(long id)
{
var news = await _context.News
.AsNoTracking()
.FirstOrDefaultAsync(x => x.Id == id);
if (news == null)
{
return(null);
}
_context.Entry(news).State = EntityState.Detached;
return(news);
}
public IHttpActionResult PutWeeklySchedule(int id, WeeklySchedule weeklySchedule)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != weeklySchedule.Id)
{
return(BadRequest());
}
db.Entry(weeklySchedule).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!WeeklyScheduleExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <int> ArticleCommentPostComment(ArticleComment model)
{
CmsContext.Entry(model).State = EntityState.Added;
await CmsContext.SaveChangesAsync();
return(model.Id);
}
public async Task ArticleUpdate(Article model, string userId, int articleStatusId, List <int> articleCategoryArticle)
{
try
{
var items = CmsContext.Article.FirstOrDefault(p => p.Id == model.Id);
if (items != null)
{
model.LastEditBy = userId;
model.LastEditDate = DateTime.Now;
if (string.IsNullOrEmpty(items.Url))
{
items.Url = await CreateArticleURL(items.Id);
}
CmsContext.Entry(items).CurrentValues.SetValues(model);
await CmsContext.SaveChangesAsync();
//Insert articleCategoryArticle
await ArticleSetArticleCategory(model.Id, articleCategoryArticle);
}
}
catch
{
}
}
public IHttpActionResult PutPropertyTaskList(int id, PropertyTaskList propertyTaskList)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != propertyTaskList.Id)
{
return(BadRequest());
}
db.Entry(propertyTaskList).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PropertyTaskListExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <int> PostSetting(Setting model)
{
CmsContext.Entry(model).State = EntityState.Modified;
await CmsContext.SaveChangesAsync();
return(model.Id);
}
public async Task ProductUpdate(Product model, string userId, int productStatusId, List <int> productCategoryProduct)
{
try
{
await CmsContext.SaveChangesAsync();
var items = CmsContext.Product.FirstOrDefault(p => p.Id == model.Id);
if (items != null)
{
model.LastEditBy = userId;
model.LastEditDate = DateTime.Now;
if (string.IsNullOrEmpty(items.Url))
{
items.Url = await CreateProductURL(items.Id);
}
CmsContext.Entry(items).CurrentValues.SetValues(model);
await CmsContext.SaveChangesAsync();
//Insert productCategoryProduct
await ProductSetProductCategory(model.Id, productCategoryProduct);
}
}
catch (Exception ex)
{
}
}
public async Task <int> ArticleCommentStaffPostComment(ArticleCommentStaff model)
{
CmsContext.Entry(model).State = model.Id > 0 ? EntityState.Modified : EntityState.Added;
await CmsContext.SaveChangesAsync();
CmsContext.ChangeTracker.Clear();
return(model.Id);
}
public bool Delete <TEntity>(TEntity entity) where TEntity : class
{
Logger.DebugFormat("Delete<TEntity>(entity) - TEntity[{0}]", typeof(TEntity).Name);
try
{
cmsCtx.Entry <TEntity>(entity).State = EntityState.Deleted;
cmsCtx.SaveChanges();
}
catch (Exception ex)
{
Logger.Error("", ex);
errMsg = ex.Message;
return(false);
}
return(true);
}
public ActionResult Edit([Bind(Include = "BookId,BookName,BookContent")] Book book)
{
if (ModelState.IsValid)
{
db.Entry(book).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(book));
}
public ActionResult Edit([Bind(Include = "Id,name,position,visible")] Subject subject)
{
if (ModelState.IsValid)
{
db.Entry(subject).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(subject));
}
public TEntity Find(int key, bool isDetached)
{
TEntity entity = Find(key);
if (entity != null && isDetached)
{
context.Entry(entity).State = EntityState.Detached;
}
return(entity);
}
public ActionResult Edit([Bind(Include = "PostId,PostTitle,PostContent")] Post post)
{
if (ModelState.IsValid)
{
db.Entry(post).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(post));
}
public async Task <ActionResult <Page> > PutPage(int id, Page page)
{
if (id != page.Id)
{
return(BadRequest());
}
context.Entry(page).State = EntityState.Modified;
await context.SaveChangesAsync();
return(NoContent());
}
public async Task <int> UserNotiCreateNew(UserNotify model)
{
model.UserNotifyTypeId = 1;
model.CreateDate = DateTime.Now;
model.Readed = false;
model.ReadCount = 0;
model.ImageUrl = model.ImageUrl ?? "/assets/images/notidefault.jpg";
CmsContext.Entry(model).State = EntityState.Added;
await CmsContext.SaveChangesAsync();
return(model.Id);
}
/// <summary>
/// Edits the specified key.
/// </summary>
/// <param name="key">The key.</param>
/// <param name="entity">The entity.</param>
/// <param name="saveChanges">if set to <c>true</c> [save changes].</param>
/// <returns>`1.</returns>
/// <exception cref="System.NotImplementedException"></exception>
public TEntity Edit(TKey key, TEntity entity, bool saveChanges = true)
{
if (this.Exists(key))
{
Entities.Attach(entity);
_context.Entry <TEntity>(entity).State = EntityState.Modified;
if (saveChanges)
{
this.SaveChanges();
}
return(entity);
}
return(null);
}
// 傳入 (emps)
// Bind 是用來指定欲異動的欄位, 以防止 Over-Posting 攻擊
public ActionResult Edit([Bind(Include = "Id, Name, Mobile, Email, Department, Title")] EmployeesNew emps)
{
// 使用 ModelState.IsValid 判斷資料是否通過驗證
if (ModelState.IsValid)
{
// 將 emps 這個 Enitity狀態設為 Modified
db.Entry(emps).State = EntityState.Modified;
// 當SaveChange() 執行時, 會向 SQL Server 發出 Update 指令
db.SaveChanges();
// 返回首頁
return(RedirectToAction("Index"));
}
return(View(emps));
}
[ValidateAntiForgeryToken] //防止跨網站的請求攻擊
public ActionResult Edit([Bind(Include = "Id,Name,Mobile,Email,Department,Title")] Employee emp) //Endit=>負責處理Post的Action，Bind指定想要改變的欄位也防止over-posting攻擊
{
//用ModelState.IsValid判斷資料是否通過驗證
if (ModelState.IsValid)
{
//將emp這個Entity狀態設為Modified,
//當SaveChanges()執行時,會向SQL Server發出Update陳述式命令
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
//儲存完成後回到Employees的Index頁面
return(RedirectToAction("Index"));
}
//若未通過驗證，返回Form，直到正確
return(View(emp));
}
// PUT api/Task/5
public HttpResponseMessage PutTask(EventViewModel task)
{
if (ModelState.IsValid)
{
var eventTaskList = db.EventTaskLists.Include("Property").Include("Crew").FirstOrDefault(e => e.Id == task.OwnerID);
if (eventTaskList != null)
{
task.Title = eventTaskList.Property.Name + ", " + eventTaskList.Crew.Name;
}
var entity = new EventSchedule
{
Id = task.TaskID,
Title = task.Title,
StartTime = task.Start,
StartTimezone = task.StartTimezone,
EndTime = task.End,
EndTimezone = task.EndTimezone,
Description = task.Description,
RecurrenceRule = task.RecurrenceRule,
RecurrenceException = task.RecurrenceException,
RecurrenceID = task.RecurrenceID,
IsAllDay = task.IsAllDay,
EventTaskListId = task.OwnerID ?? 0
};
db.EventSchedules.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, new[] { task });
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = task.TaskID }));
return(response);
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public async Task <bool> ProductAttachInsert(List <ProductAttachFile> model)
{
try
{
foreach (var p in model)
{
CmsContext.Entry(p).State = EntityState.Added;
await CmsContext.SaveChangesAsync();
}
}
catch
{
return(false);
}
return(true);
}
public ResponseModel Eliminar(int id)
{
var rm = new ResponseModel();
try
{
using (var ctx = new CmsContext())
{
contenido.idContenido = id;
ctx.Entry(this).State = EntityState.Deleted;
ctx.SaveChanges();
rm.SetResponse(true);
}
}
catch (Exception)
{
throw;
}
return(rm);
}
public IHttpActionResult PutPropertyTaskListType(int id, PropertyTaskListType propertyTaskListType)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != propertyTaskListType.Id)
{
return(BadRequest());
}
var originalPropertyTaskListType = db.PropertyTaskListTypes
.Where(t => t.Id == propertyTaskListType.Id)
.Include(t => t.PropertyTaskHeaders)
.SingleOrDefault();
if (originalPropertyTaskListType == null)
{
return(NotFound());
}
var originalEntry = db.Entry(originalPropertyTaskListType);
originalEntry.CurrentValues.SetValues(propertyTaskListType);
foreach (var header in propertyTaskListType.PropertyTaskHeaders)
{
var originalHeader = originalPropertyTaskListType.PropertyTaskHeaders
.SingleOrDefault(h => h.Id == header.Id && h.Id != 0);
if (originalHeader != null)
{
if (string.IsNullOrWhiteSpace(header.Name))
{
db.PropertyTaskDetails.Where(d => d.PropertyTaskHeaderId == originalHeader.Id)
.ToList()
.ForEach(d => db.PropertyTaskDetails.Remove(d));
db.PropertyTaskHeaders.Remove(originalHeader);
}
else
{
var headerEntry = db.Entry(originalHeader);
headerEntry.CurrentValues.SetValues(header);
}
}
else
{
header.Id = 0;
originalPropertyTaskListType.PropertyTaskHeaders.Add(header);
}
}
foreach (var originalHeader in originalPropertyTaskListType.PropertyTaskHeaders.Where(h => h.Id != 0).Where(originalHeader => propertyTaskListType.PropertyTaskHeaders.All(h => h.Id != originalHeader.Id)).ToList())
{
db.PropertyTaskDetails.Where(d => d.PropertyTaskHeaderId == originalHeader.Id)
.ToList()
.ForEach(d => db.PropertyTaskDetails.Remove(d));
db.PropertyTaskHeaders.Remove(originalHeader);
}
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PropertyTaskListTypeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
