public static int UpdateGroup(Group group) { int result = 0; EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder(Global.jSSEConn); //Parameter Names if (group.Active == null) { group.Active = true; } string[] JsseParams = new[] { "GroupID", "GroupName", "GroupDesc", "GroupType", "MajorGroup_Id", "Org_Id", "PermissionIDs", "CreatedBy", "Active" }; try { var JsseValues = new object[] { group.Group_ID, group.GroupName, group.GroupDesc, group.GroupType.Level_Id, group.MajorGroup_Id, group.Org_Id, string.Join(",", group.Permissions.Where(p => p.Selected).Select(p => p.Permission_ID.ToString()).ToArray()), group.ModifiedBy, group.Active }; var jsseMain = DBGeneric.ExecStoredProcedure(entityBuilder.ProviderConnectionString, "dbo.[usp_JSSE_InsertUpdateSecurityGroup]", JsseParams, JsseValues); } catch { throw; } return(result); }
public int AddModifyJsseCategory(JSSEMain jsse, JSSECategory category) { EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder(Global.jSSEConn); var majorGroupResults = DBGeneric.ExecInsertUpdateStoredProcedure(entityBuilder.ProviderConnectionString, "usp_JSSE_InsertUpdateJsseCategory", new[] { "JSSE_ID", "Hierarchy_ID", "Category_ID" }, new[] { Convert.ToString(jsse.JSSE_ID), Convert.ToString(jsse.Hierarchy_ID), Convert.ToString(category.Category_ID) }); return(majorGroupResults); }
public IEnumerable <JSSEMain> AddModifyJsseMain(JSSEMain jsse) { EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder(Global.jSSEConn); var jsseMain = DBGeneric.ExecInsertUpdateStoredProcedure <JSSEMain>(entityBuilder.ProviderConnectionString, "usp_JSSE_InsertUpdateJsseMain", new[] { "UserId", "JobName", "JobDescription" }, new[] { "1", jsse.JobName, jsse.JobDescription }); return(jsseMain); }
public static T Add <T>( T model, bool useWriteDb = false) where T : BaseModel { return(DBGeneric.Add(model, useWriteDb)); }
public IEnumerable <MajorGroupall> GetMajorGroup(string userId) { EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder(Global.jSSEConn); var majorGroupResults = DBGeneric.ExecStoredProcedure <MajorGroupall>(entityBuilder.ProviderConnectionString, "usp_JSSE_MajorGroupByUserId", new[] { "UserId" }, new[] { userId }); return(majorGroupResults); }
private List <object> RunQuery(string data) { using (CHUMDB context = new CHUMDB()) { DBGeneric <User> Users = new DBGeneric <User>(context); var test = Users.Read(); List <object> returnvalue = null; User_Type UT = (from ut in context.User_Type where ut.Label == data select ut).FirstOrDefault(); if (UT == null) { throw new Exception("Can't Find User Type Paramater in DB: " + data); } if (UT.Label == "Teacher") { returnvalue = (from usr in Users.Read() where usr.User_Type_ID == UT.ID && usr.UserName != null && !string.IsNullOrWhiteSpace(usr.UserName) orderby usr.User_Type_ID, usr.Year_Level select new { First_Name = usr.Preferred_First_Name, Surname = usr.Preferred_Last_Name, Email = usr.UserName + "@eq.edu.au" }).ToList <object>(); } if (data == "Student") { returnvalue = (from usr in Users.Read() where usr.User_Type_ID == UT.ID && usr.Exit_Date == null && usr.UserName != null && !string.IsNullOrWhiteSpace(usr.UserName) orderby usr.User_Type_ID, usr.Year_Level select new { First_Name = usr.Preferred_First_Name, Surname = usr.Preferred_Last_Name, Email = usr.UserName + "@eq.edu.au", YearGroup = "Year " + usr.Year_Level }).ToList <object>(); } return(returnvalue ?? new List <object>()); } }
public void LoadData() { using (CHUMDB context = new CHUMDB()) { DBGeneric <User> Users = new DBGeneric <User>(context); List <object> returnvalue = null; string paramavalue = this._Paramaters["User_Type"]; User_Type UT = (from ut in context.User_Type where ut.Label == paramavalue select ut).FirstOrDefault(); if (paramavalue == "Teacher") { returnvalue = (from usr in Users.Read() where usr.User_Type_ID == UT.ID && usr.Exit_Date == null && usr.UserName != null select new { First_Name = usr.Preferred_First_Name, Last_Name = usr.Preferred_Last_Name, Email = usr.UserName + "@eq.edu.au" }).ToList <object>(); } if (paramavalue == "Student") { returnvalue = (from usr in Users.Read() where usr.User_Type_ID == UT.ID && usr.Exit_Date == null && usr.UserName != null select new { First_Name = usr.Preferred_First_Name, Last_Name = usr.Preferred_Last_Name, Email = usr.UserName + "@eq.edu.au", YearGroup = usr.Year_Level }).ToList <object>(); } this._Data = returnvalue ?? new List <object>();; } }
public static IEnumerable <T_JSSE_Security_Group> GetGroupsByLevel(int levelId, string orgIds, int permissionID) { var orgIDList = orgIds.Split(','); var jSSEResults = from c in Global.Context.T_JSSE_Security_Group.Include("T_JSSE_Security_GroupPermission").Include("T_JSSE_Security_GroupPermission.T_JSSE_Security_Permission") where c.GroupLevel == levelId select c; if (permissionID > 0) { jSSEResults = jSSEResults.Where(g => g.T_JSSE_Security_GroupPermission.Any(a => a.T_JSSE_Security_Permission.SecurityPermission_ID == permissionID)); } if (!string.IsNullOrEmpty(orgIds)) { jSSEResults = jSSEResults.Where(DBGeneric.BuildContainsExpression <T_JSSE_Security_Group, string>(e => e.Org_Id, orgIDList)); } var jSSEEnumerable = jSSEResults.AsEnumerable(); return(jSSEEnumerable); }
public static int RemoveUserFromGroup(int groupId, int DbUserId) { int result = 0; EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder(Global.jSSEConn); //Parameter Names string[] JsseParams = new[] { "GroupId", "DbUserId" }; try { var JsseValues = new object[] { groupId, DbUserId }; var jsseMain = DBGeneric.ExecStoredProcedure(entityBuilder.ProviderConnectionString, "dbo.[usp_JSSE_DeleteUserFromGroup]", JsseParams, JsseValues); } catch { throw; } return(result); }
public static int UpdateCategory(MasterCategory category) { int result = 0; EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder(Global.jSSEConn); //Parameter Names string[] JsseParams = new[] { "CategoryID", "Category", "CategoryDesc", "CreatedBy", "Active" }; try { var JsseValues = new object[] { category.Category_ID, category.Category, category.CategoryDesc, category.ModifiedBy, category.IsActive }; var jsseMain = DBGeneric.ExecStoredProcedure(entityBuilder.ProviderConnectionString, "dbo.[usp_JSSE_InsertUpdateCategory]", JsseParams, JsseValues); } catch { throw; } return(result); }
public static int UpdateBehavior(MasterBehavior behavior) { int result = 0; EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder(Global.jSSEConn); //Parameter Names string[] JsseParams = new[] { "BehaviorID", "Behavior", "BehaviorDesc", "CreatedBy", "Active", "CategoryID", "BehaviorTypeID", "MajorGroupID", "OrgID" }; try { var JsseValues = new object[] { behavior.Behavior_ID, behavior.Behavior, behavior.BehaviorDesc, behavior.ModifiedBy, behavior.IsActive, behavior.Category.Category_ID, behavior.BehaviorType.BehaviorType_ID, behavior.MajorGroup_ID, behavior.Org_ID }; var jsseMain = DBGeneric.ExecStoredProcedure(entityBuilder.ProviderConnectionString, "dbo.[usp_JSSE_InsertUpdateBehavior]", JsseParams, JsseValues); } catch { throw; } return(result); }
public static int AddUser(UserGroup group) { int result = 0; EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder(Global.jSSEConn); string HierInfo = group.User.MajorGroup_Id + "," + group.User.Org_Id + "," + group.User.Dept_Id + "," + group.User.Section_Id; //Parameter Names string[] JsseParams = new[] { "GroupID", "UserID", "FirstName", "LastName", "EmpNo", "CompanyId", "HierarchyInfo", "CreatedBy" }; try { var JsseValues = new object[] { group.Group.Group_ID, group.User.User_ID, group.User.FirstName, group.User.LastName, group.User.Emp_Id, group.User.CompanyId, HierInfo, group.ModifiedBy }; var jsseMain = DBGeneric.ExecStoredProcedure(entityBuilder.ProviderConnectionString, "dbo.[usp_JSSE_InsertUpdateGroupUsers]", JsseParams, JsseValues); } catch { throw; } return(result); }
public void LoadData() { using (CHUMDB context = new CHUMDB()) { DBGeneric <User> Users = new DBGeneric <User>(context); List <object> returnvalue = null; string DefaultPassword = this._Paramaters["Password"]; string Enabled = this._Paramaters["Enabled"]; returnvalue = (from usr in Users.Read() where usr.Exit_Date == null && usr.UserName != null select new { username = usr.UserName, password = (usr.User_Type_ID == 2 ? "Staff" : "Student"), primary_email_password = usr.UserName + "@eq.edu.au", given_name = usr.Preferred_First_Name, surname = usr.Preferred_Last_Name, gender = usr.Sex, library_barcode = usr.Barcode, admin_system_id = usr.Barcode, graduation_yeat = "", form_class = "", enabled = "Y", staff_member = (usr.User_Type_ID == 2 ? "true" : "false"), }).ToList <object>(); //ew //{ //}).ToList<object>(); this._Data = returnvalue ?? new List <object>();; } }
public int InsertUpdateJSSE(JSSEMain jsse) { EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder(Global.jSSEConn); // Observee Data var dtObservees = new DataTable(); dtObservees.Columns.Add("Row_ID", typeof(Int32)); dtObservees.Columns.Add("Emp_Id", typeof(Int64)); dtObservees.Columns.Add("User_ID", typeof(String)); dtObservees.Columns.Add("FirstName", typeof(String)); dtObservees.Columns.Add("LastName", typeof(String)); // Observer Data var dtObservers = new DataTable(); dtObservers.Columns.Add("Row_ID", typeof(Int32)); dtObservers.Columns.Add("Emp_Id", typeof(Int64)); dtObservers.Columns.Add("User_ID", typeof(String)); dtObservers.Columns.Add("FirstName", typeof(String)); dtObservers.Columns.Add("LastName", typeof(String)); // Supervisor Data var dtSupervisors = new DataTable(); dtSupervisors.Columns.Add("Row_ID", typeof(Int32)); dtSupervisors.Columns.Add("Emp_Id", typeof(Int64)); dtSupervisors.Columns.Add("User_ID", typeof(String)); dtSupervisors.Columns.Add("FirstName", typeof(String)); dtSupervisors.Columns.Add("LastName", typeof(String)); // Jsse Categories Data var dtCategories = new DataTable(); dtCategories.Columns.Add("Row_ID", typeof(Int32)); dtCategories.Columns.Add("Category_ID", typeof(Int32)); dtCategories.Columns.Add("Rating_ID", typeof(Int32)); dtCategories.Columns.Add("Behavior_IDs", typeof(String)); dtCategories.Columns.Add("BehaviorType_IDs", typeof(String)); dtCategories.Columns.Add("Comment", typeof(String)); // Jsse Behaviors Data var dtBehaviors = new DataTable(); dtBehaviors.Columns.Add("Row_ID", typeof(Int32)); dtBehaviors.Columns.Add("Category_ID", typeof(Int32)); dtBehaviors.Columns.Add("Rating_ID", typeof(Int32)); dtBehaviors.Columns.Add("Behavior_ID", typeof(Int32)); dtBehaviors.Columns.Add("BehaviorType_ID", typeof(Int32)); dtBehaviors.Columns.Add("Comment", typeof(String)); DataRow dtRow; int jsseMain; try { //in case non-anonymous Observee, get the Observee Major group details if (jsse.IsAnonymous == false) { jsse.MajorGroup_Id = Convert.ToInt32(jsse.Observees.FirstOrDefault().MajorGroup_Id); jsse.Org_Id = Convert.ToInt32(jsse.Observees.FirstOrDefault().Org_Id); jsse.Dept_Id = Convert.ToInt32(jsse.Observees.FirstOrDefault().Dept_Id); jsse.Section_Id = Convert.ToInt32(jsse.Observees.FirstOrDefault().Section_Id); for (int i = 0; i < jsse.Observees.Length; i++) { dtRow = dtObservees.NewRow(); dtRow["Row_ID"] = i + 1; dtRow["Emp_Id"] = jsse.Observees[i].Emp_Id; dtRow["User_ID"] = jsse.Observees[i].User_ID; dtRow["FirstName"] = jsse.Observees[i].FirstName; dtRow["LastName"] = jsse.Observees[i].LastName; dtObservees.Rows.Add(dtRow); } } else { // jsse.JSSEEnteredBy = "Anonymous"; dtRow = dtObservees.NewRow(); dtRow["Row_ID"] = 1; dtRow["Emp_Id"] = 0; dtRow["User_ID"] = "Anonymous"; dtRow["FirstName"] = "Anonymous"; dtRow["LastName"] = "Anonymous"; dtObservees.Rows.Add(dtRow); } //in case non-anonymous Observer if (jsse.IsOBSRAnonymous == false) { for (int i = 0; i < jsse.Observers.Length; i++) { dtRow = dtObservers.NewRow(); dtRow["Row_ID"] = i + 1; dtRow["Emp_Id"] = jsse.Observers[i].Emp_Id; dtRow["User_ID"] = jsse.Observers[i].User_ID; dtRow["FirstName"] = jsse.Observers[i].FirstName; dtRow["LastName"] = jsse.Observers[i].LastName; dtObservers.Rows.Add(dtRow); } ////add supervisor ------Hold and comment below untill Supervisor to be shown on UI //if (jsse.IsAnonymous == true) //{ // dtRow = dtSupervisors.NewRow(); // dtRow["Row_ID"] = 1; // dtRow["Emp_Id"] = 0; // dtRow["User_ID"] = "Anonymous"; // dtRow["FirstName"] = "Anonymous"; // dtRow["LastName"] = "Anonymous"; // dtSupervisors.Rows.Add(dtRow); //} //else if(jsse.IsSupervsrOBSRSame != 1) //{ // if (jsse.Supervisors.Length > 0) // { // dtRow = dtSupervisors.NewRow(); // dtRow["Row_ID"] = 1; // dtRow["Emp_Id"] = jsse.Supervisors[0].Emp_Id; // dtRow["User_ID"] = jsse.Supervisors[0].User_ID; // dtRow["FirstName"] = jsse.Supervisors[0].FirstName; // dtRow["LastName"] = jsse.Supervisors[0].LastName; // dtSupervisors.Rows.Add(dtRow); // } //} } else { dtRow = dtObservers.NewRow(); dtRow["Row_ID"] = 1; dtRow["Emp_Id"] = 0; dtRow["User_ID"] = "Anonymous"; dtRow["FirstName"] = "Anonymous"; dtRow["LastName"] = "Anonymous"; dtObservers.Rows.Add(dtRow); ////add supervisor ------Hold and comment below untill Supervisor to be shown on UI //if (jsse.IsSupervsrOBSRSame == 1 || jsse.IsAnonymous==true) //{ // dtRow = dtSupervisors.NewRow(); // dtRow["Row_ID"] = 1; // dtRow["Emp_Id"] = 0; // dtRow["User_ID"] = "Anonymous"; // dtRow["FirstName"] = "Anonymous"; // dtRow["LastName"] = "Anonymous"; // dtSupervisors.Rows.Add(dtRow); //} //else //{ // if (jsse.Supervisors.Length > 0) // { // dtRow = dtSupervisors.NewRow(); // dtRow["Row_ID"] = 1; // dtRow["Emp_Id"] = jsse.Supervisors[0].Emp_Id; // dtRow["User_ID"] = jsse.Supervisors[0].User_ID; // dtRow["FirstName"] = jsse.Supervisors[0].FirstName; // dtRow["LastName"] = jsse.Supervisors[0].LastName; // dtSupervisors.Rows.Add(dtRow); // } //} } string[] Behavs = new string[2]; string[] BehavTys = new string[2]; int rowId = 1; int behRowId = 1; //int behOrgRowId = 1; for (int i = 0; i < jsse.Categories.Length; i++) { if (jsse.Categories[i].RatingID != null || (jsse.Categories[i].Comments != null && jsse.Categories[i].Comments != "")) { dtRow = dtCategories.NewRow(); dtRow["Row_ID"] = rowId; dtRow["Category_ID"] = jsse.Categories[i].Category_ID; if (jsse.Categories[i].RatingID == "0" || jsse.Categories[i].RatingID == null) { dtRow["Rating_ID"] = DBNull.Value; } else { dtRow["Rating_ID"] = jsse.Categories[i].RatingID; } if (jsse.Categories[i].EntBehaviors.Length > 0) { Behavs[0] = string.Join(",", jsse.Categories[i].EntBehaviors.Where(x => x.BehviorChecked).Select(x => x.Behavior_ID.ToString()).ToArray()); BehavTys[0] = string.Join(",", jsse.Categories[i].EntBehaviors.Where(x => x.BehviorChecked).Select(x => x.BehaviorType_ID.ToString()).ToArray()); } if (jsse.Categories[i].OrgBehaviors.Length > 0) { Behavs[1] = string.Join(",", jsse.Categories[i].OrgBehaviors.Where(y => y.BehviorChecked).Select(y => y.Behavior_ID.ToString()).ToArray()); BehavTys[1] = string.Join(",", jsse.Categories[i].OrgBehaviors.Where(x => x.BehviorChecked).Select(x => x.BehaviorType_ID.ToString()).ToArray()); } dtRow["Behavior_IDs"] = string.Join(",", Behavs); dtRow["BehaviorType_IDs"] = string.Join(",", BehavTys); dtRow["Comment"] = jsse.Categories[i].Comments; dtCategories.Rows.Add(dtRow); rowId = rowId + 1; } for (int beh = 0; beh < jsse.Categories[i].EntBehaviors.Length; beh++) { var currBeh = jsse.Categories[i].EntBehaviors[beh]; if (currBeh.Rating_ID != null) { dtRow = dtBehaviors.NewRow(); dtRow["Row_ID"] = behRowId; dtRow["Category_ID"] = jsse.Categories[i].Category_ID; if (currBeh.Rating_ID == null) { dtRow["Rating_ID"] = DBNull.Value; } else { dtRow["Rating_ID"] = currBeh.Rating_ID; } dtRow["Behavior_ID"] = currBeh.Behavior_ID; dtRow["BehaviorType_ID"] = currBeh.BehaviorType_ID; dtRow["Comment"] = currBeh.Comments; dtBehaviors.Rows.Add(dtRow); behRowId = behRowId + 1; } } for (int beh = 0; beh < jsse.Categories[i].OrgBehaviors.Length; beh++) { var currBeh = jsse.Categories[i].OrgBehaviors[beh]; if (currBeh.Rating_ID != null) { dtRow = dtBehaviors.NewRow(); dtRow["Row_ID"] = behRowId; dtRow["Category_ID"] = jsse.Categories[i].Category_ID; if (currBeh.Rating_ID == null) { dtRow["Rating_ID"] = DBNull.Value; } else { dtRow["Rating_ID"] = currBeh.Rating_ID; } dtRow["Behavior_ID"] = currBeh.Behavior_ID; dtRow["BehaviorType_ID"] = currBeh.BehaviorType_ID; dtRow["Comment"] = currBeh.Comments; dtBehaviors.Rows.Add(dtRow); behRowId = behRowId + 1; } } } // Jsse Attachments Data var dtAttachments = new DataTable(); dtAttachments.Columns.Add("Row_ID", typeof(Int32)); dtAttachments.Columns.Add("Title", typeof(String)); dtAttachments.Columns.Add("Description", typeof(String)); dtAttachments.Columns.Add("FileName", typeof(String)); dtAttachments.Columns.Add("Image", typeof(byte[])); for (int i = 0; i < jsse.Attachments.Length; i++) { dtRow = dtAttachments.NewRow(); dtRow["Row_ID"] = i + 1; dtRow["Title"] = jsse.Attachments[i].Title; dtRow["Description"] = jsse.Attachments[i].Description; dtRow["FileName"] = jsse.Attachments[i].FileName; dtRow["Image"] = Convert.FromBase64String(jsse.Attachments[i].Base64ImageString); dtAttachments.Rows.Add(dtRow); } List <SqlParameter> sParams = new List <SqlParameter>() { new SqlParameter("@JSSE_ID", jsse.JSSE_ID), new SqlParameter("@JobName", jsse.JobName), new SqlParameter("@JobDescription", jsse.JobDescription), new SqlParameter("@IsAnonymous", jsse.IsAnonymous), new SqlParameter("@IsExternal", false), new SqlParameter("@Status", jsse.JSSEStatus), new SqlParameter("@Region_ID", jsse.Region_ID), new SqlParameter("@JSSEDate", jsse.JSSEDate == null ? DateTime.Now : jsse.JSSEDate), new SqlParameter("@MajorGroup_Id", jsse.MajorGroup_Id), new SqlParameter("@Org_Id", jsse.Org_Id), new SqlParameter("@Dept_Id", jsse.Dept_Id), new SqlParameter("@Sect_Id", jsse.Section_Id), new SqlParameter("@JSSEEnteredBy", jsse.JSSEEnteredBy), new SqlParameter("@Location", jsse.Location), new SqlParameter() { ParameterName = "@Categories", SqlDbType = SqlDbType.Structured, Value = dtCategories }, new SqlParameter() { ParameterName = "@Behaviors", SqlDbType = SqlDbType.Structured, Value = dtBehaviors }, new SqlParameter() { ParameterName = "@Observees", SqlDbType = SqlDbType.Structured, Value = dtObservees }, new SqlParameter() { ParameterName = "@Observers", SqlDbType = SqlDbType.Structured, Value = dtObservers }, new SqlParameter() { ParameterName = "@Supervisor", SqlDbType = SqlDbType.Structured, Value = dtSupervisors }, new SqlParameter() { ParameterName = "@Attachments", SqlDbType = SqlDbType.Structured, Value = dtAttachments } }; jsseMain = DBGeneric.ExecStoredProcedureWithSqlParms(entityBuilder.ProviderConnectionString, "usp_JSSE_InsertUpdateJsse", sParams.ToArray()); } catch (Exception ex) { throw ex; } return(jsseMain); }
private List <object> RunQuery(ExportParamater UserType, ExportParamater DefaultPassword) { List <object> returnvalue = new List <object>(); using (CHUMDB context = new CHUMDB()) { DBGeneric <User> Users = new DBGeneric <User>(context); DBGeneric <User_Type> UserTypes = new DBGeneric <User_Type>(context); User_Type UT = (from ut in UserTypes.Read() where ut.Label.ToString() == UserType.Data.ToString() select ut).FirstOrDefault(); if (UT == null) { throw new Exception("Can't Find User Type Paramater in DB: " + UserType.Data.ToString()); } if (UT.Label == "Student") { returnvalue = (from usr in Users.Read() where usr.Exit_Date == null && usr.UserName != null && !string.IsNullOrWhiteSpace(usr.UserName) && usr.User_Type_ID == UT.ID orderby usr.User_Type_ID, usr.Year_Level select new { username = usr.UserName + "@eq.edu.au", password = DefaultPassword.Data.ToString(), primary_email = usr.UserName + "@eq.edu.au", given_name = usr.Preferred_First_Name, surname = usr.Preferred_Last_Name, library_barcode = usr.ID, admin_system_id = usr.ID, enabled = "Y", staff_member = (UT.Label == "Student" ? "N" : "Y"), gender = usr.Sex, form_class = usr.Form_Class ?? " ", graduation_year = CalcGradYear(usr.Year_Level), }).ToList <object>(); } if (UT.Label == "Teacher") { returnvalue = (from usr in Users.Read() where usr.Exit_Date == null && usr.UserName != null && !string.IsNullOrWhiteSpace(usr.UserName) && usr.User_Type_ID == UT.ID orderby usr.User_Type_ID, usr.Year_Level select new { username = usr.UserName + "@eq.edu.au", password = DefaultPassword.Data.ToString(), primary_email = usr.UserName + "@eq.edu.au", given_name = usr.Preferred_First_Name, surname = usr.Preferred_Last_Name, library_barcode = usr.Barcode, admin_system_id = usr.Barcode, enabled = "Y", staff_member = (UT.Label == "Student" ? "N" : "Y"), }).ToList <object>(); } } return(returnvalue); }