public JNPApproval GetJNPApprovalByStaffingObjectID(long staffingObjectID, enumStaffingObjectType staffingObjectTypeID) { JNPApproval entity = new JNPApproval(); entity.ID = -1; entity.SupervisorID = -1; entity.HRPersonnelID = -1; DataTable dt = ExecuteDataTable("spr_GetJNPApprovalByStaffingObjectID", staffingObjectID, (int)staffingObjectTypeID); if (dt != null && dt.Rows.Count > 0) { entity.ID = dt.Rows[0].Field <long>("ApprovalID"); entity.SupervisorID = dt.Rows[0].IsNull("SupervisorID") ? -1 : dt.Rows[0].Field <int>("SupervisorID"); entity.SupervisorFullName = dt.Rows[0].IsNull("SupervisorFullName") ? string.Empty : dt.Rows[0].Field <string>("SupervisorFullName"); entity.SupervisorOrgTitle = dt.Rows[0].IsNull("SupervisorOrgTitle") ? string.Empty : dt.Rows[0].Field <string>("SupervisorOrgTitle"); entity.SupervisorSignDate = dt.Rows[0].Field <DateTime?>("SupervisorSignDate"); entity.HRPersonnelID = dt.Rows[0].IsNull("HRPersonnelID") ? -1 : dt.Rows[0].Field <int>("HRPersonnelID"); entity.HRPersonnelFullName = dt.Rows[0].IsNull("HRPersonnelFullName") ? string.Empty : dt.Rows[0].Field <string>("HRPersonnelFullName"); entity.HRPersonnelOrgTitle = dt.Rows[0].IsNull("HRPersonnelOrgTitle") ? string.Empty : dt.Rows[0].Field <string>("HRPersonnelOrgTitle"); entity.HRPersonnelSignDate = dt.Rows[0].Field <DateTime?>("HRPersonnelSignDate"); entity.JNPID = dt.Rows[0].Field <long>("JNPID"); entity.JAID = dt.Rows[0].Field <long>("JAID"); entity.CRID = dt.Rows[0].IsNull("CRID") ? -1 : dt.Rows[0].Field <long>("CRID"); entity.JQID = dt.Rows[0].Field <long>("JQID"); } return(entity); }
public JNPApproval GetJNPApprovalByID(long approvalID) { JNPApproval entity; DataTable dt = ExecuteDataTable("spr_GetJNPApprovalByID", approvalID); if (dt != null && dt.Rows.Count > 0) { entity = new JNPApproval(); entity.ID = dt.Rows[0].Field <long>("ApprovalID"); entity.SupervisorID = dt.Rows[0].Field <int>("SupervisorID"); entity.SupervisorFullName = dt.Rows[0].Field <string>("SupervisorFullName"); entity.SupervisorOrgTitle = dt.Rows[0].Field <string>("SupervisorOrgTitle"); entity.SupervisorSignDate = dt.Rows[0].Field <DateTime?>("SupervisorSignDate"); entity.HRPersonnelID = dt.Rows[0].Field <int>("HRPersonnelID"); entity.HRPersonnelFullName = dt.Rows[0].Field <string>("HRPersonnelFullName"); entity.HRPersonnelOrgTitle = dt.Rows[0].Field <string>("HRPersonnelOrgTitle"); entity.HRPersonnelSignDate = dt.Rows[0].Field <DateTime?>("HRPersonnelSignDate"); entity.JNPID = dt.Rows[0].Field <long>("JNPID"); entity.JAID = dt.Rows[0].Field <long>("JAID"); entity.CRID = dt.Rows[0].Field <long>("CRID"); entity.JQID = dt.Rows[0].Field <long>("JQID"); } else { throw new Exception("You cannot create a JNPApproval object from a null data table."); } return(entity); }
protected virtual void FillObjectFromRowData(DataRow returnRow) { DataColumnCollection columns = returnRow.Table.Columns; if (returnRow["JNPID"] != DBNull.Value) { this._JNPID = (long)returnRow["JNPID"]; } if (returnRow["JNPTypeID"] != DBNull.Value) { int tempValue = (int)returnRow["JNPTypeID"]; if (Enum.IsDefined(typeof(enumJNPType), tempValue)) { this._JNPTypeID = (enumJNPType)tempValue; } } if (returnRow["JNPOptionTypeID"] != DBNull.Value) { int tempValue = (int)returnRow["JNPOptionTypeID"]; if (Enum.IsDefined(typeof(eJNPOptionType), tempValue)) { this._JNPOptionTypeID = (eJNPOptionType)tempValue; } } if (returnRow["IsStandardJNP"] != DBNull.Value) { this._isStandardJNP = (bool)returnRow["IsStandardJNP"]; } if (returnRow["IsDEU"] != DBNull.Value) { this._isDEU = (bool)returnRow["IsDEU"]; } if (returnRow["IsMP"] != DBNull.Value) { this._isMP = (bool)returnRow["IsMP"]; } if (returnRow["IsExceptedService"] != DBNull.Value) { this._isExceptedService = (bool)returnRow["IsExceptedService"]; } if (returnRow["PayPlanID"] != DBNull.Value) { this._payPlanID = (int)returnRow["PayPlanID"]; } if (returnRow["PayPlanTitle"] != DBNull.Value) { this._payPlanTitle = returnRow["PayPlanTitle"].ToString(); } if (returnRow["SeriesID"] != DBNull.Value) { this._seriesID = (int)returnRow["SeriesID"]; } if (returnRow["SeriesName"] != DBNull.Value) { this._seriesName = returnRow["SeriesName"].ToString(); } if (returnRow["IsInterdisciplinary"] != DBNull.Value) { this._isInterdisciplinary = (bool)returnRow["IsInterdisciplinary"]; } if (returnRow["AdditionalSeriesID"] != DBNull.Value) { this._additionalSeriesID = (int)returnRow["AdditionalSeriesID"]; } if (returnRow["AdditionalSeriesName"] != DBNull.Value) { this._additionalSeriesName = returnRow["AdditionalSeriesName"].ToString(); } if (returnRow["LowestAdvertisedGrade"] != DBNull.Value) { this._lowestAdvertisedGrade = (int)returnRow["LowestAdvertisedGrade"]; } if (returnRow["HighestAdvertisedGrade"] != DBNull.Value) { this._highestAdvertisedGrade = (int)returnRow["HighestAdvertisedGrade"]; } if (returnRow["HighestAdvertisedGradeName"] != DBNull.Value) { this._highestAdvertisedGradeName = returnRow["HighestAdvertisedGradeName"].ToString(); } if (returnRow["RegionID"] != DBNull.Value) { this._regionID = (int)returnRow["RegionID"]; } if (returnRow["RegionName"] != DBNull.Value) { this._regionName = returnRow["RegionName"].ToString(); } if (returnRow["OrganizationCodeID"] != DBNull.Value) { this._organizationCodeID = (int)returnRow["OrganizationCodeID"]; } if (columns.Contains("OrganizationCode")) { if (returnRow["OrganizationCode"] != DBNull.Value) { this._organizationCode = returnRow["OrganizationCode"].ToString(); } } if (columns.Contains("OrganizationName")) { if (returnRow["OrganizationName"] != DBNull.Value) { this._organizationName = returnRow["OrganizationName"].ToString(); } } if (returnRow["JNPTitle"] != DBNull.Value) { this._JNPTitle = returnRow["JNPTitle"].ToString(); } if (returnRow["DutyLocation"] != DBNull.Value) { this._dutyLocation = returnRow["DutyLocation"].ToString(); } if (returnRow["VacancyID"] != DBNull.Value) { this._vacancyID = returnRow["VacancyID"].ToString(); } if (returnRow["FullPDID"] != DBNull.Value) { this._fullPDID = (long)returnRow["FullPDID"]; } if (returnRow["FullPDName"] != DBNull.Value) { this._fullPDName = returnRow["FullPDName"].ToString(); } if (returnRow["AdditionalPDID"] != DBNull.Value) { this._additionalPDID = (long)returnRow["AdditionalPDID"]; } if (returnRow["AdditionalPDName"] != DBNull.Value) { this._additionalPDName = returnRow["AdditionalPDName"].ToString(); } if (returnRow["JAID"] != DBNull.Value) { this._JAID = (long)returnRow["JAID"]; } if (returnRow["CRID"] != DBNull.Value) { this._CRID = (long)returnRow["CRID"]; } if (returnRow["JQID"] != DBNull.Value) { this._JQID = (long)returnRow["JQID"]; } if (returnRow["FPPSPDID"] != DBNull.Value) { this._FPPSPDID = returnRow["FPPSPDID"].ToString(); } if (returnRow["CreatedByID"] != DBNull.Value) { this._createdByID = (int)returnRow["CreatedByID"]; } if (returnRow["CreateDate"] != DBNull.Value) { this._createDate = (DateTime)returnRow["CreateDate"]; } if (returnRow["UpdatedByID"] != DBNull.Value) { this._updatedByID = (int)returnRow["UpdatedByID"]; } if (returnRow["UpdateDate"] != DBNull.Value) { this._updateDate = (DateTime)returnRow["UpdateDate"]; } if (returnRow["ResultedInSuccessfulHiring"] != DBNull.Value) { this._resultedInSuccessfulHiring = (bool)returnRow["ResultedInSuccessfulHiring"]; } if (returnRow["CopyFromJNPID"] != DBNull.Value) { this._copyFromJNPID = (long)returnRow["CopyFromJNPID"]; } JNPApproval jnpApproval = GetJNPApprovalInfo(this._JNPID); if (jnpApproval.SupervisorSignDate != null) { this._IsJNPSignedBySupervisor = true; } if (jnpApproval.HRPersonnelSignDate != null) { this._IsJNPSignedByHR = true; } }
public long Add(JNPApproval entity, TransactionManager currentTransaction, SignatureType signaturetypeID) { long returnCode = -1; DbCommand commandWrapper = GetDbCommand("spr_AddJNPApproval"); try { SqlParameter returnParam = new SqlParameter("@newApprovalID", SqlDbType.BigInt); returnParam.Direction = ParameterDirection.Output; // get the new ApprovalID of the record commandWrapper.Parameters.Add(returnParam); if (entity.SupervisorID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@supervisorID", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@supervisorID", entity.SupervisorID)); } if (string.IsNullOrEmpty(entity.SupervisorFullName)) { commandWrapper.Parameters.Add(new SqlParameter("@supervisorFullName", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@supervisorFullName", entity.SupervisorFullName)); } if (string.IsNullOrEmpty(entity.SupervisorOrgTitle)) { commandWrapper.Parameters.Add(new SqlParameter("@supervisorOrgTitle", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@supervisorOrgTitle", entity.SupervisorOrgTitle)); } if (!entity.SupervisorSignDate.HasValue) { commandWrapper.Parameters.Add(new SqlParameter("@supervisorSignDate", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@supervisorSignDate", entity.SupervisorSignDate)); } if (entity.HRPersonnelID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelID", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelID", entity.HRPersonnelID)); } if (string.IsNullOrEmpty(entity.HRPersonnelFullName)) { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelFullName", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelFullName", entity.HRPersonnelFullName)); } if (string.IsNullOrEmpty(entity.HRPersonnelOrgTitle)) { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelOrgTitle", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelOrgTitle", entity.HRPersonnelOrgTitle)); } if (!entity.HRPersonnelSignDate.HasValue) { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelSignDate", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelSignDate", entity.HRPersonnelSignDate)); } if (entity.JNPID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@jNPID", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@jNPID", entity.JNPID)); } if (entity.JAID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@jAID", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@jAID", entity.JAID)); } if (entity.CRID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@cRID", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@cRID", entity.CRID)); } if (entity.JQID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@jQID", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@jQID", entity.JQID)); } commandWrapper.Parameters.Add(new SqlParameter("@signatureTypeID", (int)signaturetypeID)); if (currentTransaction != null) { DatabaseUtility.ExecuteNonQuery(currentTransaction, commandWrapper); } else { ExecuteNonQuery(commandWrapper); } returnCode = (long)returnParam.Value; } catch (Exception ex) { currentTransaction.Rollback(); HandleException(ex); } return(returnCode); }
public void Update(JNPApproval entity, TransactionManager currentTransaction, SignatureType signaturetypeID) { if (base.ValidateKeyField(entity.ID)) { DbCommand commandWrapper = GetDbCommand("spr_UpdateJNPApproval"); try { commandWrapper.Parameters.Add(new SqlParameter("@approvalID", entity.ID)); if (entity.SupervisorID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@supervisorID", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@supervisorID", entity.SupervisorID)); } if (string.IsNullOrEmpty(entity.SupervisorFullName)) { commandWrapper.Parameters.Add(new SqlParameter("@supervisorFullName", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@supervisorFullName", entity.SupervisorFullName)); } if (string.IsNullOrEmpty(entity.SupervisorOrgTitle)) { commandWrapper.Parameters.Add(new SqlParameter("@supervisorOrgTitle", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@supervisorOrgTitle", entity.SupervisorOrgTitle)); } if (!entity.SupervisorSignDate.HasValue) { commandWrapper.Parameters.Add(new SqlParameter("@supervisorSignDate", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@supervisorSignDate", entity.SupervisorSignDate)); } if (entity.HRPersonnelID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelID", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelID", entity.HRPersonnelID)); } if (string.IsNullOrEmpty(entity.HRPersonnelFullName)) { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelFullName", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelFullName", entity.HRPersonnelFullName)); } if (string.IsNullOrEmpty(entity.HRPersonnelOrgTitle)) { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelOrgTitle", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelOrgTitle", entity.HRPersonnelOrgTitle)); } if (!entity.HRPersonnelSignDate.HasValue) { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelSignDate", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@hRPersonnelSignDate", entity.HRPersonnelSignDate)); } if (entity.JNPID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@jNPID", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@jNPID", entity.JNPID)); } if (entity.JAID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@jAID", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@jAID", entity.JAID)); } if (entity.CRID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@cRID", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@cRID", entity.CRID)); } if (entity.JQID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@jQID", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@jQID", entity.JQID)); } commandWrapper.Parameters.Add(new SqlParameter("@signatureTypeID", (int)signaturetypeID)); if (currentTransaction != null) { DatabaseUtility.ExecuteNonQuery(currentTransaction, commandWrapper); } else { ExecuteNonQuery(commandWrapper); } } catch (Exception ex) { currentTransaction.Rollback(); HandleException(ex); } } }
public void Update(JNPApproval entity, SignatureType signaturetypeID) { Update(entity, null, signaturetypeID); }
public long Add(JNPApproval entity, SignatureType signaturetypeID) { return(Add(entity, null, signaturetypeID)); }