//Dispaly All CivilStatus
public static DataTable DisplayCivilStatus_BL()
{
DataTable CVS = null;
try
{
CVS = CivilStatus_DAL.DisplayAllCivilStats();
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(CVS);
}
//Delete CivilStatus
public static int DeleteCivilStatus_BL(int CVSid)
{
int rowsAffected = 0;
try
{
rowsAffected = CivilStatus_DAL.DeleteCivilStat(CVSid);
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(rowsAffected);
}
//Search CivilStatus By Id
public static DataTable SearchCivilStatusById_BL(int CVSid)
{
DataTable CVS = null;
try
{
CVS = CivilStatus_DAL.SearchCivilStatById(CVSid);
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(CVS);
}
//Get Autogenerated ID
public static int GetAutogeneratedCivilStatusID_BL()
{
int CVSid = 0;
try
{
CVSid = CivilStatus_DAL.GetAutoGeneratedCivilStatusId();
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(CVSid);
}
//Calling Update CivilStatus
public static int UpdateCivilStatus_BL(CivilStatus newCVS)
{
int rowsAffected = 0;
try
{
if (ValidatCivilStatus(newCVS))
{
rowsAffected = CivilStatus_DAL.UpdateCivilStat(newCVS);
}
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(rowsAffected);
}
