public ActionResult GetDetailsTable(string TrainingID, string Company)
{
TrainingDetailsTable DetailList = new TrainingDetailsTable();
DetailList = new DataAccess.ApplicantDAL().GetDetailsData(TrainingID,Company);
return Json(DetailList);
}
public TrainingDetailsTable GetDetailsData(string trainingid, string company)
{
TrainingDetailsTable DetailList = new TrainingDetailsTable();
string connectionString = Connstr();
string queryString = null;
queryString = "Select Address,EmailID,PhoneNumber FROM RepDetails WHERE CompanyName=@company";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
command.Parameters.AddWithValue("@company",company);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
reader.Read();
DetailList.CompanyName = company;
DetailList.Address = Convert.ToString(reader[0]);
DetailList.EmailID = Convert.ToString(reader[1]);
DetailList.Phone = Convert.ToString(reader[2]);
reader.Close();
connection.Close();
queryString = "Select StartingDate,Duration,Graduation,PG,PastExp,NoOfSeat FROM TrainingDetails WHERE TrainingID=@trainingid";
SqlCommand command1 = new SqlCommand(queryString, connection);
command1.Parameters.AddWithValue("@trainingid", trainingid);
connection.Open();
SqlDataReader reader1 = command1.ExecuteReader();
reader1.Read();
DetailList.StartDate = Convert.ToDateTime(reader1[0]);
DetailList.Duration = Convert.ToInt32(reader1[1]);
DetailList.Graduation = Convert.ToChar(reader1[2]);
DetailList.PostGraduation = Convert.ToChar(reader1[3]);
DetailList.PastExp = Convert.ToInt32(reader1[4]);
DetailList.SeatsAvailable = Convert.ToInt32(reader1[5]);
reader1.Close();
connection.Close();
}
return DetailList;
}
