public ObservableCollection <string> GetDistinctList(StaffColName colname) { ObservableCollection <string> xList = new ObservableCollection <string>(); try { conn.Open(); string sql = GetSql4DistinctList(colname); if (!string.IsNullOrEmpty(sql)) { MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { xList.Add(rdr[0].ToString()); } } } catch (Exception vx) { System.Windows.MessageBox.Show("Problem in getting distinct List list. : " + vx.Message); } finally { conn.Close(); } return(xList); }
private string GetSql4DistinctList(StaffColName colname) { string sql1 = "SELECT DISTINCT"; string sql2 = "FROM `staff` WHERE "; string sql3 = "IS NOT NULL"; string sql = string.Empty; switch (colname) { case StaffColName.VacancyStatus: sql = $"{sql1} vacancyStatus {sql2} vacancyStatus {sql3}"; break; case StaffColName.Designation: sql = $"{sql1} designation {sql2} designation {sql3}"; break; case StaffColName.Subject: sql = $"{sql1} subjectName {sql2} subjectName {sql3}"; break; case StaffColName.SalarySource: sql = $"{sql1} billType {sql2} billType {sql3}"; break; case StaffColName.EmployeeGroup: sql = $"{sql1} empGroup {sql2} empGroup {sql3}"; break; case StaffColName.ApprvQualification: sql = $"{sql1} apprvQualification {sql2} apprvQualification {sql3}"; break; case StaffColName.PayBand: sql = $"{sql1} payband {sql2} payband {sql3}"; break; default: break; } return(sql); }