public MaritalFamilyData getMaritalFamily(String Marital_Code)
{
MaritalFamilyData MaritalFamily_data = new MaritalFamilyData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From MARITAL_FAMILY Where MARITAL_CODE='" + Marital_Code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
MaritalFamily_data.Marital_Code = rowData["MARITAL_CODE"].ToString();
MaritalFamily_data.Marital_Thai = rowData["MARITAL_THAI"].ToString();
MaritalFamily_data.Marital_Eng = rowData["MARITAL_ENG"].ToString();
}
return(MaritalFamily_data);
}
public List <MaritalFamilyData> getMaritalFamily()
{
List <MaritalFamilyData> MaritalFamily_data = new List <MaritalFamilyData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From MARITAL_FAMILY Order By MARITAL_CODE";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
MaritalFamilyData MaritalFamily = new MaritalFamilyData();
MaritalFamily.Marital_Code = rowData["MARITAL_CODE"].ToString();
MaritalFamily.Marital_Thai = rowData["MARITAL_THAI"].ToString();
MaritalFamily.Marital_Eng = rowData["MARITAL_ENG"].ToString();
MaritalFamily_data.Add(MaritalFamily);
}
return(MaritalFamily_data);
}
