public Boolean AddRecord(Dashboard testCaseData) { DashboardContext dashboardContext = new DashboardContext(); Dashboard logEntry = new Dashboard(); var vv = 0; try { if (testCaseData.LogId == 0) { logEntry.LogId = Convert.ToInt32(dashboardContext.AllLogEntries.Max(x => x.LogId) + 1); } ////logEntry.LogId = vv; logEntry.BugID = testCaseData.BugID; logEntry.Comment = testCaseData.Comment; logEntry.Extra_One = testCaseData.Extra_One; logEntry.Extra_Two = testCaseData.Extra_Two; logEntry.OutCome = testCaseData.OutCome; dashboardContext.Entry(logEntry).State = System.Data.Entity.EntityState.Added; dashboardContext.SaveChanges(); return(true); } catch (Exception ex) { ViewBag.Error = ex.Message; return(false); } }
public async Task <IActionResult> PutStore(int id, Store store) { if (id != store.Id) { return(BadRequest()); } _context.Entry(store).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StoreExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public Boolean UpdateLog(Dashboard testCaseData) { DashboardContext dashboardContext = new DashboardContext(); Dashboard logEntry = new Dashboard(); try { logEntry = dashboardContext.AllLogEntries.Where(logs => logs.LogId == testCaseData.LogId).FirstOrDefault(); if (testCaseData.LogId == 0) { logEntry.LogId = dashboardContext.AllLogEntries.Max(x => x.LogId) + 1; } logEntry.BugID = testCaseData.BugID; logEntry.Comment = testCaseData.Comment; logEntry.Extra_One = testCaseData.Extra_One; logEntry.Extra_Two = testCaseData.Extra_Two; logEntry.OutCome = testCaseData.OutCome; dashboardContext.Entry(logEntry).State = System.Data.Entity.EntityState.Modified; dashboardContext.SaveChanges(); return(true); } catch (Exception ex) { ViewBag.Error = ex.Message; return(false); } }
public void CreateUser(User user) { var entity = _context.Users.FirstOrDefault(g => g.Email == user.Email); if (entity == null) { _context.Add(user); } _context.Entry(entity).CurrentValues.SetValues(user); _context.SaveChanges(); }
public virtual bool Update(TEntity obj) { try { _db.Entry(obj).State = EntityState.Modified; _db.SaveChanges(); } catch (Exception) { return(false); } return(true); }
public Boolean DeleteRecord(Int32 logID) { try { DashboardContext dashboardContext = new DashboardContext(); Dashboard logEntry = new Dashboard(); logEntry = dashboardContext.AllLogEntries.Where(logs => logs.LogId == logID).FirstOrDefault(); dashboardContext.Entry(logEntry).State = System.Data.Entity.EntityState.Deleted; dashboardContext.SaveChanges(); return(true); } catch (Exception ex) { ViewBag.Error = ex.Message; return(false); } }
/// <summary> /// 조건에 맞는 데이터가 있으면 업데이트 그렇지 않으면 입력 /// </summary> public void SaveOrUpdateProfit(int parentId, int monthNumber, int profit) { var twelve = _context.Twelves.Where(t => t.ParentId == parentId && t.MonthNumber == monthNumber).SingleOrDefault(); if (twelve != null) { // Update twelve.Profit = profit; _context.Entry(twelve).State = Microsoft.EntityFrameworkCore.EntityState.Modified; // 수정 상태로 변경 _context.SaveChanges(); } else { // Insert var t = new Twelve() { ParentId = parentId, MonthNumber = monthNumber, Profit = profit }; _context.Twelves.Add(t); _context.SaveChanges(); } }
public virtual void Update(TEntity item) { _dbSet.Attach(item); _context.Entry(item).State = EntityState.Modified; }