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