public static Staff.BLDAL.DTO.Staff Staff_Select(Staff.BLDAL.DTO.Staff _StaffLine)
{
Staff.BLDAL.DTO.Staff StaffLine = new Staff.BLDAL.DTO.Staff();
try
{
StaffDAL IO = new StaffDAL();
SqlDataReader myReader = IO.Staff_Select(_StaffLine);
while (myReader.Read())
{
if (myReader["StaffID"] != DBNull.Value)
{
StaffLine.StaffID = (int)myReader["StaffID"];
}
if (myReader["LastName"] != DBNull.Value)
{
StaffLine.LastName = (string)myReader["LastName"];
}
if (myReader["MiddleName"] != DBNull.Value)
{
StaffLine.MiddleName = (string)myReader["MiddleName"];
}
if (myReader["FirstName"] != DBNull.Value)
{
StaffLine.FirstName = (string)myReader["FirstName"];
}
if (myReader["Gender"] != DBNull.Value)
{
StaffLine.Gender = (string)myReader["Gender"];
}
if (myReader["Position"] != DBNull.Value)
{
StaffLine.Position = (string)myReader["Position"];
}
if (myReader["HiredDate"] != DBNull.Value)
{
StaffLine.HiredDate = (string)myReader["HiredDate"];
}
if (myReader["Salary"] != DBNull.Value)
{
StaffLine.Salary = (string)myReader["Salary"];
}
}
myReader.Close();
}
catch (Exception ex)
{
if (ConfigurationManager.AppSettings["RethrowErrors"] == "true")
{
throw ex;
}
return(new Staff.BLDAL.DTO.Staff());
}
return(StaffLine);
}
