//displays final bgc admins public List <BOClass> View_BGC_Admin_DAL() { List <BOClass> bolist2 = new List <BOClass>(); try { con.Open(); SqlCommand cmd1 = new SqlCommand("select * from E_Data_BGC_Administrator ", con); SqlDataReader dr = cmd1.ExecuteReader(); while (dr.Read()) { BOClass b = new BOClass(); if (dr.IsDBNull(3)) { b.BgcAdmin_EmployeeID = 0; } else { b.BgcAdmin_EmployeeID = Convert.ToInt32(dr.GetInt32(3)); } b.BgcAdmin_Status = (dr.GetString(1)); b.BgcAdmin_StatusChangeTime = (dr.GetDateTime(2)); b.BgcAdmin_AdministratorID = (dr.GetInt32(0)); bolist2.Add(b); } dr.Close(); con.Close(); } catch (Exception ex) { Console.WriteLine(ex); } return(bolist2); }
//displays list for bgc admins public List <BOClass> Add_Employee_BGC_Admin_DAL() { List <BOClass> bolist = new List <BOClass>(); try { con.Open(); SqlCommand cmd1 = new SqlCommand("select Emp_EmployeeID, Emp_EmployeeName from E_Data_Employee where Emp_EmployeeID in(select Emp_EmployeeID from E_Data_Employee where Emp_IsHR !=1 and Emp_UnitHeadID is not null except select BgcAdmin_EmployeeID from E_Data_BGC_Administrator)", con); SqlDataReader dr = cmd1.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { BOClass b = new BOClass(); if (dr.IsDBNull(0)) { b.BgcAdmin_EmployeeID = 0; } else { b.BgcAdmin_EmployeeID = Convert.ToInt32(dr.GetInt32(0)); } b.Emp_EmployeeName = (dr.GetString(1)); bolist.Add(b); } dr.Close(); con.Close(); } catch (Exception ex) { Console.WriteLine(ex); } return(bolist); }
//displays final bgc admins public List <BOClass> View_BGC_Admin_BAL() { AddBgcAdminDAL dl = new AddBgcAdminDAL(); BOClass b = new BOClass(); List <BOClass> bolist2 = new List <BOClass>(); bolist2 = dl.View_BGC_Admin_DAL(); return(bolist2); }
//displays list of added employees as bgc admin public List <BOClass> Add_BGC_Admin_BAL(string empid) { AddBgcAdminDAL dl = new AddBgcAdminDAL(); BOClass b = new BOClass(); List <BOClass> bolist2 = new List <BOClass>(); bolist2 = dl.Add_BGC_Admin_DAL(empid); return(bolist2); }
//displays list of added employees as bgc admin public List <BOClass> Add_BGC_Admin_DAL(string empid) { List <BOClass> bolist2 = new List <BOClass>(); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_AddBGCAdmin_Group1", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@empid", empid); cmd.ExecuteNonQuery(); SqlCommand cmd1 = new SqlCommand("select * from E_Data_BGC_Administrator ", con); SqlDataReader dr = cmd1.ExecuteReader(); while (dr.Read()) { BOClass b = new BOClass(); if (dr.IsDBNull(3)) { b.BgcAdmin_EmployeeID = 0; } else { b.BgcAdmin_EmployeeID = Convert.ToInt32(dr.GetInt32(3)); } b.BgcAdmin_Status = (dr.GetString(1)); b.BgcAdmin_StatusChangeTime = (dr.GetDateTime(2)); b.BgcAdmin_AdministratorID = (dr.GetInt32(0)); bolist2.Add(b); } dr.Close(); con.Close(); } catch (Exception ex) { Console.WriteLine(ex); } return(bolist2); }