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 bool AddJoinUserMarkTest(int ResourceID, string UserID, string user, int subjectID, float mark) { var myJoinUserMarks = new joinusermarks(); myJoinUserMarks.ResourceID = ResourceID; myJoinUserMarks.UserID = UserID; myJoinUserMarks.FilePath = "test"; myJoinUserMarks.Delivered = DateTime.Now; myJoinUserMarks.User = user; myJoinUserMarks.SubjectID = subjectID; myJoinUserMarks.Mark = mark; using (Model1 _db = new Model1()) { _db.joinusermarks.Add(myJoinUserMarks); _db.SaveChanges(); } return(true); }
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; } } } }