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