public void FlushDatabase()
{
using (CHUMDB context = new CHUMDB())
{
string Data = File.ReadAllText(FileLocations.CONFIG_FOLDER_PATH + "Schema.sql");
context.Database.ExecuteSqlCommand(Data);
}
}
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>();;
}
}
internal List <List <object> > GenerateDbobj(IEnumerable <Type> Types)
{
List <List <object> > data = new List <List <object> >();
foreach (Type type in Types)
{
List <object> outrecord = new List <object>();
using (CHUMDB context = new CHUMDB())
{
var records = context.Set(type);
foreach (var record in records)
{
outrecord.Add(record);
}
}
data.Add(outrecord);
}
return(data);
}
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 ReadCloud()
{
this._Context = new CHUMDB();
}
public OLDReadCloud()
{
this._ListofClasses = new List <string>();
this._Context = new CHUMDB();
}
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);
}
private void CompareData(IEnumerable <object> fileData, IEnumerable <object> dbData)
{
Type RecordType = fileData.ElementAt(0).GetType();
System.Diagnostics.Debug.WriteLine("Distinct File Count: " + fileData.Count());
IEnumerable <PropertyInfo> KeyProperties = (from prop in RecordType.GetProperties()
from att in prop.CustomAttributes
where att.AttributeType == typeof(KeyAttribute)
select prop);
IEnumerable <PropertyInfo> PropertiesToChagne = from pro in RecordType.GetProperties()
from not in KeyProperties
where pro.Name != not.Name
select pro;
Stopwatch SW = new Stopwatch();
using (CHUMDB context = new CHUMDB())
{
ILog Logger = ServiceLocator.Current.GetInstance <ILog>();
List <object> RangeAdd = new List <object>();
int count = 1;
foreach (object fileRecord in fileData)
{
if ((count % 1000) == 0)
{
Logger.LogMessage("Processed: " + RecordType.Name + "\tRecord: " + count + "/" + fileData.Count() + " in: " + SW.ElapsedMilliseconds + " ms");
SW.Restart();
}
//CHEKING db
object Record = GetRecordFromDB(fileRecord, dbData);
if (Record == null)
{
object[] Propvales = KeyProperties.Select(i => i.GetValue(fileRecord)).ToArray();
if (Propvales.Where(i => string.IsNullOrWhiteSpace(i.ToString())).Count() == 0)
{
RangeAdd.Add(fileRecord);
}
}
else
{
object[] Propvales = KeyProperties.Select(i => i.GetValue(Record)).ToArray();
object DBRecord = context.Set(Record.GetType()).Find(Propvales);
foreach (PropertyInfo prop in PropertiesToChagne)
{
if (prop.GetValue(DBRecord) != prop.GetValue(fileRecord))
{
prop.SetValue(DBRecord, prop.GetValue(fileRecord));
}
}
}
count++;
}
System.Diagnostics.Debug.WriteLine("Adding range data for: " + RecordType.Name);
context.Set(RecordType).AddRange(RangeAdd);
System.Diagnostics.Debug.WriteLine("Adding range data Done");
Logger.LogMessage("Saving Data");
Logger.LogMessage("Data Saved: " + context.SaveChanges());
}
}
