/// <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); }