public async Task <IActionResult> GetProjectNumberWithDataD2(string ProjectNumber) { ModelMenuD2ProjectNumberData e = await _IDocMenuDService.GetProjectNumberWithDataD2Async(ProjectNumber); if (e != null) { return(Ok(e)); } else { return(BadRequest()); } }
public async Task <ModelMenuD2ProjectNumberData> GetProjectNumberWithDataD2Async(string project_number) { try { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("sp_getdata_for_d2", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@project_number", SqlDbType.VarChar, 50).Value = project_number; SqlDataReader reader = await cmd.ExecuteReaderAsync(); if (reader.HasRows) { ModelMenuD2ProjectNumberData e = new ModelMenuD2ProjectNumberData(); while (await reader.ReadAsync()) { e.projectname1 = reader[1].ToString(); e.projectname2 = reader[2].ToString(); e.projectheadname = reader[3].ToString(); e.facultyname = reader[4].ToString(); e.positionname = reader[5].ToString(); e.certificatetype = reader[6].ToString(); e.remarkapproval = reader[7].ToString(); e.dateofapproval = Convert.ToDateTime(reader[8]).ToString("dd/MM/yyyy"); } e.ListDownloadFile = new List <ModelSelectOption>(); e.ListDownloadFile = await GetFileDownloadByProjectNumberAsync(project_number); return(e); } } conn.Close(); } } catch (Exception ex) { throw ex; } return(null); }