public async Task <TitleAndDept> getTitleAndDeptCode()
{
TitleAndDept _obj = new TitleAndDept()
{
titleCodeList = new List <string> {
},
deptCodeList = new List <string> {
}
};
using (SqlConnection con = SqlCon())
{
SqlCommand cmd = SqlCmd(con);
cmd.CommandText = "GetTitleAndDeptList";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt0 = new DataTable();
DataTable dt1 = new DataTable();
try
{
con.Open();
da.Fill(ds);
dt0 = ds.Tables[0];
dt1 = ds.Tables[1];
if (dt0.Rows.Count > 0)
{
foreach (DataRow dr in dt0.Rows)
{
_obj.deptCodeList.Add(dr[0].ToString());
}
}
if (dt1.Rows.Count > 0)
{
foreach (DataRow dr in dt1.Rows)
{
_obj.titleCodeList.Add(dr[0].ToString());
}
}
}
catch (SqlException ex)
{
_obj.deptCodeList.Clear();
_obj.titleCodeList.Clear();
}
finally
{
ds.Dispose();
da.Dispose();
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
cmd.Dispose();
}
}
return(_obj);
}
public async Task <IActionResult> TitleAndDeptList()
{
TitleAndDept _obj = await dal.getTitleAndDeptCode();
return(Ok(_obj));
}
