public async Task <ModelMenuB2Data> GetLabNumberWithDataB2Async(string project_id)
{
string sql = "SELECT A.doc_id, B.name_thai, A.faculty_laboratory FROM Doc_MenuA2 A " +
"INNER JOIN MST_LabMethodType B " +
"ON A.project_according_type_method = B.id " +
"WHERE A.doc_id='" + project_id + "'";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
ModelMenuB2Data e = new ModelMenuB2Data();
while (await reader.ReadAsync())
{
e.labTypeName = reader["name_thai"].ToString();
e.facultyName = reader["faculty_laboratory"].ToString();
}
e.ListDownloadFile = await GetAllDownloadFileByLabNumberB2Async(project_id);
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <IActionResult> GetLabNumberWithDataB2(string LabNumber)
{
ModelMenuB2Data e = await _IDocMenuBService.GetLabNumberWithDataB2Async(LabNumber);
if (e != null)
{
return(Ok(e));
}
else
{
return(BadRequest());
}
}
