public async Task <List <TaskViewModels> > Get()
{
using (SqlConnection db = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["wmsConnection"].ConnectionString))
{
await db.OpenAsync();
SqlCommand command = db.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = "select * from wmwhse1.taskdetail where status <>'9' and tasktype='PK' order by status desc,ORDERKEY desc,TASKDETAILKEY desc ";
SqlDataReader reader = await command.ExecuteReaderAsync();
List <TaskViewModels> list = new List <TaskViewModels>();
while (await reader.ReadAsync())
{
TaskViewModels item = new TaskViewModels();
list.Add(item);
item.TaskKey = reader["TASKDETAILKEY"].ToString();
item.OrderKey = reader["ORDERKEY"].ToString();
item.Owner = reader["USERKEY"].ToString();
item.Qty = Convert.ToInt32(reader["QTY"]);
item.Sku = reader["SKU"].ToString();
item.Status = reader["STATUS"].ToString();
item.Store = reader["STORERKEY"].ToString();
item.StartTime = Convert.ToDateTime(reader["STARTTIME"]);
}
db.Close();
return(list);
}
}
public void AddTask()
{
string taskDescription = _taskToAdd;
//TaskItemField is empty
if (taskDescription == null || taskDescription.Replace(" ", String.Empty) == "")
{
return;
}
//TaskItemDescription is not already uses, case-insensitive
if (TaskViewModels.Any(t => t.Description.Equals(taskDescription, StringComparison.CurrentCultureIgnoreCase) &&
t.CreatedDateTime.Date == TrackingDate.Date))
{
return;
}
// Insert new task to database
TaskItem newTask = _dbGateway.InsertNewTask(taskDescription, Utilities.ConvertToUnixTime(TrackingDate));
// Update collection
TaskViewModels.Add(new TaskViewModel(newTask, _dbGateway));
// Clear user input
TaskToAdd = "";
}
private void frmAddEditTask_Load(object sender, EventArgs e)
{
IRepository <Task> taskRepository = new ToDoListRepositoryTaskEF();
List <Task> tasks = taskRepository.SelectAll();
List <TaskViewModels> tasksViewModels = new List <TaskViewModels>();
foreach (var task in tasks)
{
var taskViewModel = new TaskViewModels()
{
Id = task.Id,
Name = task.Name,
DateTime = task.DateTime,
CategoryId = task.CategoryId,
Category = task.Category.Name,
Notes = task.Notes
};
tasksViewModels.Add(taskViewModel);
}
cmbCategory.DataSource = tasksViewModels;
cmbCategory.DisplayMember = "Name";
cmbCategory.ValueMember = "Id";
cmbCategory.Refresh();
}
public void DeleteTask(TaskViewModel task)
{
// Ignore delete if task is currently being tracked
if (task == _trackedTask)
{
return;
}
// Delete task from database
_dbGateway.DeleteTask(task.MainTask);
// Remove task from collection
TaskViewModels.Remove(task);
}
public ActionResult Details(int?taskId)
{
if (taskId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TaskViewModels task = null;
using (var client = new HttpClient())
{
//client.BaseAddress = new Uri("http://localhost:65076/api");
//client.DefaultRequestHeaders.Accept.Clear();
//client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
string token = "";
if (Session["accessToken"] != null)
{
token = (string)Session["accessToken"];
}
else
{
return(RedirectToAction("Login", "User"));
}
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token);
string url_api = "http://localhost:65076/api/Task/" + taskId + "/details";
//HTTP GET
var responseTask = client.GetAsync(url_api);
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <TaskViewModels>();
readTask.Wait();
task = readTask.Result;
}
else //web api sent error response
{
//log response status here..
task = new TaskViewModels();
ModelState.AddModelError(string.Empty, "Server error. Please contact administrator.");
}
}
return(View(task));
}
public IActionResult CreateTask([FromQuery] TaskViewModels model)
{
try
{
context.Tasks.Add(_mapper.Map <Tasks>(model));
context.SaveChanges();
return(Ok(new ResponseModels {
Success = true, Message = "Create task succeed"
}));
}
catch (Exception e)
{
Logger.Error(e.Message);
return(StatusCode(500, new ResponseModels {
Success = false, Message = "Something went wrong"
}));
}
}
private void LoadTasks()
{
IRepository <Task> taskRepository = new ToDoListRepositoryTaskEF();
List <Task> tasks = taskRepository.SelectAll();
List <TaskViewModels> taskViewModels = new List <TaskViewModels>();
foreach (var task in tasks)
{
TaskViewModels taskViewModel = new TaskViewModels
{
Id = task.Id,
Name = task.Name,
DateTime = task.DateTime,
CategoryId = task.CategoryId,
Notes = task.Notes,
Category = task.Category.Name
};
taskViewModels.Add(taskViewModel);
dgvTask.DataSource = taskViewModels;
dgvTask.Refresh();
}
}
public static TaskViewModels ConvertTableToView(t_task model)
{
TaskViewModels view = new TaskViewModels();
return(view);
}
