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); } } }