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