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