public async Task <ModelMenuC12Data> GetProjectNumberWithDataC12Async(string project_number)
{
string sql = "SELECT project_number, project_name_thai, project_name_eng " +
"FROM Doc_Process WHERE project_number='" + project_number + "'";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
ModelMenuC12Data e = new ModelMenuC12Data();
while (await reader.ReadAsync())
{
e.labtypename = reader["project_name_thai"].ToString();
e.facultyname = reader["project_name_eng"].ToString();
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <IActionResult> GetProjectNumberWithDataC12(string ProjectNumber)
{
ModelMenuC12Data e = await _IDocMenuCService.GetProjectNumberWithDataC12Async(ProjectNumber);
if (e != null)
{
return(Ok(e));
}
else
{
return(BadRequest());
}
}
