/// <summary> /// Method to get all designations. /// </summary> /// <returns>List of designation</returns> public static List <Designation> GetAllDesignation() { List <Designation> designationList = new List <Designation>(); DataTable dt = new DataTable(); dt = DALClass.GetAllDesignation(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { designationList.Add(new Designation { DesignationID = Convert.ToInt32(row[0]), DesignationName = row[1].ToString() }); } } return(designationList); }