public List <TeacherDesignation> GetAllDesignationsInfo()
{
Query = "SELECT * FROM Designation";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <TeacherDesignation> getAllDesignationsInfo = new List <TeacherDesignation>();
while (Reader.Read())
{
TeacherDesignation aDesignation = new TeacherDesignation()
{
Id = (int)Reader["Id"],
Designation = Reader["Designation"].ToString()
};
getAllDesignationsInfo.Add(aDesignation);
}
Reader.Close();
Connection.Close();
return(getAllDesignationsInfo);
}
public List <TeacherDesignation> GetAllDesignations()
{
string query = "SELECT *from TeacherDesignationTable order by DesignationName";
_command = new SqlCommand(query, _connection);
_connection.Open();
_sqlDataReader = _command.ExecuteReader();
List <TeacherDesignation> listOfItems = new List <TeacherDesignation>();
while (_sqlDataReader.Read())
{
TeacherDesignation item = new TeacherDesignation();
item.Id = Convert.ToInt32(_sqlDataReader["id"]);
item.DesignationId = Convert.ToInt32(_sqlDataReader["DesignationID"]);
item.DesignationName = _sqlDataReader["DesignationName"].ToString();
listOfItems.Add(item);
}
_connection.Close();
return(listOfItems);
}
public List <TeacherDesignation> GetAllDesignation()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "select * from Dic_Designation";
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
List <TeacherDesignation> designationList = new List <TeacherDesignation>();
while (reader.Read())
{
int id = Convert.ToInt32(reader["id"]);
string name = reader["name"].ToString();
TeacherDesignation teacherDesignation = new TeacherDesignation(id, name);
designationList.Add(teacherDesignation);
}
return(designationList);
}
