public async Task <ModelMenuC1Data> GetProjectNumberWithDataC1Async(string project_number) { string sql = "SELECT (C.first_name + C.full_name) AS project_head_name, B.faculty_name, B.project_name_thai, B.project_name_eng " + "FROM Doc_MenuB1 A " + "INNER JOIN Doc_MenuA1 B ON A.project_id = B.doc_id " + "INNER JOIN RegisterUser C ON B.project_head = C.register_id " + "LEFT JOIN MST_AcceptType D ON A.accept_type = D.id " + "WHERE A.project_key_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) { ModelMenuC1Data e = new ModelMenuC1Data(); while (await reader.ReadAsync()) { e.projectheadname = reader["project_head_name"].ToString(); e.projectnamethai = reader["project_name_thai"].ToString(); e.projectnameeng = reader["project_name_eng"].ToString(); e.facultyname = reader["faculty_name"].ToString(); } return(e); } } conn.Close(); } return(null); }
public async Task <IActionResult> GetProjectNumberWithDataC1(string ProjectNumber) { ModelMenuC1Data e = await _IDocMenuCService.GetProjectNumberWithDataC1Async(ProjectNumber); if (e != null) { return(Ok(e)); } else { return(BadRequest()); } }