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);
}
