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