//edit BGC admin status-admin details list -DAL
public List <EditBGCStatus_BOClass> getEditDAL(int e_id)
{
List <EditBGCStatus_BOClass> boList = new List <EditBGCStatus_BOClass>();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
try
{
con.Open();
SqlCommand cmd = new SqlCommand("select BgcAdmin_AdministratorID,BgcAdmin_StatusChangeTime from E_Data_BGC_Administrator where BgcAdmin_AdministratorID=" + e_id, con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
EditBGCStatus_BOClass b = new EditBGCStatus_BOClass();
b.BgcAdmin_AdministratorID = (dr.GetInt32(0));
//b.BgcAdmin_Status = dr.GetString(1);
b.BgcAdmin_StatusChangeTime = dr.GetDateTime(1);
boList.Add(b);
}
dr.Close();
con.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(boList);
}
//view BGC Admins list passed by HR-DAL
public List <EditBGCStatus_BOClass> getDAL()
{
List <EditBGCStatus_BOClass> boList = new List <EditBGCStatus_BOClass>();
try
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from E_Data_BGC_Administrator ", con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
EditBGCStatus_BOClass b = new EditBGCStatus_BOClass();
b.BgcAdmin_AdministratorID = (dr.GetInt32(0));
b.BgcAdmin_Status = dr.GetString(1);
b.BgcAdmin_StatusChangeTime = dr.GetDateTime(2);
boList.Add(b);
}
dr.Close();
con.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(boList);
}
