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