private bool tblUserExists(int id)
{
using (TaskDBEntities entities = new TaskDBEntities())
{
return(entities.tblUser.Count(e => e.UserID == id) > 0);
}
}
public IEnumerable <tblUser> Get()
{
using (TaskDBEntities entities = new TaskDBEntities())
{
return(entities.tblUser.ToList());
}
}
private bool TaskExists(int id)
{
using (TaskDBEntities entities = new TaskDBEntities())
{
return(entities.tblTask.Count(t => t.QuoteID == id) > 0);
}
}
// public HttpResponseMessage Get(int id)
public tblTask Get(int id)
{
using (TaskDBEntities entities = new TaskDBEntities())
{
var entity = entities.tblTask.FirstOrDefault(t => t.QuoteID == id);
if (entity != null)
{
//return 200 OK
//return Request.CreateResponse(HttpStatusCode.OK, entity);
return(entity);
}
else
{
var resp = new HttpResponseMessage(HttpStatusCode.NotFound)
{
Content = new StringContent(string.Format("No task with ID = {0}", id)),
ReasonPhrase = "Task ID Not Found"
};
throw new HttpResponseException(resp);
//return 404 not found
//return Request.CreateErrorResponse(HttpStatusCode.NotFound, "Task with ID=" + id.ToString() + " is not found.");
}
}
}
//[Route("DeleteTaskDetails")]
public HttpResponseMessage Delete(int id)
{
try
{
using (TaskDBEntities entities = new TaskDBEntities())
{
var entity = entities.tblTask.FirstOrDefault(t => t.QuoteID == id);
if (entity == null)
{
//return 404 not found
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Task with ID=" + id.ToString() + " is not found to delete."));
}
else
{
//delete the item
entities.tblTask.Remove(entity);
entities.SaveChanges();
//return 200 OK
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
//[Route("UpdateTaskDetails")]
public HttpResponseMessage Put(int id, [FromBody] tblTask newTask)
{
try {
using (TaskDBEntities entities = new TaskDBEntities())
{
var entity = entities.tblTask.FirstOrDefault(t => t.QuoteID == id);
if (entity == null)
{
//return 404 not found
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Task with ID=" + id.ToString() + " is not found to update."));
}
else
{
entity.QuoteType = newTask.QuoteType;
entity.ContactID = newTask.ContactID;
entity.TaskDescription = newTask.TaskDescription;
entity.TaskDueDate = newTask.TaskDueDate;
entity.TaskType = newTask.TaskType;
entities.SaveChanges();
//return 200 OK
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IHttpActionResult PuttblUser(int id, tblUser tblUser)
{
using (TaskDBEntities entities = new TaskDBEntities())
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblUser.UserID)
{
return(BadRequest());
}
entities.Entry(tblUser).State = EntityState.Modified;
try
{
entities.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblUserExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
}
//[NotImplExceptionFilter]
public IEnumerable <tblTask> Get()
{
using (TaskDBEntities entities = new TaskDBEntities())
{
//throw new NotImplementedException("This method is not implemented");
return(entities.tblTask.ToList());
}
}
protected override void Dispose(bool disposing)
{
using (TaskDBEntities entities = new TaskDBEntities())
{
if (disposing)
{
entities.Dispose();
}
base.Dispose(disposing);
}
}
private void DeleteAllTasks()
{
//Delete All tasks
TaskDBEntities taskDBEntities = new TaskDBEntities();
taskDBEntities.Database.ExecuteSqlCommand("Truncate table TaskDetails");
// foreach (var t in taskDao.GetAll())
// {
// taskDao.DeleteTask(t.TaskID);
// }
}
public tblUser tblUserValid(string userName, string password)
{
using (TaskDBEntities entities = new TaskDBEntities())
{
//Go to https://localhost:44350/api/users, post 请求并附加json格式的username和password。
//去tblUser里寻找是否有这个user
var user = entities.tblUser.FirstOrDefault(e => e.Username == userName && e.Password == password);
//bool ifValid = user!=null;
return(user);
}
}
public IHttpActionResult GetTasksByOwnerAndStatus(int id, int status)
{
using (TaskDBEntities entities = new TaskDBEntities())
{
var tasks = entities.Tasks.Where(t => (t.Owner == id) && (t.Status == status)).ToList();
if (tasks == null)
{
return(NotFound());
}
return(Ok(tasks));
}
}
public IHttpActionResult GetTasksByOwner(int id)
{
using (TaskDBEntities entities = new TaskDBEntities())
{
var tasks = entities.Tasks.Where(t => t.Owner == id).ToList();
if (tasks == null)
{
return(NotFound());
}
return(Ok(tasks));
}
}
public IHttpActionResult Get(int id)
{
using (TaskDBEntities entities = new TaskDBEntities())
{
var task = entities.Tasks.FirstOrDefault(t => t.ID == id);
if (task == null)
{
return(NotFound());
}
return(Ok(task));
}
}
public IHttpActionResult Get()
{
using (TaskDBEntities entities = new TaskDBEntities())
{
IEnumerable <Task> tasks = entities.Tasks.ToList();
if (tasks == null)
{
return(NotFound());
}
return(Ok(tasks));
}
//return Ok(mytasks.ToList());
}
public IHttpActionResult GetTasksByCategory(string category)
{
using (TaskDBEntities entities = new TaskDBEntities())
{
var tasks = entities.Tasks.Where(t => t.Category == category).ToList();
if (tasks == null)
{
return(NotFound());
}
return(Ok(tasks));
}
}
public void DeleteTask(int id)
{
TaskDBEntities taskDBEntities = new TaskDBEntities();
TaskDetails task = taskDBEntities.TaskDetails.SingleOrDefault(p => p.Task_ID == id);
var entry = taskDBEntities.Entry(task);
if (entry.State == System.Data.Entity.EntityState.Detached)
{
taskDBEntities.TaskDetails.Attach(task);
}
taskDBEntities.TaskDetails.Remove(task);
taskDBEntities.SaveChanges();
}
public TaskViewModel GetTask(int id)
{
string parentTask = "";
TaskDBEntities taskDBEntities = new TaskDBEntities();
var task = taskDBEntities.TaskDetails.SingleOrDefault(p => p.Task_ID == id);
if (task.Parent_ID != null)
{
parentTask = taskDBEntities.TaskDetails.SingleOrDefault(p => p.Task_ID == task.Parent_ID).Task_Description;
}
return(new TaskViewModel
(task.Task_ID, task.Task_Description, parentTask, task.Start_Date.ToShortDateString(), task.End_Date.ToShortDateString(), task.Priority));
}
public void AddTask(TaskViewModel taskVM)
{
TaskDBEntities taskDBEntities = new TaskDBEntities();
TaskDetails task = new TaskDetails();
task.Task_Description = taskVM.TaskName;
if (taskVM.ParentTaskName != null)
{
task.Parent_ID = taskDBEntities.TaskDetails.SingleOrDefault(p => p.Task_Description == taskVM.ParentTaskName).Task_ID;
}
task.Start_Date = Convert.ToDateTime(taskVM.Start_Date);
task.End_Date = Convert.ToDateTime(taskVM.End_Date);
task.Priority = taskVM.Priority;
taskDBEntities.TaskDetails.Add(task);
taskDBEntities.SaveChanges();
}
public void EditTask(TaskViewModel taskVM)
{
TaskDBEntities taskDBEntities = new TaskDBEntities();
TaskDetails task = taskDBEntities.TaskDetails.SingleOrDefault(p => p.Task_ID == taskVM.TaskID);
if (taskVM.ParentTaskName != null && taskVM.ParentTaskName != "")
{
task.Parent_ID = taskDBEntities.TaskDetails.SingleOrDefault(p => p.Task_Description == taskVM.ParentTaskName).Task_ID;
}
task.Start_Date = Convert.ToDateTime(taskVM.Start_Date);
task.End_Date = Convert.ToDateTime(taskVM.End_Date);
task.Priority = taskVM.Priority;
taskDBEntities.TaskDetails.Attach(task);
taskDBEntities.Entry(task).State = System.Data.Entity.EntityState.Modified;
taskDBEntities.SaveChanges();
}
public HttpResponseMessage AddTask([FromBody] Task task)
{
try
{
using (TaskDBEntities entities = new TaskDBEntities())
{
Task newTask = entities.Tasks.Add(task);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, newTask);
message.Headers.Location = new Uri(Request.RequestUri + newTask.ID.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage UpdateTask(int id, [FromBody] Task task)
{
try
{
using (TaskDBEntities entities = new TaskDBEntities())
{
var tsk = entities.Tasks.FirstOrDefault(t => t.ID == id);
if (tsk == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Task with Id = " + id.ToString() + " not found"));
}
if (task.Data != null)
{
tsk.Data = task.Data;
}
if (task.Category != null)
{
tsk.Category = task.Category;
}
if (task.Status != null)
{
tsk.Status = task.Status;
}
if (task.TaskOrder != null)
{
tsk.TaskOrder = task.TaskOrder;
}
if (task.Priority != null)
{
tsk.Priority = task.Priority;
}
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, tsk));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public List <TaskViewModel> GetAll()
{
string parentTask = "";
TaskDBEntities taskDBEntities = new TaskDBEntities();
//taskDBEntities.TaskDetails.Include(x => x.TaskDetail1);
List <TaskDetails> task = taskDBEntities.TaskDetails.ToList();
List <TaskViewModel> taskViewModelList = new List <TaskViewModel>();
foreach (var t in task)
{
parentTask = "";
if (t.Parent_ID != null)
{
parentTask = taskDBEntities.TaskDetails.SingleOrDefault(p => p.Task_ID == t.Parent_ID).Task_Description;
}
taskViewModelList.Add(new TaskViewModel
(t.Task_ID, t.Task_Description, parentTask, t.Start_Date.ToShortDateString(), t.End_Date.ToShortDateString(), t.Priority));
}
return(taskViewModelList);
}
public HttpResponseMessage Post([FromBody] tblTask newTask)
{
try {
using (TaskDBEntities entities = new TaskDBEntities())
{
entities.tblTask.Add(newTask);
entities.SaveChanges();
//show http status code response: 201 created
var message = Request.CreateResponse(HttpStatusCode.Created, newTask);
//create an instance of Uri of the newly created item
message.Headers.Location = new Uri(Request.RequestUri + newTask.QuoteID.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
//接收HTTP请求，验证用户名和密码。如果user valid，我们将token发回。
public IHttpActionResult Authenticate([FromBody] LoginRequest loginUser)
{
using (TaskDBEntities entities = new TaskDBEntities())
{
var loginResponse = new LoginResponse {
};
LoginRequest loginrequest = new LoginRequest {
};
loginrequest.Username = loginUser.Username.ToLower();
loginrequest.Password = loginUser.Password;
IHttpActionResult response;
HttpResponseMessage responseMsg = new HttpResponseMessage();
bool isUsernamePasswordValid = false;
//根据用户名、密码，到DB里查找
var user = entities.tblUser.FirstOrDefault(e => e.Username == loginrequest.Username && e.Password == loginrequest.Password);
if (loginUser != null)
{
isUsernamePasswordValid = user != null ? true : false;
}
// if credentials are valid
if (isUsernamePasswordValid)
{
string token = createToken(loginrequest.Username);
//return the token
return(Ok <string>(token));
//return Request.CreateResponse(HttpStatusCode.OK, Configuration.Formatters.JsonFormatter);
}
else
{
// if credentials are not valid send unauthorized status code in response
loginResponse.responseMsg.StatusCode = HttpStatusCode.Unauthorized;
response = ResponseMessage(loginResponse.responseMsg);
return(response);
//return Request.CreateResponse(HttpStatusCode.Unauthorized, "Invalid User", Configuration.Formatters.JsonFormatter);
}
}
}
public HttpResponseMessage Login([FromBody] string userName, string password)
{
using (TaskDBEntities entities = new TaskDBEntities())
{
try
{
tblUser user = tblUserValid(userName, password);
if (user == null)
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "Invalid User", Configuration.Formatters.JsonFormatter));
}
else
{
//AuthenticationModule authentication = new AuthenticationModule();
//string token = authentication.GenerateTokenForUser(user.Username, user.UserID);
return(Request.CreateResponse(HttpStatusCode.OK, Configuration.Formatters.JsonFormatter));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
}
public HttpResponseMessage DeleteTask(int id)
{
try
{
using (TaskDBEntities entities = new TaskDBEntities())
{
Task tsk = entities.Tasks.FirstOrDefault(t => t.ID == id);
if (tsk == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Task with Id = " + id.ToString() + " not found"));
}
else
{
entities.Tasks.Remove(tsk);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public void UpdateAddedTasks(string addedTasks)
{
if (addedTasks == null)
{
Response.Write("Unable to add task into Tasks Table");
return;
}
TaskDBEntities taskDB = new TaskDBEntities();
JavaScriptSerializer taskListSerilizer = new JavaScriptSerializer();
Task task = (Task)taskListSerilizer.Deserialize(addedTasks, typeof(Task));
taskDB.Tasks.Add(task);
taskDB.SaveChanges();
Response.Write("Task updated success");
}
public TaskBL()
{
tb = new TaskDBEntities();
}
public TaskBL(TaskDBEntities taskManager)
{
tb = taskManager;
}
public GenericRepository(TaskDBEntities context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
