public HttpResponseMessage put(int id, TASK task) { try { using (TaskEntities entities = new TaskEntities()) { var entity = entities.TASK.FirstOrDefault(e => e.TaskId == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Task doesnt exist")); } else { entity.AssignDate = task.AssignDate; entity.DueDate = task.DueDate; entity.ProjectId = task.ProjectId; entity.TaskName = task.TaskName; entity.Status = task.Status; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public bool UpdateTaskDetail([FromBody] Models.TaskDetails taskDetails) { var taskDetailsObj = Mapper.Map <Models.TaskDetails, DataAccessLayer.TaskDetail>(taskDetails); var status = TaskEntities.UpdateTaskDetail(taskDetailsObj); return(status); }
public JsonResult <Models.TaskDetails> GetTaskDetail(int id) { DataAccessLayer.TaskDetail TaskInfo = TaskEntities.GetTaskDetail(id); var task = new Models.TaskDetails(); Models.TaskDetails obj = Mapper.Map <DataAccessLayer.TaskDetail, Models.TaskDetails>(TaskInfo); return(Json <Models.TaskDetails>(obj)); }
public ActionResult UserTasks(string Name) { TaskEntities ORM = new TaskEntities(); ViewBag.Tasks = ORM.Tasks.Where(x => x.User.Name == Name).ToList(); return(View()); }
public TaskHub() { try { taskEntities = new TaskEntities(); } catch (Exception ex) { exceptionEncountered(ex); } }
public JsonResult <List <Models.TaskDetails> > GetAllTaskDetailsSorted(string sortBy, bool ascending) { List <DataAccessLayer.TaskDetail> prodList = TaskEntities.GetAllTasks().AsQueryable().OrderByPropertyName(sortBy, ascending).ToList(); var result = new List <DataAccessLayer.TaskDetail>(); var taskObject = Mapper.Map <List <DataAccessLayer.TaskDetail>, List <Models.TaskDetails> >(prodList); return(Json(taskObject)); }
// // GET: /Home/ public ActionResult Index() { TaskEntities db = new TaskEntities(); var list = db.TblStudents.ToList(); ViewBag.record = list; return(View()); }
public JsonResult <List <Models.TaskDetails> > GetAllTaskDetails() { List <DataAccessLayer.TaskDetail> taskList = TaskEntities.GetAllTasks(); List <Models.TaskDetails> tasks = new List <Models.TaskDetails>(); List <Models.TaskDetails> taskObj = Mapper.Map <List <DataAccessLayer.TaskDetail>, List <Models.TaskDetails> >(taskList); return(Json(taskObj)); }
public bool InsertTaskDetail([FromBody] Models.TaskDetails taskDetails) { bool status = false; if (ModelState.IsValid) { taskDetails.id = TaskEntities.GetMaxId() + 1; var taskDetailsObj = Mapper.Map <Models.TaskDetails, DataAccessLayer.TaskDetail>(taskDetails); status = TaskEntities.InsertTask(taskDetailsObj); } return(status); }
public HttpResponseMessage get() { try { using (TaskEntities entities = new TaskEntities()) { return(Request.CreateResponse(HttpStatusCode.OK, entities.TASK.ToList())); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult getActivities(int actid) { TaskEntities DbContext = new TaskEntities(); //activities.Add(activities); Receive receive = new Receive(); int id = Convert.ToInt32(Session["UserId"]); receive.UserId = id; receive.ReceiveTime = DateTime.Now; receive.ActId = actid; receiveBLL.Add(receive); return(Redirect(Url.Action("UserCenter", "Users", new { userid = Session["UserId"] }))); //Content("<script>alert('预约成功!');window.open('" + Url.Content("~/Student/Index") + "', '_blank')</script>"); }
//个人中心页面 public ActionResult UserCenter(int UserId) { TaskEntities DbContext = new TaskEntities(); UsersViewModel uv = new UsersViewModel(); int id = Convert.ToInt32(Session["UserId"]); var users = DbContext.Users.Where(c => c.UserId == id); uv.Users = users; ViewBag.UserId = UserId; //发动态 uv.Dynamics = dynamicsBLL.GetDAL().GetList(3, 1); //接取的兼职 var a = receiveBLL.GetDAL().getrecivebyuid(UserId); uv.Receive = a; return(View(uv)); }
public HttpResponseMessage post([FromBody] TASK task) { try { using (TaskEntities entities = new TaskEntities()) { entities.TASK.Add(task); entities.SaveChanges(); HttpResponseMessage message = Request.CreateResponse(HttpStatusCode.Created, task); message.Headers.Location = new Uri(Request.RequestUri + task.TaskId.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public JsonResult Status() { TaskEntities db = new TaskEntities(); var schedules = db.Schedule_t.ToList(); RedisClient rc = new RedisClient("192.168.1.70"); schedules.ForEach( p => { p.App = db.Application_t.First(p1 => p1.Uid == p.ApplicationUid); p.Status = rc.HGetAll("status_" + p.Uid.ToString()); } ); JsonResult result = new JsonResult(); result.Data = schedules; return(result); }
public JsonResult updateSchedule(Guid uid, string cron, int enable, string paras) { JsonResult result = new JsonResult(); try { TaskEntities db = new TaskEntities(); var old = db.Schedule_t.FirstOrDefault(p => p.Uid == uid); old.Paras = paras; old.Enable = enable; old.Cron = cron; db.SaveChanges(); result.Data = new { status = 1, msg = "成功修改" }; } catch (Exception ex) { result.Data = new { status = 0, msg = ex.ToString() }; } return(result); }
public JsonResult <List <Models.TaskDetails> > GetAllTaskDetailsFiltered([FromBody] SearchSortParameter request) { var result = TaskEntities.GetAllTasks(); List <DataAccessLayer.TaskDetail> prodList; IEnumerable <DataAccessLayer.TaskDetail> searchResult; if (!string.IsNullOrEmpty(request.Search)) { searchResult = result.Where(x => x.Task.Contains(request.Search)); } else { searchResult = result; } prodList = searchResult.AsQueryable().OrderByPropertyName(request.SortBy, request.Ascending).ToList(); var taskObj = Mapper.Map <List <DataAccessLayer.TaskDetail>, List <Models.TaskDetails> >(prodList); return(Json(taskObj)); }
public HttpResponseMessage get(int id) { try { using (TaskEntities entities = new TaskEntities()) { TASK task = entities.TASK.FirstOrDefault(e => e.TaskId == id); if (task != null) { return(Request.CreateResponse(HttpStatusCode.OK, task)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No entity with id " + id + "found!")); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public static void InitializeMembership() { //TaskEntities context = new TaskEntities(); //context.Database.Initialize(true); try { using (var context = new TaskEntities()) { if (!context.Database.Exists()) { context.Database.Initialize(true); } } if (!WebSecurity.Initialized) { WebSecurity.InitializeDatabaseConnection("DefaultConnection", "User", "UserId", "UserName", autoCreateTables: true); } } catch (Exception ex) { throw new InvalidOperationException("Database could not be initialized", ex); } }
public HttpResponseMessage delete(int id) { try { using (TaskEntities entities = new TaskEntities()) { var entity = entities.TASK.FirstOrDefault(e => e.TaskId == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Task doesnt exist")); } else { entities.TASK.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public TaskRepository(TaskEntities context) : base(context) { }
public TaskEntities Init() { return(dbContext ?? (dbContext = new TaskEntities())); }
public TasksController() { taskEntities = new TaskEntities(); }
public bool DeleteTaskDetail(int id) { var status = TaskEntities.DeleteTask(id); return(status); }
public GenericRepository(TaskEntities DBEntity) { _DBEntity = DBEntity; _DbSet = DBEntity.Set <Tbl_Entity>(); }