//Login
private void BtnSubmit_Clicked(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(entPassword.Text) || String.IsNullOrEmpty(entUsername.Text))
{
lblError.Text = "Please enter your credentials first.";
lblError.IsVisible = true;
}
else
{
int userID = NetworkUtils.Login(entUsername.Text, entPassword.Text);
if (userID == 0)
{
lblError.Text = "Not a valid username and password.";
lblError.IsVisible = true;
}
else
{
AppProperties.setSavedUserId(userID);
AppProperties.saveUserName(entUsername.Text);
if (Application.Current.Properties.ContainsKey("currentGroupID"))
{
String groupName = Application.Current.Properties["currentGroup"].ToString();
CreatePage.createHamburgerIcon(new GroupPage(), groupName);
}
else
{
CreatePage.createHamburgerIcon(new MainPage(), entUsername.Text);
}
}
}
}
//Insert new users into DB
public static int insertUser(String userIP, String userName, String password)
{
int userID = 0;
String connString = @"Server=youseedatabase.cxj5odskcws0.us-east-2.rds.amazonaws.com,1433;DataBase=yousee;User ID=youseeDatabase; Password=yousee18";
try
{
using (SqlConnection sqlConn = new SqlConnection(connString))
{
String spName = "insertUser";
String passUserName = "******";
String passUserIP = "@userIP";
String passPassword = "******";
using (SqlCommand command = sqlConn.CreateCommand())
{
command.CommandType = CommandType.StoredProcedure;
command.CommandText = spName;
command.Parameters.Add(new SqlParameter(passUserIP, userIP));
command.Parameters.Add(new SqlParameter(passUserName, userName));
command.Parameters.Add(new SqlParameter(passPassword, password));
sqlConn.Open();
try
{
//Executes the stored procedure and returns the userID
userID = (int)command.ExecuteScalar();
AppProperties.setSavedUserId(userID);
}
catch (Exception exc)
{
Console.WriteLine(exc.Message);
userID = 0;
}
finally
{
sqlConn.Close();
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
//App.Current.Properties.Add("savedUserID", userID);
//Console.WriteLine(App.Current.Properties["savedUserID"]);
return(userID);
}//end InsertDB