public void EditTaskResource(object sender, EventArgs e) { Model1 _db = new Model1(); int id = int.Parse(ViewState["ResID"].ToString()); taskresources res = (from resources in _db.taskresources where resources.ResourceID == id select resources).FirstOrDefault(); TextBox taskName = (TextBox)Page.FindControlRecursive("EditTaskName"); TextBox taskText = (TextBox)Page.FindControlRecursive("EditTaskText"); TextBox taskDate = (TextBox)Page.FindControlRecursive("EditTaskDate"); HiddenField hidden = (HiddenField)Page.FindControlRecursive("deadlineHidden"); res.TaskName = taskName.Text; res.Text = taskText.Text; if (!string.IsNullOrEmpty(taskDate.Text)) { res.Deadline = DateTime.Parse(taskDate.Text); } else { res.Deadline = DateTime.Parse(hidden.Value); } _db.SaveChanges(); Refresh(); }
public bool AddTaskResource(int blockID, string taskName, string taskText, DateTime deadline) { var myResource = new resources(); myResource.BlockID = blockID; myResource.ResourceName = taskName; myResource.ResourcePath = taskName; myResource.ResourceType = "task"; myResource.IsVisible = false; using (Model1 _db = new Model1()) { _db.resources.Add(myResource); _db.SaveChanges(); var myTask = new taskresources(); myTask.ResourceID = myResource.ResourceID; myTask.TaskName = taskName; myTask.Text = taskText; myTask.Deadline = deadline; _db.taskresources.Add(myTask); _db.SaveChanges(); int subjectID = (from blocks in _db.blocks where blocks.BlockID == blockID select blocks.SubjectID).First(); Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/Subjects/" + subjectID) + "/Tasks/" + myResource.ResourceID); } return(true); }
public bool AddJoinUserMarks(int ResourceID, string UserID, string filepath, string user, int subjectID) { var myJoinUserMarks = new joinusermarks(); myJoinUserMarks.ResourceID = ResourceID; myJoinUserMarks.UserID = UserID; myJoinUserMarks.FilePath = filepath; myJoinUserMarks.Delivered = DateTime.Now; myJoinUserMarks.User = user; myJoinUserMarks.SubjectID = subjectID; using (Model1 _db = new Model1()) { taskresources task = (from tasks in _db.taskresources where tasks.ResourceID == ResourceID select tasks).FirstOrDefault(); myJoinUserMarks.TaskName = task.TaskName; _db.joinusermarks.Add(myJoinUserMarks); _db.SaveChanges(); } return(true); }
public void ShowEditTask(object sender, CommandEventArgs e) { ViewState["ResID"] = e.CommandArgument.ToString(); ModalPopupExtender modalPopupExtender = (ModalPopupExtender)Page.FindControlRecursive("EditTaskPopup"); modalPopupExtender.Show(); Model1 _db = new Model1(); int id = int.Parse(ViewState["ResID"].ToString()); taskresources res = (from resources in _db.taskresources where resources.ResourceID == id select resources).FirstOrDefault(); TextBox taskName = (TextBox)Page.FindControlRecursive("EditTaskName"); TextBox taskText = (TextBox)Page.FindControlRecursive("EditTaskText"); TextBox taskDate = (TextBox)Page.FindControlRecursive("EditTaskDate"); HiddenField hidden = (HiddenField)Page.FindControlRecursive("deadlineHidden"); taskName.Text = res.TaskName; taskText.Text = res.Text; taskDate.TextMode = TextBoxMode.DateTimeLocal; taskDate.Text = res.Deadline.ToString(); hidden.Value = res.Deadline.ToString(); }
protected void Page_Load(object sender, EventArgs e) { var _db = new Model1(); id = Convert.ToInt32(Request.QueryString["ResourceID"]); int blockID = (from resources in _db.resources where resources.ResourceID == id select resources.BlockID).First(); subjectID = (from blocks in _db.blocks where blocks.BlockID == blockID select blocks.SubjectID).First(); taskresources task = (from tasks in _db.taskresources where tasks.ResourceID == id select tasks).FirstOrDefault(); Label name = (Label)Page.FindControlRecursive("name"); name.Text = task.TaskName; HtmlGenericControl desc = (HtmlGenericControl)Page.FindControlRecursive("description"); desc.InnerText = task.Text; if (User.IsInRole("Profesor") || User.IsInRole("admin")) { TableCell dateCell = (TableCell)Page.FindControlRecursive("date"); dateCell.Text = task.Deadline.ToString(); TableCell leftCell = (TableCell)Page.FindControlRecursive("leftTime"); TimeSpan timeLeft = task.Deadline.Subtract(DateTime.Now); int days = (int)timeLeft.TotalDays; int hours = (int)timeLeft.TotalHours - days * 24; int minutes = (int)timeLeft.TotalMinutes - (days * 24 * 60 + hours * 60); if (minutes < 0) { leftCell.Text = "Hace " + days + " días " + hours + " horas " + minutes + " minutos"; leftCell.ForeColor = System.Drawing.Color.Red; } else { leftCell.Text = "Quedan " + days + " días " + hours + " horas " + minutes + " minutos"; } } if (User.IsInRole("Alumno")) { TableCell dateCell = (TableCell)Page.FindControlRecursive("date"); dateCell.Text = task.Deadline.ToString(); TableCell leftCell = (TableCell)Page.FindControlRecursive("leftTime"); TimeSpan timeLeft = task.Deadline.Subtract(DateTime.Now); int days = (int)timeLeft.TotalDays; int hours = (int)timeLeft.TotalHours - days * 24; int minutes = (int)timeLeft.TotalMinutes - (days * 24 * 60 + hours * 60); Label warning = (Label)Page.FindControlRecursive("warning"); warning.Visible = false; if (minutes < 0) { leftCell.Text = "Hace " + days + " días " + hours + " horas " + minutes + " minutos"; leftCell.ForeColor = System.Drawing.Color.Red; TableCell uploadCell = (TableCell)Page.FindControlRecursive("uploadCell"); uploadCell.Visible = false; Button uploadButton = (Button)Page.FindControlRecursive("uploadButton"); uploadButton.Visible = false; } else { leftCell.Text = "Quedan " + days + " días " + hours + " horas " + minutes + " minutos"; } string currentID = User.Identity.GetUserId(); joinusermarks joinUserMark = (from joinUserMarks in _db.joinusermarks where joinUserMarks.ResourceID == id && joinUserMarks.UserID == currentID select joinUserMarks).FirstOrDefault(); if (joinUserMark != null) { alredySent = true; if (joinUserMark.FilePath != "" && joinUserMark.Mark == 0) { TableCell status = (TableCell)Page.FindControlRecursive("status"); status.Text = "Entregado"; TableCell file = (TableCell)Page.FindControlRecursive("file"); file.Text = joinUserMark.FilePath + " (" + joinUserMark.Delivered.ToString() + ")"; warning.Visible = true; } if (joinUserMark.FilePath != "" && joinUserMark.Mark != 0) { TableCell status = (TableCell)Page.FindControlRecursive("status"); status.Text = "Calificado"; TableCell file = (TableCell)Page.FindControlRecursive("file"); file.Text = joinUserMark.FilePath; TableCell mark = (TableCell)Page.FindControlRecursive("mark"); mark.Text = joinUserMark.Mark.ToString(); Button uploadButton = (Button)Page.FindControlRecursive("uploadButton"); uploadButton.Visible = false; } } } }