private void cmdSubmit_Click(object sender, EventArgs e) {
ArrayList prins = ucSectionExpl.Principals;
ArrayList tests = GetTests();
string warnings="";
int asstID = Convert.ToInt32(HttpContext.Current.Request.Params["AsstID"]);
AutoJobs jobs = new AutoJobs(Globals.CurrentIdentity);
Principals aprins = new Principals(Globals.CurrentIdentity);
foreach (int prin in prins) {
foreach (int evalid in tests) {
try {
Components.Submission sub = aprins.GetLatestSubmission(prin, asstID);
if (sub == null) {
warnings += aprins.GetInfo(prin).Name + " ";
break;
}
else
jobs.Create(txtName.Text, evalid, sub.ID);
} catch (DataAccessException er) {
PageError(er.Message);
return;
}
}
}
PageError("Job: " + txtName.Text + " created successfully. Refer to the " +
"job status page to monitor its progress through the testing centers. Users/Groups: " +
warnings + " do not have any submissions and tests will not be run on them.");
}
public Movie(String file, JsonMainDetails.Data infos, String coverFileName) : this()
{
TimeAdded = DateTime.Now.ToUnixTimestamp();
Title = infos.title;
try
{
Year = int.Parse(infos.year);
}
catch { }
if (infos.plot != null)
{
Plot = infos.plot.outline;
}
ImdbId = infos.tconst;
Principals.AddRange(infos.cast_summary.NoNull().Select(p => p.name.name));
Directors.AddRange(infos.directors_summary.NoNull().Select(p => p.name.name));
Writers.AddRange(infos.writers_summary.NoNull().Select(p => p.name.name));
Genres.AddRange(infos.genres.NoNull());
ImdbRating = infos.rating;
if (infos.runtime != null)
{
Duration = infos.runtime.time;
}
Files.Add(file);
Cover = coverFileName;
}
private void dgReport_ItemDataBound(object sender, DataGridItemEventArgs e)
{
Label lblPoints;
if (null != (lblPoints = (Label)e.Item.FindControl("lblPoints")))
{
int asstID = Convert.ToInt32(dgReport.DataKeys[e.Item.ItemIndex]);
User user = new Users(Globals.CurrentIdentity).GetInfo(GetUsername(), null);
Components.Submission latsub =
new Principals(Globals.CurrentIdentity).GetLatestGradedSubmission(user.PrincipalID, asstID);
double total = new Assignments(Globals.CurrentIdentity).GetRubric(asstID).Points;
if (latsub != null)
{
double userp = new Users(Globals.CurrentIdentity).GetAsstPoints(user.UserName, asstID);
lblPoints.Text =
String.Format("{0} / {1} ({2}%)", userp, total, Math.Round((userp / total) * 100.0, 2));
}
else
{
lblPoints.Text =
String.Format("?? / {0}", total);
}
}
}
public string Post([FromBody] Principals principals)
{
//Create
db.Principals.Add(principals);
db.SaveChanges();
return(JsonConvert.SerializeObject(principals));
}
/// <summary>
/// Authorize a user on a file for an action
/// </summary>
protected bool Authorize(int principalID, CFile file, FileAction action, User hint)
{
//Hack for system path
if (file.Path.StartsWith(@"c:\system"))
{
return(true);
}
else if (hint != null)
{
if (hint.Admin)
{
return(true);
}
else
{
return(m_dp.AuthorizeFile(principalID, file, action));
}
}
else
{
//Check for a user
Principal prin = new Principals(m_ident).GetInfo(principalID);
if (prin.Type == Principal.USER)
{
User user = new Users(m_ident).GetInfo(prin.Name, null);
if (user.Admin)
{
return(true);
}
}
return(m_dp.AuthorizeFile(principalID, file, action));
}
}
public User(string name, string description)
{
Name = name;
Description = description;
Principals.Add(Principal.Everyone);
Principals.Add(this.AsPrincipal());
}
public bool RemoveRootNode(IFrameworkItem frameworkItem)
{
var localItemPrincipals = frameworkItem as VulcanEngine.IR.Ast.Table.AstPrincipalNode;
if (localItemPrincipals != null)
{
return(Principals.Remove(localItemPrincipals));
}
var localItemSchemas = frameworkItem as VulcanEngine.IR.Ast.Table.AstSchemaNode;
if (localItemSchemas != null)
{
return(Schemas.Remove(localItemSchemas));
}
var localItemTemplates = frameworkItem as VulcanEngine.IR.Ast.AstTemplateNode;
if (localItemTemplates != null)
{
return(Templates.Remove(localItemTemplates));
}
var localItemPersistentVariables = frameworkItem as VulcanEngine.IR.Ast.PersistentVariables.AstPersistentVariableNode;
if (localItemPersistentVariables != null)
{
return(PersistentVariables.Remove(localItemPersistentVariables));
}
var localItemPackages = frameworkItem as VulcanEngine.IR.Ast.Task.AstPackageBaseNode;
if (localItemPackages != null)
{
return(Packages.Remove(localItemPackages));
}
var localItemConnections = frameworkItem as VulcanEngine.IR.Ast.Connection.AstConnectionNode;
if (localItemConnections != null)
{
return(Connections.Remove(localItemConnections));
}
var localItemDimensions = frameworkItem as VulcanEngine.IR.Ast.Dimension.AstDimensionNode;
if (localItemDimensions != null)
{
return(Dimensions.Remove(localItemDimensions));
}
var localItemFacts = frameworkItem as VulcanEngine.IR.Ast.Fact.AstFactNode;
if (localItemFacts != null)
{
return(Facts.Remove(localItemFacts));
}
var localItemTables = frameworkItem as VulcanEngine.IR.Ast.Table.AstTableBaseNode;
if (localItemTables != null)
{
return(Tables.Remove(localItemTables));
}
return(false);
}
private void BindPermissions()
{
Permission.PermissionList perms =
new Permissions(Globals.CurrentIdentity).GetTypePermissions(GetObjectType());
int prinID = (int)dgRoles.DataKeys[dgRoles.SelectedIndex];
Principal prin = new Principals(Globals.CurrentIdentity).GetInfo(prinID);
lblPrin.Text = "Selection: " + prin.Name;
dgPerms.DataSource = perms;
dgPerms.DataBind();
}
private Components.Submission GetLatestSub(int principalID)
{
Components.Submission gsub, rsub;
gsub = new Principals(Globals.CurrentIdentity).GetLatestGradedSubmission(
principalID, GetAsstID());
if (gsub != null)
{
return(gsub);
}
rsub = new Principals(Globals.CurrentIdentity).GetLatestSubmission(
principalID, GetAsstID());
return(rsub);
}
public override bool Equals(object obj)
{
if (ReferenceEquals(obj, this))
{
return(true);
}
if (obj is SimpleAccount)
{
var account = (SimpleAccount)obj;
return(Principals == null ? account.Principals == null : Principals.Equals(account.Principals));
}
return(false);
}
private void BindSubs()
{
int asstID = Convert.ToInt32(Request.Params["AsstID"]);
Components.Submission.SubmissionList subs =
new Users(Globals.CurrentIdentity).GetAsstSubmissions(Globals.CurrentUserName, asstID);
ddlSubs.Items.Clear();
foreach (Components.Submission sub in subs)
{
string name =
new Principals(Globals.CurrentIdentity).GetInfo(sub.PrincipalID).Name +
" (" + sub.Creation.ToString() + ")";
ddlSubs.Items.Add(new ListItem(name, sub.ID.ToString()));
}
}
protected string GetAsstPoints(User user, int asstID)
{
Components.Submission latsub =
new Principals(Globals.CurrentIdentity).GetLatestGradedSubmission(user.PrincipalID, asstID);
double total = new Assignments(Globals.CurrentIdentity).GetRubric(asstID).Points;
if (latsub != null)
{
double userp = new Users(Globals.CurrentIdentity).GetAsstPoints(user.UserName, asstID);
return(String.Format("{0} / {1} ({2}%)", userp, total, Math.Round((userp / total) * 100.0, 2)));
}
else
{
return(String.Format("?? / {0}", total));
}
}
private void BindUserItem(User user, Label lblName, Label numSubmissions, LinkButton lnkProgress,
System.Web.UI.WebControls.Image imgStatus,
System.Web.UI.WebControls.Image imgType, CheckBox chkSelect)
{
imgType.ImageUrl = "../../attributes/user.gif";
lblName.Text = user.FullName + "(" + user.UserName + ")";
if (lnkProgress == null)
{
lnkProgress = new LinkButton();
}
Principals prinda = new Principals(Globals.CurrentIdentity);
Components.Submission sub = prinda.GetLatestSubmission(user.PrincipalID, GetAsstID());
int numsubs = prinda.GetSubmissions(user.PrincipalID, GetAsstID()).Count;
numSubmissions.Text = numsubs.ToString();
if (sub == null)
{
imgStatus.ImageUrl = "../../attributes/nosub.gif";
lnkProgress.Text = "N/A";
chkSelect.Enabled = false;
}
else
{
switch (sub.Status)
{
case Components.Submission.GRADED:
imgStatus.ImageUrl = "../../attributes/subgrade.gif";
lnkProgress.Text = "100%";
break;
case Components.Submission.INPROGRESS:
imgStatus.ImageUrl = "../../attributes/clock.gif";
lnkProgress.Text = "??%";
break;
case Components.Submission.UNGRADED:
imgStatus.ImageUrl = "../../attributes/sub.gif";
lnkProgress.Text = "0%";
break;
}
}
}
private DataTable TabulateUsers(User.UserList users)
{
DataTable resulttab = new DataTable();
int asstID = GetAsstID();
Rubrics rubda = new Rubrics(Globals.CurrentIdentity);
Principals prinda = new Principals(Globals.CurrentIdentity);
Rubric asstrub = new Assignments(Globals.CurrentIdentity).GetRubric(asstID);
//Add rubric columns to data grid
Rubric.RubricList flatrub = rubda.Flatten(asstrub);
resulttab.Columns.Add("UserName");
resulttab.Columns.Add("Status");
resulttab.Columns.Add("Total");
foreach (Rubric rub in flatrub)
{
AddRubricColumn(rub.Name, rub.Name);
resulttab.Columns.Add(rub.Name);
}
//Add user data to the datatable
foreach (User user in users)
{
Components.Submission sub = prinda.GetLatestSubmission(user.PrincipalID, asstID);
DataRow row = resulttab.NewRow();
if (sub == null)
{
continue;
}
row["UserName"] = user.UserName;
row["Status"] = sub.Status;
row["Total"] = rubda.GetPoints(asstrub.ID, sub.ID).ToString() + "/" + asstrub.Points.ToString();
foreach (Rubric rub in flatrub)
{
row[rub.Name] = GetRubricPoints(rub, sub.ID) + "/" + rub.Points.ToString();
}
resulttab.Rows.Add(row);
}
return(resulttab);
}
public List <DatabaseObjectBase> GetDatabaseObjects(bool filter)
{
var lst = (from s in Schemas
from rs in s.RoutinesSynonyms
select rs).OfType <DatabaseObjectBase>().ToList();
lst.AddRange((from s in Schemas
from v in s.Views
select v).OfType <DatabaseObjectBase>());
lst.AddRange(Principals.Where(p => !filter || !"|INFORMATION_SCHEMA|sys|guest|public|".Contains("|" + p.PrincipalName + "|")).ToList());
lst.AddRange(Schemas.Where(s => !filter || !"|INFORMATION_SCHEMA|dbo|".Contains("|" + s.SchemaName + "|")).ToList());
//lst.AddRange(Principals.Where(p => !"|INFORMATION_SCHEMA|sys|guest|public|dbo|".Contains("|" + p.PrincipalName + "|")).ToList());
//lst.AddRange(Schemas.Where(s => !"|INFORMATION_SCHEMA|dbo|".Contains("|" + s.SchemaName + "|")).ToList());
lst.AddRange(ServerLogins.Where(l => !filter || l.LoginType != LoginType.WindowsLogin).ToList());
lst.AddRange(Permissions.ToList());
lst.AddRange(Credentials.ToList());
return(lst);
}
public bool SendByPrincipal(int principalID, string subj, string body)
{
Principal prin = new Principals(m_ident).GetInfo(principalID);
if (prin.Type == Principal.USER)
{
User user = new Users(m_ident).GetInfo(prin.Name, null);
return(SendByEmail(user.Email, subj, body));
}
else
{
User.UserList users =
new Groups(m_ident).GetMembership(principalID);
foreach (User user in users)
{
SendByEmail(user.Email, subj, body);
}
}
return(true);
}
private string GetSubImage(User user)
{
Components.Submission gsub =
new Principals(Globals.CurrentIdentity).GetLatestGradedSubmission(
user.PrincipalID, GetAsstID());
Components.Submission rsub =
new Principals(Globals.CurrentIdentity).GetLatestSubmission(
user.PrincipalID, GetAsstID());
if (gsub != null)
{
return("../../attributes/subgrade.gif");
}
else if (rsub != null)
{
return("../../attributes/sub.gif");
}
else
{
return("../../attributes/nosub.gif");
}
}
private void cmdSubmit_Click(object sender, EventArgs e)
{
ArrayList prins = GetPrincipals();
ArrayList tests = GetTests();
AutoJobs jobs = new AutoJobs(Globals.CurrentIdentity);
Principals aprins = new Principals(Globals.CurrentIdentity);
//Check for nothing
if (tests.Count == 0 || prins.Count == 0)
{
PageAutoError("Must select at least one user and one test to create an auto job");
return;
}
AutoJob job = jobs.Create(txtName.Text, GetAsstID());
foreach (int prin in prins)
{
foreach (int evalid in tests)
{
try {
Components.Submission sub =
aprins.GetLatestSubmission(prin, GetAsstID());
if (sub != null)
{
jobs.CreateTest(job.ID, sub.ID, evalid, false);
}
} catch (DataAccessException er) {
PageAutoError(er.Message);
return;
}
}
}
mpViews.SelectedIndex = 1;
}
public override string ToString()
{
return(Principals == null ? "Empty" : Principals.ToString());
}
public override int GetHashCode()
{
return(Principals == null ? 0 : Principals.GetHashCode());
}
public void Put(int id, [FromBody] Principals principals)
{
//Update
db.Principals.Update(principals);
db.SaveChanges();
}
public string Delete([FromBody] Principals principals)
{
db.Principals.Remove(principals);
db.SaveChanges();
return(JsonConvert.SerializeObject("Ok"));
}
