public List<YearTermModel> GetAllYearTermIdBysessionId(int sessionId) { List<YearTermModel> yearTermModels = new List<YearTermModel>(); string query = String.Format(@"select yearTermId from tblStudentSemisterRegistration where sessionId=@sessionId"); using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString)) { using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.Clear(); command.Parameters.AddWithValue("@sessionId",sessionId); connection.Open(); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { YearTermModel yearTermModel = new YearTermModel(); yearTermModel.ID = Convert.ToInt32(rdr[0]); yearTermModels.Add(yearTermModel); } connection.Close(); } } return yearTermModels; }
public List<YearTermModel> GetAllYearTerm() { List<YearTermModel> yearTermModels = new List<YearTermModel>(); string query = String.Format("spGetAllYearTerm"); using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString)) { using (SqlCommand command = new SqlCommand(query, connection)) { connection.Open(); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { YearTermModel yearTermModel = new YearTermModel(); yearTermModel.ID = Convert.ToInt32(rdr[0]); yearTermModel.YearTerm = rdr[1].ToString(); yearTermModels.Add(yearTermModel); } connection.Close(); } } return yearTermModels; }
public List<YearTermModel> GetAllYearTermByYearTermId(List<YearTermModel> yearTermModelsParameter) { List<YearTermModel> yearTermModels = new List<YearTermModel>(); string query = String.Format(@"select * from tblYearTerm where id=@yearTermId"); foreach (YearTermModel yearTerm in yearTermModelsParameter) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString)) { using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.Clear(); command.Parameters.AddWithValue("@yearTermId", yearTerm.ID); connection.Open(); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { YearTermModel yearTermModel = new YearTermModel(); yearTermModel.ID = Convert.ToInt32(rdr[0]); yearTermModel.YearTerm = rdr[1].ToString(); yearTermModels.Add(yearTermModel); } connection.Close(); } } } return yearTermModels; }