/// <summary>
/// Cached Map.
/// </summary>
private static void CacheThreadMap()
{
using (MapContext connection = new MapContext())
{
var entity = connection.Map.ToList().FirstOrDefault();
}
}
/// <summary>
/// Event: Connect to the database.
/// </summary>
/// <param name="sender">Sender</param>
/// <param name="e">Event Args</param>
override protected void btnConnected_Click(object sender, RoutedEventArgs e)
{
#region The code required for diagnosis - measures the time
var spectator = new Stopwatch();
spectator.Start();
#endregion
// Sample.
lstFriends.Items.Clear();
_listOfFriends.Clear();
using (var mapContext = new MapContext())
{
IQueryable<Map> queryMap = null;
if (txtLogin.Text == string.Empty && txtPassword.Text == string.Empty && txtId.Text == string.Empty)
MessageBox.Show("More than one field is not filled", "Connection error", MessageBoxButton.OK, MessageBoxImage.Error);
else if (txtLogin.Text == string.Empty && txtPassword.Text == string.Empty && Convert.ToInt32(txtId.Text) < 500001)
{
var idFromTxt = Convert.ToInt32(txtId.Text);
queryMap = mapContext.Map.Where(x => x.User_Id == idFromTxt);
}
else if (txtLogin.Text != string.Empty && txtPassword.Text != string.Empty && txtId.Text == string.Empty)
{
var pass = GetMd5Hash(txtPassword.Text);
queryMap = mapContext.Map.Where(x => x.Login == txtLogin.Text.ToString() && x.Password == pass);
}
else
MessageBox.Show("Check the correctness of filling the fields", "Connection error", MessageBoxButton.OK, MessageBoxImage.Error);
if (queryMap != null)
{
var find = queryMap.ToList();
var userId = find[0].User_Id;
Connected(userId);
}
}
#region The code required for diagnosis - measures the time
spectator.Stop();
var ts = spectator.Elapsed;
lblTime.Content = $"Lead time: {ts.Hours:00}:{ts.Minutes:00}:{ts.Seconds:00}.{ts.Milliseconds/10:00}";
#endregion
}
