/// <summary>
/// Get all available budgets in the application
/// </summary>
/// <param name="userId">User ID</param>
/// <returns>Set of available budgets </returns>
public DataSet GetAvailableBudgets(string userId)
{
object[] objUserCredentials = new object[2];
objUserCredentials[0] = userId;
objUserCredentials[1] = userSession.CompanyId;
return(DataLibrary.ExecuteDataSet(ref objUserCredentials, "bspViewBudget"));
}
/// <summary>
/// Get User Details
/// </summary>
/// <param name="userId">User Id</param>
/// <returns>Data set</returns>
public DataSet GetUserDetails(string userId)
{
object[] objUserDetails = new object[2];
objUserDetails[0] = userId;
objUserDetails[1] = userSession.CompanyId;
return(DataLibrary.ExecuteDataSet(ref objUserDetails, "bspGetUserDetailsForFriendInvitation"));
}
/// <summary>
/// Get the account settings data
/// </summary>
/// <param name="userId">Logged In User Id</param>
/// <param name="companyId">Users company</param>
/// <returns>Data set</returns>
public DataSet GetAccountSettingsData(string userId, long?companyId)
{
companyId = userSession.CompanyId;
object[] objAccountInputParameter = new object[2];
objAccountInputParameter[0] = userId;
objAccountInputParameter[1] = companyId;
return(DataLibrary.ExecuteDataSet(ref objAccountInputParameter, "bspGetAccountSettingsData"));
}
/// <summary>
/// Get transaction lookup data
/// </summary>
/// <param name="lookupType">Lookup type</param>
/// <param name="lookupCondition">Look up condition</param>
/// <returns></returns>
public DataSet GetTransactionLookUpData(char lookupType, string lookupCondition)
{
object[] expenseDetails = new object[3];
expenseDetails[0] = lookupType;
expenseDetails[1] = lookupCondition;
expenseDetails[2] = userSession.CompanyId;
return(DataLibrary.ExecuteDataSet(ref expenseDetails, "bspGetTransactionLookUpData"));
}
/// <summary>
/// Get User group Details by Userid
/// </summary>
/// <returns>User Group Data</returns>
public DataSet GetUserGroups()
{
object[] objUserGroup = new object[1];
objUserGroup[0] = userSession.CompanyId;
DataSet userPermissionDataSet = DataLibrary.ExecuteDataSet(ref objUserGroup, "bspGetUSerGroup");
return(userPermissionDataSet);
}
/// <summary>
/// Get the list of application users
/// </summary>
/// <returns>Dataset</returns>
public DataSet GetAllApplicationUsers()
{
object[] objUserParameter = new object[1];
objUserParameter[0] = userSession.CompanyId;
DataSet userPermissionDataSet = DataLibrary.ExecuteDataSet(ref objUserParameter, "bspGetApplicationUsers");
return(userPermissionDataSet);
}
/// <summary>
/// Get Users by user name
/// </summary>
/// <param name="userName">User Name</param>
/// <param name="loggedInUserId">Logged In User Id</param>
/// <returns>Dataset</returns>
public DataSet GetUsers(string userName, string loggedInUserId)
{
object[] objGetUsersByUserName = new object[3];
objGetUsersByUserName[0] = userName;
objGetUsersByUserName[1] = loggedInUserId;
objGetUsersByUserName[2] = userSession.CompanyId;
return(DataLibrary.ExecuteDataSet(ref objGetUsersByUserName, "bspGetUsersByUserName"));
}
/// <summary>
/// Get the required data for the user permisssion screen
/// </summary>
/// <returns>Dataset</returns>
public DataSet GetUserPermissions(string sessionId, bool showUserList = false)
{
object[] objUserPermissions = new object[3];
objUserPermissions[0] = sessionId;
objUserPermissions[1] = showUserList;
objUserPermissions[2] = userSession.CompanyId;
DataSet userPermissionDataSet = DataLibrary.ExecuteDataSet(ref objUserPermissions, "bspGetUserPermissions");
return(userPermissionDataSet);
}
/// <summary>
/// Get result set from analysis.
/// </summary>
/// <param name="analysisQuery">Analysis query entity.</param>
/// <returns>Analysis result set.</returns>
public DataSet GetAnalysisData(AnalysisQuery analysisQuery)
{
object[] objAnalysisQueryParams = new object[8];
objAnalysisQueryParams[0] = analysisQuery.User1;
objAnalysisQueryParams[1] = analysisQuery.User2;
objAnalysisQueryParams[2] = analysisQuery.GroupId;
objAnalysisQueryParams[3] = analysisQuery.ExpenseId;
objAnalysisQueryParams[4] = analysisQuery.From;
objAnalysisQueryParams[5] = analysisQuery.To;
objAnalysisQueryParams[6] = analysisQuery.Action;
objAnalysisQueryParams[7] = userSession.CompanyId;
return(DataLibrary.ExecuteDataSet(ref objAnalysisQueryParams, "bspGetAnalysisData"));
}
/// <summary>
/// To add the user to the application
/// </summary>
/// <returns>Bool</returns>
public bool AddUser(string userName, string password, string emailId, string displayName)
{
object[] objAddUserParameters = new object[4];
objAddUserParameters[0] = userName;
objAddUserParameters[1] = encDecryption.Encrypt(password);
objAddUserParameters[2] = emailId;
objAddUserParameters[3] = displayName;
System.Data.DataSet execResult = DataLibrary.ExecuteDataSet(ref objAddUserParameters, "bspAddUser");
if (execResult.Tables.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// Check whether the user name already exists or not
/// </summary>
/// <param name="UserName">chosen user name </param>
/// <returns>return boolean value either true or false; if true user name exists else not exists.</returns>
public bool CheckUserNameOrEmailIsExists(string userNameOrEmail, string fieldType = "Name")
{
object[] objUserCredentials = new object[2];
objUserCredentials[0] = userNameOrEmail;
objUserCredentials[1] = fieldType;
System.Data.DataSet userData = DataLibrary.ExecuteDataSet(ref objUserCredentials, "bspCheckUserNameOrEmailIsExists");
if (userData.Tables.Count > 0)
{
if (userData.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
/// <summary>
/// To check whether the user is a valid user
/// </summary>
/// <param name="UserName">User name</param>
/// <param name="Password">password</param>
/// <returns></returns>
public bool CheckIsValidUser(string UserName, string Password)
{
object[] objUserCredentials = new object[2];
objUserCredentials[0] = UserName;
objUserCredentials[1] = encDecryption.Encrypt(Password);
System.Data.DataSet userData = DataLibrary.ExecuteDataSet(ref objUserCredentials, "bspAuthorizeUserLogIn");
if (userData.Tables.Count > 0)
{
if (userData.Tables[0].Rows.Count > 0)
{
DataTable userDataTable = userData.Tables[0];
var resultSet = userDataTable.AsEnumerable().Select(result => new { UserName = result.Field <string>("userid"), DisplayName = result.Field <string>("DisplayName"), CompanyId = result.Field <int?>("CompanyId") }).FirstOrDefault();
Resources.DisplayName = resultSet.DisplayName;
userSession.SetSession("CompanyId", resultSet.CompanyId);
userSession.SetSession("DisplayName", resultSet.DisplayName);
userData = null;
userDataTable = null;
if (UserName.ToLower() == resultSet.UserName.ToLower())
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
else
{
return(false);
}
}
/// <summary>
/// Get the navigation links for the logged in user
/// </summary>
/// <param name="userId">User Id</param>
/// <returns><see cref="UserMenu"/></returns>
public IEnumerable <UserMenu> GetLoggedInUserScreens(string userId)
{
object[] objUserId = new object[2];
objUserId[0] = userId;
objUserId[1] = userSession.CompanyId;
DataSet userMenuDataSet = DataLibrary.ExecuteDataSet(ref objUserId, "bspGetUserScreens");
IEnumerable <UserMenu> userMenu = userMenuDataSet.Tables[0].AsEnumerable().GroupJoin(userMenuDataSet.Tables[1].AsEnumerable(), a => a.Field <string>("ControllerName"),
b => b.Field <string>("ControllerName"), (a, b) => new UserMenu
{
GroupMenuTitle = a.Field <string>("GroupMenuTitle"),
Links = b.Select(links => new UserScreenLink
{
ActionLinkText = links.Field <string>("ActionLinkText"),
ActionName = links.Field <string>("ActionName"),
AreaName = links.Field <string>("AreaName"),
ControllerName = links.Field <string>("ControllerName").Replace("Controller", string.Empty),
LinkIcon = links.Field <string>("linkIcon"),
LinkOrderId = links.Field <int?>("linkOrderId"),
ScreenID = links.Field <int>("screenId")
}).ToList()
});
return(userMenu);
}
/// <summary>
/// Get the available budget category
/// </summary>
/// <returns>Return busdget category result set</returns>
public DataSet GetAvailableBudgetCategory()
{
object[] objBudgetCategory = new object[1];
objBudgetCategory[0] = userSession.CompanyId;
return(DataLibrary.ExecuteDataSet(ref objBudgetCategory, "bspGetAvailableBudgetCategory"));
}
/// <summary>
/// Get all my transactions.
/// </summary>
/// <returns>Transaction result set.</returns>
public DataSet GetAllMyTransactions()
{
object[] transactionInput = new object[1];
transactionInput[0] = userSession.CompanyId;
return(DataLibrary.ExecuteDataSet(ref transactionInput, "bspGetAllMyTransactions"));
}
/// <summary>
/// Get look ups for transaction analysis.
/// </summary>
/// <returns></returns>
public DataSet GetAnalysisLookUps()
{
object[] objAnalysisLookUpParams = new object[2];
objAnalysisLookUpParams[0] = userSession.CompanyId;
return(DataLibrary.ExecuteDataSet(ref objAnalysisLookUpParams, "bspGetAnalysisLookUps"));
}
/// <summary>
/// Get dashboard data
/// </summary>
/// <param name="userId">User Id</param>
/// <returns><see cref="DataSet"/></returns>
public DataSet GetDashboardData(string userId)
{
object[] objDashBoard = new object[] { userId, userSession.CompanyId };
return(DataLibrary.ExecuteDataSet(ref objDashBoard, "bspGetDashboardBudgetSummary"));
}
/// <summary>
/// Get all my expenses.
/// </summary>
/// <returns>All the expenses associated to the company user belongs to.</returns>
public DataSet GetAllMyExpenses()
{
object[] expenseDetails = new object[1];
expenseDetails[0] = userSession.CompanyId;
return(DataLibrary.ExecuteDataSet(ref expenseDetails, "bspGetAllMyExpenses"));
}