public static bool Add(HCMS.Business.Series.SeriesGradeKSATaskStatement seriesGradeKSATaskStatement)
{
bool isSuccessfullyInserted = false;
DbCommand commandWrapper = GetDbCommand("spr_AddSeriesGradeKSATaskStatement");
try
{
//SqlParameter returnParam = new SqlParameter("@newWorkflowRuleID", SqlDbType.Int);
//returnParam.Direction = ParameterDirection.Output;
//commandWrapper.Parameters.Add(returnParam);
commandWrapper.Parameters.Add(new SqlParameter("@SeriesID", seriesGradeKSATaskStatement.SeriesID));
commandWrapper.Parameters.Add(new SqlParameter("@Grade", seriesGradeKSATaskStatement.Grade));
commandWrapper.Parameters.Add(new SqlParameter("@KSAID", seriesGradeKSATaskStatement.KSAID));
commandWrapper.Parameters.Add(new SqlParameter("@TaskStatementID", seriesGradeKSATaskStatement.TaskStatementID));
ExecuteNonQuery(commandWrapper);
isSuccessfullyInserted = true;
}
catch (Exception ex)
{
HandleException(ex);
}
return(isSuccessfullyInserted);
}
public static bool Delete(HCMS.Business.Series.SeriesGradeKSATaskStatement seriesGradeKSATaskStatement)
{
bool isSuccessfullyDeleted = false;
DbCommand commandWrapper = GetDbCommand("spr_DeleteSeriesGradeKSATaskStatement");
try
{
commandWrapper.Parameters.Add(new SqlParameter("@seriesID", seriesGradeKSATaskStatement.SeriesID));
commandWrapper.Parameters.Add(new SqlParameter("@grade", seriesGradeKSATaskStatement.Grade));
commandWrapper.Parameters.Add(new SqlParameter("@kSAID", seriesGradeKSATaskStatement.KSAID));
commandWrapper.Parameters.Add(new SqlParameter("@taskStatementID", seriesGradeKSATaskStatement.TaskStatementID));
ExecuteNonQuery(commandWrapper);
}
catch (Exception ex)
{
HandleException(ex);
}
return(isSuccessfullyDeleted);
}
