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;
}
