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