public static JNPWorkflowStatus GetCurrentJNPWorkflowStatus(long jnpID)
{
JNPWorkflowStatus item = null;
try
{
DataTable dataTable = ExecuteDataTable("spr_GetJNPWorkflowStatusByJNPID", jnpID);
if (dataTable.Rows.Count == 1)
{
DataRow dataRow = dataTable.Rows[0];
if (dataRow != null)
{
item = new JNPWorkflowStatus(dataRow);
}
}
}
catch (Exception ex)
{
item = null;
ExceptionBase.HandleException(ex);
}
return(item);
}
//public static JobAnnouncementPackage GetByID(int userID, long JNPID)
//{
// JobAnnouncementPackage item = null;
// try
// {
// //TODO: this stored procedure returns rows more sutable for Business.TrackerItem.
// //think about modifying this SP eliminating some fields and @userID and creating a separate
// //stored procedure for retrieving a separate Business.TrackerItem. (better - rename this SP
// //to spr_GetTrackerItemByID and create a new spr_GetJNPByID
// DataTable dataTable = ExecuteDataTable("spr_GetJNPByID", userID, JNPID);
// if (dataTable.Rows.Count == 1)
// {
// DataRow dataRow = dataTable.Rows[0];
// if (dataRow != null)
// {
// item = new JobAnnouncementPackage(dataRow);
// }
// }
// }
// catch (Exception ex)
// {
// item = null;
// ExceptionBase.HandleException(ex);
// }
// return item;
//}
public static JobAnnouncementPackage GetByID(long JNPID)
{
JobAnnouncementPackage item = null;
try
{
DataTable dataTable = ExecuteDataTable("spr_GetJNPByID", JNPID);
if (dataTable.Rows.Count == 1)
{
DataRow dataRow = dataTable.Rows[0];
if (dataRow != null)
{
item = new JobAnnouncementPackage(dataRow);
}
}
}
catch (Exception ex)
{
item = null;
ExceptionBase.HandleException(ex);
}
return(item);
}
protected void rgSearchResults_ItemClick(object sender, RadMenuEventArgs e)
{
RadMenu menu = (RadMenu)sender;
int OrganizatinChartID = int.Parse(menu.DataFieldID);
enumNavigationMode currentNavigationMode = enumNavigationMode.None;
if (OrganizatinChartID > 0)
{
try
{
switch (e.Item.Value)
{
case "View":
ResetCurrentOrgChart(OrganizatinChartID);
currentNavigationMode = enumNavigationMode.View;
GoToOrgChartLink("~/OrgChart/OrgChartDetails.aspx", currentNavigationMode);
break;
case "ViewPublished":
ResetCurrentOrgChartLog(OrganizatinChartID);
currentNavigationMode = enumNavigationMode.View;
GoToOrgChartLink("~/PubOrgChart/OrgChartDetails.aspx", currentNavigationMode);
break;
case "Edit":
ResetCurrentOrgChart(OrganizatinChartID);
OrganizationChartManager.Instance.Check(CurrentOrgChartID, CurrentUserID, enumActionType.CheckOut);
currentNavigationMode = enumNavigationMode.Edit;
GoToOrgChartLink("~/OrgChart/OrgChartDetails.aspx", currentNavigationMode);
break;
case "ContinueEdit":
ResetCurrentOrgChart(OrganizatinChartID);
currentNavigationMode = enumNavigationMode.Edit;
GoToOrgChartLink("~/OrgChart/OrgChartDetails.aspx", currentNavigationMode);
break;
case "FinishEdit":
ResetCurrentOrgChart(OrganizatinChartID);
FinishEditOrgChart(CurrentOrgChartID, CurrentUserID);
break;
case "Delete":
DeleteOrgChart(OrganizatinChartID);
break;
default:
break;
}
rgSearchResults.Rebind();
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
}
private static JQWorkflowStatus FillObjectFromDataRow(DataRow returnRow)
{
JQWorkflowStatus jqw = new JQWorkflowStatus();
try
{
jqw.JQWorkflowRecID = (long)returnRow["JQWorkflowRecID"];
jqw.JQID = (long)returnRow["JQID"];
jqw.JQWorkflowStatusID = (int)returnRow["JQWorkflowStatusID"];
if (returnRow["IsCurrent"] != DBNull.Value)
{
jqw.IsCurrent = (bool)returnRow["IsCurrent"];
}
if (returnRow["CreatedByID"] != DBNull.Value)
{
jqw.CreatedByID = (int)returnRow["CreatedByID"];
}
if (returnRow["CreateDate"] != DBNull.Value)
{
jqw.CreateDate = (DateTime)returnRow["CreateDate"];
}
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
jqw = null;
}
return(jqw);
}
public static List <JNPWorkflowNoteStatus> GetAll()
{
List <JNPWorkflowNoteStatus> list = new List <JNPWorkflowNoteStatus>();
try
{
DataTable dataTable = ExecuteDataTable("spr_GetAllJNPWorkflowNoteStatus");
if (dataTable.Rows.Count > 0)
{
foreach (DataRow dataRow in dataTable.Rows)
{
JNPWorkflowNoteStatus item = new JNPWorkflowNoteStatus();
item.FillObjectFromRowData(dataRow);
list.Add(item);
}
}
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
return(list);
}
private static CRWorkflowStatus FillObjectFromDataRow(DataRow dataRow)
{
CRWorkflowStatus crw = new CRWorkflowStatus();
try
{
crw.CRWorkflowRecID = (long)dataRow["CRWorkflowRecID"];
crw.CRID = (long)dataRow["CRID"];
crw.CRWorkflowStatusID = (int)dataRow["CRWorkflowStatusID"];
if (dataRow["IsCurrent"] != DBNull.Value)
{
crw.IsCurrent = (bool)dataRow["IsCurrent"];
}
if (dataRow["CreatedByID"] != DBNull.Value)
{
crw.CreatedByID = (int)dataRow["CreatedByID"];
}
if (dataRow["CreateDate"] != DBNull.Value)
{
crw.CreateDate = (DateTime)dataRow["CreateDate"];
}
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
crw = null;
}
return(crw);
}
private void SaveCategoryRatingGroups()
{
try
{
CategoryRatingGroup bestQuilifiedGroup = CategoryRatingGroupManager.GetBestQuilifiedGroup(CurrentCRID);
bestQuilifiedGroup.ScoringRangeGroupTypeName = rtbBQGroupTypeName.Text.Trim();
bestQuilifiedGroup.RangeMin = Int32.Parse(rtbBQRangeMin.Text);
bestQuilifiedGroup.RangeMax = Int32.Parse(rtbBQRangeMax.Text);
bestQuilifiedGroup.QualifyingStatements = rtbBQQualifyingStatements.Text.Trim();
CategoryRatingGroupManager.Update(bestQuilifiedGroup, base.CurrentUserID);
CategoryRatingGroup wellQuilifiedGroup = CategoryRatingGroupManager.GetWellQuilifiedGroup(CurrentCRID);
if (wellQuilifiedGroup != null)
{
wellQuilifiedGroup.ScoringRangeGroupTypeName = rtbWQGroupTypeName.Text.Trim();
wellQuilifiedGroup.RangeMin = Int32.Parse(rtbWQRangeMin.Text);
wellQuilifiedGroup.RangeMax = Int32.Parse(rtbWQRangeMax.Text);
wellQuilifiedGroup.QualifyingStatements = rtbWQQualifyingStatements.Text.Trim();
CategoryRatingGroupManager.Update(wellQuilifiedGroup, base.CurrentUserID);
}
CategoryRatingGroup quilifiedGroup = CategoryRatingGroupManager.GetQuilifiedGroup(CurrentCRID);
quilifiedGroup.ScoringRangeGroupTypeName = rtbQGroupTypeName.Text.Trim();
quilifiedGroup.RangeMin = Int32.Parse(rtbQRangeMin.Text);
quilifiedGroup.RangeMax = Int32.Parse(rtbQRangeMax.Text);
quilifiedGroup.QualifyingStatements = rtbQQualifyingStatements.Text.Trim();
CategoryRatingGroupManager.Update(quilifiedGroup, base.CurrentUserID);
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
public static TrackerItem GetForUser(int userID, long JNPID)
{
TrackerItem trackerItem = null;
try
{
DataTable dataTable = ExecuteDataTable("spr_GetTrackerItemByID", userID, JNPID);
if (dataTable.Rows.Count == 1)
{
DataRow dataRow = dataTable.Rows[0];
if (dataRow != null)
{
trackerItem = new TrackerItem(dataRow);
}
}
}
catch (Exception ex)
{
trackerItem = null;
ExceptionBase.HandleException(ex);
}
return(trackerItem);
}
public static JNPWorkflowNote GetByRecID(long jnpWorkflowRecID)
{
JNPWorkflowNote item = null;
try
{
DataTable dataTable = ExecuteDataTable("spr_GetJNPWorkflowNoteByRecID", jnpWorkflowRecID);
if (dataTable.Rows.Count == 1)
{
DataRow dataRow = dataTable.Rows[0];
if (dataRow != null)
{
item = new JNPWorkflowNote(dataRow);
}
}
}
catch (Exception ex)
{
item = null;
ExceptionBase.HandleException(ex);
}
return(item);
}
public SeriesGradeKSATaskStatement(DataRow singleRowData)
{
// Load Object by dataRow
try
{
this.FillObjectFromRowData(singleRowData);
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
private void BindData()
{
try
{
rtbFinalKSA.Text = CategoryRatingManager.GetFinalKSAS(CurrentJAID);
PopulateCategoryRatingGroups();
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
public static long CreateCategoryRatingFromJobAnalysis(long?JNPID, long JAID, bool IsStandardCR, int CreatedByID)
{
long crid = -1;
try
{
crid = (long)ExecuteScalar("spr_CreateCategoryRating", JNPID, JAID, IsStandardCR, CreatedByID);
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
return(crid);
}
public static int RestoreCategoryRating(long CRID, int currentUserID)
{
int retcode = -1;
try
{
retcode = (int)ExecuteScalar("spr_RestoreCategoryRating", CRID, currentUserID);
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
return(retcode);
}
public static enumDocumentType GetActiveDocumentType(long JNPID)
{
enumDocumentType activeDocumentType = enumDocumentType.Unknown;
try
{
activeDocumentType = (enumDocumentType)ExecuteScalar("spr_GetActiveDocumentType", JNPID);
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
return(activeDocumentType);
}
public DataTable GetDocumentStatusTable()
{
DataTable table = null;
try
{
table = ExecuteDataTable("spr_GetJNPRelatedDocumentsStatusByJNPID", this.JNPID);
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
return(table);
}
public static JNPWorkflowStatusCollection GetCollection(long jnpID)
{
JNPWorkflowStatusCollection collection = null;
try
{
DataTable dataTable = ExecuteDataTable("spr_GetJNPWorkflowStatuses", jnpID);
collection = GetCollection(dataTable);
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
return(collection);
}
public static CRWorkflowStatus GetByCRID(long CRID)
{
CRWorkflowStatus item = null;
try
{
DataTable dataTable = ExecuteDataTable("spr_GetCRWorkflowStatusByCRID", CRID);
item = loadData(dataTable);
}
catch (Exception ex)
{
item = null;
ExceptionBase.HandleException(ex);
}
return(item);
}
public static CategoryRatingGroup GetByID(long CategoryRatingGroupID)
{
CategoryRatingGroup item = null;
try
{
DataTable dataTable = ExecuteDataTable("spr_GetCategoryRatingGroupByID", CategoryRatingGroupID);
item = loadData(dataTable);
}
catch (Exception ex)
{
item = null;
ExceptionBase.HandleException(ex);
}
return(item);
}
private static CategoryRating FillObjectFromRowData(DataRow dataRow)
{
CategoryRating currentcr = new CategoryRating();
try
{
currentcr.CRID = (long)dataRow["CRID"];
currentcr.JAID = (long)dataRow["JAID"];
currentcr.PayPlanID = (int)dataRow["PayPlanID"];
currentcr.SeriesID = (int)dataRow["SeriesID"];
currentcr.LowestAdvertisedGrade = (int)dataRow["LowestAdvertisedGrade"];
currentcr.HighestAdvertisedGrade = (int)dataRow["HighestAdvertisedGrade"];
if (dataRow["IsStandardCR"] != DBNull.Value)
{
currentcr.IsStandardCR = (bool)dataRow["IsStandardCR"];
}
if (dataRow["CreatedByID"] != DBNull.Value)
{
currentcr.CreatedByID = (int)dataRow["CreatedByID"];
}
if (dataRow["CreateDate"] != DBNull.Value)
{
currentcr.CreateDate = (DateTime)dataRow["CreateDate"];
}
if (dataRow["UpdatedByID"] != DBNull.Value)
{
currentcr.UpdatedByID = (int)dataRow["UpdatedByID"];
}
if (dataRow["UpdateDate"] != DBNull.Value)
{
currentcr.UpdateDate = (DateTime)dataRow["UpdateDate"];
}
if (dataRow["IsActive"] != DBNull.Value)
{
currentcr.IsActive = (bool)dataRow["IsActive"];
}
}
catch (Exception ex)
{
currentcr = null;
ExceptionBase.HandleException(ex);
}
return(currentcr);
}
protected void btnConfirmDelete_OK_Click(object sender, EventArgs e)
{
rwConfirmBeforeDelete.VisibleOnPageLoad = false;
try
{
CategoryRatingManager.DeleteCategoryRating(CurrentCRID, CurrentUserID);
// MD 8/1: Stay on same page after delete
//string url = Page.ResolveUrl("~/Package/JNPTracker.aspx");
//GoToLink(url, CurrentNavMode);
ReloadCurrentJNP(CurrentJNPID);
base.GoToLink("~/JQ/FinalJQ.aspx", enumNavigationMode.Edit);
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
protected void btnWellQualified_Command(object sender, CommandEventArgs e)
{
try
{
if (e.CommandName == "Delete")
{
CategoryRatingGroup group = CategoryRatingGroupManager.GetWellQuilifiedGroup(CurrentCRID);
if (group != null)
{
CategoryRatingGroupManager.Delete(group, this.CurrentUserID);
wellQualified.Visible = false;
btnWellQualified.Text = "Add Well Qualified Section";
btnWellQualified.CommandName = "Add";
}
}
else if (e.CommandName == "Add")
{
long crGroupID = CategoryRatingGroupManager.AddCRGroupByScoringRangeGroupType(enumScoringRangeGroupType.WellQualified, CurrentCRID, CurrentUserID);
if (crGroupID > 0)
{
wellQualified.Visible = true;
CategoryRatingGroup wellQuilifiedGroup = CategoryRatingGroupManager.GetByID(crGroupID);
if (wellQuilifiedGroup != null)
{
rtbWQGroupTypeName.Text = wellQuilifiedGroup.ScoringRangeGroupTypeName;
rtbWQRangeMin.Text = wellQuilifiedGroup.RangeMin.ToString();
rtbWQRangeMax.Text = wellQuilifiedGroup.RangeMax.ToString();
rtbWQQualifyingStatements.Text = wellQuilifiedGroup.QualifyingStatements;
btnWellQualified.Text = "Remove Well Qualified Section";
btnWellQualified.CommandName = "Delete";
}
}
}
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
// disabled this method since is not being used anywhere in the system and it adds more overhead to this object
//public static long AddCategoryRating(CategoryRating currentcr)
//{
// long crid = -1;
// try
// {
// DbCommand commandWrapper = GetDbCommand("spr_CreateCategoryRating");
// SqlParameter returnParam = new SqlParameter("@newCRID", SqlDbType.BigInt);
// returnParam.Direction = ParameterDirection.Output;
// // get the new CRID of the record
// commandWrapper.Parameters.Add(returnParam);
// commandWrapper.Parameters.Add(new SqlParameter("@jAID", currentcr.JAID ));
// commandWrapper.Parameters.Add(new SqlParameter("@payPlanID", currentcr.PayPlanID));
// commandWrapper.Parameters.Add (new SqlParameter("@seriesID",currentcr.SeriesID ));
// commandWrapper.Parameters.Add (new SqlParameter("@LowestAdvertisedGrade",currentcr.LowestAdvertisedGrade ));
// commandWrapper.Parameters.Add (new SqlParameter("@HighestAdvertisedGrade",currentcr.HighestAdvertisedGrade ));
// commandWrapper.Parameters.Add (new SqlParameter("@isStandardCR",currentcr.IsStandardCR ));
// commandWrapper.Parameters.Add (new SqlParameter("@createdByID",currentcr.CreatedByID ));
// commandWrapper.Parameters.Add (new SqlParameter("@createDate",currentcr.CreateDate ));
// commandWrapper.Parameters.Add (new SqlParameter("@updatedByID",currentcr.UpdatedByID ));
// commandWrapper.Parameters.Add (new SqlParameter("@updateDate",currentcr.UpdateDate ));
// ExecuteNonQuery(commandWrapper);
// crid = (long)returnParam.Value;
// }
// catch (Exception ex)
// {
// HandleException(ex);
// }
// return crid;
//}
public static void UpdateCategoryRating(CategoryRating currentcr)
{
try
{
DbCommand commandWrapper = GetDbCommand("spr_UpdateCategoryRating");
commandWrapper.Parameters.Add(new SqlParameter("@cRID", currentcr.CRID));
commandWrapper.Parameters.Add(new SqlParameter("@jAID", currentcr.JAID));
commandWrapper.Parameters.Add(new SqlParameter("@payPlanID", currentcr.PayPlanID));
commandWrapper.Parameters.Add(new SqlParameter("@seriesID", currentcr.SeriesID));
commandWrapper.Parameters.Add(new SqlParameter("@LowestAdvertisedGrade", currentcr.LowestAdvertisedGrade));
commandWrapper.Parameters.Add(new SqlParameter("@HighestAdvertisedGrade", currentcr.HighestAdvertisedGrade));
commandWrapper.Parameters.Add(new SqlParameter("@isStandardCR", currentcr.IsStandardCR));
commandWrapper.Parameters.Add(new SqlParameter("@updatedByID", currentcr.UpdatedByID));
commandWrapper.Parameters.Add(new SqlParameter("@IsActive", currentcr.IsActive));
ExecuteNonQuery(commandWrapper);
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
private static CategoryRatingGroup FillObjectFromRowData(DataRow dataRow)
{
CategoryRatingGroup crgroup = new CategoryRatingGroup();
try
{
crgroup.CategoryRatingGroupID = (long)dataRow["CategoryRatingGroupID"];
crgroup.CRID = (long)dataRow["CRID"];
crgroup.ScoringRangeGroupTypeID = (int)dataRow["ScoringRangeGroupTypeID"];
crgroup.ScoringRangeGroupTypeName = (string)dataRow["ScoringRangeGroupTypeName"];
crgroup.RangeMin = (int)dataRow["RangeMin"];
crgroup.RangeMax = (int)dataRow["RangeMax"];
if (dataRow["QualifyingStatements"] != DBNull.Value)
{
crgroup.QualifyingStatements = (string)dataRow["QualifyingStatements"];
}
}
catch (Exception ex)
{
crgroup = null;
ExceptionBase.HandleException(ex);
}
return(crgroup);
}
private void FillObjectFromDataRow(DataRow dataRow)
{
try
{
DataColumnCollection columns = dataRow.Table.Columns;
JNPID = (long)dataRow["JNPID"];
JNPTypeID = (int)dataRow["JNPTypeID"];
JNPOptionTypeID = (int)dataRow["JNPOptionTypeID"];
if (dataRow["IsStandardJNP"] != DBNull.Value)
{
IsStandardJNP = (bool)dataRow["IsStandardJNP"];
}
if (dataRow["IsDEU"] != DBNull.Value)
{
IsStandardJNP = (bool)dataRow["IsDEU"];
}
PayPlanID = (int)dataRow["PayPlanID"];
SeriesID = (int)dataRow["SeriesID"];
if (dataRow["Grade"] != DBNull.Value)
{
Grade = (string)dataRow["Grade"];
}
if (dataRow["IsInterdisciplinary"] != DBNull.Value)
{
IsInterdisciplinary = (bool)dataRow["IsInterdisciplinary"];
}
if (dataRow["AdditionalSeriesID"] != DBNull.Value)
{
AdditionalSeriesID = (int)dataRow["AdditionalSeriesID"];
}
LowestAdvertisedGrade = (int)dataRow["LowestAdvertisedGrade"];
HighestAdvertisedGrade = (int)dataRow["HighestAdvertisedGrade"];
if (dataRow["RegionID"] != DBNull.Value)
{
RegionID = (int)dataRow["RegionID"];
}
dataRow["OrganizationCodeID"] = (int)dataRow["OrganizationCodeID"];
if (columns.Contains("OrganizationCode"))
{
if (dataRow ["OrganizationCode"] != DBNull.Value)
{
OrganizationCode = (string)dataRow["OrganizationCode"];
}
}
if (columns.Contains("OrganizationCodeName"))
{
if (dataRow["OrganizationName"] != DBNull.Value)
{
OrganizationName = (string)dataRow["OrganizationName"];
}
}
if (columns.Contains("OldOrganizationCode"))
{
if (dataRow["OldOrganizationCode"] != DBNull.Value)
{
OldOrganizationCode = dataRow["OldOrganizationCode"].ToString();
}
}
if (dataRow["JNPTitle"] != DBNull.Value)
{
JNPTitle = (string)dataRow["JNPTitle"];
}
if (dataRow["JNPTitleCombined"] != DBNull.Value)
{
JNPTitleCombined = (string)dataRow["JNPTitleCombined"];
}
if (dataRow["FullPDID"] != DBNull.Value)
{
FullPDID = (long)dataRow["FullPDID"];
}
if (dataRow["AdditionalPDID"] != DBNull.Value)
{
AdditionalPDID = (long)dataRow["AdditionalPDID"];
}
if (dataRow["JAID"] != DBNull.Value)
{
JAID = (long)dataRow["JAID"];
}
if (dataRow["CRID"] != DBNull.Value)
{
CRID = (long)dataRow["CRID"];
}
if (dataRow["JQID"] != DBNull.Value)
{
JQID = (long)dataRow["JQID"];
}
if (dataRow["CreatedByID"] != DBNull.Value)
{
CreatedByID = (int)dataRow["CreatedByID"];
}
if (dataRow["CreatedBy"] != DBNull.Value)
{
CreatedBy = (string)dataRow["CreatedBy"];
}
if (dataRow["CreateDate"] != DBNull.Value)
{
CreateDate = (DateTime)dataRow["CreateDate"];
}
//if (dataRow["CreateDateShort"] != DBNull.Value) CreateDateShort = (string)dataRow["CreateDateShort"];
if (dataRow["CreateDateShort"] != DBNull.Value)
{
CreateDateShort = Convert.ToDateTime(dataRow["CreateDateShort"]);
}
if (dataRow["UpdatedByID"] != DBNull.Value)
{
UpdatedByID = (int)dataRow["UpdatedByID"];
}
if (dataRow["UpdatedBy"] != DBNull.Value)
{
UpdatedBy = (string)dataRow["UpdatedBy"];
}
if (dataRow["UpdateDate"] != DBNull.Value)
{
UpdateDate = (DateTime)dataRow["UpdateDate"];
}
//if (dataRow["UpdateDateShort"] != DBNull.Value) UpdateDateShort = (string)dataRow["UpdateDateShort"];
if (dataRow["UpdateDateShort"] != DBNull.Value)
{
UpdateDateShort = Convert.ToDateTime(dataRow["UpdateDateShort"]);
}
if (dataRow["JNPWorkflowStatusID"] != DBNull.Value)
{
JNPWorkflowStatusID = (int)dataRow["JNPWorkflowStatusID"];
}
if (dataRow["JNPWorkflowStatus"] != DBNull.Value)
{
JNPWorkflowStatus = (string)dataRow["JNPWorkflowStatus"];
}
if (dataRow["JNPScheduleStatus"] != DBNull.Value)
{
JNPScheduleStatus = (enumScheduleStatus)dataRow["JNPScheduleStatus"];
}
if (dataRow["JNPNextScheduleStatus"] != DBNull.Value)
{
JNPNextScheduleStatus = (string)dataRow["JNPNextScheduleStatus"];
}
if (dataRow["CheckID"] != DBNull.Value)
{
CheckID = (long)dataRow["CheckID"];
}
if (dataRow["CheckedOutByID"] != DBNull.Value)
{
CheckedOutByID = (int)dataRow["CheckedOutByID"];
}
if (dataRow["CheckedOutDate"] != DBNull.Value)
{
CheckedOutDate = (DateTime)dataRow["CheckedOutDate"];
}
if (dataRow["CheckedOutBy"] != DBNull.Value)
{
CheckedOutBy = (string)dataRow["CheckedOutBy"];
}
CanViewJNP = (bool)dataRow["CanViewJNP"];
CanEditJNP = (bool)dataRow["CanEditJNP"];
CanContinueEditJNP = (bool)dataRow["CanContinueEditJNP"];
CanFinishEditJNP = (bool)dataRow["CanFinishEditJNP"];
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
protected void rmJNPAction_ItemClick(object sender, RadMenuEventArgs e)
{
RadMenu rmJNPAction = sender as RadMenu;
long JNPID = Convert.ToInt64(rmJNPAction.Attributes["JNPID"]);
enumNavigationMode currentNavigationMode = enumNavigationMode.None;
WorkflowObject wo = new WorkflowObject();
wo.StaffingObjectTypeID = enumStaffingObjectType.JNP;
wo.StaffingObjectID = JNPID;
wo.UserID = CurrentUserID;
base.CurrentJNPID = JNPID;
try
{
//bool navigateToActiveDocument = false;
switch (e.Item.Value)
{
case "View":
this.CurrentJNPID = JNPID;
//navigateToActiveDocument = true;
currentNavigationMode = enumNavigationMode.View;
GoToLink("~/JA/JAPositionInformation.aspx", currentNavigationMode);
break;
case "Edit":
wo.ActionTypeID = enumActionType.CheckOut;
WorkflowManager.CheckJNP(wo);
this.CurrentJNPID = JNPID;
//navigateToActiveDocument = true;
currentNavigationMode = enumNavigationMode.Edit;
GoToLink("~/JA/JAPositionInformation.aspx", currentNavigationMode);
break;
case "ContinueEdit":
this.CurrentJNPID = JNPID;
//navigateToActiveDocument = true;
currentNavigationMode = enumNavigationMode.Edit;
GoToLink("~/JA/JAPositionInformation.aspx", currentNavigationMode);
break;
case "FinishEdit":
wo.ActionTypeID = enumActionType.CheckIn;
WorkflowManager.CheckJNP(wo);
break;
case "UpdateHiringResult":
//GoToLink("~/Package/UpdateHiringResult.aspx");
//CurrentJNPID = JNPID;
//rmJNPAction.Attributes.Add("onClick", "javascript:ShowJNPUpdateHiringResultPopUp(" + JNPID.ToString() + "); return false;");
ShowUpdateHiringResultWindow(JNPID);
break;
case "CSN":
//GoToLink("~/Package/CopyJNPFromExisting.aspx?CopyJNPID=" + JNPID.ToString());
if (JNPID > 0)
{
//Fixed JA issue 906 -Classifier 14's My Tracker missing packages that Classifier creates by copying from existing pacakges.
//addjnpfrom existing jnp - newpackage.createdbyid is set based on current userid
JNPackage NewPackage = new JNPackage();
JNPackage existingPackage = new JNPackage(JNPID);
NewPackage.PayPlanID = existingPackage.PayPlanID;
NewPackage.RegionID = existingPackage.RegionID;
NewPackage.SeriesID = existingPackage.SeriesID;
NewPackage.OrganizationCodeID = existingPackage.OrganizationCodeID;
NewPackage.IsStandardJNP = existingPackage.IsStandardJNP;
NewPackage.JNPTitle = existingPackage.JNPTitle;
NewPackage.IsInterdisciplinary = existingPackage.IsInterdisciplinary;
NewPackage.AdditionalSeriesID = existingPackage.AdditionalSeriesID;
NewPackage.JNPTypeID = existingPackage.JNPTypeID;
NewPackage.LowestAdvertisedGrade = existingPackage.LowestAdvertisedGrade;
NewPackage.HighestAdvertisedGrade = existingPackage.HighestAdvertisedGrade;
NewPackage.FullPDID = existingPackage.FullPDID;
NewPackage.AdditionalPDID = existingPackage.AdditionalPDID;
NewPackage.DutyLocation = existingPackage.DutyLocation;
NewPackage.IsDEU = existingPackage.IsDEU;
NewPackage.IsMP = existingPackage.IsMP;
NewPackage.IsExceptedService = existingPackage.IsExceptedService;
NewPackage.CreatedByID = base.CurrentUserID;
NewPackage.JNPOptionTypeID = eJNPOptionType.CreateFromExisting;
NewPackage.CopyFromJNPID = JNPID;
NewPackage.AddBasedOnExistingJNP();
base.CurrentJNPID = NewPackage.JNPID;
base.CurrentJAID = NewPackage.JAID;
base.CurrentNavMode = enumNavigationMode.Edit;
ReloadCurrentJNP(NewPackage.JNPID);
GoToLink("~/JA/JAPositionInformation.aspx");
}
break;
default:
break;
}
rgSearchResults.Rebind();
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
protected void jnpTrackerGrid_ItemDataBound(object sender, GridItemEventArgs e)
{
try
{
HideRefreshButton(e);
if (e.Item is GridDataItem)
{
GridDataItem gridDataItem = e.Item as GridDataItem;
if (gridDataItem.ItemType == GridItemType.Item || gridDataItem.ItemType == GridItemType.AlternatingItem || gridDataItem.ItemType == GridItemType.SelectedItem)
{
TrackerItem trackerItem = e.Item.DataItem as TrackerItem;
string checkedoutdt = string.Empty;
string editedBy = string.Empty;
Image imgJNPCheckedOutStatus = gridDataItem.FindControl("imgJNPCheckedOutStatus") as Image;
Image scheduleStatusImage = gridDataItem.FindControl("imgScheduleStatus") as Image;
Label scheduleStatusLabel = gridDataItem.FindControl("lblScheduleStatus") as Label;
imgJNPCheckedOutStatus.Visible = false;
if (trackerItem.IsCheckedOut)
{
if (trackerItem.CheckedOutDate != null)
{
checkedoutdt = string.Format(trackerItem.CheckedOutDate.ToString(), "d");
editedBy = String.Format("Being edited by {0} since {1}", trackerItem.CheckedOutBy, checkedoutdt);
}
imgJNPCheckedOutStatus.Visible = true;
if (trackerItem.CheckedOutByID == CurrentUserID)
{
imgJNPCheckedOutStatus.ImageUrl = Page.ResolveUrl(String.Format("~/App_Themes/{0}/Images/Icons/icon_unlock.gif", Page.Theme));
}
else
{
imgJNPCheckedOutStatus.ImageUrl = Page.ResolveUrl(String.Format("~/App_Themes/{0}/Images/Icons/icon_lock.gif", Page.Theme));
imgJNPCheckedOutStatus.ToolTip = editedBy;
gridDataItem.ToolTip = editedBy;
}
}
RadMenu menuAction = gridDataItem.FindControl("jnpTrackerMenu") as RadMenu;
menuAction.Attributes["JNPID"] = trackerItem.JNPID.ToString();
RadMenuItem viewMenuItem = menuAction.FindItemByValue("View");
RadMenuItem editMenuItem = menuAction.FindItemByValue("Edit");
RadMenuItem continueMenuItem = menuAction.FindItemByValue("ContinueEdit");
RadMenuItem finishMenuItem = menuAction.FindItemByValue("FinishEdit");
viewMenuItem.Visible = trackerItem.CanViewJNP;
editMenuItem.Visible = trackerItem.CanEditJNP;
continueMenuItem.Visible = trackerItem.CanContinueEditJNP;
finishMenuItem.Visible = trackerItem.CanFinishEditJNP;
enumScheduleStatus scheduleStatus = trackerItem.JNPScheduleStatus;
scheduleStatusImage.ImageUrl = Page.ResolveUrl(ScheduleStatusIconURL(scheduleStatus));
string scaduleStatusName = EnumHelper <enumScheduleStatus> .GetEnumDescription(scheduleStatus.ToString());
scheduleStatusImage.ToolTip = scaduleStatusName;
scheduleStatusLabel.Text = scaduleStatusName;
}
}
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
protected void jnpTrackerMenu_ItemClick(object sender, RadMenuEventArgs e)
{
RadMenu menu = (RadMenu)sender;
long JNPID = long.Parse(menu.DataFieldID);
enumNavigationMode currentNavigationMode = enumNavigationMode.None;
WorkflowObject wo = new WorkflowObject();
wo.StaffingObjectTypeID = enumStaffingObjectType.JNP;
wo.StaffingObjectID = JNPID;
wo.UserID = CurrentUserID;
base.CurrentJNPID = JNPID;
try
{
//bool navigateToActiveDocument = false;
switch (e.Item.Value)
{
case "View":
CurrentJNPID = JNPID;
//navigateToActiveDocument = true;
currentNavigationMode = enumNavigationMode.View;
GoToLink("~/JA/JAPositionInformation.aspx", currentNavigationMode);
break;
case "Edit":
wo.ActionTypeID = enumActionType.CheckOut;
WorkflowManager.CheckJNP(wo);
CurrentJNPID = JNPID;
//navigateToActiveDocument = true;
currentNavigationMode = enumNavigationMode.Edit;
GoToLink("~/JA/JAPositionInformation.aspx", currentNavigationMode);
break;
case "ContinueEdit":
CurrentJNPID = JNPID;
//navigateToActiveDocument = true;
currentNavigationMode = enumNavigationMode.Edit;
GoToLink("~/JA/JAPositionInformation.aspx", currentNavigationMode);
break;
case "FinishEdit":
wo.ActionTypeID = enumActionType.CheckIn;
WorkflowManager.CheckJNP(wo);
break;
default:
break;
}
jnpTrackerGrid.Rebind();
//if (navigateToActiveDocument)
//{
// if (base.CurrentJNPWS == enumJNPWorkflowStatus.Draft)
// {
// enumDocumentType activeDocumentType = TrackerItem.GetActiveDocumentType(JNPID);
// switch (activeDocumentType)
// {
// // GoToLink method of UserControlBase provide screen mode as parameter
// case enumDocumentType.JNP:
// case enumDocumentType.JA:
// GoToLink("~/JA/JAPositionInformation.aspx", currentNavigationMode);
// break;
// case enumDocumentType.CR:
// GoToLink("~/CR/CategoryRating.aspx", currentNavigationMode);
// break;
// case enumDocumentType.JQ:
// if ((base.HasHRGroupPermission) || (base.IsAdmin))
// {
// GoToLink("~/JQ/Qualifications.aspx", currentNavigationMode);
// }
// else
// {
// GoToLink("~/JQ/JQKSA.aspx", currentNavigationMode);
// }
// break;
// default:
// throw new Exception(String.Format("Unexpected JNP Active Document Type: {0}", (int)activeDocumentType));
// }
// }
// else if (base.CurrentJNPWS == enumJNPWorkflowStatus.FinalReview)
// {
// GoToLink("~/JA/JAPositionInformation.aspx", currentNavigationMode);
// }
// // Issue # 77 - Modify CommonEnum.cs - Modify enumJNPWorkflowStatus as per the new workflow statuses
// //else if (base.CurrentJNPWS == enumJNPWorkflowStatus.Approval)
// //{
// // base.CurrentApprovalObjectType = enumStaffingObjectType.JNP;
// // GoToLink("~/Approval/Approval.aspx", currentNavigationMode);
// //}
//}
//else
//{
// e.Item.Selected = false;
// jnpTrackerGrid.Rebind();
//}
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
private void FillObjectFromDataRow(DataRow dataRow)
{
try
{
OrgChartSearchResult schR = new OrgChartSearchResult();
schR.OrganizationChartID = (int)dataRow["OrganizationChartID"];
schR.OrganizationChartTypeID = (int)dataRow["OrganizationChartTypeID"];
schR.OrganizationChartType = (string)dataRow["OrganizationChartType"];
schR.OrganizationCodeID = (int)dataRow["OrganizationCodeID"];
schR.OrganizationCode = (string)dataRow["OrganizationCode"];
schR.OrganizationName = (string)dataRow["OrganizationName"];
schR.RegionID = (int)dataRow["RegionID"];
schR.ReportingOrganizationCode = (string)dataRow["ReportingOrganizationCode"];
if (dataRow["OldOrganizationCode"] != DBNull.Value)
{
schR.OldOrganizationCode = (string)dataRow["OldOrganizationCode"];
}
if (dataRow["LevelID"] != DBNull.Value)
{
schR.LevelID = (int)dataRow["LevelID"];
}
if (dataRow["CreateDate"] != DBNull.Value)
{
schR.CreateDate = (DateTime)dataRow["CreateDate"];
}
if (dataRow["CreatedByID"] != DBNull.Value)
{
schR.CreatedByID = (int)dataRow["CreatedByID"];
}
if (dataRow["CreatedByName"] != DBNull.Value)
{
schR.CreatedByName = (string)dataRow["CreatedByName"];
}
if (dataRow["OrgWorkflowStatusID"] != DBNull.Value)
{
schR.OrgWorkflowStatusID = (int)dataRow["OrgWorkflowStatusID"];
}
if (dataRow["OrgWorkflowStatusCreateDate"] != DBNull.Value)
{
schR.OrgWorkflowStatusCreateDate = (DateTime)dataRow["OrgWorkflowStatusCreateDate"];
}
if (dataRow["OrgWorkflowStatus"] != DBNull.Value)
{
schR.OrgWorkflowStatus = (string)dataRow["OrgWorkflowStatus"];
}
if (dataRow["CheckedOutByDate"] != DBNull.Value)
{
schR.CheckedOutByDate = (DateTime)dataRow["CheckedOutByDate"];
}
if (dataRow["CheckedOutByID"] != DBNull.Value)
{
schR.CheckedOutByID = (int)dataRow["CheckedOutByID"];
}
if (dataRow["CheckedOutByName"] != DBNull.Value)
{
schR.CheckedOutByName = (string)dataRow["CheckedOutByName"];
}
if (dataRow["UpdatedByDate"] != DBNull.Value)
{
schR.UpdatedByDate = (DateTime)dataRow["UpdatedByDate"];
}
if (dataRow["UpdateByID"] != DBNull.Value)
{
schR.UpdateByID = (int)(dataRow["UpdateByID"]);
}
if (dataRow["UpdatedByName"] != DBNull.Value)
{
schR.UpdatedByName = (string)(dataRow["UpdatedByName"]);
}
if (dataRow["CanEdit"] != DBNull.Value)
{
schR.CanEdit = (bool)dataRow["CanEdit"];
}
if (dataRow["CanDelete"] != DBNull.Value)
{
schR.CanDelete = (bool)dataRow["CanDelete"];
}
schR.CheckedOutTypeID = schR.CheckedOutByID > 0 ?1:0;
if (dataRow["CanContinueEdit"] != DBNull.Value)
{
schR.CanContinueEdit = (bool)dataRow["CanContinueEdit"];
}
if (dataRow["CanFinishEdit"] != DBNull.Value)
{
schR.CanFinishEdit = (bool)dataRow["CanFinishEdit"];
}
if (dataRow["CanViewOnly"] != DBNull.Value)
{
schR.CanViewOnly = (bool)dataRow["CanViewOnly"];
}
if (dataRow["CheckedOut"] != DBNull.Value)
{
schR.CheckedOut = (bool)dataRow["CheckedOut"];
}
if (dataRow["ApprovedDate"] != DBNull.Value)
{
schR.ApprovedDate = (DateTime)dataRow["ApprovedDate"];
}
if (dataRow["ApprovedByID"] != DBNull.Value)
{
schR.ApprovedByID = (int)dataRow["ApprovedByID"];
}
if (dataRow["ApprovedByName"] != DBNull.Value)
{
schR.ApprovedByName = (string)dataRow["ApprovedByName"];
}
if (dataRow["ApprovedByTitle"] != DBNull.Value)
{
schR.ApprovedByTitle = (string)dataRow["ApprovedByTitle"];
}
ls.Add(schR);
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
private void FillObjectFromDataRow(DataRow dataRow)
{
try
{
JNPID = (long)dataRow["JNPID"];
JNPTypeID = (int)dataRow["JNPTypeID"];
JNPOptionTypeID = (int)dataRow["JNPOptionTypeID"];
if (dataRow["IsStandardJNP"] != DBNull.Value)
{
IsStandardJNP = (bool)dataRow["IsStandardJNP"];
}
if (dataRow["IsDEU"] != DBNull.Value)
{
IsDEU = (bool)dataRow["IsDEU"];
}
//if (dataRow["IsMP"] != DBNull.Value) IsMP = (bool)dataRow["IsMP"];
//if (dataRow["IsExceptedService"] != DBNull.Value) IsExceptedService = (bool)dataRow["IsExceptedService"];
PayPlanID = (int)dataRow["PayPlanID"];
SeriesID = (int)dataRow["SeriesID"];
if (dataRow["IsInterdisciplinary"] != DBNull.Value)
{
IsInterdisciplinary = (bool)dataRow["IsInterdisciplinary"];
}
if (dataRow["AdditionalSeriesID"] != DBNull.Value)
{
AdditionalSeriesID = (int)dataRow["AdditionalSeriesID"];
}
LowestAdvertisedGrade = (int)dataRow["LowestAdvertisedGrade"];
HighestAdvertisedGrade = (int)dataRow["HighestAdvertisedGrade"];
if (dataRow["RegionID"] != DBNull.Value)
{
RegionID = (int)dataRow["RegionID"];
}
OrganizationCode = (int)dataRow["OrganizationCode"];
if (dataRow["JNPTitle"] != DBNull.Value)
{
JNPTitle = (string)dataRow["JNPTitle"];
}
if (dataRow["FullPDID"] != DBNull.Value)
{
FullPDID = (long)dataRow["FullPDID"];
}
if (dataRow["AdditionalPDID"] != DBNull.Value)
{
AdditionalPDID = (long)dataRow["AdditionalPDID"];
}
if (dataRow["JAID"] != DBNull.Value)
{
JAID = (long)dataRow["JAID"];
}
if (dataRow["CRID"] != DBNull.Value)
{
CRID = (long)dataRow["CRID"];
}
if (dataRow["JQID"] != DBNull.Value)
{
JQID = (long)dataRow["JQID"];
}
if (dataRow["CreatedByID"] != DBNull.Value)
{
CreatedByID = (int)dataRow["CreatedByID"];
}
if (dataRow["CreateDate"] != DBNull.Value)
{
CreateDate = (DateTime)dataRow["CreateDate"];
}
if (dataRow["UpdatedByID"] != DBNull.Value)
{
UpdatedByID = (int)dataRow["UpdatedByID"];
}
if (dataRow["UpdateDate"] != DBNull.Value)
{
UpdateDate = (DateTime)dataRow["UpdateDate"];
}
//TODO: make sure that all stored procedures return these fields and then uncomment the lines
//if (dataRow["ResultedInSuccessfullHiring"] != DBNull.Value) ResultedInSuccessfullHiring = (bool)dataRow["ResultedInSuccessfullHiring"];
//if (dataRow["VacancyID"] != DBNull.Value) VacancyID = (long)dataRow["VacancyID"];
if (dataRow["JNPTitleCombined"] != DBNull.Value)
{
JNPTitleCombined = (string)dataRow["JNPTitleCombined"];
}
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}
protected void OrgChartTrackerGrid_ItemDataBound(object sender, GridItemEventArgs e)
{
try
{
HideRefreshButton(e);
if (e.Item is GridDataItem)
{
GridDataItem gridDataItem = e.Item as GridDataItem;
if (gridDataItem.ItemType == GridItemType.Item || gridDataItem.ItemType == GridItemType.AlternatingItem || gridDataItem.ItemType == GridItemType.SelectedItem)
{
OrgChartTrackerItem trackerItem = e.Item.DataItem as OrgChartTrackerItem;
string checkedoutdt = string.Empty;
string editedBy = string.Empty;
//Need to have new image for Org Chart
Image imgOrgChartCheckedOutStatus = gridDataItem.FindControl("imgOrgChartCheckedOutStatus") as Image;
imgOrgChartCheckedOutStatus.Visible = false;
if (trackerItem.CheckedOut)
{
if (trackerItem.CheckedOutBy.ActionDate != null)
{
DateTime?checkedoutbydate = trackerItem.CheckedOutBy.ActionDate;
checkedoutdt = string.Format("{0:MM/dd/yyyy}", checkedoutbydate);
editedBy = String.Format("Being edited by {0} since {1}", trackerItem.CheckedOutBy.FullNameReverse, checkedoutdt);
}
imgOrgChartCheckedOutStatus.Visible = true;
if (trackerItem.CheckedOutBy.UserID == CurrentUserID)
{
imgOrgChartCheckedOutStatus.ImageUrl = Page.ResolveUrl(String.Format("~/App_Themes/{0}/Images/Icons/icon_unlock.gif", Page.Theme));
}
else
{
imgOrgChartCheckedOutStatus.ImageUrl = Page.ResolveUrl(String.Format("~/App_Themes/{0}/Images/Icons/icon_lock.gif", Page.Theme));
}
gridDataItem.ToolTip = editedBy;
}
RadMenu menuAction = gridDataItem.FindControl("OrgChartTrackerMenu") as RadMenu;
menuAction.Attributes["OrganizationChartID"] = trackerItem.OrganizationChartID.ToString();
RadMenuItem viewMenuItem = menuAction.FindItemByValue("View");
RadMenuItem editMenuItem = menuAction.FindItemByValue("Edit");
RadMenuItem continueMenuItem = menuAction.FindItemByValue("ContinueEdit");
RadMenuItem finishMenuItem = menuAction.FindItemByValue("FinishEdit");
RadMenuItem deleteMenuItem = menuAction.FindItemByValue("Delete");
viewMenuItem.Visible = (!trackerItem.CanContinueEdit);
editMenuItem.Visible = trackerItem.CanEdit;
continueMenuItem.Visible = trackerItem.CanContinueEdit;
finishMenuItem.Visible = trackerItem.CanFinishEdit;
deleteMenuItem.Visible = trackerItem.CanDelete;
}
}
}
catch (Exception ex)
{
ExceptionBase.HandleException(ex);
}
}