public void LoadSendUsers(Cde_UserSurvey userSurvey) { var sqlwhere = "Cde_SurveySendUsers.Status<>4 AND Cde_SurveySendUsers.UserSurveyId=" + userSurvey.UserSurveyId; var sendusers = _dataAccess.GetList <Cde_SurveySendUsers>(sqlwhere); userSurvey.SendUsers.AddRange(sendusers); }
public int AddUserSurvey(Cde_UserSurvey userSurvey) { _dataAccess.AddEntity(userSurvey); foreach (var user in userSurvey.SendUsers) { user.UserSurveyId = userSurvey.UserSurveyId; } _dataAccess.AddEntities(userSurvey.SendUsers); return(userSurvey.UserSurveyId); }
public bool UpdateUserSurvey(Cde_UserSurvey userSurvey) { foreach (var user in userSurvey.SendUsers) { user.UserSurveyId = userSurvey.UserSurveyId; } string sqlwhere = "UserSurveyId=" + userSurvey.UserSurveyId; _dataAccess.DeleteEntities <Cde_SurveySendUsers>(sqlwhere); _dataAccess.AddEntities(userSurvey.SendUsers); return(_dataAccess.UpdateEntity(userSurvey) > 0); }
public bool DeleteUserSurvey(Cde_UserSurvey userSurvey) { return(_dataAccess.UpdateField("Cde_UserSurvey", "Status", "1", "Cde_UserSurvey.UserSurveyId=" + userSurvey.UserSurveyId) > 0); }