protected void cmdOverwrite_Click(object sender, EventArgs e)
{
panAlert.Visible = true;
panDatabaseAlert.Visible = false;
DatabaseMgr dm = new DatabaseMgr();
bool didDelete = dm.DeleteMeet(meetID);
if (didDelete)
{
bool didAdd = dm.AddMeet(newMeet, Session["Username"].ToString());
if (didAdd)
{
Session["ActiveMeet"] = newMeet;
//Open MeetHub here
Response.Redirect("MeetHub.aspx");
}
else
{
lblAlert.Text = "Meet deleted from database, but error adding new database entry";
}
}
else
{
lblAlert.Text = "Error deleting existing meet from database";
}
}
// it looks like most of the classes using the DatabaseManager have callbacks that only use the string 'data' to process, so we could cache these strings
// based on the parameter set passed in, like 'LoadCases','Owner', or 'LoadCase', 'caseName', and the string containing the data we want to use for offline session
public void DBCallOffline(string URL, WWWForm form, DatabaseMgr.Callback callback){
// if we can find a match in our list of cached responses, send it back
// first, find the arguments
string strFormData = Encoding.UTF8.GetString(form.data, 0, form.data.Length); //"command=cmd¶m=paramvalue"
string[] fields = strFormData.Split ('&');
string command = "";
string param1 = "";
string[] pair;
if (fields [0].Contains ("=")) {
pair = fields [0].Split ('=');
command = pair [1];
if (fields.Length > 1 && fields[1].Contains("=")){
pair = fields [1].Split ('=');
param1 = pair [1].Replace("+"," ");
}
}
string data = "";
foreach (CachedDBResult result in OfflineDBResults) {
if (result.command == command && result.param1 == param1){
data = result.data;
break;
}
}
// don't use coroutine here because the timescale might be 0 and
// then we will never return...
//StartCoroutine(CallbackAfterDelay(callback,data));
// do callback
if ( callback != null )
callback(true,data,"",null);
}
public questStatus GetDatabaseViews(DatabaseId databaseId, out List <BootstrapTreenodeViewModel> dbViewNodeList)
{
// Initialize
questStatus status = null;
dbViewNodeList = null;
// Get db tables
List <DBTable> dbTableList = null;
DatabaseMgr databaseMgr = new DatabaseMgr(this.UserSession);
status = databaseMgr.GetDatabaseTables(databaseId, out dbTableList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Format into bootstrap nodes
dbViewNodeList = new List <BootstrapTreenodeViewModel>();
foreach (DBTable dbTable in dbTableList)
{
BootstrapTreenodeViewModel bootstrapTreenodeViewModel = null;
status = FormatBootstrapTreeviewNode(dbTable, out bootstrapTreenodeViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
dbViewNodeList.Add(bootstrapTreenodeViewModel);
}
return(new questStatus(Severity.Success));
}
public IEnumerable <UserInfo> GetAllUsers()
{
DatabaseMgr dbgetAll = new DatabaseMgr();
IEnumerable <UserInfo> allUsers = dbgetAll.GetAllUsers();
return(allUsers);
}
protected void Page_Load(object sender, EventArgs e)
{
DatabaseMgr dm = new DatabaseMgr();
Dictionary <int, Meet> listOfMeets = dm.ListOfMeets(Session["Username"].ToString());
foreach (int key in listOfMeets.Keys)
{
lstMeets.Items.Add(new ListItem(listOfMeets[key].dateOfMeet.ToString() + " @ " + listOfMeets[key].location, key.ToString()));
}
}
protected void cmdOpen_Click(object sender, EventArgs e)
{
DatabaseMgr dm = new DatabaseMgr();
Meet meetToOpen = dm.FindMeet(Convert.ToInt32(lstMeets.SelectedValue));
Session["ActiveMeet"] = meetToOpen;
//Open MeetHub here
Response.Redirect("MeetHub.aspx");
}
public questStatus ReadTablesetConfiguration(TablesetId tablesetId, out TablesetConfiguration tablesetConfiguration)
{
// Initialize
questStatus status = null;
tablesetConfiguration = null;
// Read tableset configuration
status = _dbTablesetMgr.ReadTablesetConfiguration(tablesetId, out tablesetConfiguration);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Read database entities
DatabaseId databaseId = new DatabaseId(tablesetConfiguration.Database.Id);
DatabaseEntities databaseEntities = null;
DatabaseMgr databaseMgr = new DatabaseMgr(this.UserSession);
status = databaseMgr.ReadDatabaseEntities(databaseId, out databaseEntities);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Sort out what's assigned and not assigned to the tableset.
List <Table> nonAssignedTableList = new List <Table>();
List <View> nonAssignedViewList = new List <View>();
foreach (Table table in databaseEntities.TableList)
{
TablesetTable tablesetTable = tablesetConfiguration.TablesetTables.Find(delegate(TablesetTable ts) { return(ts.Schema == table.Schema && ts.Name == table.Name); });
if (tablesetTable == null)
{
nonAssignedTableList.Add(table);
}
}
tablesetConfiguration.DBTableList = nonAssignedTableList;
// Load database views and columns into configuration NOT assigned to tableset.
foreach (View view in databaseEntities.ViewList)
{
TablesetView tablesetView = tablesetConfiguration.TablesetViews.Find(delegate(TablesetView tv) { return(tv.Schema == view.Schema && tv.Name == view.Name); });
if (tablesetView == null)
{
nonAssignedViewList.Add(view);
}
}
tablesetConfiguration.DBViewList = nonAssignedViewList;
return(new questStatus(Severity.Success));
}
void Awake()
{
_inst = this;
DontDestroyOnLoad(gameObject);
_cacheData = new Dictionary <string, Dictionary <string, object> >();
_tmpData = new Dictionary <string, Dictionary <string, object> >();
// ab = ResMgr.Inst.getAB("cfgdata.ab");
CacahData();
}
public void AddUser(UserInfo user)
{
DatabaseMgr dbmgr = new DatabaseMgr();
if (dbmgr.AddUser(user))
{
Console.WriteLine("Success");
}
else
{
Console.WriteLine("Failure");
}
}
public void LoginUser(UserInfo user)
{
DatabaseMgr dbmgr = new DatabaseMgr();
user = dbmgr.loginUser(user);
if (user != null)
{
Console.WriteLine("Logged in");
}
else
{
Console.WriteLine("Account credentials are wrong");
}
}
public questStatus Delete(DatabaseId databaseId)
{
// Initialize
questStatus status = null;
// Delete
DatabaseMgr databaseMgr = new DatabaseMgr(this.UserSession);
status = databaseMgr.Delete(databaseId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
//TablesetConfigurationViewModel
#endregion
#region Public Methods
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region CRUD
//----------------------------------------------------------------------------------------------------------------------------------
// CRUD
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus GetDatabaseEntities(DatabaseId databaseId, out List <BootstrapTreenodeViewModel> dbTableNodeList, out List <BootstrapTreenodeViewModel> dbViewNodeList)
{
// Initialize
questStatus status = null;
dbTableNodeList = null;
dbViewNodeList = null;
// Read database entities
DatabaseEntities databaseEntities = null;
DatabaseMgr databaseMgr = new DatabaseMgr(this.UserSession);
status = databaseMgr.ReadDatabaseEntities(databaseId, out databaseEntities);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Transfer model
// Tables
dbTableNodeList = new List <BootstrapTreenodeViewModel>();
foreach (Table dbTable in databaseEntities.TableList)
{
BootstrapTreenodeViewModel bootstrapTreenodeViewModel = null;
status = FormatBootstrapTreeviewNode(dbTable, out bootstrapTreenodeViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
dbTableNodeList.Add(bootstrapTreenodeViewModel);
}
// Views
dbViewNodeList = new List <BootstrapTreenodeViewModel>();
foreach (View dbView in databaseEntities.ViewList)
{
BootstrapTreenodeViewModel bootstrapTreenodeViewModel = null;
status = FormatBootstrapTreeviewNode(dbView, out bootstrapTreenodeViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
dbViewNodeList.Add(bootstrapTreenodeViewModel);
}
return(new questStatus(Severity.Success));
}
public questStatus RefreshSchema(DatabaseEditorViewModel databaseEditorViewModel)
{
// Initialize
questStatus status = null;
// Refresh schema
DatabaseId databaseId = new DatabaseId(databaseEditorViewModel.Id);
DatabaseMgr databaseMgr = new DatabaseMgr(this.UserSession);
status = databaseMgr.RefreshSchema(databaseId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region CRUD
//----------------------------------------------------------------------------------------------------------------------------------
// CRUD
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus Save(DatabaseEditorViewModel databaseEditorViewModel)
{
// Initialize
questStatus status = null;
// Transfer model
Quest.Functional.MasterPricing.Database database = new Quest.Functional.MasterPricing.Database();
BufferMgr.TransferBuffer(databaseEditorViewModel, database);
// Determine if this is a create or update
DatabaseMgr databaseMgr = new DatabaseMgr(this.UserSession);
if (databaseEditorViewModel.Id < BaseId.VALID_ID)
{
// Create
DatabaseId databaseId = null;
status = databaseMgr.Create(database, out databaseId);
if (!questStatusDef.IsSuccess(status))
{
if (databaseId != null && databaseId.Id >= BaseId.VALID_ID)
{
databaseEditorViewModel.Id = databaseId.Id;
}
FormatErrorMessage(status, databaseEditorViewModel);
return(status);
}
databaseEditorViewModel.Id = databaseId.Id;
}
else
{
// Update
status = databaseMgr.Update(database);
if (!questStatusDef.IsSuccess(status))
{
FormatErrorMessage(status, databaseEditorViewModel);
return(status);
}
}
return(new questStatus(Severity.Success));
}
public questStatus RefreshSchema(DatabasesListViewModel databasesListViewModel)
{
// Initialize
questStatus status = null;
// Refresh schema(s)
foreach (DatabaseLineItemViewModel databaseLineItemViewModel in databasesListViewModel.Items)
{
DatabaseId databaseId = new DatabaseId(databaseLineItemViewModel.Id);
DatabaseMgr databaseMgr = new DatabaseMgr(this.UserSession);
status = databaseMgr.RefreshSchema(databaseId);
if (!questStatusDef.IsSuccess(status))
{
// TODO: DATABASE-SPECIFIC ERROR MESSAGE TO KNOW WHICH DATABASE FAILED.
return(status);
}
}
return(new questStatus(Severity.Success));
}
protected void cmdOpen_Click(object sender, EventArgs e)
{
panAlert.Visible = true;
panDatabaseAlert.Visible = false;
DatabaseMgr dm = new DatabaseMgr();
Meet openedMeet = dm.FindMeet(meetID);
if (openedMeet != null)
{
Session["ActiveMeet"] = openedMeet;
//Open MeetHub here
Response.Redirect("MeetHub.aspx");
}
else
{
lblAlert.Text = "Unknown error loading meet from database";
}
}
public static DatabaseMgr GetInstance()
{
if (instance == null)
{
//UnityEngine.Debug.LogError("DatabaseMgr.GetInstance() : Script not attached!");
// instance = new DatabaseMgr(); can't use 'new' to create a component, use AddCOmponent
instance = FindObjectOfType(typeof(DatabaseMgr)) as DatabaseMgr;
if (instance == null){
Brain brainComponent = FindObjectOfType(typeof(Brain)) as Brain;
if (brainComponent != null){
instance = brainComponent.gameObject.AddComponent<DatabaseMgr>();
}
else
{
UnityEngine.Debug.LogError("DatabaseMgr.GetInstance() : script not present!!");
}
}
}
return instance;
}
protected void Button4_Click(object sender, EventArgs e)
{
Dictionary <string, string> boysNames = new Dictionary <string, string>();
boysNames.Add("BLN", "Baldwin");
boysNames.Add("TJ", "Thomas Jefferson");
boysNames.Add("WHS", "Washington HS");
Dictionary <string, string> girlsNames = new Dictionary <string, string>();
girlsNames.Add("PLM", "Plum");
girlsNames.Add("GWY", "Gateway");
girlsNames.Add("KCH", "Knoch");
Teams teams = new Teams(boysNames, girlsNames);
Meet myMeetNoEvents = new Meet(new DateTime(2017, 04, 13), "Baldwin HS", "Windy", teams);
DatabaseMgr dbm = new DatabaseMgr();
int meetID = dbm.FindMeetId(myMeetNoEvents);
dbm.DeleteMeet(meetID);
}
public void DBCall(string URL, WWWForm form, DatabaseMgr.Callback callback)
{
// if we are offline then do trauma offline container
if (TraumaOfflineAssetContainer.GetInstance () != null &&
TraumaOfflineAssetContainer.GetInstance ().bUseOfflineAssets ) {
TraumaOfflineAssetContainer.GetInstance ().DBCallOffline (GameMgr.GetInstance().DatabaseURL, form, callback);
} else {
DatabaseMgr.GetInstance().DBCall(GameMgr.GetInstance().DatabaseURL,form,callback);
}
}
public void LoadCaseConfiguration( string name, DatabaseMgr.Callback callback )
{
if ( UsingLocalData == true )
{
// load local case if available
CaseInfo localCase = LoadCaseInfo(name);
if ( localCase != null )
{
// set local data
Data = localCase.CaseOptionData;
// prepare
PrepareCaseForStart();
// do callback
if ( callback != null )
callback(true,null,null,null);
}
}
else
{
// check to see if we have local data, if so just copy the data
loadCaseCallback = callback;
WWWForm form = new WWWForm();
form.AddField("command", "loadCase");
form.AddField("name", name);
loadTime = Time.time;
// if we are offline then do trauma offline container
if (TraumaOfflineAssetContainer.GetInstance () != null &&
TraumaOfflineAssetContainer.GetInstance ().bUseOfflineAssets ) {
TraumaOfflineAssetContainer.GetInstance ().DBCallOffline (GameMgr.GetInstance().DatabaseURL, form, loadCase);
} else {
DBCall(GameMgr.GetInstance().DatabaseURL,form,loadCase);
}
}
}
public void LoadCaseConfiguration( CaseInfo ci, DatabaseMgr.Callback callback )
{
if ( ci != null )
LoadCaseConfiguration(ci.name,callback);
}
public void LoadUserAssignedCases( DatabaseMgr.Callback callback )
{
// first try to load local CaseInfo.xml....if available then just use that
if ( LoadXML("XML/CaseInfo") != null )
{
// we have a local file, we're ok
if ( callback != null )
callback(true,null,null,null);
return;
}
loadCasesCallback = callback;
WWWForm form = new WWWForm();
form.AddField("command", "loadUserAssignedCasesWithData"); // command without data is loadUserAssignedCases
form.AddField("username", LoginMgr.GetInstance().Username);
// if we are offline then do trauma offline container
if (TraumaOfflineAssetContainer.GetInstance () != null &&
TraumaOfflineAssetContainer.GetInstance ().bUseOfflineAssets ) {
TraumaOfflineAssetContainer.GetInstance ().DBCallOffline (GameMgr.GetInstance().DatabaseURL, form, loadCases);
} else {
DBCall(GameMgr.GetInstance().DatabaseURL,form,loadCases);
}
}
public void LoadCaseConfigurations( DatabaseMgr.Callback callback )
{
if ( UsingLocalData == true )
{
// first try to load local CaseInfo.xml....if available then just use that
if ( LoadXML("XML/CaseInfo") != null )
{
// we have a local file, we're ok
callback(true,null,null,null);
return;
}
}
else
{
loadCasesCallback = callback;
WWWForm form = new WWWForm();
form.AddField("command", "loadCases");
form.AddField("owner", LoginMgr.GetInstance().Username);
// if we are offline then do trauma offline container
if (TraumaOfflineAssetContainer.GetInstance () != null &&
TraumaOfflineAssetContainer.GetInstance ().bUseOfflineAssets ) {
TraumaOfflineAssetContainer.GetInstance ().DBCallOffline (GameMgr.GetInstance().DatabaseURL, form, loadCases);
} else {
DBCall(GameMgr.GetInstance().DatabaseURL,form,loadCases);
}
}
}
public void LMSLoginWithPing( string username, string password, DatabaseMgr.Callback Callback )
{
UnityEngine.Debug.Log ("LMSLoginWithPing(" + username + ")");
// start off assuming logon is invalid
LMSLogout ();
// start login coroutine
StartCoroutine(lmsLoginWithPing(username,password,Callback));
}
public void Awake(){
instance=this;
}
protected void Button2_Click(object sender, EventArgs e)
{
Performance myPerformance1 = new Performance("A", "AA", 1.1m);
Performance myPerformance2 = new Performance("B", "BB", 2.2m);
Performance myPerformance3 = new Performance("C", "CC", 3.3m);
Performance myPerformance4 = new Performance("D", "AA", 4.1m);
Performance myPerformance5 = new Performance("E", "BB", 5.2m);
Performance myPerformance6 = new Performance("F", "CC", 6.3m);
List <Performance> myPerformancesA = new List <Performance>();
myPerformancesA.Add(myPerformance1);
myPerformancesA.Add(myPerformance2);
myPerformancesA.Add(myPerformance3);
List <Performance> myPerformancesB = new List <Performance>();
myPerformancesB.Add(myPerformance4);
myPerformancesB.Add(myPerformance5);
myPerformancesB.Add(myPerformance6);
Dictionary <string, List <Performance> > myPerformances = new Dictionary <string, List <Performance> >();
myPerformances.Add("Boy's 100", myPerformancesA);
myPerformances.Add("Boy's 200", myPerformancesB);
Dictionary <string, string> boysNames = new Dictionary <string, string>();
boysNames.Add("BLN", "Baldwin");
boysNames.Add("TJ", "Thomas Jefferson");
boysNames.Add("WHS", "Washington HS");
Dictionary <string, string> girlsNames = new Dictionary <string, string>();
girlsNames.Add("PLM", "Plum");
girlsNames.Add("GWY", "Gateway");
girlsNames.Add("KCH", "Knoch");
Teams teams = new Teams(boysNames, girlsNames);
Meet myMeetNoEvents = new Meet(new DateTime(2017, 04, 13), "Baldwin HS", "Windy", teams, myPerformances);
DatabaseMgr dbm = new DatabaseMgr();
dbm.AddMeet(myMeetNoEvents, "NoUsername");
/*TableRow meetRow = new TableRow();
* tblMeets.Rows.Add(meetRow);
*
* TableCell idCell = new TableCell();
* idCell.Text = "1";
* meetRow.Cells.Add(idCell);
*
* TableCell dateOfMeetCell = new TableCell();
* dateOfMeetCell.Text = myMeetNoEvents.dateOfMeet.ToString();
* meetRow.Cells.Add(dateOfMeetCell);
*
* TableCell locationCell = new TableCell();
* locationCell.Text = myMeetNoEvents.location;
* meetRow.Cells.Add(locationCell);
*
* TableCell weatherCell = new TableCell();
* weatherCell.Text = myMeetNoEvents.weatherConditions;
* meetRow.Cells.Add(weatherCell);
*
* for (int i = 0; i < myMeetNoEvents.schoolNames.boySchoolNames.Count; i++)
* {
* TableRow boysRow = new TableRow();
* tblBoysTeams.Rows.Add(boysRow);
*
* TableCell boysId = new TableCell();
* boysId.Text = (i + 1).ToString();
* boysRow.Cells.Add(boysId);
*
* TableCell abbrCell = new TableCell();
* abbrCell.Text = myMeetNoEvents.schoolNames.boySchoolNames.ElementAt(i).Key;
* boysRow.Cells.Add(abbrCell);
*
* TableCell tNameCell = new TableCell();
* tNameCell.Text = myMeetNoEvents.schoolNames.boySchoolNames.ElementAt(i).Value;
* boysRow.Cells.Add(tNameCell);
*
* TableCell meetKeyBoys = new TableCell();
* meetKeyBoys.Text = idCell.Text;
* boysRow.Cells.Add(meetKeyBoys);
* }
*
* for (int i = 0; i < myMeetNoEvents.schoolNames.girlSchoolNames.Count; i++)
* {
* TableRow girlsRow = new TableRow();
* tblGirlsTeams.Rows.Add(girlsRow);
*
* TableCell girlsId = new TableCell();
* girlsId.Text = (i + 1).ToString();
* girlsRow.Cells.Add(girlsId);
*
* TableCell abbrCell = new TableCell();
* abbrCell.Text = myMeetNoEvents.schoolNames.girlSchoolNames.ElementAt(i).Key;
* girlsRow.Cells.Add(abbrCell);
*
* TableCell tNameCell = new TableCell();
* tNameCell.Text = myMeetNoEvents.schoolNames.girlSchoolNames.ElementAt(i).Value;
* girlsRow.Cells.Add(tNameCell);
*
* TableCell meetKeygirls = new TableCell();
* meetKeygirls.Text = idCell.Text;
* girlsRow.Cells.Add(meetKeygirls);
* }
*
* if (myMeetNoEvents != null && myMeetNoEvents.performances != null)
* {
* foreach (string eventName in myMeetNoEvents.performances.Keys)
*
* //for (int i = 0; i < myMeetNoEvents.performances.Keys; i++)
* {
* foreach (Performance perf in myMeetNoEvents.performances[eventName])
* {
* TableRow perfRow = new TableRow();
* tblPerformances.Rows.Add(perfRow);
*
* TableCell perfId = new TableCell();
* perfId.Text = (100).ToString();
* perfRow.Cells.Add(perfId);
*
* TableCell athleteCell = new TableCell();
* athleteCell.Text = perf.athleteName;
* perfRow.Cells.Add(athleteCell);
*
* TableCell tNameCell = new TableCell();
* tNameCell.Text = perf.schoolName;
* perfRow.Cells.Add(tNameCell);
*
* TableCell genderCell = new TableCell();
* if (eventName.ToUpper().Contains("BOY"))
* {
* genderCell.Text = "Boy's";
* }
* else if (eventName.ToUpper().Contains("GIRL"))
* {
* genderCell.Text = "Girl's";
* }
* else
* {
* genderCell.Text = "";
* }
* perfRow.Cells.Add(genderCell);
*
* TableCell eventCell = new TableCell();
* eventCell.Text = eventName;
* perfRow.Cells.Add(eventCell);
*
* TableCell heatCell = new TableCell();
* heatCell.Text = perf.heatNum.ToString();
* perfRow.Cells.Add(heatCell);
*
* TableCell perfCell = new TableCell();
* perfCell.Text = perf.performance.ToString();
* perfRow.Cells.Add(perfCell);
*
* TableCell meetKeyPerf = new TableCell();
* meetKeyPerf.Text = idCell.Text;
* perfRow.Cells.Add(meetKeyPerf);
*
* }
* }
* }*/
}
IEnumerator lmsLoginWithPing( string username, string password, DatabaseMgr.Callback Callback )
{
//string URL="http://192.168.12.148/api3/corwin/r2d0/statefull/auth/";
//string bodyString = "{\"action\":\"NoOrg\",\"params\":{\"username\":\"" + username + "\",\"password\":\"" + password + "\"},\"authKey\":null}";
string url = "http://" + URL + "statefull/auth";
//string bodyString = "{\"action\":\"User\",\"params\":{\"user_name\":\"" + username + "\",\"password\":\"" + password + "\"},\"authKey\":null}";
// make JSON
JSONObject j = new JSONObject(JSONObject.Type.OBJECT);
//number
j.AddField("action", "NoOrg");
// make param area
JSONObject arr = new JSONObject(JSONObject.Type.ARRAY);
j.AddField("params", arr);
// add params
arr.AddField ("username",username);
arr.AddField ("password", password );
// add authkey
string keyNoQuotes = pingAuthKey.Replace ("\"","");
j.AddField ("authKey",keyNoQuotes);
// get bodystring
string bodyString = j.print();
WWW download = new WWW(url,Encoding.ASCII.GetBytes(bodyString));
yield return download;
//Application.ExternalCall("Debug","LMSIntegration.lmsLoginWithPing() : URL=" + url + " : bodyString=" + bodyString + " : text=" + download.text + " : error=" + download.error );
string DBResult="";
string DBErrorString;
if (download.error != null)
{
LMSDebug ("LMSIntegration.lmsLoginWithPing(" + username + "," + password + ") url=<" + url + "> bodyString=<" + bodyString + "> error=<" + download.error + ">");
// save the error
DBResult = null;
DBErrorString = download.error;
// do callback
if (Callback != null)
Callback(false, DBResult, DBErrorString, download);
// do global callback
if (DatabaseMgr.GetInstance() != null && DatabaseMgr.GetInstance().ErrorCallback != null )
DatabaseMgr.GetInstance().ErrorCallback(false,DBResult,DBErrorString,download);
}
else
{
LMSDebug ("LMSIntegration.lmsLoginWithPing(" + username + "," + password + ") url=<" + url + "> bodyString=<" + bodyString + "> text=<" + download.text + ">");
if ( download.text == null )
{
DBResult = "invalid";
UnityEngine.Debug.LogError ("LMSIntegration.LMSLoginWithPing() : download.text is null!");
}
else
{
JSONObject decoder = new JSONObject(download.text);
if ( CheckReturn(decoder) == true )
{
JSONObject authkey = decoder.GetField ("authKey");
if ( authkey != null )
{
#if !UNITY_WEBPLAYER
// get response headers
GetCookies(download);
#endif
// get authkey
pingAuthKey = authkey.print ();
LMSPing (pingAuthKey);
DBResult = "ok";
}
else
{
DBResult = "invalid";
UnityEngine.Debug.LogError ("LMSIntegration.LMSLoginWithPing() : username=<" + username + "> password=<" + password + "> result=" + download.text);
}
}
else
{
DBResult = "invalid";
UnityEngine.Debug.LogError ("LMSIntegration.LMSLoginWithPing() : username=<" + username + "> password=<" + password + "> result=" + download.text);
}
}
// save the results
DBErrorString = "";
// do callback
if (Callback != null)
Callback(true, DBResult, DBErrorString, download);
}
}
public questStatus SaveTablesetConfiguration(TablesetConfiguration tablesetConfiguration, out TablesetId tablesetId)
{
// Initialize
questStatus status = null;
tablesetId = null;
DbMgrTransaction trans = null;
bool bFiltersRemoved = false;
questStatus status2 = null;
try
{
// BEGIN TRANSACTION
status = BeginTransaction("SaveTablesetConfiguration" + Guid.NewGuid().ToString(), out trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
/*
* Update tableset info.
*/
// Read the tableset
TablesetsMgr tablesetsMgr = new TablesetsMgr(this.UserSession);
TablesetId _tablesetId = new TablesetId(tablesetConfiguration.Tableset.Id);
Tableset _tableset = null;
status = tablesetsMgr.Read(trans, _tablesetId, out _tableset);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
/*
* Remove all tableset entities.
*/
status = ClearTablesetEntities(trans, _tablesetId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
// TESTING ONLY: COMMIT TRANSACTION
bool bKlugie = false;
if (bKlugie)
{
status = CommitTransaction(trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
/*
* Get database entites.
*/
DatabaseId databaseId = new DatabaseId(tablesetConfiguration.Database.Id);
DatabaseMgr databaseMgr = new DatabaseMgr(this.UserSession);
DatabaseEntities databaseEntities = null;
status = databaseMgr.ReadDatabaseEntities(databaseId, out databaseEntities);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
#region Save tableset info.
/*
* Save tableset info.
*/
DbTablesetColumnsMgr dbTablesetColumnsMgr = new DbTablesetColumnsMgr(this.UserSession);
// Save table info.
DbTablesetTablesMgr dbTablesetTablesMgr = new DbTablesetTablesMgr(this.UserSession);
List <TablesetTable> tablesetTableList = new List <TablesetTable>();
foreach (TablesetTable tablesetTable in tablesetConfiguration.TablesetTables)
{
Table _table = databaseEntities.TableList.Find(delegate(Table t) { return(t.Schema == tablesetTable.Schema && t.Name == tablesetTable.Name); });
if (_table == null)
{
RollbackTransaction(trans);
return(new questStatus(Severity.Error, String.Format("ERROR: tableset table [{0}].[{1}] not found in database metainfo. Try refreshing database schema info",
tablesetTable.Schema, tablesetTable.Name)));
}
tablesetTable.TablesetId = _tableset.Id;
tablesetTable.Table = _table;
tablesetTableList.Add(tablesetTable);
// Create tableset table.
TablesetTableId tablesetTableId = null;
status = dbTablesetTablesMgr.Create(trans, tablesetTable, out tablesetTableId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
foreach (Column column in _table.ColumnList)
{
Column _column = _table.ColumnList.Find(delegate(Column c) { return(c.Name == column.Name); });
if (_column == null)
{
RollbackTransaction(trans);
return(new questStatus(Severity.Error, String.Format("ERROR: column [{0}] not found in table [{1}].[{2}] in database metainfo. Try refreshing database schema info",
column.Name, _table.Schema, _table.Name)));
}
TablesetColumn tablesetColumn = new TablesetColumn();
tablesetColumn.EntityTypeId = EntityType.Table;
tablesetColumn.TableSetEntityId = tablesetTableId.Id;
tablesetColumn.Name = column.Name;
TablesetColumnId tablesetColumnId = null;
status = dbTablesetColumnsMgr.Create(trans, tablesetColumn, out tablesetColumnId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
}
}
// Save view info.
DbTablesetViewsMgr dbTablesetViewsMgr = new DbTablesetViewsMgr(this.UserSession);
List <TablesetView> tablesetViewList = new List <TablesetView>();
foreach (TablesetView tablesetView in tablesetConfiguration.TablesetViews)
{
View _view = databaseEntities.ViewList.Find(delegate(View v) { return(v.Schema == tablesetView.Schema && v.Name == tablesetView.Name); });
if (_view == null)
{
RollbackTransaction(trans);
return(new questStatus(Severity.Error, String.Format("ERROR: tableset view [{0}].[{1}] not found in database metainfo. Try refreshing database schema info",
tablesetView.Schema, tablesetView.Name)));
}
tablesetView.TablesetId = _tableset.Id;
tablesetView.View = _view;
tablesetViewList.Add(tablesetView);
// Create tableset view.
TablesetViewId tablesetViewId = null;
status = dbTablesetViewsMgr.Create(trans, tablesetView, out tablesetViewId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
foreach (Column column in _view.ColumnList)
{
Column _column = _view.ColumnList.Find(delegate(Column c) { return(c.Name == column.Name); });
if (_column == null)
{
RollbackTransaction(trans);
return(new questStatus(Severity.Error, String.Format("ERROR: column [{0}] not found in view [{1}].[{2}] in database metainfo. Try refreshing database schema info",
column.Name, _view.Schema, _view.Name)));
}
TablesetColumn tablesetColumn = new TablesetColumn();
tablesetColumn.EntityTypeId = EntityType.View;
tablesetColumn.TableSetEntityId = tablesetViewId.Id;
tablesetColumn.Name = column.Name;
TablesetColumnId tablesetColumnId = null;
status = dbTablesetColumnsMgr.Create(trans, tablesetColumn, out tablesetColumnId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
}
}
#endregion
// Update tableset.
bFiltersRemoved = false;
_tableset.DatabaseId = tablesetConfiguration.Database.Id;
status2 = tablesetsMgr.Update(trans, _tableset);
if (!questStatusDef.IsSuccess(status2))
{
if (questStatusDef.IsWarning(status2))
{
bFiltersRemoved = true;
}
else
{
RollbackTransaction(trans);
return(status);
}
}
// COMMIT TRANSACTION
status = CommitTransaction(trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Return the tableset id
tablesetId = new TablesetId(tablesetConfiguration.Tableset.Id);
}
catch (System.Exception ex)
{
if (trans != null)
{
RollbackTransaction(trans);
}
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
if (bFiltersRemoved)
{
return(status2);
}
return(new questStatus(Severity.Success));
}
//
// LOGIN METHODS
// passes username ,password, and callback
//
//
public void LMSLogin( string username, string password, DatabaseMgr.Callback Callback )
{
StartCoroutine(lmsLogin(username,password,Callback));
}
protected void Button3_Click(object sender, EventArgs e)
{
DatabaseMgr dbm = new DatabaseMgr();
dbm.ResetPrimaryKeys();
}
protected void cmdCreate_Click(object sender, EventArgs e)
{
panAlert.Visible = true;
if (txtLocation.Text == "")
{
lblAlert.Text = "Please enter a location";
}
else if (txtWeather.Text == "")
{
lblAlert.Text = "Please enter weather conditions";
}
else if (string.IsNullOrWhiteSpace(txtBoysTeam1.Text) || string.IsNullOrWhiteSpace(txtBoysAbbr1.Text))
{
lblAlert.Text = "Please enter team name information for boy's team #1";
}
else if ((string.IsNullOrWhiteSpace(txtBoysTeam2.Text) && !string.IsNullOrWhiteSpace(txtBoysAbbr2.Text)) || (!string.IsNullOrWhiteSpace(txtBoysTeam2.Text) && string.IsNullOrWhiteSpace(txtBoysAbbr2.Text)))
{
lblAlert.Text = "Invalid name information for boy's team #2";
}
else if ((string.IsNullOrWhiteSpace(txtBoysTeam3.Text) && !string.IsNullOrWhiteSpace(txtBoysAbbr3.Text)) || (!string.IsNullOrWhiteSpace(txtBoysTeam3.Text) && string.IsNullOrWhiteSpace(txtBoysAbbr3.Text)))
{
lblAlert.Text = "Invalid name information for boy's team #3";
}
else if ((string.IsNullOrWhiteSpace(txtBoysTeam4.Text) && !string.IsNullOrWhiteSpace(txtBoysAbbr4.Text)) || (!string.IsNullOrWhiteSpace(txtBoysTeam4.Text) && string.IsNullOrWhiteSpace(txtBoysAbbr4.Text)))
{
lblAlert.Text = "Invalid name information for boy's team #4";
}
else if ((string.IsNullOrWhiteSpace(txtBoysTeam5.Text) && !string.IsNullOrWhiteSpace(txtBoysAbbr5.Text)) || (!string.IsNullOrWhiteSpace(txtBoysTeam5.Text) && string.IsNullOrWhiteSpace(txtBoysAbbr5.Text)))
{
lblAlert.Text = "Invalid name information for boy's team #5";
}
else if ((string.IsNullOrWhiteSpace(txtBoysTeam6.Text) && !string.IsNullOrWhiteSpace(txtBoysAbbr6.Text)) || (!string.IsNullOrWhiteSpace(txtBoysTeam6.Text) && string.IsNullOrWhiteSpace(txtBoysAbbr6.Text)))
{
lblAlert.Text = "Invalid name information for boy's team #6";
}
else if (string.IsNullOrWhiteSpace(txtGirlsTeam1.Text) || string.IsNullOrWhiteSpace(txtGirlsAbbr1.Text))
{
lblAlert.Text = "Please enter team name information for girl's team #1";
}
else if ((string.IsNullOrWhiteSpace(txtGirlsTeam2.Text) && !string.IsNullOrWhiteSpace(txtGirlsAbbr2.Text)) || (!string.IsNullOrWhiteSpace(txtGirlsTeam2.Text) && string.IsNullOrWhiteSpace(txtGirlsAbbr2.Text)))
{
lblAlert.Text = "Invalid name information for girl's team #2";
}
else if ((string.IsNullOrWhiteSpace(txtGirlsTeam3.Text) && !string.IsNullOrWhiteSpace(txtGirlsAbbr3.Text)) || (!string.IsNullOrWhiteSpace(txtGirlsTeam3.Text) && string.IsNullOrWhiteSpace(txtGirlsAbbr3.Text)))
{
lblAlert.Text = "Invalid name information for girl's team #3";
}
else if ((string.IsNullOrWhiteSpace(txtGirlsTeam4.Text) && !string.IsNullOrWhiteSpace(txtGirlsAbbr4.Text)) || (!string.IsNullOrWhiteSpace(txtGirlsTeam4.Text) && string.IsNullOrWhiteSpace(txtGirlsAbbr4.Text)))
{
lblAlert.Text = "Invalid name information for girl's team #4";
}
else if ((string.IsNullOrWhiteSpace(txtGirlsTeam5.Text) && !string.IsNullOrWhiteSpace(txtGirlsAbbr5.Text)) || (!string.IsNullOrWhiteSpace(txtGirlsTeam5.Text) && string.IsNullOrWhiteSpace(txtGirlsAbbr5.Text)))
{
lblAlert.Text = "Invalid name information for girl's team #5";
}
else if ((string.IsNullOrWhiteSpace(txtGirlsTeam6.Text) && !string.IsNullOrWhiteSpace(txtGirlsAbbr6.Text)) || (!string.IsNullOrWhiteSpace(txtGirlsTeam6.Text) && string.IsNullOrWhiteSpace(txtGirlsAbbr6.Text)))
{
lblAlert.Text = "Invalid name information for girl's team #6";
}
else
{
string meetLocation = txtLocation.Text;
int month = 1;
if (ddlMonth.Text == "February")
{
month = 2;
}
else if (ddlMonth.Text == "March")
{
month = 3;
}
else if (ddlMonth.Text == "April")
{
month = 4;
}
else if (ddlMonth.Text == "May")
{
month = 5;
}
else if (ddlMonth.Text == "June")
{
month = 6;
}
else if (ddlMonth.Text == "July")
{
month = 7;
}
else if (ddlMonth.Text == "August")
{
month = 8;
}
else if (ddlMonth.Text == "September")
{
month = 9;
}
else if (ddlMonth.Text == "October")
{
month = 10;
}
else if (ddlMonth.Text == "November")
{
month = 11;
}
else if (ddlMonth.Text == "December")
{
month = 12;
}
DateTime meetDateTime = new DateTime(Convert.ToInt32(ddlYear.Text), month, Convert.ToInt32(ddlDay.Text));
string meetWeather = txtWeather.Text;
string boysTeam1Abbr = txtBoysAbbr1.Text.Trim();
string boysTeam1Name = txtBoysTeam1.Text.Trim();
string boysTeam2Abbr = txtBoysAbbr2.Text.Trim();
string boysTeam2Name = txtBoysTeam2.Text.Trim();
string boysTeam3Abbr = txtBoysAbbr3.Text.Trim();
string boysTeam3Name = txtBoysTeam3.Text.Trim();
string boysTeam4Abbr = txtBoysAbbr4.Text.Trim();
string boysTeam4Name = txtBoysTeam4.Text.Trim();
string boysTeam5Abbr = txtBoysAbbr5.Text.Trim();
string boysTeam5Name = txtBoysTeam5.Text.Trim();
string boysTeam6Abbr = txtBoysAbbr6.Text.Trim();
string boysTeam6Name = txtBoysTeam6.Text.Trim();
string girlsTeam1Abbr = txtGirlsAbbr1.Text.Trim();
string girlsTeam1Name = txtGirlsTeam1.Text.Trim();
string girlsTeam2Abbr = txtGirlsAbbr2.Text.Trim();
string girlsTeam2Name = txtGirlsTeam2.Text.Trim();
string girlsTeam3Abbr = txtGirlsAbbr3.Text.Trim();
string girlsTeam3Name = txtGirlsTeam3.Text.Trim();
string girlsTeam4Abbr = txtGirlsAbbr4.Text.Trim();
string girlsTeam4Name = txtGirlsTeam4.Text.Trim();
string girlsTeam5Abbr = txtGirlsAbbr5.Text.Trim();
string girlsTeam5Name = txtGirlsTeam5.Text.Trim();
string girlsTeam6Abbr = txtGirlsAbbr6.Text.Trim();
string girlsTeam6Name = txtGirlsTeam6.Text.Trim();
List <string> boysNames = new List <string>();
if (!string.IsNullOrWhiteSpace(boysTeam1Name))
{
boysNames.Add(boysTeam1Name);
}
if (!string.IsNullOrWhiteSpace(boysTeam2Name))
{
boysNames.Add(boysTeam2Name);
}
if (!string.IsNullOrWhiteSpace(boysTeam3Name))
{
boysNames.Add(boysTeam3Name);
}
if (!string.IsNullOrWhiteSpace(boysTeam4Name))
{
boysNames.Add(boysTeam4Name);
}
if (!string.IsNullOrWhiteSpace(boysTeam5Name))
{
boysNames.Add(boysTeam5Name);
}
if (!string.IsNullOrWhiteSpace(boysTeam6Name))
{
boysNames.Add(boysTeam6Name);
}
List <string> boysAbbrs = new List <string>();
if (!string.IsNullOrWhiteSpace(boysTeam1Abbr))
{
boysAbbrs.Add(boysTeam1Abbr);
}
if (!string.IsNullOrWhiteSpace(boysTeam2Abbr))
{
boysAbbrs.Add(boysTeam2Abbr);
}
if (!string.IsNullOrWhiteSpace(boysTeam3Abbr))
{
boysAbbrs.Add(boysTeam3Abbr);
}
if (!string.IsNullOrWhiteSpace(boysTeam4Abbr))
{
boysAbbrs.Add(boysTeam4Abbr);
}
if (!string.IsNullOrWhiteSpace(boysTeam5Abbr))
{
boysAbbrs.Add(boysTeam5Abbr);
}
if (!string.IsNullOrWhiteSpace(boysTeam6Abbr))
{
boysAbbrs.Add(boysTeam6Abbr);
}
List <string> girlsNames = new List <string>();
if (!string.IsNullOrWhiteSpace(girlsTeam1Name))
{
girlsNames.Add(girlsTeam1Name);
}
if (!string.IsNullOrWhiteSpace(girlsTeam2Name))
{
girlsNames.Add(girlsTeam2Name);
}
if (!string.IsNullOrWhiteSpace(girlsTeam3Name))
{
girlsNames.Add(girlsTeam3Name);
}
if (!string.IsNullOrWhiteSpace(girlsTeam4Name))
{
girlsNames.Add(girlsTeam4Name);
}
if (!string.IsNullOrWhiteSpace(girlsTeam5Name))
{
girlsNames.Add(girlsTeam5Name);
}
if (!string.IsNullOrWhiteSpace(girlsTeam6Name))
{
girlsNames.Add(girlsTeam6Name);
}
List <string> girlsAbbrs = new List <string>();
if (!string.IsNullOrWhiteSpace(girlsTeam1Abbr))
{
girlsAbbrs.Add(girlsTeam1Abbr);
}
if (!string.IsNullOrWhiteSpace(girlsTeam2Abbr))
{
girlsAbbrs.Add(girlsTeam2Abbr);
}
if (!string.IsNullOrWhiteSpace(girlsTeam3Abbr))
{
girlsAbbrs.Add(girlsTeam3Abbr);
}
if (!string.IsNullOrWhiteSpace(girlsTeam4Abbr))
{
girlsAbbrs.Add(girlsTeam4Abbr);
}
if (!string.IsNullOrWhiteSpace(girlsTeam5Abbr))
{
girlsAbbrs.Add(girlsTeam5Abbr);
}
if (!string.IsNullOrWhiteSpace(girlsTeam6Abbr))
{
girlsAbbrs.Add(girlsTeam6Abbr);
}
if (boysNames.Distinct().Count() != boysNames.Count())
{
lblAlert.Text = "All Boy's names must be unique";
}
else if (boysAbbrs.Distinct().Count() != boysAbbrs.Count())
{
lblAlert.Text = "All Boy's abbrs must be unique";
}
else if (girlsNames.Distinct().Count() != girlsNames.Count())
{
lblAlert.Text = "All Girl's names must be unique";
}
else if (girlsAbbrs.Distinct().Count() != girlsAbbrs.Count())
{
lblAlert.Text = "All Girl's abbrs must be unique";
}
else
{
Dictionary <string, string> boysTeams = new Dictionary <string, string>();
boysTeams.Add(boysTeam1Abbr, boysTeam1Name);
if (!string.IsNullOrWhiteSpace(boysTeam2Abbr))
{
boysTeams.Add(boysTeam2Abbr, boysTeam2Name);
}
if (!string.IsNullOrWhiteSpace(boysTeam3Abbr))
{
boysTeams.Add(boysTeam3Abbr, boysTeam3Name);
}
if (!string.IsNullOrWhiteSpace(boysTeam4Abbr))
{
boysTeams.Add(boysTeam4Abbr, boysTeam4Name);
}
if (!string.IsNullOrWhiteSpace(boysTeam5Abbr))
{
boysTeams.Add(boysTeam5Abbr, boysTeam5Name);
}
if (!string.IsNullOrWhiteSpace(boysTeam6Abbr))
{
boysTeams.Add(boysTeam6Abbr, boysTeam6Name);
}
Dictionary <string, string> girlsTeams = new Dictionary <string, string>();
girlsTeams.Add(girlsTeam1Abbr, girlsTeam1Name);
if (!string.IsNullOrWhiteSpace(girlsTeam2Abbr))
{
girlsTeams.Add(girlsTeam2Abbr, girlsTeam2Name);
}
if (!string.IsNullOrWhiteSpace(girlsTeam3Abbr))
{
girlsTeams.Add(girlsTeam3Abbr, girlsTeam3Name);
}
if (!string.IsNullOrWhiteSpace(girlsTeam4Abbr))
{
girlsTeams.Add(girlsTeam4Abbr, girlsTeam4Name);
}
if (!string.IsNullOrWhiteSpace(girlsTeam5Abbr))
{
girlsTeams.Add(girlsTeam5Abbr, girlsTeam5Name);
}
if (!string.IsNullOrWhiteSpace(girlsTeam6Abbr))
{
girlsTeams.Add(girlsTeam6Abbr, girlsTeam6Name);
}
Teams newTeams = new Teams(boysTeams, girlsTeams);
newMeet = new Meet(meetDateTime, meetLocation, meetWeather, newTeams);
if (newMeet.validate())
{
DatabaseMgr dm = new DatabaseMgr();
meetID = dm.FindMeetId(newMeet);
if (meetID < 0)
{
panAlert.GroupingText = "Problem loading meet database. Please try again later";
}
else
{
if (meetID == 0) //Meet does not exist in database
{
bool didAdd = dm.AddMeet(newMeet, Session["Username"].ToString());
if (didAdd)
{
Session["ActiveMeet"] = newMeet;
//Open MeetHub here
Response.Redirect("MeetHub.aspx");
}
else
{
lblAlert.Text = "Problem addign meet to database, please try again later";
}
}
else
{
panAlert.Visible = false;
panDatabaseAlert.Visible = true;
lblDatabaseAlert.Text = "Meet already exists, do you wish to overwrite existing meet, or open existing meet?";
cmdCreate.Visible = false;
}
}
}
else
{
lblAlert.Text = "Unknown problem creating this meet. Data was invalid.";
}
}
}
}
public void CheckLoginWithPing( string username, string password, DatabaseMgr.Callback callback )
{
this.username = username;
this.password = password;
// check for built-in admin
if ( username == AdminName && password == AdminPassword )
{
admin = true;
validLogin = true;
if ( callback != null )
callback(true,"","",null);
return;
}
checkLoginCallback = callback;
LMSIntegration.GetInstance().LMSLoginWithPing(username,password,LoginCallback);
}
public DatabaseMgr() // don't use constructors for MonoBehavior derived classes, use Awake or Start to initialize
{
instance = this;
}
IEnumerator CallbackAfterDelay(DatabaseMgr.Callback callback, string data){
yield return new WaitForSeconds(0.1f);
callback(true, data, "", null); // could tell them we are offline...
}
public void GetLogins( DatabaseMgr.Callback callback )
{
WWWForm form = new WWWForm();
form.AddField("command","loadLogins");
DatabaseMgr.GetInstance().DBCall(GameMgr.GetInstance().DatabaseURL,form,getLoginsCallback);
loginsCallback = callback;
}
public void CreateUser( string username, string password, string first, string last, bool admin, bool tutorial, DatabaseMgr.Callback createCallback )
{
// create empty case list
Serializer<List<string>> serializer = new Serializer<List<string>>();
string emptyCaseList = serializer.ToString(new List<string>());
// create user in logins
WWWForm form = new WWWForm();
form.AddField("command","createUser");
form.AddField("username",username);
form.AddField("password",password);
form.AddField("first",first);
form.AddField("last",last);
form.AddField("admin",(admin==true)?"1":"0");
form.AddField("tutorial",(tutorial==true)?"1":"0");
form.AddField("data",emptyCaseList);
DatabaseMgr.GetInstance().DBCall(GameMgr.GetInstance().DatabaseURL,form,createCallback);
}
public void CheckLogin( string username, string password, DatabaseMgr.Callback callback )
{
this.username = username;
this.password = password;
// check for built-in admin
if ( username == AdminName && password == AdminPassword )
{
admin = true;
validLogin = true;
if ( callback != null )
callback(true,"","",null);
return;
}
if ( AllowGuest == true && username == "guest" )
{
admin = false;
validLogin = true;
if ( callback != null )
callback(true,"","",null);
return;
}
checkLoginCallback = callback;
#if USE_LMS_LOGIN
LMSIntegration.GetInstance().LMSLoginWithPing(username,password,LoginCallback);
#else
WWWForm form = new WWWForm();
form.AddField("command","login");
form.AddField("username", username);
form.AddField("password", password);
DatabaseMgr.GetInstance().DBCall(GameMgr.GetInstance().DatabaseURL,form,LoginCallback);
#endif
}
public DBCallInfo( string url, WWWForm form, DatabaseMgr.Callback callback )
{
URL = url;
Form = form;
Callback = callback;
}
IEnumerator lmsLogin( string username, string password, DatabaseMgr.Callback Callback )
{
string url = "http://www.sitelms.org/restapi/auth";
//string bodyString = "{\"action\":\"User\",\"params\":{\"user_name\":\"" + username + "\",\"password\":\"" + password + "\"},\"authKey\":null}";
// make JSON
JSONObject j = new JSONObject(JSONObject.Type.OBJECT);
//number
j.AddField("action", "User");
// make param area
JSONObject arr = new JSONObject(JSONObject.Type.ARRAY);
j.AddField("params", arr);
// add params
arr.AddField ("user_name",username);
arr.AddField ("password", password );
// add authkey
string keyNoQuotes = pingAuthKey.Replace ("\"","");
j.AddField ("authKey",keyNoQuotes);
// get bodystring
string bodyString = j.print();
// Create a download object
WWW download = new WWW(url,Encoding.ASCII.GetBytes(bodyString));
yield return download;
//Application.ExternalCall("Debug","LMSIntegration.lmsLogin() : URL=" + url + " : bodyString=" + bodyString );
string DBResult;
string DBErrorString;
if (download.error != null)
{
DBResult = "";
DBErrorString = download.error;
// do callback
if (Callback != null)
Callback(false, DBResult, DBErrorString, download);
// do global callback
if (DatabaseMgr.GetInstance().ErrorCallback != null )
DatabaseMgr.GetInstance().ErrorCallback(false,DBResult,DBErrorString,download);
}
else
{
if ( download.text == null )
{
DBResult = "invalid";
UnityEngine.Debug.LogError ("LMSIntegration.LMSLogin() : download.text is null!");
}
else
{
JSONObject decoder = new JSONObject(download.text);
if ( CheckReturn(decoder) == true )
{
JSONObject authkey = decoder.GetField ("authKey");
if ( authkey != null )
{
if ( authkey.print () != "null" )
{
DBResult = "ok";
UnityEngine.Debug.LogError ("LMSIntegration.LMSLogin() : authKey=" + authkey.print () + " : valid");
}
else
{
DBResult = "invalid";
UnityEngine.Debug.LogError ("LMSIntegration.LMSLogin() : authKey=" + authkey.print () + " : not valid");
}
}
else
{
DBResult = "invalid";
UnityEngine.Debug.LogError ("LMSIntegration.LMSLogin() : username=<" + username + "> password=<" + password + "> result=" + download.text);
}
}
else
{
DBResult = "invalid";
UnityEngine.Debug.LogError ("LMSIntegration.LMSLogin() : username=<" + username + "> password=<" + password + "> result=" + download.text);
}
}
// save the results
DBErrorString = "";
// do callback
if (Callback != null)
Callback(true, DBResult, DBErrorString, download);
}
}
