/// <summary> /// Check budget category exists /// </summary> /// <returns>Boolean</returns> public bool CheckCategoryExists(string categoryName) { object[] objCategoryCheck = new object[2]; objCategoryCheck[0] = categoryName; objCategoryCheck[1] = userSession.CompanyId; return(DataLibrary.ExecuteReaderSql(ref objCategoryCheck, "bspCheckCategoryExists").HasRows); }
/// <summary> /// Check group already exists /// </summary> /// <param name="groupName">Group Name</param> /// <returns>True if exists else false</returns> public bool CheckGroupAlreadyExists(string groupName) { object[] objCheckGroup = new object[2]; objCheckGroup[0] = groupName; objCheckGroup[1] = userSession.CompanyId; return(DataLibrary.ExecuteReaderSql(ref objCheckGroup, "bspCheckGroupAlreadyExists").HasRows); }
/// <summary> /// Check is budget already exists /// </summary> /// <param name="BudgetName"></param> /// <returns>true if exists else false</returns> public bool CheckBudgetExists(string budgetName) { object[] objBudgetCheck = new object[2]; objBudgetCheck[0] = budgetName; objBudgetCheck[1] = userSession.CompanyId; return(DataLibrary.ExecuteReaderSql(ref objBudgetCheck, "bspCheckBudgetAlreadyExists").HasRows); }
/// <summary> /// Check Amount Beyond Level /// </summary> /// <param name="AmountReturned">Amount returned</param> /// <param name="expenseId">Expense id.</param> /// <param name="amountReturnedBy">Amount returned by</param> /// <returns>true if the amount received is greater than the amount to be given then return true else false.</returns> public bool CheckAmountBeyondLevel(decimal AmountReturned, long expenseId, string amountReturnedBy, string amountReceivedBy) { object[] objReturnAmountCheck = new object[5]; objReturnAmountCheck[0] = expenseId; objReturnAmountCheck[1] = AmountReturned; objReturnAmountCheck[2] = userSession.CompanyId; objReturnAmountCheck[3] = amountReturnedBy; objReturnAmountCheck[4] = amountReceivedBy; return(DataLibrary.ExecuteReaderSql(ref objReturnAmountCheck, "bspCheckAmountBeyondLevel").HasRows); }
/// <summary> /// Check is valid password /// </summary> /// <param name="currentPassword">The current password.</param> /// <returns><see cref="bool"/></returns> public bool IsValidPassword(string currentPassword) { object[] objUserInput = new object[3]; objUserInput[0] = userSession.UserId; objUserInput[1] = userSession.CompanyId; objUserInput[2] = encDecryption.Encrypt(currentPassword); SqlDataReader sdr = DataLibrary.ExecuteReaderSql(ref objUserInput, "bspCheckIsValidPassword"); return(sdr.HasRows); }
/// <summary> /// Get the currently available roles for a logged in user /// </summary> /// <param name="userName">Name of the logged in user</param> /// <returns>Return currently logged in user role</returns> public string GetCurrentUserRole(string userName) { object[] objUserRoles = new object[0]; string userRole = string.Empty; SqlDataReader readData = DataLibrary.ExecuteReaderSql(ref objUserRoles, "bspGetCurrentUserRole"); while (readData.Read()) { userRole = readData.GetValue(0).ToString(); } readData.Dispose(); return(userRole); }
/// <summary> /// Get all available roles in the application /// </summary> /// <returns></returns> public string[] GetAllAvailableRoles() { object[] objUserRoles = new object[0]; ArrayList userRoles = new ArrayList(); SqlDataReader readData = DataLibrary.ExecuteReaderSql(ref objUserRoles, "bspGetAllAvailableRoles"); while (readData.Read()) { userRoles.Add(readData.GetValue(0).ToString()); } readData.Dispose(); return((string[])userRoles.ToArray()); }
// <summary> // Get the list of application users // </summary> // <returns>Dictionary object of user list</returns> public Dictionary <string, string> GetAllApplicationUsers() { object[] objUserParameter = new object[1]; objUserParameter[0] = userSession.CompanyId; Dictionary <string, string> userList = new Dictionary <string, string>(); SqlDataReader userListReader = DataLibrary.ExecuteReaderSql(ref objUserParameter, "bspGetApplicationUsers"); while (userListReader.Read()) { userList.Add(TypeConversionHelper.GetDefaultValueIfNull <string>(userListReader["UserId"]), TypeConversionHelper.GetDefaultValueIfNull <string>(userListReader["DisplayName"])); } return(userList); }
/// <summary> /// Gets all of the available screens /// </summary> /// <returns>List of screen route entity</returns> public List <SharedAssembly.ScreenRoute> GetAvailableScreens() { object[] objUserRoles = new object[0]; ArrayList userRoles = new ArrayList(); SqlDataReader readData = DataLibrary.ExecuteReaderSql(ref objUserRoles, "bspGetAllAvailableScreens"); List <SharedAssembly.ScreenRoute> screenRouteData = new List <SharedAssembly.ScreenRoute>(); while (readData.Read()) { screenRouteData.Add(new SharedAssembly.ScreenRoute { ActionName = readData["screenActionName"].ToString(), AreaName = readData["screenControllerName"].ToString(), ControllerName = readData["screenAreaName"].ToString(), }); } readData.Dispose(); return(screenRouteData); }
/// <summary> /// To verify the email id /// </summary> /// <param name="userName"></param> /// <param name="emailId"></param> /// <returns></returns> public bool VerifyAccount(string userName, string emailId) { object[] objChkEmail = new object[2]; objChkEmail[0] = userName; objChkEmail[1] = emailId; string userRole = string.Empty; bool? isValidVerfId = false; SqlDataReader readData = DataLibrary.ExecuteReaderSql(ref objChkEmail, "bspVerifyEmail"); if (readData != null && !readData.IsClosed) { while (readData.Read()) { isValidVerfId = (Nullable <bool>)readData["verified"]; } } readData.Dispose(); return(isValidVerfId ?? false); }
/// <summary> /// Check is user has access to screen /// </summary> /// <param name="userId">Currently logged in user's Id </param> /// <param name="screenParameters">Screen url parameters</param> /// <returns>True if user has access else false</returns> public bool CheckIsUserHasAccessOnScreen(string userId, SharedAssembly.ScreenRoute screenParameters) { object[] objAppScreens = new object[5]; objAppScreens[0] = userId; objAppScreens[1] = screenParameters.ActionName; objAppScreens[2] = screenParameters.ControllerName; objAppScreens[3] = screenParameters.AreaName; objAppScreens[4] = userSession.CompanyId; bool isReadable = false; SqlDataReader userPermissionReader = DataLibrary.ExecuteReaderSql(ref objAppScreens, "bspIsUserHasAccess"); while (userPermissionReader.Read()) { isReadable = TypeConversionHelper.GetDefaultValueIfNull <bool>(userPermissionReader["isRead"]); permissionHelper.SetPermission(isReadable, TypeConversionHelper.GetDefaultValueIfNull <bool>(userPermissionReader["isWrite"]), TypeConversionHelper.GetDefaultValueIfNull <bool>(userPermissionReader["isDelete"])); } return(isReadable); }
/// <summary> /// Get the forgot password /// </summary> /// <param name="emailID"></param> /// <param name="newPassword">New password.</param> /// <returns>list of email id</returns> public string[] ResetPassword(string emailID, string newPassword) { try { object[] objForgotPassword = new object[] { emailID, newPassword }; string[] forgottenPasswordResult = null; SqlDataReader readData = DataLibrary.ExecuteReaderSql(ref objForgotPassword, "bspResetPassword"); if (readData != null && !readData.IsClosed) { while (readData.Read()) { forgottenPasswordResult = new string[] { readData["DisplayName"].ToString(), readData["PassKey"].ToString() }; } } readData.Dispose(); return(forgottenPasswordResult); } catch { return(null); } }