/// <summary>
/// API call to get employee details on the basis if name prefix
/// </summary>
/// <param name="argName">Name prefix</param>
/// <returns></returns>
public async Task <UserDetailsBECollection> GetEmployeeDetailsFromDatabase(string argName)
{
#region Declarations
UserDetailsBECollection l_UserDetailsBECollection = new UserDetailsBECollection();
int l_LoggedInUser = 0;
string l_FindEmployeeURL = string.Empty;
#endregion
try
{
l_LoggedInUser = GetLoggedInUserID();
l_FindEmployeeURL = apiBaseURL + "/GetUsersByName?argLoggedInUser="******"&argNamePrefix=" + argName;
HttpResponseMessage l_EmployeeData = await client.GetAsync(l_FindEmployeeURL);
if (l_EmployeeData != null && l_EmployeeData.IsSuccessStatusCode)
{
var l_EmployeeDataResponse = l_EmployeeData.Content.ReadAsStringAsync().Result;
l_UserDetailsBECollection = JsonConvert.DeserializeObject <UserDetailsBECollection>(l_EmployeeDataResponse);
}
}
catch (Exception ex)
{
throw ex;
}
return(l_UserDetailsBECollection);
}
public IHttpActionResult GetUsersByName(int argLoggedInUser, string argNamePrefix)
{
#region Declarations
BadgeBLO l_BadgeBLO = new BadgeBLO();
UserDetailsBECollection l_UserDetailsBECollection = new UserDetailsBECollection();
#endregion
try
{
l_UserDetailsBECollection = l_BadgeBLO.GetUsersByName(argLoggedInUser, argNamePrefix);
if (l_UserDetailsBECollection == null || l_UserDetailsBECollection.Count == 0)
{
return(NotFound());
}
}
catch (Exception ex)
{
throw ex;
}
return(Ok(l_UserDetailsBECollection));
}
/// <summary>
/// Get list of users on the basis of name prefix
/// </summary>
/// <param name="argLoggedInUser">Logged in user ID</param>
/// <param name="argNamePrefix">Name prefix for search</param>
/// <returns></returns>
public UserDetailsBECollection GetUsersByName(int argLoggedInUser, string argNamePrefix)
{
#region Declarations
UserDetailsBECollection l_UserDetailsBECollection = new UserDetailsBECollection();
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
DataTable l_UsersDataTable = new DataTable();
UserDetailsBE l_UserDetailsBE;
int l_UserCount = 0;
#endregion
try
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.NAMEPREFIX, argNamePrefix, DbType.String));
l_UsersDataTable = l_SkillsDBManager.GetDataTable(StoredProcedures.GET_ALLUSERSBYNAME, CommandType.StoredProcedure, l_Parameters.ToArray());
if (l_UsersDataTable != null && l_UsersDataTable.Rows.Count > 0)
{
l_UserCount = l_UsersDataTable.Rows.Count;
for (int i = 0; i < l_UserCount; i++)
{
l_UserDetailsBE = new UserDetailsBE();
DataRow l_Row = l_UsersDataTable.Rows[i];
l_UserDetailsBE.UserName = l_Row["UserName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["UserName"]);
l_UserDetailsBE.UserID = l_Row["UserID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["UserID"]);
l_UserDetailsBECollection.Add(l_UserDetailsBE);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(l_UserDetailsBECollection);
}