//Get Autogenerated ID
public static int GetAutogeneratedSpecialityID_BL()
{
int Specialityid = 0;
try
{
Specialityid = Speciality_DAL.GetAutoGeneratedSpecId();
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(Specialityid);
}
//Search Speciality By Id
public static DataTable SearchSpecialityById_BL(int Specialityid)
{
DataTable Speciality = null;
try
{
Speciality = Speciality_DAL.SearchSpecById(Specialityid);
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(Speciality);
}
//Display All Speciality
public static DataTable DisplaySpeciality_BL()
{
DataTable Speciality = null;
try
{
Speciality = Speciality_DAL.DisplayAllSpeciality();
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(Speciality);
}
//Delete Speciality
public static int DeleteSpeciality_BL(int Specialityid)
{
int rowsAffected = 0;
try
{
rowsAffected = Speciality_DAL.DeleteSpec(Specialityid);
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(rowsAffected);
}
//Calling Update Speciality
public static int UpdateSpeciality_BL(Speciality newSpec)
{
int rowsAffected = 0;
try
{
if (ValidatSpec(newSpec))
{
rowsAffected = Speciality_DAL.UpdateSpec(newSpec);
}
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(rowsAffected);
}
