public static EmpEmailContent Checking(string emp) { DataBankManager DBM = new DataBankManager(); EmpEmailContent EEC = new EmpEmailContent(); DataSet DS = new DataSet(); int count; string ei; string en; string em; try { try { if (emp != "" && emp != "System.Data.DataRowView") { DBM.IDepName = emp.ToString(); DS = DBM.CommitteeEmailDashBoard(DBM); //this works based on departments // DS=DBM.CommitteeEmailDashBoard_byEmployeeeID(emp); // this works based on employee id count = DS.Tables[0].Rows.Count; if (DS != null || DS.Tables[0].Rows.Count > 0) { if (count == 1) { EEC.HEmployeeID = DS.Tables[0].Rows[0].ItemArray[5].ToString(); EEC.HEmployeeName = DS.Tables[0].Rows[0].ItemArray[3].ToString(); EEC.Email = DS.Tables[0].Rows[0].ItemArray[4].ToString(); } else { for (int i = 0; i < count; i++) { ei = DS.Tables[0].Rows[i].ItemArray[5].ToString(); en = DS.Tables[0].Rows[i].ItemArray[3].ToString(); em = DS.Tables[0].Rows[i].ItemArray[4].ToString(); if (i < count - 1) { EEC.HEmployeeID = EEC.HEmployeeID + ei + ", "; EEC.HEmployeeName = EEC.HEmployeeName + en + ", "; EEC.Email = EEC.Email + em + ", "; } else { EEC.HEmployeeID = EEC.HEmployeeID + ei; EEC.HEmployeeName = EEC.HEmployeeName + en; EEC.Email = EEC.Email + em; } } } EEC.ErrorLabel = "0"; } else if (emp == "") { EEC.ErrorLabel = "Check the Employee ID "; } else { EEC.ErrorLabel = "1"; } } else { string err = "Check the Input Record is not Exit "; } } catch (Exception ex) { string err = "Check the Input Record is not Exit "; } return(EEC); } catch (Exception ex) { throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message); } }