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