public async Task <IActionResult> GetProjectNumberWithDataD1(string ProjectNumber) { ModelMenuD1ProjectNumberData e = await _IDocMenuDService.GetProjectNumberWithDataD1Async(ProjectNumber); if (e != null) { return(Ok(e)); } else { return(BadRequest()); } }
public async Task <ModelMenuD1ProjectNumberData> GetProjectNumberWithDataD1Async(string project_number) { try { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("sp_getdata_for_d1", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@project_number", SqlDbType.VarChar, 50).Value = project_number; SqlDataReader reader = await cmd.ExecuteReaderAsync(); if (reader.HasRows) { ModelMenuD1ProjectNumberData e = new ModelMenuD1ProjectNumberData(); while (await reader.ReadAsync()) { e.projectnamethai = reader[1].ToString(); e.projectnameeng = reader[2].ToString(); e.projectheadname = reader[3].ToString(); e.facultyname = reader[4].ToString(); e.positionname = reader[5].ToString(); e.certificatetype = reader[6].ToString(); e.acceptprojectno = reader[8].ToString(); e.advisorsnamethai = ""; e.accepttypenamethai = reader[6].ToString(); e.dateofapproval = Convert.ToDateTime(reader[7]).ToString("dd/MM/yyyy"); } e.listRenewDate = new List <ModelMenuD1RenewTable>(); e.listRenewDate = await GetListRenewDateAsync(project_number); return(e); } } conn.Close(); } } catch (Exception ex) { throw ex; } return(null); }