Пример #1
0
        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());
            }
        }