/// <summary>
/// Modify the badge status by manager
/// </summary>
/// <param name="argLoggedInUser">Logged in user ID</param>
/// <param name="argSaveBadgeBE">Badge Details</param>
/// <returns></returns>
public void ApproveBadge(int argLoggedInUser, SaveBadgeBE argSaveBadgeBE)
{
#region Declarations
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
#endregion
try
{
if (argSaveBadgeBE != null)
{
//Create Parameters
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.USERBADGEID, argSaveBadgeBE.UserBadgeID, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.COMMENTS, argSaveBadgeBE.Comments, DbType.String));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.STATUS, argSaveBadgeBE.Status, DbType.String));
//Call stored procedure
l_SkillsDBManager.Update(StoredProcedures.SAVE_APPROVEBADGE, CommandType.StoredProcedure, l_Parameters.ToArray());
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Used to save the initial skill request (primary skills)
/// </summary>
/// <param name="argLoggedInUser">Logged in User ID</param>
/// <param name="argInitialRequest">Request Details</param>
/// <returns></returns>
public void CreateInitialRequest(UserInitialSkillRequestBE argSkillRequest, string argLoggedInUser)
{
#region Declarations
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
XElement l_skillXML = null;
int l_LastID = 0;
#endregion
try
{
if (argLoggedInUser != null && argSkillRequest != null && argSkillRequest.UserSubskills != null && argSkillRequest.UserSubskills.Count > 0)
{
//Generate XML
l_skillXML = GenerateSkillXML(argSkillRequest.UserSubskills);
//Create Parameters
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.String));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.COMMENTS, argSkillRequest.Comments, DbType.String));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.SKILLXML, l_skillXML.ToString(), DbType.Xml));
//Call stored procedure
l_SkillsDBManager.Insert(StoredProcedures.SAVE_INITIALSKILLREQUEST, CommandType.StoredProcedure, l_Parameters.ToArray(), out l_LastID);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Used to save manager action (APPROVE/REJECT)
/// </summary>
/// <param name="argLoggedInUser">Logged in user ID</param>
/// <param name="argManagerApprovalBE">Manager approval details</param>
/// <returns></returns>
public void SaveManagerApprovals(int argLoggedInUser, ManagerApprovalBE argManagerApproval)
{
#region Declarations
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
#endregion
try
{
if (argManagerApproval != null)
{
//Create Parameters
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.TYPE, argManagerApproval.Type, DbType.String));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.UNIQUEID, argManagerApproval.UniqueID, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.COMMENTS, argManagerApproval.Comments, DbType.String));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.STATUS, argManagerApproval.Status, DbType.String));
//Call stored procedure
l_SkillsDBManager.Update(StoredProcedures.SAVE_MANAGERACTION, CommandType.StoredProcedure, l_Parameters.ToArray());
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Save badge given by user
/// </summary>
/// <param name="argLoggedInUser">Logged in user ID</param>
/// <param name="argSaveBadgeBE">Badge Details to save</param>
/// <returns></returns>
public void SaveBadgeForUser(int argLoggedInUser, SaveBadgeBE argSaveBadgeBE)
{
#region Declarations
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
int l_LastID = 0;
#endregion
try
{
if (argSaveBadgeBE != null)
{
//Create Parameters
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.BADGEGIVENTO, argSaveBadgeBE.BadgeGivenTo, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.BADGEID, argSaveBadgeBE.BadgeID, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.COMMENTS, argSaveBadgeBE.Comments, DbType.String));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.TYPE, argSaveBadgeBE.Type, DbType.String));
//Call stored procedure
l_SkillsDBManager.Insert(StoredProcedures.SAVE_USERBADGE, CommandType.StoredProcedure, l_Parameters.ToArray(), out l_LastID);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Used to save Schedule Demo by skill expert
/// </summary>
/// <param name="argLoggedInUser">Logged in user ID</param>
/// <param name="argScheduleDemoBE">Demo details</param>
/// <returns></returns>
public void ScheduleDemo(int argLoggedInUser, ScheduleDemoBE argScheduleDemoBE)
{
#region Declarations
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
#endregion
try
{
if (argScheduleDemoBE != null)
{
//Create Parameters
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.DEMOSCHEDULE, argScheduleDemoBE.DemoSchedule, DbType.DateTime));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.UNIQUEID, argScheduleDemoBE.UniqueID, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.COMMENTS, argScheduleDemoBE.Comments, DbType.String));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.ROOM, argScheduleDemoBE.Room, DbType.String));
//Call stored procedure
l_SkillsDBManager.Update(StoredProcedures.SAVE_SCHEDULEDEMO, CommandType.StoredProcedure, l_Parameters.ToArray());
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <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);
}
/// <summary>
/// Used to save skills & subskills created using Improve Skills option
/// </summary>
/// <param name="argLoggedInUser">Logged in user</param>
/// <param name="argImproveSkills">Skill and Subskill details</param>
/// <returns></returns>
public void ImproveSkills(ImproveSkillsBE argImproveSkills, string argLoggedInUser)
{
#region Declarations
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
XElement l_skillXML = null;
int l_LastID = 0;
#endregion
try
{
if (argLoggedInUser != null && argImproveSkills != null && argImproveSkills.UserSubskills != null && argImproveSkills.UserSubskills.Count > 0)
{
//Generate XML
l_skillXML = GenerateSkillXML(argImproveSkills.UserSubskills);
//Create Parameters
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.String));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.COMMENTS, argImproveSkills.Comments, DbType.String));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.SKILLXML, l_skillXML.ToString(), DbType.Xml));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.TYPE, argImproveSkills.Mode, DbType.String));
if (string.IsNullOrEmpty(argImproveSkills.FileUploadGUID))
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.FILEUPLOADGUID, DBNull.Value, DbType.String));
}
else
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.FILEUPLOADGUID, argImproveSkills.FileUploadGUID, DbType.String));
}
if (string.IsNullOrEmpty(argImproveSkills.FileUploadName))
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.FILEUPLOADNAME, DBNull.Value, DbType.String));
}
else
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.FILEUPLOADNAME, argImproveSkills.FileUploadName, DbType.String));
}
//Call stored procedure
l_SkillsDBManager.Insert(StoredProcedures.SAVE_IMPROVESKILLS, CommandType.StoredProcedure, l_Parameters.ToArray(), out l_LastID);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <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);
}
/// <summary>
/// Used to sync user required points
/// </summary>
/// <returns></returns>
public void SyncUserRequiredPoints(int argLoggedInUser)
{
#region Declarations
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
#endregion
try
{
//Create Parameters
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32));
//Call stored procedure
l_SkillsDBManager.Insert(StoredProcedures.SAV_SYNCUSERREQUIREDPOINTS, CommandType.StoredProcedure, l_Parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Used to get list of experts with required skills and subskills
/// </summary>
/// <param name="argLoggedInUser">Logged in User ID</param>
/// <param name="argSkillID">Skill ID</param>
/// <param name="argSubSkillID">SubSkill ID</param>
/// <returns></returns>
public QueryBECollection GetEmployeesBasedOnSkillAndSubskill(int argLoggedInUser, int argSkillID, int argSubSkillID)
{
#region Declarations
QueryBECollection l_QueryBECollection = new QueryBECollection();
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
DataTable l_QueryDataTable = new DataTable();
QueryBE l_Query;
int l_QueryResultCount = 0;
#endregion
try
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.SKILLID, argSkillID, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.SUBSKILLID, argSubSkillID, DbType.Int32));
l_QueryDataTable = l_SkillsDBManager.GetDataTable(StoredProcedures.GET_EMPLOYEESFORASKILLSUBSKILL, CommandType.StoredProcedure, l_Parameters.ToArray());
if (l_QueryDataTable != null && l_QueryDataTable.Rows.Count > 0)
{
l_QueryResultCount = l_QueryDataTable.Rows.Count;
for (int i = 0; i < l_QueryResultCount; i++)
{
l_Query = new QueryBE();
DataRow l_Row = l_QueryDataTable.Rows[i];
l_Query.Name = l_Row["Employee Name"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Employee Name"]);
l_Query.Email = l_Row["Email"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Email"]);
l_Query.ContactNumber = l_Row["Contact Number"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Contact Number"]);
l_Query.SkillPoints = l_Row["Skill Points"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["Skill Points"]);
l_QueryBECollection.Add(l_Query);
}
}
}
catch (Exception ex)
{
throw;
}
return(l_QueryBECollection);
}
/// <summary>
/// Used to fetch all subskills for a skill
/// </summary>
/// <param name="argLoggedInUser">Logged in UserID</param>
/// <param name="argSkillID">SkillID</param>
/// <returns></returns>
public SubSkillBECollection GetAllSubSkills(int argLoggedInUser, int argSkillID)
{
#region Declarations
SubSkillBECollection l_SubSkillCollection = new SubSkillBECollection();
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
DataTable l_SubSkillDataTable = new DataTable();
SubskillsBE l_SubSkill;
int l_SubSkillCount = 0;
#endregion
try
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.SKILLID, argSkillID, DbType.Int32));
l_SubSkillDataTable = l_SkillsDBManager.GetDataTable(StoredProcedures.GET_ALLSUBSKILLS_FORASKILL, CommandType.StoredProcedure, l_Parameters.ToArray());
if (l_SubSkillDataTable != null && l_SubSkillDataTable.Rows.Count > 0)
{
l_SubSkillCount = l_SubSkillDataTable.Rows.Count;
for (int i = 0; i < l_SubSkillCount; i++)
{
l_SubSkill = new SubskillsBE();
DataRow l_Row = l_SubSkillDataTable.Rows[i];
l_SubSkill.SkillID = l_Row["SkillID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["SkillID"]);
l_SubSkill.SubSkillID = l_Row["SubskillID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["SubskillID"]);
l_SubSkill.SubSkillName = l_Row["SubskillName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["SubskillName"]);
l_SubSkillCollection.Add(l_SubSkill);
}
}
}
catch (Exception ex)
{
throw;
}
return(l_SubSkillCollection);
}
/// <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);
}
/// <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);
}
/// <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);
}
