internal static List <PositionCompetencyKSA> GetCollection(DataTable dataItems)
{
List <PositionCompetencyKSA> listCollection = new List <PositionCompetencyKSA>();
PositionCompetencyKSA current = null;
if (dataItems != null)
{
for (int i = 0; i < dataItems.Rows.Count; i++)
{
current = new PositionCompetencyKSA(dataItems.Rows[i]);
listCollection.Add(current);
}
}
else
{
throw new Exception("You cannot create a PositionCompetencyKSA collection from a null data table.");
}
return(listCollection);
}
public void UpdatePDCompetencyKSAFactor(PositionCompetencyKSA positionCompetencyKSA, JQFactor jqFactor)
{
if (base.ValidateKeyField(positionCompetencyKSA.CompetencyKSAID))
{
TransactionManager currentTransaction = new TransactionManager(base.CurrentDatabase);
currentTransaction.BeginTransaction();
DbCommand commandWrapper = GetDbCommand("spr_UpdatePositionCompetencyKSAFactor");
try
{
commandWrapper.Parameters.Add(new SqlParameter("@PositionCompetencyKSAID", positionCompetencyKSA.CompetencyKSAID));
commandWrapper.Parameters.Add(new SqlParameter("@positionDescriptionID", positionCompetencyKSA.PositionDescriptionID));
if (positionCompetencyKSA.CompetencyKSA == null)
{
commandWrapper.Parameters.Add(new SqlParameter("@competencyKSA", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@competencyKSA", positionCompetencyKSA.CompetencyKSA));
}
if (positionCompetencyKSA.Certification == null)
{
commandWrapper.Parameters.Add(new SqlParameter("@certification", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@certification", positionCompetencyKSA.Certification));
}
if (positionCompetencyKSA.QualificationID < 0)
{
commandWrapper.Parameters.Add(new SqlParameter("@qualificationID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@qualificationID", positionCompetencyKSA.QualificationID));
}
if (positionCompetencyKSA.QualificationTypeID < 0)
{
commandWrapper.Parameters.Add(new SqlParameter("@qualificationTypeID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@qualificationTypeID", positionCompetencyKSA.QualificationTypeID));
}
commandWrapper.Parameters.Add(new SqlParameter("@createdByID", positionCompetencyKSA.CreatedByID));
commandWrapper.Parameters.Add(new SqlParameter("@createDate", positionCompetencyKSA.CreateDate));
commandWrapper.Parameters.Add(new SqlParameter("@updatedByID", positionCompetencyKSA.UpdatedByID));
commandWrapper.Parameters.Add(new SqlParameter("@updateDate", positionCompetencyKSA.UpdateDate));
if (positionCompetencyKSA.AssociatedPDDutyID == null)
{
commandWrapper.Parameters.Add(new SqlParameter("@AssociatedPDDutyID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@AssociatedPDDutyID", positionCompetencyKSA.AssociatedPDDutyID));
}
if (jqFactor.JQFactorTypeID < 0)
{
commandWrapper.Parameters.Add(new SqlParameter("@jQFactorTypeID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@jQFactorTypeID", jqFactor.JQFactorTypeID));
}
if (jqFactor.KSAID < 0)
{
commandWrapper.Parameters.Add(new SqlParameter("@KSAID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@KSAID", jqFactor.KSAID));
}
commandWrapper.Parameters.Add(new SqlParameter("@isSF", jqFactor.IsSF));
if (jqFactor.JQID < 0)
{
commandWrapper.Parameters.Add(new SqlParameter("@jQID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@jQID", jqFactor.JQID));
}
if (currentTransaction != null)
{
DatabaseUtility.ExecuteNonQuery(currentTransaction, commandWrapper);
}
else
{
ExecuteNonQuery(commandWrapper);
}
currentTransaction.Commit();
}
catch (Exception ex)
{
currentTransaction.Rollback();
HandleException(ex);
}
}
}
/// <summary>
/// Determines whether the specified System.Object is equal to the current object.
/// </summary>
/// <param name="obj">The System.Object to compare with the current object.</param>
/// <returns>Returns true if the specified System.Object is equal to the current object; otherwise, false.</returns>
public override bool Equals(Object obj)
{
PositionCompetencyKSA PositionCompetencyKSAobj = obj as PositionCompetencyKSA;
return((PositionCompetencyKSAobj == null) ? false : (this.CompetencyKSAID == PositionCompetencyKSAobj.CompetencyKSAID));
}
