public async Task <IActionResult> GetProjectNumberWithDataA7(string ProjectNumber)
{
ModelMenuA7ProjectNumberData e = await _IDocMenuAService.GetProjectNumberWithDataA7Async(ProjectNumber);
if (e != null)
{
return(Ok(e));
}
else
{
return(BadRequest());
}
}
public async Task <ModelMenuA7ProjectNumberData> GetProjectNumberWithDataA7Async(string project_number)
{
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_getdata_for_a7", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@project_number", SqlDbType.VarChar, 50).Value = project_number;
SqlDataReader reader = await cmd.ExecuteReaderAsync();
if (reader.HasRows)
{
ModelMenuA7ProjectNumberData e = new ModelMenuA7ProjectNumberData();
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.dateofapproval = reader[7].ToString();
}
return(e);
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(null);
}
