public staffPostTrainingDetails postTrainingDetails(string trainingID) { staffPostTrainingDetails details = new staffPostTrainingDetails(); string connectionString = Connstr(); string queryString = null; queryString = "SELECT Location,Domain,Graduation,PG,PastExp,StartingDate,Duration,NoOfSeat,TrainingDesc" + " from TrainingDetails " + " Where TrainingID=@train and StaffApproval='Pending' and " + "StartingDate >= GETDATE() "; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); command.Parameters.AddWithValue("@train", trainingID); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { details.location = Convert.ToString(reader[0]); details.domain = Convert.ToString(reader[1]); details.graduation = Convert.ToChar(reader[2]); details.postgrad = Convert.ToChar(reader[3]); details.experience = Convert.ToInt32(reader[4]); details.startDate = Convert.ToDateTime(reader[5]); details.duration = Convert.ToInt32(reader[6]); details.seats = Convert.ToInt32(reader[7]); details.description = Convert.ToString(reader[8]); } connection.Close(); reader.Close(); } return details; }
public ActionResult adminTrainingOfferDetails(string trainingID) { staffPostTrainingDetails table = new staffPostTrainingDetails(); table = new DataAccess.StaffDAL().postTrainingDetails(trainingID); return PartialView("~/Views/Admin/adminTrainingOfferDetails.cshtml", table); }