// Methods public ModelResult Update() { using (var entities = new DB_SWQUALEntities()) { int actorId = SessionUtil.GetUserId(); using (var transaction = entities.Database.BeginTransaction()) { if (PlanId.HasValue) // Update { try { plan item = entities.plan.Find(PlanId.Value); item.name = name; item.objective = objective; item.problem = problem; item.steps = steps; item.update_date = DateTime.Now; entities.SaveChanges(); transaction.Commit(); return new ModelResult() { Success = true }; } catch(Exception ex) { transaction.Rollback(); return new ModelResult() { DisplayMessage = true, Message = Core.CoreFunction.InnermostException(ex), Success = false }; } } else // Insert { try { entities.plan.Add(new plan() { create_date = DateTime.Now, name = name, objective = objective, owner_id = actorId, problem = problem, steps = steps, update_date = update_date }); entities.SaveChanges(); transaction.Commit(); return new ModelResult() { Success = true }; } catch (Exception ex) { transaction.Rollback(); return new ModelResult() { DisplayMessage = true, Message = Core.CoreFunction.InnermostException(ex), Success = false }; } } } } }
public void Search(PlanSearch condition) { using (var entities = new DB_SWQUALEntities()) { Items = new _DatatableResponseModel(); var result = from o in entities.plan select o; Items.data = result.ToList().Skip(condition.start).Take(condition.length).Select(MediaItemSelector).Cast<object>().ToList(); Items.draw = condition.draw; Items.recordsFiltered = result.Count(); Items.recordsTotal = result.Count(); } }
// Methods public ModelResult Update() { using (var entities = new DB_SWQUALEntities()) { int actorId = SessionUtil.GetUserId(); using (var transaction = entities.Database.BeginTransaction()) { if (SampleId.HasValue) // Update { try { transaction.Commit(); return new ModelResult() { Success = true }; } catch (Exception ex) { transaction.Rollback(); return new ModelResult() { DisplayMessage = true, Message = Core.CoreFunction.InnermostException(ex), Success = false }; } } else // Insert { try { transaction.Commit(); return new ModelResult() { Success = true }; } catch (Exception ex) { transaction.Rollback(); return new ModelResult() { DisplayMessage = true, Message = Core.CoreFunction.InnermostException(ex), Success = false }; } } } } }