public async Task <IActionResult> Edit(int id, [Bind("TaskId,TextTask,DateTask,CompleteTask,UserId")] TaskTable taskTable)
{
if (id != taskTable.TaskId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(taskTable);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TaskTableExists(taskTable.TaskId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["UserId"] = new SelectList(_context.User, "Id", "Id", taskTable.UserId);
return(View(taskTable));
}
public IHttpActionResult PutTaskTable(int id, TaskTable taskTable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != taskTable.TaskID)
{
return(BadRequest());
}
db.Entry(taskTable).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TaskTableExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private void deleteButton_Click(object sender, RoutedEventArgs e)
{
TaskTable selectedTask = (TaskTable)todogrid.SelectedItem;
if (selectedTask != null)
{
using (var context = new ScheduleUpDBEntities())
{
context.Entry(selectedTask).State = EntityState.Deleted;
context.SaveChanges();
}
todoTaskTable.Remove(selectedTask);
todogrid.ItemsSource = null;
todogrid.ItemsSource = todoTaskTable;
}
else
{
var message = "You didn't pick any task";
if ((TaskTable)donegrid.SelectedItem != null)
{
message = "Can not delete task in \"DONE\" status. Please change task status as \"ToDo\" or \"InProgress\" and try deleting again.";
}
MessageBox.Show(message, "Alert", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void done_button_Click(object sender, RoutedEventArgs e)
{
TaskTable selectedTask = (TaskTable)todogrid.SelectedItem;
todoTaskTable.Remove(selectedTask);
if (selectedTask != null)
{
using (var context = new ScheduleUpDBEntities())
{
var updateTask = context.TaskTable.Where(x => x.TaskID == selectedTask.TaskID).FirstOrDefault();
updateTask.TaskStatu = "Done";
context.SaveChanges();
doneTaskTable.Add(updateTask);
}
todogrid.ItemsSource = null;
todogrid.ItemsSource = todoTaskTable;
donegrid.ItemsSource = null;
donegrid.ItemsSource = doneTaskTable;
}
else
{
var message = "Nothing Selected From Active Tasks Table";
MessageBox.Show(message, "Alert", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public IHttpActionResult InsertGetTaskTable(string jsonModel)
{
TaskTable oData = Newtonsoft.Json.JsonConvert.DeserializeObject <TaskTable>(jsonModel);
var index = _taskTableService.Add(oData);
return(Ok(index > 0 ? "ok" : "no"));
}
protected override void OnCreate(Bundle savedInstanceState)
{
try
{
base.OnCreate(savedInstanceState);
_task = Rep.DatabaseHelper.Tasks.Enumerator.Current;
var category = Rep.DatabaseHelper.Tasks.GetCategory(_task.CategoryId);
SetContentView(Resource.Layout.ImageCard);
_image = FindViewById <ImageView>(Resource.Id.imageCardView);
var imageIdentifier = this.Resources.GetIdentifier(category.Image, "drawable", this.PackageName);
_image.SetImageResource(imageIdentifier);
var text = FindViewById <TextView>(Resource.Id.textCard);
text.SetTypeface(Rep.FontManager.Get(Font.BankirRetro), TypefaceStyle.Normal);
text.Text = _task.TaskName;
_contentFrameLayout = FindViewById(Resource.Id.contentFrameLayout);
_contentFrameLayout.Click += ContentFrameLayoutOnClick;
}
catch (Exception exception)
{
GaService.TrackAppException(this.Class, "OnCreate", exception, false);
base.OnBackPressed();
}
}
public IHttpActionResult PostTaskTable(TaskTable taskTable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.TaskTables.Add(taskTable);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (TaskTableExists(taskTable.TaskID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = taskTable.TaskID }, taskTable));
}
private void DoneButton_Click(object sender, EventArgs e)
{
if (MetroFramework.MetroMessageBox.Show(this, "Are you sure task is done? This action is irrevocable and it will remove the task from the list..", "Proceed?", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
Bunifu.Framework.UI.BunifuImageButton selecteddonebutton = (Bunifu.Framework.UI.BunifuImageButton)sender;
int getRowDone = TaskTable.GetRow(selecteddonebutton);
var getPlayPauseButton = (Bunifu.Framework.UI.BunifuImageButton)TaskTable.GetControlFromPosition(2, getRowDone);
if (getPlayPauseButton.Tag.ToString() == "Played")
{
PlayPauseButton_Click(getPlayPauseButton, e);
}
using (var conn = new MySqlConnection(ConnectionString))
{
conn.Open();
using (MySqlCommand cmd = conn.CreateCommand())
{
var getTaskLabelText = (Label)TaskTable.GetControlFromPosition(0, getRowDone);
cmd.CommandText = "UPDATE `tbl_tasks` SET `isDone` = '1', `timestampUpdated` = NOW() WHERE `taskName` = @taskname AND `userID` = @userid AND `isDone` = '0' LIMIT 1;";
cmd.Parameters.AddWithValue("@userid", SetUser.Text);
cmd.Parameters.AddWithValue("@taskname", getTaskLabelText.Text);
if (cmd.ExecuteNonQuery() != 0)
{
getPlayPauseButton.Tag = "Stopped";
getPlayPauseButton.Image = new Bitmap(Properties.Resources.CircledPlay_34px);
TaskTable.RowStyles[getRowDone].Height = 0F;
}
else
{
MetroFramework.MetroMessageBox.Show(this, "Cannot set the task to done! Please check db connection and try again!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
public ActionResult RetrivingTaks(TaskTable Taskies)
{
TaskListEntities ORM = new TaskListEntities();
ViewBag.Tasks = ORM.TaskTables.ToList();
return(View());
}
public bool Update(int taskId, TaskTable tasks)
{
try
{
var query = (from update in db.Tasks.Where(x => x.TaskId == taskId)
select update).SingleOrDefault();
if (query != null)
{
query.TaskId = taskId;
query.ParentTask = !string.IsNullOrEmpty(tasks.ParentTask)
? tasks.ParentTask : string.Empty;
query.StartDate = tasks.StartDate;
query.EndDate = tasks.EndDate;
query.Priority = tasks.Priority;
query.TaskName = !string.IsNullOrEmpty(tasks.TaskName)
? tasks.TaskName : string.Empty;
query.ProjectId = tasks.ProjectId;
query.UserId = tasks.UserId;
db.Entry(query).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception)
{
return(false);
}
return(true);
}
public HomeController(ILogger <HomeController> logger, Helper helper, UserTable ut, TenantTable tt,
UserManager <User> userManager, SignInManager <User> signInManager,
UserManager <GlobalUser> sharedUserManager, SignInManager <GlobalUser> sharedSignInManager,
NewTenantProcedure newTenant, IAuthorizationService auth, ServiceOrderTable serviceOrderTable, NotificationTable notificationTable, TaskTable taskTable)
{
_logger = logger;
_helper = helper;
_ut = ut;
_tt = tt;
_serviceOrderTable = serviceOrderTable;
_newTenant = newTenant;
UserMgr = userManager;
SignInMgr = signInManager;
SharedUserMgr = sharedUserManager;
SharedSignInMgr = sharedSignInManager;
_authorization = auth;
_notificationTable = notificationTable;
_taskTable = taskTable;
}
void ReleaseDesignerOutlets()
{
if (TaskTable != null)
{
TaskTable.Dispose();
TaskTable = null;
}
if (TaskTitle != null)
{
TaskTitle.Dispose();
TaskTitle = null;
}
if (SaveButton != null)
{
SaveButton.Dispose();
SaveButton = null;
}
if (DeleteButton != null)
{
DeleteButton.Dispose();
DeleteButton = null;
}
}
private void ElapsedTimer_Tick(object sender, EventArgs e)
{
if (DateTime.Compare(DateTime.Today, currentDate) > 0 && notified == true)
{
notified = false;
NotifiedLabel.Text = "False";
currentDate = DateTime.Now.Date;
}
if (TaskTable.RowCount > 0)
{
bool isthereRunning = false;
for (int i = 0; i < TaskTable.RowCount - 2; i++)
{
var onPlayedIncrement = (Bunifu.Framework.UI.BunifuImageButton)TaskTable.GetControlFromPosition(2, i);
if (onPlayedIncrement != null)
{
if (onPlayedIncrement.Tag.ToString() == "Played")
{
isthereRunning = true;
var incrementTimer = (Label)TaskTable.GetControlFromPosition(1, i);
incrementTimer.Text = TimeSpan.Parse(incrementTimer.Text).Add(TimeSpan.FromSeconds(1)).ToString();
}
}
}
if (DateTime.Compare(DateTime.Now, Convert.ToDateTime("17:30:00")) >= 0 && DateTime.Compare(DateTime.Now, Convert.ToDateTime("17:30:02")) <= 0 && notified == false && isthereRunning == true)
{
notified = true;
NotifiedLabel.Text = "True";
RunAutoSave();
MetroFramework.MetroMessageBox.Show(this, "Time is already 5:30, Auto pause task executed.", "Attention!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
public ActionResult AddTask(TaskAttachment taskAttachment)
{
try
{
TaskTable task = taskAttachment.Task;
db.AddTask.Add(task);
List <int> attachmentIDs = new List <int>();
bool result = db.SaveChanges() > 0 ? true : false;
if (result)
{
foreach (var item in taskAttachment.Attachment)
{
db.Attachments.Add(new AttachmentModel
{
FK_TypeID = item.FK_TypeID,
FK_ItemID = task.ID,
Title = item.Title,
Content = item.Content,
CreationDate = item.CreationDate,
FK_CreatedBy = item.FK_TypeID,
});
bool result2 = db.SaveChanges() > 0 ? true : false;
}
}
return(Ok(new { id = task.ID /*, AttachmentIDs = taskAttachment.Attachment*/ }));
}
catch
{
return(BadRequest());
}
}
private void unselectAll_()
{
previewTranCon_.Reset();
TaskTable.Clear();
taskElemsToRows_.Clear();
rowsToTasks_.Clear();
}
public ActionResult DeleteConfirmed(int id)
{
TaskTable taskTable = db.TaskTables.Find(id);
db.TaskTables.Remove(taskTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult UpdateTask(string UpdateTaskies)
{
TaskListEntities ORM = new TaskListEntities();
TaskTable item = ORM.TaskTables.Find(UpdateTaskies);
return(View(item));
}
internal void PopulateTasks(string tableName)
{
var table = new TaskTable(tableName, this.Db);
foreach (var task in this.Tasks)
{
table.Add(task);
}
}
public async Task <TaskModel> AddTask(TaskModel task)
{
var taskRow = new TaskTable()
{
Id = task.Id, Name = task.Name, Status = task.Status
};
await _taskRepository.Create(taskRow);
return(task);
}
public ActionResult DeleteTask(string TaskNu)
{
TaskListEntities ORM = new TaskListEntities();
TaskTable founded = ORM.TaskTables.Find(TaskNu);
ORM.TaskTables.Remove(founded);
ORM.SaveChanges();
return(RedirectToAction("RetrivingTaks"));
}
public ActionResult Edit([Bind(Include = "Id,title,details,assingname,date")] TaskTable taskTable)
{
if (ModelState.IsValid)
{
db.Entry(taskTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(taskTable));
}
public async Task <bool> UpdateTask(string id, TaskModel task)
{
var taskRow = new TaskTable()
{
Id = task.Id, Name = task.Name, Status = task.Status
};
await _taskRepository.Update(taskRow, id);
return(true);
}
public ProjectController(TaskTable taskTable, ProjectTable projectTable, UserTable userTable,
TenantTable tenantTable, ServiceOrderTable serviceOrderTable, NotificationTable notificationTable)
{
_taskTable = taskTable;
_projectTable = projectTable;
_userTable = userTable;
_tenantTable = tenantTable;
_serviceOrderTable = serviceOrderTable;
_notificationTable = notificationTable;
}
public void clearContext()
{
addin_.SelectionChangedEvent -= Addin_SelectionChangedEvent;
previewTranCon_?.Reset();
selectionTranCon_?.Reset();
taskElemsToRows_.Clear();
TaskTable.Clear();
OnPropertyChanged(NP.TaskSelection);
}
public IHttpActionResult GetTaskTable(int id)
{
TaskTable taskTable = db.TaskTables.Find(id);
if (taskTable == null)
{
return(NotFound());
}
return(Ok(taskTable));
}
public ActionResult Create([Bind(Include = "Id,title,details,assingname,date")] TaskTable taskTable)
{
if (ModelState.IsValid)
{
db.TaskTables.Add(taskTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(taskTable));
}
public ActionResult Edit([Bind(Include = "task_id,title,project_id")] TaskTable taskTable)
{
if (ModelState.IsValid)
{
db.Entry(taskTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.project_id = new SelectList(db.ProjectTables, "project_id", "title", taskTable.project_id);
return(View(taskTable));
}
public ActionResult Create([Bind(Include = "task_id,title,project_id")] TaskTable taskTable)
{
if (ModelState.IsValid)
{
db.TaskTables.Add(taskTable);
db.SaveChanges();
return(RedirectToAction("Index", "Projects"));
}
ViewBag.project_id = new SelectList(db.ProjectTables, "project_id", "title", taskTable.project_id);
return(View(taskTable));
}
public async Task <IActionResult> Create([Bind("TaskId,TextTask,DateTask,CompleteTask,UserId")] TaskTable taskTable)
{
if (ModelState.IsValid)
{
_context.Add(taskTable);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["UserId"] = new SelectList(_context.User, "Id", "Id", taskTable.UserId);
return(View(taskTable));
}
public void SaveTasks()
{
var tasks = new TaskTable {
ProjectName = "NUNIT", ProjectId = 100, TaskName = "NUNIT",
Priority = 10, ParentTask = "TEST", IsParent = true,
StartDate = Convert.ToDateTime("2018-10-18"), EndDate = Convert.ToDateTime("2018-10-18"),
UserId = 1, UserName = "******", Deleted = false, Status = "Completed"
};
bool added = task.Add(tasks);
Assert.AreEqual(true, added);
}
