public IHttpActionResult GetSkillExpertApprovals(int argLoggedInUser, string argType)
{
#region Declarations
SkillExpertActionableBLO l_SkillExpertActionableBLO = new SkillExpertActionableBLO();
PendingSkillExpertApprovalBECollection l_PendingSkillExpertApprovalBECollection = new PendingSkillExpertApprovalBECollection();
#endregion
try
{
l_PendingSkillExpertApprovalBECollection = l_SkillExpertActionableBLO.GetPendingSkillExpertApprovals(argLoggedInUser, argType);
if (l_PendingSkillExpertApprovalBECollection == null || l_PendingSkillExpertApprovalBECollection.Count == 0)
{
return(NotFound());
}
}
catch (Exception ex)
{
throw ex;
}
return(Ok(l_PendingSkillExpertApprovalBECollection));
}
public async Task <ActionResult> GetPendingSkillExpertApprovals(string argRequestType)
{
#region Declarations
PendingSkillExpertApprovals l_Requests = new PendingSkillExpertApprovals();
PendingSkillExpertApprovalBECollection l_ApprovalBECollection = new PendingSkillExpertApprovalBECollection();
PendingSkillExpertApprovalsCollection l_ApprovalCollection = new PendingSkillExpertApprovalsCollection();
string l_skillsURL = string.Empty;
#endregion
l_skillsURL = apiBaseURL + "/GetSkillExpertApprovals?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_ApprovalBECollection = JsonConvert.DeserializeObject <PendingSkillExpertApprovalBECollection>(l_SkillResponse);
}
l_ApprovalCollection = ConverPendingSkillExpertApprovalsToModel(l_ApprovalBECollection);
return(PartialView("_partialPendingSkillExpertApprovals", l_ApprovalCollection));
}
/// <summary>
/// Method to convert SkillExpertBECollection to Model
/// </summary>
/// <param name="argApprovalsBECollection">Business Entity collection for skill expert approval</param>
/// <returns></returns>
private PendingSkillExpertApprovalsCollection ConverPendingSkillExpertApprovalsToModel(PendingSkillExpertApprovalBECollection argApprovalsBECollection)
{
#region Declarations
PendingSkillExpertApprovalsCollection l_PendingApprovalsCollection = new PendingSkillExpertApprovalsCollection();
PendingSkillExpertApprovals l_Approvals;
#endregion
try
{
if (argApprovalsBECollection != null && argApprovalsBECollection.Count > 0)
{
foreach (var item in argApprovalsBECollection)
{
l_Approvals = new PendingSkillExpertApprovals();
l_Approvals.ManagerComments = item.ManagerComments;
l_Approvals.UserComments = item.UserComments;
l_Approvals.SkillExpertComments = item.SkillExpertComments;
l_Approvals.DemoSchedule = item.DemoSchedule;
l_Approvals.Room = item.Room;
l_Approvals.Status = item.Status;
l_Approvals.RequestedDate = item.RequestedDate;
l_Approvals.RequestType = item.RequestType;
l_Approvals.SkillName = item.SkillName;
l_Approvals.SkillPoints = item.SkillPoints;
l_Approvals.SubSkillName = item.SubSkillName;
l_Approvals.RequestedBy = item.RequestedBy;
l_Approvals.UniqueID = item.UniqueID;
l_Approvals.FileGUID = item.FileGUID;
l_Approvals.FileName = item.FileName;
l_Approvals.RequestCode = item.RequestCode;
l_PendingApprovalsCollection.Add(l_Approvals);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(l_PendingApprovalsCollection);
}
/// <summary>
/// Used to get list of pending approvals for skill expert
/// </summary>
/// <param name="argLoggedInUser">Logged in User ID</param>
/// <param name="argType">Request Type</param>
/// <returns></returns>
public PendingSkillExpertApprovalBECollection GetPendingSkillExpertApprovals(int argLoggedInUser, string argType)
{
#region Declarations
PendingSkillExpertApprovalBECollection l_requestCollection = new PendingSkillExpertApprovalBECollection();
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
DataTable l_SkillDataTable = new DataTable();
PendingSkillExpertApprovalBE 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_ALLPENDINGSKILLEXPERTAPPROVALS, 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 PendingSkillExpertApprovalBE();
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.ManagerComments = l_Row["ManagerComments"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["ManagerComments"]);
l_RequestBE.SkillExpertComments = l_Row["SkillExpertComments"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["SkillExpertComments"]);
l_RequestBE.UserComments = l_Row["UserComments"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["UserComments"]);
l_RequestBE.RequestedDate = l_Row["Request date"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(l_Row["Request date"]);
l_RequestBE.SkillName = l_Row["SkillName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["SkillName"]);
l_RequestBE.SubSkillName = l_Row["SubskillName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["SubskillName"]);
l_RequestBE.SkillPoints = l_Row["SkillPoints"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["SkillPoints"]);
l_RequestBE.UniqueID = l_Row["UniqueID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["UniqueID"]);
l_RequestBE.SubSkillName = l_Row["SubskillName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["SubskillName"]);
l_RequestBE.FileName = l_Row["FileName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["FileName"]);
l_RequestBE.FileGUID = l_Row["FileGUID"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["FileGUID"]);
l_RequestBE.RequestedBy = l_Row["UserName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["UserName"]);
l_RequestBE.Room = l_Row["Room"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Room"]);
l_RequestBE.DemoSchedule = l_Row["DemoSchedule"] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(l_Row["DemoSchedule"]);
l_RequestBE.RequestCode = l_Row["RequestCode"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["RequestCode"]);
l_requestCollection.Add(l_RequestBE);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(l_requestCollection);
}
