/// <summary>
/// Method to convert UserRequests business entity to Model
/// </summary>
/// <param name="argUserRequestsBECollection">UserRequests Business Entity</param>
/// <returns></returns>
private UserRequestsCollection ConvertUserRequestsToModel(UserRequestsBECollection argUserRequestsBECollection)
{
UserRequestsCollection l_UserRequestsCollection = new UserRequestsCollection();
UserRequests l_Requests;
try
{
if (argUserRequestsBECollection != null && argUserRequestsBECollection.Count > 0)
{
foreach (var item in argUserRequestsBECollection)
{
l_Requests = new UserRequests();
l_Requests.Comments = item.Comments;
l_Requests.Status = item.Status;
l_Requests.RequestedDate = item.RequestedDate;
l_Requests.RequestType = item.RequestType;
l_Requests.Skill = item.Skill;
l_Requests.SubSkill = item.SubSkill;
l_Requests.BadgeID = item.BadgeID;
l_Requests.BadgeGivenFor = item.BadgeGivenFor;
l_UserRequestsCollection.Add(l_Requests);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(l_UserRequestsCollection);
}
/// <summary>
/// Used to get the list of requests made by user along with their status
/// </summary>
/// <param name="argLoggedInUser">Logged in User ID</param>
/// <param name="argType">Request Type</param>
/// <returns></returns>
public UserRequestsBECollection GetUserSkillRequests(int argLoggedInUser, string argType)
{
#region Declarations
UserRequestsBECollection l_requestCollection = new UserRequestsBECollection();
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
DataTable l_SkillDataTable = new DataTable();
UserRequestsBE l_RequestBE;
int l_SkillCount = 0;
#endregion
try
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32));
if (string.IsNullOrEmpty(argType))
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.TYPE, DBNull.Value, DbType.String));
}
else
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.TYPE, argType, DbType.String));
}
l_SkillDataTable = l_SkillsDBManager.GetDataTable(StoredProcedures.GET_ALLSKILLREQUESTS, CommandType.StoredProcedure, l_Parameters.ToArray());
if (l_SkillDataTable != null && l_SkillDataTable.Rows.Count > 0)
{
l_SkillCount = l_SkillDataTable.Rows.Count;
for (int i = 0; i < l_SkillCount; i++)
{
l_RequestBE = new UserRequestsBE();
DataRow l_Row = l_SkillDataTable.Rows[i];
l_RequestBE.RequestType = l_Row["Request type"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Request type"]);
l_RequestBE.Status = l_Row["Status"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Status"]);
l_RequestBE.Comments = l_Row["Comments"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Comments"]);
l_RequestBE.RequestedDate = l_Row["Request date"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(l_Row["Request date"]);
l_RequestBE.Skill = l_Row["Skill"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Skill"]);
l_RequestBE.SubSkill = l_Row["Sub-skill"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Sub-skill"]);
//Badge Details
l_RequestBE.BadgeGivenFor = l_Row["BadgeGivenFor"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["BadgeGivenFor"]);
l_RequestBE.BadgeName = l_Row["BadgeName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["BadgeName"]);
l_RequestBE.BadgeImageURL = l_Row["BadgeImageURL"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["BadgeImageURL"]);
l_RequestBE.BadgeID = l_Row["BadgeID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["BadgeID"]);
l_requestCollection.Add(l_RequestBE);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(l_requestCollection);
}
public async Task <ActionResult> GetUserRequests(string argRequestType)
{
#region Declarations
UserRequests l_UserRequests = new UserRequests();
UserRequestsBECollection l_UserRequestsBECollection = new UserRequestsBECollection();
UserRequestsCollection l_UserRequestsCollection = new UserRequestsCollection();
string l_skillsURL = string.Empty;
#endregion
l_skillsURL = apiBaseURL + "/GetUserRequests?argLoggedInUser="******"&argType=" + argRequestType + "";
HttpResponseMessage l_SkillsData = await client.GetAsync(l_skillsURL);
if (l_SkillsData != null && l_SkillsData.IsSuccessStatusCode)
{
var l_SkillResponse = l_SkillsData.Content.ReadAsStringAsync().Result;
l_UserRequestsBECollection = JsonConvert.DeserializeObject <UserRequestsBECollection>(l_SkillResponse);
}
l_UserRequestsCollection = ConvertUserRequestsToModel(l_UserRequestsBECollection);
return(PartialView("_partialGetUserRequests", l_UserRequestsCollection));
}
public IHttpActionResult GetUserRequests(int argLoggedInUser, string argType)
{
#region Declarations
UserRequestsBLO l_RequestBLO = new UserRequestsBLO();
UserRequestsBECollection l_UserRequestsBECollection = new UserRequestsBECollection();
#endregion
try
{
l_UserRequestsBECollection = l_RequestBLO.GetUserSkillRequests(argLoggedInUser, argType);
if (l_UserRequestsBECollection == null || l_UserRequestsBECollection.Count == 0)
{
return(NotFound());
}
}
catch (Exception ex)
{
throw ex;
}
return(Ok(l_UserRequestsBECollection));
}
