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