public void SaveFamily()
{
login = new Login();
login.AcctType = "Family";
login.UserName = family.UserName;
login.Password = family.Password;
try
{
AdoptDatabase adoptDatabase = new AdoptDatabase();
int i = adoptDatabase.SaveFamily(family).Result;
int l = adoptDatabase.SaveLogin(login).Result;
if (i == 1 && l == 1)
{
ClearFamily();
lblInfo = "User Saved Successfully.";
}
else
{
lblInfo = "Cannot Save User";
}
}
catch (Exception ex)
{
lblInfo = ex.Message.ToString();
}
}
public void GetWorkers()
{
try
{
AdoptDatabase adoptDB = new AdoptDatabase();
var workers = adoptDB.GetCaseWorkers().Result;
if (workers != null && workers.Count > 0)
{
lstWorkers = new ObservableCollection <CaseWorker>();
foreach (var worker in workers)
{
lstWorkers.Add(new CaseWorker
{
WorkerId = worker.WorkerId,
UserName = worker.UserName,
Password = worker.Password,
Name = worker.Name
});
}
lblInfo = "Total " + workers.Count.ToString() + " record(s) found";
}
else
{
lblInfo = "No logins records found. Please add one";
}
}
catch (Exception ex)
{
lblInfo = ex.Message.ToString();
}
}
public void GetLogins()
{
try
{
AdoptDatabase adoptDB = new AdoptDatabase();
var logins = adoptDB.GetLogins().Result;
if (logins != null && logins.Count > 0)
{
lstLogins = new ObservableCollection <Login>();
foreach (var login in logins)
{
lstLogins.Add(new Login
{
LoginId = login.LoginId,
UserName = login.UserName,
Password = login.Password,
AcctType = login.AcctType
});
}
lblInfo = "Total " + logins.Count.ToString() + " record(s) found";
}
else
{
lblInfo = "No login records found. Please add one";
}
}
catch (Exception ex)
{
lblInfo = ex.Message.ToString();
}
}
public void SaveCaseWorker()
{
login = new Login();
login.AcctType = "Worker";
login.UserName = caseWorker.UserName;
login.Password = caseWorker.Password;
try
{
AdoptDatabase adoptDatabase = new AdoptDatabase();
int i = adoptDatabase.SaveCaseWorker(caseWorker).Result;
int l = adoptDatabase.SaveLogin(login).Result;
if (i == 1 && l == 1)
{
ClearCaseWorker();
lblInfo = "Caseworker Saved Successfully.";
}
else
{
lblInfo = "Cannot save Caseworker Information";
}
}
catch (Exception ex)
{
lblInfo = ex.Message.ToString();
}
}
public void GetFamilies()
{
try
{
AdoptDatabase adoptDB = new AdoptDatabase();
var fams = adoptDB.GetFamilies().Result;
if (fams != null && fams.Count > 0)
{
lstFams = new ObservableCollection <Family>();
foreach (var fam in fams)
{
lstFams.Add(new Family
{
FamilyId = fam.FamilyId,
UserName = fam.UserName,
Password = fam.Password
});
}
lblInfo = "Total " + fams.Count.ToString() + " record(s) found";
}
else
{
lblInfo = "No family records found. Please add one";
}
}
catch (Exception ex)
{
lblInfo = ex.Message.ToString();
}
}
async Task ExecuteLoadCasesCommand()
{
try
{
lstCases.Clear();
AdoptDatabase caseDatabase = new AdoptDatabase();
var cases = await caseDatabase.GetCases();
foreach (var child in cases)
{
lstCases.Add(child);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
}
public void GetCases()
{
try
{
AdoptDatabase caseDatabase = new AdoptDatabase();
var cases = caseDatabase.GetCases().Result;
if (cases != null && cases.Count > 0)
{
lstCases = new ObservableCollection <Case>();
foreach (var child in cases)
{
lstCases.Add(new Case
{
CaseNum = child.CaseNum,
Pic = child.Pic,
Description = child.Description,
Group = child.Group,
Name = child.Name,
Age = child.Age,
Gender = child.Gender,
State = child.State,
Race = child.Race,
Language = child.Language,
Bio = child.Bio,
Interests = child.Interests
});
}
lblInfo = "Total " + cases.Count.ToString() + " record(s) found";
}
else
{
lblInfo = "No case records found. Please add one";
}
}
catch (Exception ex)
{
lblInfo = ex.Message.ToString();
}
}
public void SaveCase()
{
try
{
AdoptDatabase adoptDatabase = new AdoptDatabase();
int i = adoptDatabase.SaveCase(child).Result;
if (i == 1)
{
ClearCase();
lblInfo = "Case Saved Successfully.";
}
else
{
lblInfo = "Cannot Save Case Information";
}
}
catch (Exception ex)
{
lblInfo = ex.Message.ToString();
}
}
private async void OnLoginClicked(object obj)
{
Routing.RegisterRoute(nameof(WorkerNav), typeof(WorkerNav));
Routing.RegisterRoute(nameof(FamNav), typeof(FamNav));
AdoptDatabase adoptDB = new AdoptDatabase();
string userName = login.UserName;
string password = login.Password;
if (userName != null && userName != "" && password != null && password != "")
{
Login check = await adoptDB.GetLogin(userName);
if (check.UserName == userName && check.Password == password)
{
if (check.AcctType == "Family")
{
await Shell.Current.GoToAsync(nameof(FamNav));
}
else if (check.AcctType == "Worker")
{
await Shell.Current.GoToAsync(nameof(WorkerNav));
}
else
{
lblInfo = "There was an error - Account type";
}
}
else
{
lblInfo = "Incorrect username and/or password, please try again.";
}
}
else
{
lblInfo = "Please enter a username and password.";
}
}
