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);
}
