public List <UserFamilyBirthYearVo> selectlistUserFamilyTypeVo(UserFamilyBirthYearVo userFamilyBirthYearVo)
{
List <UserFamilyBirthYearVo> userFamilyBirthYearVoList = new List <UserFamilyBirthYearVo>();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FAMILY_BIRTH_YEAR_LIST";
DataSet ds = sqlCommon.ExecuteProcedure(procedureName, null);
if ((ds != null) &&
(ds.Tables != null) && (ds.Tables[0] != null) &&
(ds.Tables[0].Rows.Count > 0) && (ds.Tables[0].Rows[0] != null))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
UserFamilyBirthYearVo userFamilyBirthYearVoResult = new UserFamilyBirthYearVo();
userFamilyBirthYearVoResult.userFamilyBirthYear.birthYear = int.Parse(dr["BIRTH_YEAR"].ToString());
if ((dr["DEFAULT_VAL"] != null) && (dr["DEFAULT_VAL"].ToString() == "Y"))
{
userFamilyBirthYearVoResult.userFamilyBirthYear.defaultVal = true;
}
userFamilyBirthYearVoList.Add(userFamilyBirthYearVoResult);
}
}
}
return(userFamilyBirthYearVoList);
}
public UserFamilyBirthYearListVo selectlistUserFamilyBirthYearVo(UserFamilyBirthYearVo userFamilyBirthYearVo)
{
UserFamilyBirthYearListVo userFamilyBirthYearListVo = new UserFamilyBirthYearListVo();
using (UserFamilyBirthYearDao userFamilyBirthYearDao = new UserFamilyBirthYearDao())
{
userFamilyBirthYearListVo.userFamilyBirthYearVoList = userFamilyBirthYearDao.selectlistUserFamilyTypeVo(userFamilyBirthYearVo);
}
return(userFamilyBirthYearListVo);
}
public UserFamilyBirthYearListVo selectlistUserFamilyBirthYearVo(UserFamilyBirthYearVo userFamilyBirthYearVo)
{
UserFamilyBirthYearListVo userFamilyBirthYearListVo = new UserFamilyBirthYearListVo();
using (UserFamilyBirthYearService userFamilyBirthYearService = new UserFamilyBirthYearService())
{
userFamilyBirthYearListVo = userFamilyBirthYearService.selectlistUserFamilyBirthYearVo(userFamilyBirthYearVo);
}
return(userFamilyBirthYearListVo);
}