public static void SaveTask(List <TaskVO> tasksRequest)
{
if (tasksRequest == null)
{
throw new ArgumentNullException(nameof(tasksRequest));
}
var tasksToUpdate = new List <TaskVO>();
for (int i = 1; i <= tasksRequest.Count; i++)
{
TaskVO task = tasksRequest[i - 1];
if (string.IsNullOrEmpty(task.firstName) ||
string.IsNullOrEmpty(task.lastName) ||
string.IsNullOrEmpty(task.task) ||
string.IsNullOrEmpty(task.status))
{
Console.WriteLine("TaskVO has NULL Value, error out..." + task);
}
else
{
task.tid = i.ToString();
tasksToUpdate.Add(task);
Console.WriteLine("Added To Update List =====> " + task);
}
}
Console.WriteLine("Task To Update Size : " + tasksToUpdate.Count);
TasksDAO.UpdateTasks(tasksToUpdate);
}
public NewTask(object[] args)
{
this.Font = new System.Drawing.Font(Font.Name, 8.25f * 96f / CreateGraphics().DpiX, Font.Style, Font.Unit, Font.GdiCharSet, Font.GdiVerticalFont);
this.AutoScaleMode = AutoScaleMode.None;
InitializeComponent();
listPriority = _priorityBLL.GetList();
listStatus = _statusBLL.GetList();
cbbPriority.Items.AddRange(listPriority.Select(p => new ComboboxItem()
{
Text = p.Name, Value = p.PriorityID
}).ToArray());
cbbStatus.Items.AddRange(listStatus.Select(p => new ComboboxItem()
{
Text = p.Name, Value = p.StatusID
}).ToArray());
task = new TaskVO();
if (args != null && args.Length == 1)
{
task = _taskBLL.GetById((int)args[0]);
UpdateTask();
}
else
{
btnReset.Visible = false;
}
}
public static List <TaskVO> GetIndividualTasks1()
{
//TaskVO task = new TaskVO();
var taskList = new List <TaskVO>();
DataSet taskResultSet = new DataSet();
taskResultSet = TasksDAO.RetrieveTasks1();
if (taskResultSet.Tables.Count > 0)
{
taskList = taskResultSet.Tables[0].AsEnumerable().Select(m => new TaskVO
{
tid = Convert.ToString(m["task_id"]),
firstName = Convert.ToString(m["first_name"]),
lastName = Convert.ToString(m["last_name"]),
task = Convert.ToString(m["task_name"]),
status = Convert.ToString(m["Status"]),
iteration = Convert.ToString(m["iteration"])
}).ToList();
}
Console.WriteLine("=====> Printing tasks list: " + taskList.Count());
for (int i = 0; i < taskList.Count(); i++)
{
TaskVO task = taskList[i];
Console.WriteLine("=====> Printing tasks: " + task);
}
return(taskList);
}
public static List <List <TaskVO> > GetIndividualTasks2()
{
//TaskVO task = new TaskVO();
var taskList = new List <List <TaskVO> >();
var iterationList = new List <TaskVO>();
var tempList = new List <TaskVO>();
iterationList = TasksDAO.RetrieveTasks();
Console.WriteLine("=====> Printing tasks list: " + iterationList.Count());
for (int i = 0; i < iterationList.Count(); i++)
{
TaskVO task = iterationList[i];
Console.WriteLine("=====> Printing tasks: " + task);
if (i % 2 == 0)
{
tempList.Add(task);
taskList.Add(tempList);
tempList = new List <TaskVO>();
}
else
{
tempList.Add(task);
}
}
Console.WriteLine("=====> Task list size: " + taskList.Count());
return(taskList);
}
public static void SaveTask1()
{
Console.WriteLine("=====> Starting Save Task1...");
List <TaskVO> tasks = new List <TaskVO>();
TaskVO task1 = new TaskVO();
TaskVO task2 = new TaskVO();
task1.firstName = "TestSave1";
task1.lastName = "Tester101";
task1.task = "Fun";
task1.status = "Enjoy";
task1.iteration = "Iteration1";
task1.tid = "1";
task2.firstName = "Funny";
task2.lastName = "Stuff";
task2.task = "LuLu";
task2.status = "OK";
task2.iteration = "Iteration1";
task2.tid = "2";
tasks.Add(task1);
tasks.Add(task2);
TasksDAO.UpdateTasks(tasks);
}
public static void UpdateTasks(List <TaskVO> taskList)
{
Console.WriteLine("=====> Starting Saving Tasks DAO...");
MySqlConnection mySqlConn = new MySqlConnection(connectionStr);
mySqlConn.Open();
for (int i = 0; i < taskList.Count; i++)
{
TaskVO taskToUpdate = taskList[i];
var updateTasksQuery = "UPDATE task SET first_name = @firstname, last_name = @lastname, task_name = @task, status = @status WHERE task_id = @tid";
MySqlCommand mySqlCmd = new MySqlCommand(updateTasksQuery, mySqlConn);
mySqlCmd.Parameters.AddWithValue("@firstname", taskToUpdate.firstName ?? " ");
mySqlCmd.Parameters.AddWithValue("@lastname", taskToUpdate.lastName ?? " ");
mySqlCmd.Parameters.AddWithValue("@task", taskToUpdate.task);
mySqlCmd.Parameters.AddWithValue("@status", taskToUpdate.status);
mySqlCmd.Parameters.AddWithValue("@tid", Int32.Parse(taskToUpdate.tid));
Console.WriteLine("=====> " + mySqlCmd.CommandText);
mySqlCmd.ExecuteNonQuery();
}
}
public ICallReportVO ProcessCallReport(ICallReportVO callReport, string action)
{
IUserVO loginUser = UserDAO.RetrieveUserByLoginId(callReport.LastUpdateBy);
if (callReport.Id == 0)
{
callReport.Owner = loginUser;
}
CallReportDAO.SaveCallReport(callReport);
ITaskVO task = TaskDAO.RetrieveTaskByRefIdAndFlowType(callReport.Id, WORKFLOW_TYPE);
if (task == null)
{
task = new TaskVO()
{
ReferenceId = callReport.Id, WorkflowType = WORKFLOW_TYPE
};
task.LastUpdateBy = callReport.LastUpdateBy;
task.Initiator = loginUser;
}
task.PreviousOwner = loginUser;
task.TaskAction = action;
task = WorkflowManager.ExecuteWorkflow(task, callReport.Reviewer);
TaskDAO.SaveTask(task);
callReport.Status = task.TaskStatus;
callReport.WorkflowProcessId = task.WorkflowProcessId;
callReport.TaskStatus = task.TaskStatus;
callReport.CurrentRecipient = UserDAO.RetrieveUserById(task.CurrentOwner.Id);
return(callReport);
}
public TaskVO Create(TaskVO task)
{
var departamentEntity = _converter.Parse(task);
departamentEntity = _repository.Create(_converter.Parse(task));
return(_converter.Parse(departamentEntity));
}
public TaskVO Update(TaskVO item)
{
var departamentntiry = _converter.Parse(item);
departamentntiry = _repository.Update(_converter.Parse(item));
return(_converter.Parse(departamentntiry));
}
public IActionResult Put([FromBody] TaskVO task)
{
if (task == null)
{
return(BadRequest());
}
return(new ObjectResult(_taskBusiness.Update(task)));
}
private void btnDeleteTask_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Você têm certeza, que deseja deletar esta tarefa", "Deletar Tarefa",
MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
int id = Convert.ToInt32(((PictureBox)sender).Tag);
TaskVO item = _taskBLL.GetById(id);
_taskBLL.Delete(item);
MessageBox.Show("Tarefa deletada com sucesso.");
loadTasks();
}
}
public static List <TaskVO> GetIndividualTasks()
{
//TaskVO task = new TaskVO();
var taskList = new List <TaskVO>();
taskList = TasksDAO.RetrieveTasks();
for (int i = 0; i < taskList.Count(); i++)
{
TaskVO task = taskList[i];
Console.WriteLine("=====> Printing tasks: " + task);
}
Console.WriteLine("=====> Task list size: " + taskList.Count());
return(taskList);
}
protected void DataGrid_DeleteCommand(object sender, GridCommandEventArgs e)
{
var editableItem = ((GridEditableItem)e.Item);
var taskID = (int)editableItem.GetDataKeyValue("Task_ID");
if (staff.Status_ID.Equals((int)Config.StaffStatus.OnJob) || staff.Status_ID.Equals((int)Config.StaffStatus.Active))
{
dh.DeleteTaskByID(taskID);
TaskVO task = dh.GetTaskByID(taskID);
WebHelper.CreateTaskLog(task);
DataGrid.MasterTableView.Rebind();
}
else
{
RadWindowManager.RadAlert("目前状态不能撤销任务", 300, 200, "操作结果", null);
}
}
public IActionResult AddTasks()
{
Console.WriteLine("=====> Adding Tasks Controller start...");
var tasksRequest = new List <TaskVO>();
for (int i = 1; i < 9; i++)
{
TaskVO task = new TaskVO
{
firstName = Request.Form["firstname" + i],
lastName = Request.Form["lastname" + i],
task = Request.Form["task" + i],
status = Request.Form["status" + i]
};
Console.WriteLine("=====> Getting Firstname :: " + task.firstName);
Console.WriteLine("=====> Getting Lastname :: " + task.lastName);
Console.WriteLine("=====> Getting Task :: " + task.task);
Console.WriteLine("=====> Getting Status :: " + task.status);
tasksRequest.Add(task);
Console.WriteLine("========= Added New TaskVO =========");
}
TaskService.SaveTask(tasksRequest);
var displayTasks = TaskService.GetIndividualTasks();
ViewBag.TaskMessage = "Manage Tasks in this page.";
ViewBag.Task1 = displayTasks[0];
ViewBag.Task2 = displayTasks[1];
ViewBag.Task3 = displayTasks[2];
ViewBag.Task4 = displayTasks[3];
ViewBag.Task5 = displayTasks[4];
ViewBag.Task6 = displayTasks[5];
ViewBag.Task7 = displayTasks[6];
ViewBag.Task8 = displayTasks[7];
return(View());
}
private Panel CreateTaskPanel(TaskVO task, int nSize)
{
Panel newPanel = new Panel {
AutoScroll = true,
BorderStyle = BorderStyle.FixedSingle,
Location = new Point(6, 45 + (186 * nSize)),
Size = new Size(1060, 177)
};
Label title = new Label {
AutoSize = true,
Font = new Font("Microsoft Sans Serif", 14F, FontStyle.Bold, GraphicsUnit.Point, ((byte)(0))),
Location = new Point(15, 12),
Size = new Size(165, 29),
Text = task.Name
};
Label statusPriority = new Label {
AutoSize = true,
Font = new Font("Microsoft Sans Serif", 7.8F, FontStyle.Italic, GraphicsUnit.Point, ((byte)(0))),
Location = new Point(17, 42),
Size = new Size(239, 17),
Text = "Prioridade: " + task.Priority.Name + " Status: " + task.Status.Name
};
Label description = new Label {
Location = new Point(17, 75),
Size = new Size(977, 82),
Text = task.Description
};
PictureBox delete = new PictureBox {
Anchor = ((AnchorStyles)((AnchorStyles.Top | AnchorStyles.Right))),
Cursor = Cursors.Hand,
Image = global::Tasklist.Properties.Resources.closeButton,
Location = new Point(1013, 3),
Size = new Size(40, 40),
TabStop = false,
Tag = task.TaskID
};
delete.Click += new EventHandler(btnDeleteTask_Click);
PictureBox edit = new PictureBox {
Anchor = ((AnchorStyles)((AnchorStyles.Top | AnchorStyles.Right))),
Cursor = Cursors.Hand,
Image = global::Tasklist.Properties.Resources.editButton,
Location = new Point(1013, 49),
Size = new Size(40, 40),
TabStop = false,
Tag = task.TaskID
};
edit.Click += new EventHandler(btnEditTask_Click);
newPanel.Controls.Add(title);
newPanel.Controls.Add(statusPriority);
newPanel.Controls.Add(description);
newPanel.Controls.Add(delete);
newPanel.Controls.Add(edit);
/*Resize Description*/
Size sz = new Size(description.Width, Int32.MaxValue);
sz = TextRenderer.MeasureText(description.Text, description.Font, sz, TextFormatFlags.WordBreak);
description.Height = sz.Height;
return(newPanel);
}
