public ActionResult AddItem(string Task, string date, bool priority)
{
try
{
string check = "";
Nullable<System.DateTime> datetime;
using (DatabaseEntities2 context = new DatabaseEntities2())
{
int myID = context.Users.First(x => x.login == HttpContext.User.Identity.Name).Id;
if (Task != check)
{
if (date != "")
datetime = DateTime.Parse(date);
else datetime = null;
ToDoItem item = new ToDoItem(Task, datetime, priority, myID);
context.ToDoItems.Add(item);
context.SaveChanges();
}
}
return RedirectToAction("ActiveItemList");
}
catch
{
return RedirectToAction("ActiveItemList");
}
}
public ActionResult GetAvatar(int id)
{
using(DatabaseEntities2 context =new DatabaseEntities2())
{
return File(context.Users.FirstOrDefault(i => i.Id == id).avatar, "image/png");
}
}
public PartialViewResult AddInerTask(int itemid, string tasktext)
{
List<AddTask> tasks;
AddTask item;
using (DatabaseEntities2 context = new DatabaseEntities2())
{
item = new AddTask(itemid, tasktext);
context.AddTasks.Add(item);
context.SaveChanges();
tasks = context.AddTasks.Where(i => i.itemID == itemid).ToList();
}
if (tasks.Count > 0) return PartialView("AddTasks", tasks);
else return PartialView("AddTasks");
}
public PartialViewResult ActiveItemList()
{
try
{
List<ToDoItem> items;
using (DatabaseEntities2 context = new DatabaseEntities2())
{
int myID = context.Users.First(x => x.login == HttpContext.User.Identity.Name).Id;
items = context.ToDoItems.Where(i => i.userID == myID && i.isComplete == false).ToList();
}
return PartialView("_Item", items);
}
catch
{
return PartialView("_Login_Layout");
}
}
public PartialViewResult ShowInerTask(int? taskid)
{
try
{
List<AddTask> tasks;
using (DatabaseEntities2 context = new DatabaseEntities2())
{
tasks = context.AddTasks.Where(i => i.itemID == taskid).ToList();
}
if (tasks.Count > 0) return PartialView("AddTasks", tasks);
else return PartialView("AddTasks");
}
catch
{
return PartialView("AddTasks");
}
}
public void RingTime(int itemid, string time)
{
using (DatabaseEntities2 context = new DatabaseEntities2())
{
if (time != "") context.ToDoItems.First(i => i.Id == itemid).RememberTime = DateTime.Parse(time);
else context.ToDoItems.First(i => i.Id == itemid).RememberTime = null;
context.SaveChanges();
}
}
public void NoteEdit(int itemid, string notext)
{
try
{
using (DatabaseEntities2 context = new DatabaseEntities2())
{
context.ToDoItems.First(i => i.Id == itemid).Note = notext;
context.SaveChanges();
}
}
catch { return; }
}
public JsonResult Mark(int id, bool check)
{
try
{
using (DatabaseEntities2 context = new DatabaseEntities2())
{
if (check) context.ToDoItems.FirstOrDefault(i => i.Id == id).Mark = false;
else context.ToDoItems.FirstOrDefault(i => i.Id == id).Mark = true;
context.SaveChanges();
}
return Json(new { marked = !check });
}
catch { return Json(new { marked = check }); }
}
public ActionResult Index(int id)
{
User user;
using (DatabaseEntities2 context = new DatabaseEntities2())
{
user = context.Users.FirstOrDefault(i => i.Id == id);
}
return View(user);
}
public void DeleteFile(int id)
{
try
{
using (DatabaseEntities2 context = new DatabaseEntities2())
{
context.Files.Remove(context.Files.First(i => i.Id == id));
context.SaveChanges();
}
}
catch { return; }
}
public ActionResult UploadFile(int id)
{
using (DatabaseEntities2 context = new DatabaseEntities2())
{
HttpPostedFileBase file = Request.Files["upl"];
//bool isUploaded = false;
string message = "File upload failed";
int length = file.ContentLength;
string name = file.FileName;
string type = file.ContentType;
try
{
using (BinaryReader reader = new BinaryReader(file.InputStream))
{
context.Files.Add(new Models.File(id, reader.ReadBytes(file.ContentLength), name, type, DateTime.Now));
context.SaveChanges();
}
//isUploaded = true;
message = "File uploaded successfully!";
}
catch (Exception ex)
{
message = string.Format("File upload failed: {0}", ex.Message);
}
return RedirectToAction("Files", new { id = id });
}
}
public PartialViewResult FinishTask(int id)
{
try
{
using (DatabaseEntities2 context = new DatabaseEntities2())
{
context.ToDoItems.FirstOrDefault(i => i.Id == id).isComplete = true;
context.SaveChanges();
}
return PartialView("_Item");
}
catch
{
return PartialView("_Item");
}
}
public ActionResult Files(int id)
{
List<Models.File> files = null;
using (DatabaseEntities2 context = new DatabaseEntities2())
{
files = context.Files.Where(f => f.itemid == id).ToList();
}
return PartialView("Files", files);
}
public PartialViewResult EndItemList()
{
List<ToDoItem> items;
using (DatabaseEntities2 context = new DatabaseEntities2())
{
int myID = context.Users.First(x => x.login == HttpContext.User.Identity.Name).Id;
items = context.ToDoItems.Where(i => i.userID == myID && i.isComplete == true).ToList();
}
return PartialView("_EndItem", items);
}
public PartialViewResult Details(int itemId)
{
try
{
ToDoItem item;
using (DatabaseEntities2 context = new DatabaseEntities2())
{
item = context.ToDoItems.First(i => i.Id == itemId);
}
return PartialView("_Details", item);
}
catch
{
return PartialView("_NotFound");
}
}
public void DeleteInerTask(int id)
{
using (DatabaseEntities2 context = new DatabaseEntities2())
{
context.AddTasks.Remove(context.AddTasks.First(i => i.Id == id));
context.SaveChanges();
}
}
public void UnfinishTask(int id)
{
try
{
using (DatabaseEntities2 context = new DatabaseEntities2())
{
context.ToDoItems.FirstOrDefault(i => i.Id == id).isComplete = false;
context.SaveChanges();
}
}
catch
{
return;
}
}
public ActionResult Comments(int id)
{
List<Comment> comments;
using (DatabaseEntities2 context = new DatabaseEntities2())
{
comments = context.Comments.Where(i => i.itemid == id).ToList();
}
return PartialView("Comments", comments);
}
public void CompleteInerTask(string taskid, bool completed)
{
int id;
try
{
id = int.Parse(taskid);
using (DatabaseEntities2 context = new DatabaseEntities2())
{
if (completed) context.AddTasks.First(i => i.Id == id).isComplete = false;
else context.AddTasks.First(i => i.Id == id).isComplete = true;
context.SaveChanges();
}
}
catch
{
return;
}
}
public void FinishTime(int itemid, string time)
{
try
{
using (DatabaseEntities2 context = new DatabaseEntities2())
{
if (time != "") context.ToDoItems.First(i => i.Id == itemid).FinishTime = DateTime.Parse(time);
else context.ToDoItems.First(i => i.Id == itemid).FinishTime = null;
context.SaveChanges();
}
}
catch
{
return;
}
}
public void Delete(int id)
{
try
{
using (DatabaseEntities2 context = new DatabaseEntities2())
{
context.ToDoItems.Remove(context.ToDoItems.First(itemId => itemId.Id == id));
context.SaveChanges();
}
}
catch { return; }
}
public ActionResult GetFile(int? id)
{
using(DatabaseEntities2 context = new DatabaseEntities2())
{
Models.File temp = context.Files.First(f => f.Id == id);
return File(temp.file1, temp.type);
}
}
public JsonResult Complete(int id, bool check)
{
try
{
using (DatabaseEntities2 context = new DatabaseEntities2())
{
if (check) context.ToDoItems.FirstOrDefault(i => i.Id == id).isComplete = false;
else
{
context.ToDoItems.FirstOrDefault(i => i.Id == id).isComplete = true;
foreach (var item in context.AddTasks.Where(i => i.itemID == id))
{
if (item!=null)
item.isComplete = true;
}
}
context.SaveChanges();
}
return Json(new { id = id, complete = !check });
}
catch
{
return Json(new { });
}
}