public List<Designation> GetAllDesignations()
{
try
{
List<Designation> designation = new List<Designation>();
connection.Open();
string designationQuery = "select * from t_Designation";
command.CommandText = designationQuery;
SqlDataReader designationReader = command.ExecuteReader();
while (designationReader.Read())
{
Designation aDesignation = new Designation();
aDesignation.Id = Convert.ToInt16(designationReader[0].ToString());
aDesignation.DesignationName = designationReader[1].ToString();
designation.Add(aDesignation);
//designation.Add(designationReader[0].ToString());
}
return designation;
}
finally
{
connection.Close();
}
}
public Designation GetDesignation(int id)
{
Designation aDesignation = new Designation();
List<Designation> designations = GetAllDesignations();
foreach (Designation designation in designations)
{
if (designation.Id == id)
{
aDesignation.Id = designation.Id;
aDesignation.DesignationName = designation.DesignationName;
}
}
return aDesignation;
}