public static TasksDTO getTaskByTaskId(int taskId)
{
ConnectionDatabase.getConnection();
string query = @"select * from tasks where id = @taskId";
SqlCommand cmd = new SqlCommand(query, ConnectionDatabase.conn);
cmd.Parameters.AddWithValue("@taskId", taskId);
IDataReader reader = cmd.ExecuteReader();
TasksDTO task = null;
while (reader.Read())
{
int id = Convert.ToInt32(reader["id"].ToString());
string taskTitle = reader["title"].ToString();
string taskStartDate = reader["startDate"].ToString();
string taskEndDate = reader["endDate"].ToString();
string taskStatus = reader["status"].ToString();
bool taskPrivate = Convert.ToBoolean(reader["private"]);
string urlFile = reader["urlFile"].ToString();
task = new TasksDTO(id, taskTitle, taskStartDate, taskEndDate, taskStatus, taskPrivate, urlFile);
}
ConnectionDatabase.closeConnection();
return(task);
}
public async Task <IActionResult> Put(int taskId, TasksDTO model)
{
try
{
var task = await _repository.GetTaskAsyncById(taskId, false);
if (task == null)
{
return(NotFound());
}
_mapper.Map(model, task);
_repository.Update(task);
if (await(_repository.SaveChangesAsync()))
{
return(Created($"/api/tasks/{model.Id}", _mapper.Map <TasksDTO>(task)));
}
}
catch (System.Exception)
{
return(this.StatusCode(StatusCodes.Status500InternalServerError, "Database failure"));
}
return(BadRequest());
}
protected void handleUpdateTaskDetail(object sender, EventArgs e)
{
// get info task
string titleTask = title.Text;
String startDateTask = startDate.Text;
String endDateTask = endDate.Text;
String statusTask = status.Value;
bool IsPrivate = privateScope.Checked;
TasksDTO newTask = new TasksDTO(task.ID, titleTask, startDateTask, endDateTask, statusTask, IsPrivate, task.urlFile);
// get list partner
List <int> arr = new List <int>();
foreach (GridViewRow row in usersGridView.Rows)
{
CheckBox checkBox = (CheckBox)row.FindControl("checkbox");
if (checkBox.Checked)
{
arr.Add(Int32.Parse(usersGridView.DataKeys[row.RowIndex].Value.ToString()));
}
}
TasksBLL.updateTask(newTask, arr);
Helper.Toast(this, Page.ClientScript, "success", "Update task success");
TasksBLL.expiringTask();
renderActionButtons();
getValueTask();
initValue();
renderActionButtons();
loadDisEnInput();
}
private void getValueTask()
{
TasksBLL.expiringTask();
int taskId = Convert.ToInt32(Request.QueryString["id"]);
task = TasksBLL.getTaskByTaskId(taskId);
}
public static int updateTask(TasksDTO task, List <int> arrPartnerId)
{
int ownerId = getOwnerByTaskId(task.ID);
ConnectionDatabase.getConnection();
// update task
string query = @"update tasks
set title=@title,startDate=@startDate,endDate=@endDate,status=@status,private=@private
where id=@taskId";
SqlCommand cmd = new SqlCommand(query, ConnectionDatabase.conn);
cmd.Parameters.AddWithValue("@title", task.Title);
cmd.Parameters.AddWithValue("@startDate", Convert.ToDateTime(task.startDate));
cmd.Parameters.AddWithValue("@endDate", Convert.ToDateTime(task.endDate));
cmd.Parameters.AddWithValue("@status", task.Status);
cmd.Parameters.AddWithValue("@private", task.Private);
cmd.Parameters.AddWithValue("@taskId", task.ID);
cmd.ExecuteNonQuery();
// remove all usersTasks by taskId
string sql = @"delete from usersTasks
where taskId = @taskId";
cmd = new SqlCommand(sql, ConnectionDatabase.conn);
cmd.Parameters.AddWithValue("@taskId", task.ID);
cmd.ExecuteNonQuery();
// add the owner into task
query = @"insert into usersTasks(userId, taskId, isOwner)
values (@userId, @taskId, 1)";
cmd = new SqlCommand(query, ConnectionDatabase.conn);
cmd.Parameters.AddWithValue("@userId", ownerId);
cmd.Parameters.AddWithValue("@taskId", task.ID);
cmd.ExecuteNonQuery();
// remove owner checked in arrPartnerId cause owner is inserted above
arrPartnerId.Remove(ownerId);
// add again by list partnerId
// add partner into task
for (int i = 0; i < arrPartnerId.Count; i++)
{
query = @"insert into usersTasks(userId, taskId, isOwner)
values (@userId, @taskId, 0)";
cmd = new SqlCommand(query, ConnectionDatabase.conn);
cmd.Parameters.AddWithValue("@userId", arrPartnerId[i]);
cmd.Parameters.AddWithValue("@taskId", task.ID);
cmd.ExecuteNonQuery();
}
ConnectionDatabase.closeConnection();
return(1);
}
public static int CreateTask(TasksDTO task, List <int> arrUser, int ownerId)
{
ConnectionDatabase.getConnection();
string query;
if (task.urlFile == null)
{
query = @"insert into tasks(title, startDate, endDate, status, private)
values(@title, @startDate, @endDate, @status, @private);
select MAX(id) FROM tasks";
}
else
{
query = @"insert into tasks(title, startDate, endDate, status, private, urlFile)
values(@title, @startDate, @endDate, @status, @private, @urlFile);
select MAX(id) FROM tasks";
}
SqlCommand cmd = new SqlCommand(query, ConnectionDatabase.conn);
cmd.Parameters.AddWithValue("@title", task.Title);
cmd.Parameters.AddWithValue("@startDate", Convert.ToDateTime(task.startDate));
cmd.Parameters.AddWithValue("@endDate", Convert.ToDateTime(task.endDate));
cmd.Parameters.AddWithValue("@status", task.Status);
cmd.Parameters.AddWithValue("@private", task.Private);
if (task.urlFile != null)
{
cmd.Parameters.AddWithValue("@urlFile", task.urlFile);
}
Int32 lastestId = (Int32)cmd.ExecuteScalar();
// add partner into task
for (int i = 0; i < arrUser.Count; i++)
{
query = @"insert into usersTasks(userId, taskId, isOwner)
values (@userId, @taskId, 0)";
cmd = new SqlCommand(query, ConnectionDatabase.conn);
cmd.Parameters.AddWithValue("@userId", arrUser[i]);
cmd.Parameters.AddWithValue("@taskId", lastestId);
cmd.ExecuteNonQuery();
}
// add the owner into task
query = @"insert into usersTasks(userId, taskId, isOwner)
values (@userId, @taskId, 1)";
cmd = new SqlCommand(query, ConnectionDatabase.conn);
cmd.Parameters.AddWithValue("@userId", ownerId);
cmd.Parameters.AddWithValue("@taskId", lastestId);
cmd.ExecuteNonQuery();
ConnectionDatabase.closeConnection();
return(1);
}
public ActionResult AddTaskInSession(TasksDTO task)
{
var list = TasksSession;
if (list.FindIndex(f => f.Name == task.Name) < 0)
{
list.Add(task);
TasksSession = list;
}
return(Success(TasksSession));
}
public ActionResult UpdateTask(TasksDTO task)
{
var list = TasksSession;
var toUpdate = list.FirstOrDefault(f => f.Name == task.Name);
if (toUpdate != null)
{
list.FirstOrDefault(f => f.Name == task.Name).Desc = task.Desc;
TasksSession = list;
}
;
return(Success(TasksSession));
}
public async Task <IActionResult> Post(TasksDTO model)
{
try
{
var task = _mapper.Map <Tasks>(model);
_repository.Add(task);
if (await(_repository.SaveChangesAsync()))
{
return(Created($"/api/tasks/{model.Id}", _mapper.Map <TasksDTO>(task)));
}
}
catch (System.Exception)
{
return(this.StatusCode(StatusCodes.Status500InternalServerError, "Database failure"));
}
return(BadRequest());
}
protected void HandleCreateTask(object sender, EventArgs e)
{
string titleTask = title.Text;
String startDateTask = startDate.Text;
String endDateTask = endDate.Text;
String statusTask = TaskStatus.InProgress;
bool IsPrivate = privateScope.Checked;
string urlFile = null;
if (fileInput.HasFile)
{
try
{
string fileName = Path.GetFileName(fileInput.FileName);
fileInput.SaveAs(Server.MapPath("~") + "/Upload/" + fileName);
urlFile = "/Upload/" + fileName;
} catch (Exception ex)
{
}
}
// find list selected user
List <int> arr = new List <int>();
foreach (GridViewRow row in usersGridView.Rows)
{
CheckBox checkBox = (CheckBox)row.FindControl("checkbox");
if (checkBox.Checked)
{
arr.Add(Int32.Parse(usersGridView.DataKeys[row.RowIndex].Value.ToString()));
}
}
TasksDTO task = new TasksDTO(titleTask, startDateTask, endDateTask, statusTask, IsPrivate, urlFile);
int ownerId = Convert.ToInt32(Session["id"].ToString());
TasksBLL.CreateTask(task, arr, ownerId);
TasksBLL.expiringTask();
GridViewTaskBind();
GridViewUserBind();
GridViewTasksDayOfWeek(null); // get current date time
Helper.Toast(this, Page.ClientScript, "success", "Create task sussess");
}
public IActionResult Index()
{
var statuses = _taskStatusService.GetAll();
var tasks = _taskService.GetAll(_userId);
var tasksTodo = tasks.Where(i => i.StatusId == (int)TaskStatusesDTO.ToDo);
var tasksInProgress = tasks.Where(i => i.StatusId == (int)TaskStatusesDTO.InProgress);
var tasksDone = tasks.Where(i => i.StatusId == (int)TaskStatusesDTO.Done);
TasksDTO tasksModel = new TasksDTO
{
TasksToDo = tasksTodo,
TasksInProgress = tasksInProgress,
TasksDone = tasksDone
};
return(View(tasksModel));
}
public static int CreateTask(TasksDTO task, List <int> arrUser, int ownerId)
{
return(TasksDAL.CreateTask(task, arrUser, ownerId));
}
public static int updateTask(TasksDTO task, List <int> arrPartnerId)
{
return(TasksDAL.updateTask(task, arrPartnerId));
}
