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;
}
}
}
}
