void EnteredAdminUser(User check_user)
{
flag = true;
num_table = check_user.Id_WorkArea;
currrent_id = check_user.Id;
List <UsersSessions> list = null;
try
{
list = ReadFromDatabase.AllUsersSessions(num_table).ToList();
}
catch { }
if (list == null)
{
db.Database.ExecuteSqlCommand(
$"CREATE TABLE [dbo].[UserSessions_{num_table}] (" +
$"[Id] INT IDENTITY(1, 1) NOT NULL," +
$"[CurLogin] NVARCHAR(50) NULL," +
$"[CurPassword] NVARCHAR(50) NULL," +
$"[RememberMe] Bit NULL," +
$"[IsActive] Bit NULL," +
$"[AccessToken] uniqueidentifier NULL," +
$"[DateEnter] datetime NULL," +
$"[DateLeave] datetime NULL)");
session = new UsersSessions();
session.CurLogin = login_txt.Text;
session.CurPassword = passwd_txt.Password;
session.RememberMe = Convert.ToBoolean(remeber_check.IsChecked);
session.DateEnter = DateTime.Now;
session.AccessToken = Guid.NewGuid();
WorkAreas area_window = new WorkAreas(check_user.Id_WorkArea, check_user.Role, $"{check_user.First_Name} {check_user.Last_Name}", this);
area_window.Owner = this;
area_window.ShowDialog();
}
else
{
session = new UsersSessions();
session.CurLogin = login_txt.Text;
session.CurPassword = passwd_txt.Password;
session.RememberMe = Convert.ToBoolean(remeber_check.IsChecked);
session.DateEnter = DateTime.Now;
session.AccessToken = Guid.NewGuid();
new WorkAreas(check_user.Id_WorkArea, check_user.Role, $"{check_user.First_Name} {check_user.Last_Name}", this).ShowDialog();
}
}
public async Task <Response> FindById(int id)
{
WorkAreas result = await _workAreaRepository.FindById(id);
if (result.Id > 0)
{
return(new Response
{
IsSuccess = true,
Message = "Se consulto exitosamente",
Result = result
});
}
else
{
return(new Response
{
IsSuccess = false,
Message = "Error"
});
}
}
public async Task <WorkAreas> FindById(int id)
{
using (SqlConnection sql = new SqlConnection(_connectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_WorkSubArea_FindById", sql))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Id", id));
WorkAreas response = null;
await sql.OpenAsync();
using (var reader = await cmd.ExecuteReaderAsync())
{
if (reader != null)
{
response = reader.Translate <WorkAreas>().FirstOrDefault();
}
}
return(response);
}
}
}
