public Response RoleNotAllowedCombinationExistAndDate(ApplicationPMX application, Role roleA, Role roleB) { //Se debe de regresar falso si no existe y se debe de interpretar en la llamada de la funcion var response = new Response { Message = "No existe la combinacion", Result = true }; var roleDa = new RoleDA(_configuration); try { response.Result = roleDa.RoleNotAllowedCombinationExistAndDate(application, roleA, roleB); if (response.Result) { response.Message = string.Format( "La combinación no permitida de rol se encuentra registrada."); } } catch (Exception e) { response.Message = string.Format( "Ocurrio un error al verificar si la combinacion de operaciones no permititda existe. {0}", e.Message); response.Result = true; } roleDa.Dispose(); return(response); }
public Response DeleteRoleCombinationNotAllowed(ApplicationPMX application, Role roleA, Role roleB) { //Se debe de regresar falso si no existe y se debe de interpretar en la llamada de la funcion var response = new Response { Message = "No existe la combinacion", Result = false }; var roleDa = new RoleDA(_configuration); try { roleDa.DeleteRoleNotAllowedCombination(application, roleA, roleB); } catch (Exception e) { response.Message = string.Format( "Ocurrio un error al eliminar la combinacion de operaciones. {0}", e.Message); response.Result = false; } response.Result = true; response.Message = string.Format( "Se eliminó la combinación no permitida de la operacion {0} y {1} de la aplicacion {2}.", roleA.RoleName, roleB.RoleName, application.ApplicationName); roleDa.Dispose(); return(response); }
public void FindSession(User user, ApplicationPMX application, out bool sessionFinded, out bool isSessionValid) { sessionFinded = false; isSessionValid = false; var conn = StrConexion; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_LoggingSessionsSelect" }; cmd.Parameters.Add("@SessionId", SqlDbType.UniqueIdentifier).Value = user.SessionId; cmd.Parameters.Add("@ApplicationId", SqlDbType.Int).Value = application.ApplicationId; using (IDataReader reader = cmd.ExecuteReader()) { if (!reader.Read()) { return; } sessionFinded = true; isSessionValid = (bool)reader["IsSessionValid"]; } } }
public User AddSession(User user, ApplicationPMX application) { var conn = StrConexion; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_LoggingSessionsInsert" }; cmd.Parameters.Add("@UserId", SqlDbType.NVarChar).Value = user.UserId; cmd.Parameters.Add("@ApplicationId", SqlDbType.NVarChar).Value = application.ApplicationId; //cmd.Parameters.Add("@CreationUserId", System.Data.SqlDbType.NVarChar).Value = registerUser.UserId; using (IDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { user.SessionId = (Guid)reader["SessionID"]; } } } return(user); }
public List <Role> GetRoleList(ApplicationPMX application) { var conn = StrConexion; var roleList = new List <Role>(); using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_ApplicationRolesSelectByApplicationId" }; cmd.Parameters.AddWithValue("@ApplicationId", application.ApplicationId); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var role = new Role { RoleId = (int)reader["RoleId"] , RoleName = (string)reader["RoleName"] , RoleDescription = (string)reader["RoleDescription"] , ApplicationId = (int)reader["ApplicationId"] }; roleList.Add(role); } } return(roleList); }
public Response AddOperationToRole(ApplicationPMX application, Operation operation, Role role, User registerUser) { var response = new Response { Message = "Sin inicializar", Result = false }; var operationDa = new OperationDA(_configuration); try { operationDa.AddOperationToRole(operation, role, registerUser); response.Message = string.Format("Se agregó la operacion {0} al rol {1}", operation.OperationName, role.RoleName); var log = new Log { Application = application , EventTypeId = LogTypeEnum.Notification , EventUser = registerUser , LogDescription = string.Format("Se agregó la operacion {0} al rol {1}", operation.OperationName, role.RoleName) }; var loglogic = new LogLogic(_configuration); loglogic.InsertLogEvent(log); loglogic.Dispose(); response.Result = true; } catch (Exception) { response.Message = string.Format("Ocurrio un error al intentar insertar operacion {0} al rol {1}", operation.OperationName, role.RoleName); } return(response); }
public List <ApplicationPMX> GetApplicationList(string strValue) { var conn = StrConexion; var appList = new List <ApplicationPMX>(); using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_GetApplications" }; cmd.Parameters.AddWithValue("@strCampo", strValue); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var app = new ApplicationPMX { ApplicationId = (int)reader["ApplicationId"], ApplicationName = (string)reader["ApplicationName"], ApplicationDescription = (string)reader["ApplicationDescription"], ApplicationPassword = (string)reader["Observations"] }; appList.Add(app); } } return(appList); }
public Response GetRoleCombinationNotAllowedByApplication(ApplicationPMX application, out DataTable roleCombinationsNotAllowed) { var response = new Response { Result = false, Message = "Not initialized" }; roleCombinationsNotAllowed = new DataTable(); var roleDa = new RoleDA(_configuration); try { roleCombinationsNotAllowed = roleDa.GetRoleCombinationsNotAllowed(application); response.Message = string.Format("Se encontraron {0} combinaciones no permitidas para la aplicación {1}.", roleCombinationsNotAllowed.Rows.Count.ToString(), application.ApplicationName); response.Result = true; } catch (Exception e) { response.Message = string.Format("Ocurrió un error al obtener las combinaciones de rol no autorizadas. {0}", e.Message); response.Result = false; } roleDa.Dispose(); return(response); }
public void UpdApplication(ApplicationPMX application, User registerUser) { var conn = StrConexion; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_ApplicationsUpdate" }; cmd.Parameters.AddWithValue("@ApplicationId", application.ApplicationId); cmd.Parameters.AddWithValue("@ApplicationName", application.ApplicationName); cmd.Parameters.AddWithValue("@ApplicationDescription", application.ApplicationDescription); cmd.Parameters.AddWithValue("@ValidityStartDate", Convert.ToDateTime(string.Format("{0:yyyy/MM/dd}", Convert.ToDateTime(application.ValidityStartDate)))); cmd.Parameters.AddWithValue("@DeclineDate", Convert.ToDateTime(string.Format("{0:yyyy/MM/dd}", Convert.ToDateTime(application.DeclineDate)))); cmd.Parameters.AddWithValue("@Observations", application.Observations); cmd.Parameters.AddWithValue("@TecnicalUserId", application.TecnicalUserId); cmd.Parameters.AddWithValue("@TecnicalUserIdDos", application.TecnicalUserIdDos); cmd.Parameters.AddWithValue("@TecnicalUserIdTres", application.TecnicalUserIdTres); cmd.Parameters.AddWithValue("@TecnicalUserIdCuatro", application.TecnicalUserIdCuatro); cmd.Parameters.AddWithValue("@FunctionalUserId", application.FunctionalUserId); cmd.Parameters.AddWithValue("@ModificationUserId", registerUser.UserId); cmd.Parameters.AddWithValue("@HashedPassword", application.ApplicationPassword); cmd.ExecuteNonQuery(); } }
public List <User> FindRoleUsers(Role role, ApplicationPMX application) { var usersApplicationsRoleDa = new UsersApplicationsRoleDA(_configuration); var userList = usersApplicationsRoleDa.FindRoleUsers(role, application); usersApplicationsRoleDa.Dispose(); return(userList); }
public List <Operation> GetOperationList(ApplicationPMX application) { var operationDa = new OperationDA(_configuration); var listOperation = operationDa.GetOperationsList(application); operationDa.Dispose(); return(listOperation); }
public List <Role> GetRoleList(ApplicationPMX application) { var roleDa = new RoleDA(_configuration); var listrole = roleDa.GetRoleList(application); roleDa.Dispose(); return(listrole); }
public object [] GetApplicationAdministration(ApplicationPMX application) { var applicationDa = new ApplicationDA(_configuration); var applicationAdmin = applicationDa.GetApplicationAdministration(application); applicationDa.Dispose(); return(applicationAdmin); }
public ApplicationPMX FindApplication(int idApplication) { var conn = StrConexion; var objApp = new ApplicationPMX(); using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_FindApplication" }; cmd.Parameters.AddWithValue("@IdApplication", idApplication); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var app = new ApplicationPMX(); app.ApplicationDescription = (string)reader["ApplicationDescription"]; app.ApplicationId = (int)reader["ApplicationId"]; app.ApplicationName = (string)reader["ApplicationName"]; app.ValidityStartDate = string.IsNullOrEmpty(reader["ValidityStartDate"].ToString()) ? string.Empty : string.Format("{0:dd/MM/yyyy}", reader["ValidityStartDate"]); app.DeclineDate = string.IsNullOrEmpty(reader["DeclineDate"].ToString()) ? string.Empty : string.Format("{0:dd/MM/yyyy}", reader["DeclineDate"]); app.Observations = (string)reader["Observations"]; app.ApplicationPassword = (string)reader["HashedPassword"]; app.FunctionalUserId = (string)reader["FunctionalUserId"]; app.TecnicalUserId = (string)reader["TecnicalUserId"]; app.TecnicalUserIdDos = reader["TecnicalUserIdDos"] == System.DBNull.Value ? string.Empty : (string)reader["TecnicalUserIdDos"]; app.TecnicalUserIdTres = reader["TecnicalUserIdTres"] == System.DBNull.Value ? string.Empty : (string)reader["TecnicalUserIdTres"]; app.TecnicalUserIdCuatro = reader["TecnicalUserIdCuatro"] == System.DBNull.Value ? string.Empty : (string)reader["TecnicalUserIdCuatro"]; objApp = app; } return(objApp); } }
public Response AddApplicationAdministration(ApplicationPMX application, User user, bool canAdminAppRolesAndOperations, bool canAdminUsers, string userId) { var response = new Response() { Message = "Not initizalizated", Result = false }; string userIdRecuperado = string.Empty; if (!(string.IsNullOrEmpty(userId))) { string[] usuario = userId.Split(new Char[] { ' ' }); userIdRecuperado = usuario[0]; } try { var conn = StrConexion; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_ApplicationAdministrationInsert" }; cmd.Parameters.AddWithValue("@ApplicationId", application.ApplicationId); cmd.Parameters.AddWithValue("@UserId", userIdRecuperado); cmd.Parameters.AddWithValue("@CanAdminApplicationRO", canAdminAppRolesAndOperations); cmd.Parameters.AddWithValue("@CanAdminApplicationUsers", canAdminUsers); cmd.ExecuteNonQuery(); } response.Message = string.Format( "Se agregó correctamente al usuario {0} para administrar la aplicacion {1}", user.UserId, application.ApplicationName); response.Result = true; } catch (Exception exception) { response.Result = false; response.Message = String.Format("Ocurrió un error al agregar al usuario. {0}", exception.Message); } return(response); }
public object[] GetApplicationAdministration(ApplicationPMX application) { var response = new Response() { Message = "Not initizalizated", Result = false }; var ds = new DataSet(); object[] obj = null; try { var conn = StrConexion; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var da = new SqlDataAdapter(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_ApplicationAdministrationSelect" }; cmd.Parameters.AddWithValue("@ApplicationId", application.ApplicationId); cmd.Parameters.AddWithValue("@UserId", application.FunctionalUserId); da.SelectCommand = cmd; da.Fill(ds); obj = new object[ds.Tables[0].Rows.Count]; ds.Tables[0].Rows.CopyTo(obj, 0); } } catch (Exception exception) { response.Result = false; response.Message = String.Format("Ocurrió un error al agregar al usuario. {0}", exception.Message); } return(obj); }
public List <User> FindRoleUsers(Role role, ApplicationPMX application) { var conn = StrConexion; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_UsersSelectByApplicationIdAndRoleId" }; cmd.Parameters.Add("@ApplicationId", SqlDbType.NVarChar).Value = application.ApplicationId; cmd.Parameters.Add("@RoleId", SqlDbType.Int).Value = role.RoleId; SqlDataReader reader = cmd.ExecuteReader(); var userList = new List <User>(); while (reader.Read()) { var user = new User { UserId = (string)reader["UserId"], EmployeeNumber = (string)reader["EmployeeNumber"] , EmployeeNames = (string)reader["EmployeeNames"] , EmployeeLastName = (string)reader["EmployeeLastName"] , EmployeeEmail = (string)reader["EmployeeEmail"] , Telephone = (string)reader["Telephone"] , MobileTelephone = (string)reader["MobileTelephone"] , DeclineDate = reader["DeclineDate"] == System.DBNull.Value ? "01/01/2000" : reader["DeclineDate"].ToString() , DeclineDateSIO = reader["DeclineDateSIO"] == System.DBNull.Value ? "01/01/2000" : reader["DeclineDateSIO"].ToString() }; userList.Add(user); } return(userList); } }
public Response UpdateOperationCombinationNotAllowed(ApplicationPMX application, Operation operationA, Operation operationB, DateTime declineDate, User registerUser) { //Se debe de regresar falso si no existe y se debe de interpretar en la llamada de la funcion var response = new Response { Message = "No existe la combinacion", Result = false }; var operationDA = new OperationDA(_configuration); try { operationDA.UpdateOperationNotAllowedCombination(application, operationA, operationB, declineDate, registerUser); #region logRegister var log = new Log { Application = new ApplicationPMX { ApplicationName = _applicationName }, EventUser = registerUser, EventTypeId = LogTypeEnum.Notification, LogDescription = string.Format("Se actualizó la fecha de vigencia de combinación no autorizada de operaciones. Operaciones {0} - {1} nueva fecha de vigencia {3}", operationA.OperationId.ToString() + " " + operationA.OperationName, operationB.OperationId.ToString() + " " + operationB.OperationName, declineDate.ToShortDateString()) }; #endregion var loglogic = new LogLogic(_configuration); loglogic.InsertLogEvent(log); loglogic.Dispose(); } catch (Exception e) { response.Message = string.Format( "Ocurrio un error al eliminar la combinacion de operaciones. {0}", e.Message); response.Result = false; } response.Result = true; response.Message = string.Format( "Se eliminó la combinación no permitida de la operacion {0} y {1} de la aplicacion {2}.", operationA.OperationName, operationB.OperationName, application.ApplicationName); operationDA.Dispose(); return(response); }
public void DeleteRoleNotAllowedCombination(ApplicationPMX application, Role roleA, Role roleB) { var conn = StrConexion; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_RolesCombinationNotAllowedDelete" }; cmd.Parameters.AddWithValue("@ApplicationId", application.ApplicationId); cmd.Parameters.AddWithValue("@RoleIdA", roleA.RoleId); cmd.Parameters.AddWithValue("@RoleIdB", roleB.RoleId); cmd.ExecuteNonQuery(); } }
public void UpdateSessionEndTime(User user, ApplicationPMX application) { var conn = StrConexion; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_LoggingSessionsUpdate" }; cmd.Parameters.Add("@SessionId", SqlDbType.UniqueIdentifier).Value = user.SessionId; cmd.Parameters.Add("@ApplicationId", SqlDbType.Int).Value = application.ApplicationId; cmd.ExecuteNonQuery(); } }
public Response UpdApplicationAdministration(ApplicationPMX application, bool canAdminAppRolesAndOperations, bool canAdminUsers, string strUser) { var response = new Response() { Message = "Not initizalizated", Result = false }; string[] strUserRecuperado = strUser.Split(new Char[] { ' ' }); try { var conn = StrConexion; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_ApplicationAdministrationUpdate" }; cmd.Parameters.AddWithValue("@ApplicationId", application.ApplicationId); cmd.Parameters.AddWithValue("@UserId", strUserRecuperado[0]); cmd.Parameters.AddWithValue("@CanAdminApplicationRO", canAdminAppRolesAndOperations); cmd.Parameters.AddWithValue("@CanAdminApplicationUsers", canAdminUsers); cmd.ExecuteNonQuery(); } response.Message = string.Format("Se actualizó correctamente el o los usuarios para administrar la aplicacion {0}", application.ApplicationName); response.Result = true; } catch (Exception exception) { response.Result = false; response.Message = String.Format("Ocurrió un error al agregar al usuario. {0}", exception.Message); } return(response); }
public void DelApplication(ApplicationPMX application, User registerUser) { var conn = StrConexion; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_ApplicationsDelete" }; cmd.Parameters.AddWithValue("@ApplicationId", application.ApplicationId); cmd.Parameters.AddWithValue("@DeclinateDate", Convert.ToDateTime(string.Format("{0:yyyy/MM/dd}", Convert.ToDateTime(application.DeclineDate)))); cmd.Parameters.AddWithValue("@ModificationUserId", registerUser.UserId); cmd.ExecuteNonQuery(); } }
public DataTable GetRoleCombinationsNotAllowed(ApplicationPMX application) { var conn = StrConexion; DataTable dt = new DataTable(); using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_RolesCombinationNotAllowedSelectByApplicationId" }; cmd.Parameters.AddWithValue("@ApplicationId", application.ApplicationId); SqlDataReader dr = cmd.ExecuteReader(); dt.Load(dr); } return(dt); }
public void InsertOperationNotAllowedCombination(ApplicationPMX application, Operation operationA, Operation operationB, DateTime declineDate, User registerUser) { var conn = StrConexion; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_OperationsCombinationsNotAllowedInsert" }; cmd.Parameters.AddWithValue("@ApplicationId", application.ApplicationId); cmd.Parameters.AddWithValue("@OperationIdA", operationA.OperationId); cmd.Parameters.AddWithValue("@OperationIdB", operationB.OperationId); cmd.Parameters.AddWithValue("@UserId", registerUser.UserId); cmd.Parameters.AddWithValue("@DeclineDate", declineDate); cmd.ExecuteNonQuery(); } }
public void UpdateRoleNotAllowedCombination(ApplicationPMX application, Role roleA, Role roleB, DateTime dtDeclineDate, User registerUser) { var conn = StrConexion; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_RolesCombinationNotAllowedUpdate" }; cmd.Parameters.AddWithValue("@ApplicationID", application.ApplicationId); cmd.Parameters.AddWithValue("@RoleIdA", roleA.RoleId); cmd.Parameters.AddWithValue("@RoleIdB", roleB.RoleId); cmd.Parameters.AddWithValue("@UserId", registerUser.UserId); cmd.Parameters.AddWithValue("@DeclineDate", dtDeclineDate); cmd.ExecuteNonQuery(); } }
public void AddApplication(ApplicationPMX application, User registerUser) { string conn = string.Empty; using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_ApplicationsInsert" }; cmd.Parameters.AddWithValue("@ApplicationName", application.ApplicationName); cmd.Parameters.AddWithValue("@ApplicationDescription", application.ApplicationDescription); cmd.Parameters.AddWithValue("@ValidityStartDate", Convert.ToDateTime(string.Format("{0:yyyy/MM/dd}", Convert.ToDateTime(application.ValidityStartDate)))); cmd.Parameters.AddWithValue("@Observations", application.Observations); cmd.Parameters.AddWithValue("@TecnicalUserId", application.TecnicalUserId); cmd.Parameters.AddWithValue("@TecnicalUserIdDos", application.TecnicalUserIdDos); cmd.Parameters.AddWithValue("@TecnicalUserIdTres", application.TecnicalUserIdTres); cmd.Parameters.AddWithValue("@TecnicalUserIdCuatro", application.TecnicalUserIdCuatro); cmd.Parameters.AddWithValue("@FunctionalUserId", application.FunctionalUserId); cmd.Parameters.AddWithValue("@CreationUserId", registerUser.UserId); cmd.Parameters.AddWithValue("@DeclineDate", Convert.ToDateTime(string.Format("{0:yyyy/MM/dd}", Convert.ToDateTime(application.DeclineDate)))); cmd.Parameters.AddWithValue("@HashedPassword", application.ApplicationPassword); cmd.Parameters.Add("@IdApplication", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); //SqlParameter idAppOut = cmd.Parameters.Add("@IdApplication", SqlDbType.Int); //idAppOut.Direction = ParameterDirection.Output; //application.ApplicationId =(int) idAppOut.Value; application.ApplicationId = (int)cmd.Parameters["@IdApplication"].Value; } }
public Response DelApplicationAdministration(ApplicationPMX application, User user) { var response = new Response() { Message = "Not initizalizated", Result = false }; try { var conn = StrConexion; string[] usuario = user.UserId.Split(' '); using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_ApplicationAdministrationDelete" }; cmd.Parameters.AddWithValue("@ApplicationId", application.ApplicationId); cmd.Parameters.AddWithValue("@UserId", usuario[0]); cmd.ExecuteNonQuery(); } response.Message = string.Format( "Se elimino correctamente la clave del usuario funcional {0} para administrar la aplicacion {1}", user.UserId, application.ApplicationName); response.Result = true; } catch (Exception exception) { response.Result = false; response.Message = String.Format("Ocurrió un error al agregar al usuario. {0}", exception.Message); } return(response); }
public List <ApplicationPMX> GetApplicationList() { var conn = StrConexion; var appList = new List <ApplicationPMX>(); using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_ApplicationsSelect" }; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var app = new ApplicationPMX { ApplicationDescription = (string)reader["ApplicationDescription"] , ApplicationId = (int)reader["ApplicationId"] , ApplicationName = (string)reader["ApplicationName"] , ApplicationPassword = (string)reader["HashedPassword"] , DeclineDate = ((DateTime)reader["DeclineDate"]).ToShortDateString() , DeclineDateDF = (DateTime)reader["DeclineDate"] , ValidityStartDate = ((DateTime)reader["ValidityStartDate"]).ToShortDateString() }; appList.Add(app); } } return(appList); }
public Response ValidateSession(User userAuthenticaded, ApplicationPMX appFinded) { var response = new Response { Message = "Not initialized", Result = false }; var sessionDataAccess = new SessionsDataAccess(_configuration); try { bool sessionFinded; bool isSessionValid; sessionDataAccess.FindSession(userAuthenticaded, appFinded, out sessionFinded, out isSessionValid); if (sessionFinded) { if (isSessionValid) { sessionDataAccess.UpdateSessionEndTime(userAuthenticaded, appFinded); response.Message = "Sesión valida. Se actualizó tiempo de expiración."; response.Result = true; return(response); } response.Message = "Tiempo de sesión expirado. Autentique nuevamente"; return(response); } response.Message = "No se encontró la sesión especificada."; } catch (Exception err) { response.Message = string.Format("Ocurrio un error mientras se consultaba la sesión. Err. {0}", err.Message); } sessionDataAccess.Dispose(); return(response); }
public Response OperationsNotAllowedCombinationExist(ApplicationPMX application, Operation operationA, Operation operationB) { //Se debe de regresar falso si no existe y se debe de interpretar en la llamada de la funcion var response = new Response { Message = "No existe la combinacion", Result = true }; var operationDa = new OperationDA(_configuration); try { response.Result = operationDa.OperationNotAllowedCombinationExist(application, operationA, operationB); if (response.Result) { response.Message = string.Format( "La combinación no permitida de la operacion {0} y {1} de la aplicacion {2}, se encuentra registrada.", operationA.OperationName, operationB.OperationName, application.ApplicationName); } else { response.Message = string.Format( "La combinación no permitida de la operacion {0} y {1} de la aplicacion {2}, no existe registrada.", operationA.OperationName, operationB.OperationName, application.ApplicationName); } return(response); } catch (Exception e) { response.Message = string.Format( "Ocurrio un error al verificar si la combinacion de operaciones no permititda existe. {0}", e.Message); response.Result = true; } operationDa.Dispose(); return(response); }