/// <summary>
/// Method to get badge details from API
/// </summary>
/// <param name="argType">Badge Type</param>
/// <returns></returns>
public async Task <BadgeBE> GetBadgeDetails(string argType)
{
#region Declarations
BadgeBECollection l_BadgeBECollection = new BadgeBECollection();
BadgeBE l_BadgeBE = new BadgeBE();
int l_LoggedInUser = 0;
string l_BadgeURL = string.Empty;
#endregion
try
{
l_LoggedInUser = GetLoggedInUserID();
l_BadgeURL = apiBaseURL + "/GetBadges?argLoggedInUser="******"&argBadgeType=" + argType;
HttpResponseMessage l_BadgeData = await client.GetAsync(l_BadgeURL);
if (l_BadgeData != null && l_BadgeData.IsSuccessStatusCode)
{
var l_BadgeResponse = l_BadgeData.Content.ReadAsStringAsync().Result;
l_BadgeBECollection = JsonConvert.DeserializeObject <BadgeBECollection>(l_BadgeResponse);
l_BadgeBE = l_BadgeBECollection.Where(x => x.BadgeName == argType).FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(l_BadgeBE);
}
/// <summary>
/// Get badge details in system
/// </summary>
/// <param name="argLoggedInUser">Logged in user ID</param>
/// <param name="argBadgeType">Badge Type</param>
/// <returns></returns>
public BadgeBECollection GetBadges(int argLoggedInUser, string argBadgeType)
{
#region Declarations
BadgeBECollection l_BadgeBECollection = new BadgeBECollection();
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
DataTable l_BadgeDataTable = new DataTable();
BadgeBE l_BadgeBE;
int l_BadgeCount = 0;
#endregion
try
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32));
if (string.IsNullOrEmpty(argBadgeType))
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.TYPE, DBNull.Value, DbType.String));
}
else
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.TYPE, argBadgeType, DbType.String));
}
l_BadgeDataTable = l_SkillsDBManager.GetDataTable(StoredProcedures.GET_ALLBADGES, CommandType.StoredProcedure, l_Parameters.ToArray());
if (l_BadgeDataTable != null && l_BadgeDataTable.Rows.Count > 0)
{
l_BadgeCount = l_BadgeDataTable.Rows.Count;
for (int i = 0; i < l_BadgeCount; i++)
{
l_BadgeBE = new BadgeBE();
DataRow l_Row = l_BadgeDataTable.Rows[i];
l_BadgeBE.BadgeName = l_Row["BadgeName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["BadgeName"]);
l_BadgeBE.BadgeID = l_Row["BadgeID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["BadgeID"]);
l_BadgeBE.BadgeURL = l_Row["BadgeImageURL"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["BadgeImageURL"]);
l_BadgeBECollection.Add(l_BadgeBE);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(l_BadgeBECollection);
}
public IHttpActionResult GetBadges(int argLoggedInUser, string argBadgeType)
{
#region Declarations
BadgeBLO l_BadgeBLO = new BadgeBLO();
BadgeBECollection l_BadgeBECollection = new BadgeBECollection();
#endregion
try
{
l_BadgeBECollection = l_BadgeBLO.GetBadges(argLoggedInUser, argBadgeType);
if (l_BadgeBECollection == null || l_BadgeBECollection.Count == 0)
{
return(NotFound());
}
}
catch (Exception ex)
{
throw ex;
}
return(Ok(l_BadgeBECollection));
}
/// <summary>
/// Get dashboard data for user
/// </summary>
/// <param name="argLoggedInUser">Logged in user ID</param>
/// <param name="argUserID">User for whom dashboard details should be loaded</param>
/// <returns></returns>
public DashboardBE GetDashboardDetails(int argLoggedInUser, int argUserID)
{
#region Declarations
DashboardBE l_DashboardBE = new DashboardBE();
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
DataSet l_DashboardDataset = new DataSet();
DataTable l_SkillTable = new DataTable();
DataTable l_SubSkillTable = new DataTable();
DataTable l_DemoDetailsTable = new DataTable();
DataTable l_BadgeDetailsTable = new DataTable();
DataTable l_UserDetailsTable = new DataTable();
SkillsBECollection l_skillsBECollection = new SkillsBECollection();
ScheduleDemoBECollection l_ScheduleDemoBECollection = new ScheduleDemoBECollection();
ScheduleDemoBE l_ScheduleDemoBE;
BadgeBECollection l_BadgeBECollection = new BadgeBECollection();
BadgeBE l_BadgeBE;
SkillsBE l_SkillsBE;
#endregion
try
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.USERID, argUserID, DbType.Int32));
l_DashboardDataset = l_SkillsDBManager.GetDataSet(StoredProcedures.GET_DASHBOARDDETAILS, CommandType.StoredProcedure, l_Parameters.ToArray());
if (l_DashboardDataset != null && l_DashboardDataset.Tables.Count > 0)
{
l_UserDetailsTable = l_DashboardDataset.Tables[0];
l_SkillTable = l_DashboardDataset.Tables[1];
l_SubSkillTable = l_DashboardDataset.Tables[2];
//Get UserDetails
if (l_UserDetailsTable != null && l_UserDetailsTable.Rows.Count > 0)
{
l_DashboardBE.UserID = l_UserDetailsTable.Rows[0]["UserID"] == DBNull.Value ? 0 : Convert.ToInt32(l_UserDetailsTable.Rows[0]["UserID"]);
l_DashboardBE.UserName = l_UserDetailsTable.Rows[0]["UserName"] == DBNull.Value ? string.Empty : Convert.ToString(l_UserDetailsTable.Rows[0]["UserName"]);
l_DashboardBE.EmailID = l_UserDetailsTable.Rows[0]["EmailID"] == DBNull.Value ? string.Empty : Convert.ToString(l_UserDetailsTable.Rows[0]["EmailID"]);
l_DashboardBE.InitialSkillExists = l_UserDetailsTable.Rows[0]["InitialSkillExists"] == DBNull.Value ? false : Convert.ToBoolean(l_UserDetailsTable.Rows[0]["InitialSkillExists"]);
}
//Get skill and subskill
if (l_SkillTable != null && l_SkillTable.Rows.Count > 0)
{
for (int i = 0; i < l_SkillTable.Rows.Count; i++)
{
l_SkillsBE = new SkillsBE();
DataRow l_Row = l_SkillTable.Rows[i];
l_SkillsBE.SkillID = l_Row["SkillID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["SkillID"]);
l_SkillsBE.SkillName = l_Row["SkillName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["SkillName"]);
l_SkillsBE.SkillPoints = l_Row["SkillPoints"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["SkillPoints"]);
l_SkillsBE.SkillType = l_Row["SkillType"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["SkillType"]);
l_SkillsBE.SubSkillBECollection = GetSubSkillData(l_SkillsBE.SkillID, l_SubSkillTable, l_SkillsBE.SkillType);
l_skillsBECollection.Add(l_SkillsBE);
}
l_DashboardBE.SkillsBECollection = l_skillsBECollection;
}
//Get badge data
l_BadgeDetailsTable = l_DashboardDataset.Tables[3];
if (l_BadgeDetailsTable != null && l_BadgeDetailsTable.Rows.Count > 0)
{
for (int i = 0; i < l_BadgeDetailsTable.Rows.Count; i++)
{
DataRow l_Row = l_BadgeDetailsTable.Rows[i];
l_BadgeBE = new BadgeBE();
l_BadgeBE.BadgeID = l_Row["BadgeID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["BadgeID"]);
l_BadgeBE.BadgeName = l_Row["BadgeName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["BadgeName"]);
l_BadgeBE.BadgeURL = l_Row["BadgeImageURL"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["BadgeImageURL"]);
l_BadgeBE.BadgeCount = l_Row["BadgeCount"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["BadgeCount"]);
l_BadgeBECollection.Add(l_BadgeBE);
}
l_DashboardBE.BadgeBECollection = l_BadgeBECollection;
}
//Get demo details
l_DemoDetailsTable = l_DashboardDataset.Tables[4];
if (l_DemoDetailsTable != null && l_DemoDetailsTable.Rows.Count > 0)
{
for (int i = 0; i < l_DemoDetailsTable.Rows.Count; i++)
{
DataRow l_Row = l_DemoDetailsTable.Rows[i];
l_ScheduleDemoBE = new ScheduleDemoBE();
l_ScheduleDemoBE.UniqueID = l_Row["UDID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["UDID"]);
l_ScheduleDemoBE.UserID = l_Row["UserID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["UserID"]);
l_ScheduleDemoBE.SkillID = l_Row["SkillID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["SkillID"]);
l_ScheduleDemoBE.SubSkillID = l_Row["SubskillID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["SubskillID"]);
l_ScheduleDemoBE.SkillName = l_Row["SkillName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["SkillName"]);
l_ScheduleDemoBE.SubSkillName = l_Row["SubskillName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["SubskillName"]);
l_ScheduleDemoBE.Room = l_Row["Room"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Room"]);
l_ScheduleDemoBE.EventConductedBy = l_Row["EventConductedBy"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["EventConductedBy"]);
l_ScheduleDemoBE.DemoSchedule = l_Row["DateAndTime"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(l_Row["DateAndTime"]);
l_ScheduleDemoBECollection.Add(l_ScheduleDemoBE);
}
l_DashboardBE.ScheduleDemoBECollection = l_ScheduleDemoBECollection;
}
}
}
catch (Exception)
{
throw;
}
return(l_DashboardBE);
}