/// <summary>
/// Inteface method to fetch sessions by User id
/// </summary>
/// <param name="objSession">User Id</param>
/// <returns>List Of session</returns>
public bool AddEditSessions(Session objSession)
{
var prms = new List <SqlParameter>
{
SqlUtility.CreateParameter(SPAddEditSession.PARAM_PRESENTER, SqlDbType.NVarChar, objSession.Presenter),
SqlUtility.CreateParameter(SPAddEditSession.PARAM_ID, SqlDbType.Int, objSession.Id),
SqlUtility.CreateParameter(SPAddEditSession.PARAM_TITLE, SqlDbType.NVarChar, objSession.Title),
SqlUtility.CreateParameter(SPAddEditSession.PARAM_DESCRIPTION, SqlDbType.NVarChar, objSession.Description),
SqlUtility.CreateParameter(SPAddEditSession.PARAM_DATE, SqlDbType.DateTime, objSession.Date),
SqlUtility.CreateParameter(SPAddEditSession.PARAM_ATTENDEES, SqlDbType.NVarChar, string.Join(",", objSession.Attendee))
};
try
{
var rowsAffected = SqlUtility.ExecuteNonQuery(SPAddEditSession.NAME,
CommandType.StoredProcedure,
prms);
return(rowsAffected > 0);
}
catch (Exception ex)
{
LogUtility.ErrorRoutine(ex);
return(false);
}
}
/// <summary>
/// Calls stored procedure which adds user.
/// </summary>
/// <param name="userData">User data object.</param>
/// <returns>True if added.</returns>
public bool AddUser(User userData)
{
var prms = new List <SqlParameter>
{
SqlUtility.CreateParameter(SPAddUser.PARAM_FIRST_NAME,
SqlDbType.VarChar, userData.FirstName),
SqlUtility.CreateParameter(SPAddUser.PARAM_LAST_NAME,
SqlDbType.VarChar, userData.LastName),
SqlUtility.CreateParameter(SPAddUser.PARAM_USER_NAME,
SqlDbType.VarChar, userData.UserName),
SqlUtility.CreateParameter(SPAddUser.PARAM_PASSWORD,
SqlDbType.VarChar, userData.Password),
SqlUtility.CreateParameter(SPAddUser.PARAM_EMAIL,
SqlDbType.VarChar, userData.Email),
SqlUtility.CreateParameter(SPAddUser.PARAM_DESIGNATION,
SqlDbType.VarChar, userData.Designation),
SqlUtility.CreateParameter(SPAddUser.PARAM_PROFILE_PICTURE_NAME,
SqlDbType.VarChar, userData.ProfilePictureName),
SqlUtility.CreateParameter(SPAddUser.PARAM_IS_FEMALE,
SqlDbType.Bit, userData.IsFemale),
SqlUtility.CreateParameter(SPAddUser.PARAM_IS_ADMINISTRATOR,
SqlDbType.VarChar, userData.IsAdministrator),
SqlUtility.CreateParameter(SPAddUser.PARAM_IS_TRAINER,
SqlDbType.VarChar, userData.IsTrainer),
SqlUtility.CreateParameter(SPAddUser.PARAM_IS_TRAINEE,
SqlDbType.VarChar, userData.IsTrainee),
SqlUtility.CreateParameter(SPAddUser.PARAM_IS_MANAGER,
SqlDbType.VarChar, userData.IsManager)
};
try
{
var rowsAffected = SqlUtility.ExecuteNonQuery(SPAddUser.NAME,
CommandType.StoredProcedure, prms);
return(rowsAffected > 0);
}
catch (Exception ex)
{
LogUtility.ErrorRoutine(ex);
}
return(false);
}
public bool AddFeedback(Feedback feedbackData)
{
try
{
var prms = new List <SqlParameter>
{
SqlUtility.CreateParameter(SPAddFeedback.PARAM_FEEDBACK_TEXT,
SqlDbType.VarChar, feedbackData.FeedbackText),
SqlUtility.CreateParameter(SPAddFeedback.PARAM_TITLE,
SqlDbType.VarChar, feedbackData.Title),
SqlUtility.CreateParameter(SPAddFeedback.PARAM_FEEDBACK_TYPE,
SqlDbType.Int, feedbackData.FeedbackType.FeedbackTypeId),
SqlUtility.CreateParameter(SPAddFeedback.PARAM_PROJECT_ID,
SqlDbType.Int, feedbackData.Project.ProjectId),
SqlUtility.CreateParameter(SPAddFeedback.PARAM_SKILL_ID,
SqlDbType.Int, feedbackData.Skill.SkillId),
SqlUtility.CreateParameter(SPAddFeedback.PARAM_RATING,
SqlDbType.Int, feedbackData.Rating),
SqlUtility.CreateParameter(SPAddFeedback.PARAM_ADDED_BY,
SqlDbType.Int, feedbackData.AddedBy.UserId),
SqlUtility.CreateParameter(SPAddFeedback.PARAM_ADDED_FOR,
SqlDbType.Int, feedbackData.AddedFor.UserId),
SqlUtility.CreateParameter(SPAddFeedback.PARAM_START_DATE,
SqlDbType.Date, feedbackData.StartDate),
SqlUtility.CreateParameter(SPAddFeedback.PARAM_END_DATE,
SqlDbType.Date, feedbackData.EndDate)
};
var rowsAffected = SqlUtility.ExecuteNonQuery(SPAddFeedback.NAME,
CommandType.StoredProcedure, prms);
return(rowsAffected > 0);
}
catch (Exception ex)
{
LogUtility.ErrorRoutine(ex);
}
return(false);
}
protected void ExecuteNonQuery(SqlCommand command)
{
command.Connection = _connection;
SqlUtility.ExecuteNonQuery(command);
}
