public string Get_BelowAverageEvaluationDetails(int CrewID, int EvaluationId)
{
return(UDFLib.CreateHtmlTableFromDataTable(DAL_Crew_Evaluation.Get_BelowAverageEvaluation_Details_DL(CrewID, EvaluationId),
new string[] { "Question", "Answer", "Remarks" },
new string[] { "Criteria", "OptionText", "Remarks" },
new string[] { },
"CrewQuery-Followup-table",
"CrewQuery-Followup-DataHeder",
"CrewQuery-Followup-Data"));
}
public static int Add_Criteria_ToEvaluation(int Criteria_ID, int Evaluation_ID, int Created_By)
{
try
{
return(DAL_Crew_Evaluation.Add_Criteria_ToEvaluation_DL(Criteria_ID, Evaluation_ID, Created_By));
}
catch
{
throw;
}
}
public static int DELETE_Grading(int ID, int Deleted_By)
{
try
{
return(DAL_Crew_Evaluation.DELETE_Grading_DL(ID, Deleted_By));
}
catch
{
throw;
}
}
public static DataTable Get_EvaluatedCrewDetails(int Schedule_ID)
{
try
{
return(DAL_Crew_Evaluation.Get_EvaluatedCrewDetails(Schedule_ID));
}
catch
{
throw;
}
}
public static DataTable Get_MandatoryGrades(int Evaluation_ID, int Criteria_ID)
{
try
{
return(DAL_Crew_Evaluation.Get_MandatoryGrades_DL(Evaluation_ID, Criteria_ID));
}
catch
{
throw;
}
}
public static DataTable Get_Assigned_EvaluatorRank_ForCrew(int CrewID)
{
try
{
return(DAL_Crew_Evaluation.Get_Assigned_EvaluatorRank_ForCrew_DL(CrewID));
}
catch
{
throw;
}
}
public static DataTable Get_FeedbackCategories()
{
try
{
return(DAL_Crew_Evaluation.Get_FeedbackCategories_DL());
}
catch
{
throw;
}
}
public static int INS_CrewEvaluationFeedback(int?ID, int Crew_ID, string Remarks, int Created_By, string Evaluation_ID, string Month, string Schedule_ID, int?Dtl_Evaluation_ID, int?Vessel_ID, int?Office_ID, int FeedbackCategory_ID)
{
try
{
return(DAL_Crew_Evaluation.INS_CrewEvaluationFeedback_DL(ID, Crew_ID, Remarks, Created_By, Evaluation_ID, Month, Schedule_ID, Dtl_Evaluation_ID, Vessel_ID, Office_ID, FeedbackCategory_ID));
}
catch
{
throw;
}
}
//public static int INSERT_Crew_Evaluation_Answer(int CrewEvaluation_ID, int Criteria_ID, int UserAnswer, string Remarks, int Created_By)
//{
// try
// {
// return DAL_Crew_Evaluation.INSERT_Crew_Evaluation_Answer_DL(CrewEvaluation_ID, Criteria_ID, UserAnswer, Remarks, Created_By);
// }
// catch
// {
// throw;
// }
//}
public static int INSERT_Crew_Evaluation_Answer(int CrewEvaluation_ID, int Criteria_ID, int UserAnswer, string TextAnswer, string Remarks, int Created_By)
{
try
{
return(DAL_Crew_Evaluation.INSERT_Crew_Evaluation_Answer_DL(CrewEvaluation_ID, Criteria_ID, UserAnswer, TextAnswer, Remarks, Created_By));
}
catch
{
throw;
}
}
public static int INSERT_Crew_Evaluation_Answer(int CrewEvaluation_ID, DataTable dt, int Created_By)
{
try
{
return(DAL_Crew_Evaluation.INSERT_Crew_Evaluation_Answer_DL(CrewEvaluation_ID, dt, Created_By));
}
catch
{
throw;
}
}
public static void Swap_Criteria_Sort_Order(int Evaluation_ID, int Criteria_ID, int UpDown)
{
try
{
DAL_Crew_Evaluation.Swap_Criteria_Sort_Order_DL(Evaluation_ID, Criteria_ID, UpDown);
}
catch
{
throw;
}
}
public static DataTable Get_CrewEvaluationResults(int CrewID, int Year)
{
try
{
return(DAL_Crew_Evaluation.Get_CrewEvaluationResults_DL(CrewID, Year));
}
catch
{
throw;
}
}
public static DataTable Get_EvaluationScheduleByVessel(int Vessel_ID, int StartMonth, int Eva_Type, string SearchText)
{
try
{
return(DAL_Crew_Evaluation.Get_EvaluationScheduleByVessel_DL(Vessel_ID, StartMonth, Eva_Type, SearchText));
}
catch
{
throw;
}
}
public static DataTable Get_Crew_EvaluationSchedule(int CrewID)
{
try
{
return(DAL_Crew_Evaluation.Get_Crew_EvaluationSchedule_DL(CrewID));
}
catch
{
throw;
}
}
public static int Remove_Criteria_FromEvaluation(int CriteriaID, int Evaluation_ID, int Deleted_By)
{
try
{
return(DAL_Crew_Evaluation.Remove_Criteria_FromEvaluation_DL(CriteriaID, Evaluation_ID, Deleted_By));
}
catch
{
throw;
}
}
public static DataTable Get_CrewEvaluationFeedbackRequest_Details(int ID, int Vessel_ID, int Office_ID)
{
try
{
return(DAL_Crew_Evaluation.Get_CrewEvaluationFeedbackRequest_Details_DL(ID, Vessel_ID, Office_ID));
}
catch
{
throw;
}
}
public static int INS_CrewEvaluationFeedbackRequest_Details(int ID, int Vessel_ID, int Office_ID, int Created_By, int Requested_From, DateTime?DueDate, string Evaluation_ID, string Month, string Schedule_ID, int Crew_ID, string Req_Comment, int?FeedbackCategory_ID)
{
try
{
return(DAL_Crew_Evaluation.INS_CrewEvaluationFeedbackRequest_Details_DL(ID, Vessel_ID, Office_ID, Created_By, Requested_From, DueDate, Evaluation_ID, Month, Schedule_ID, Crew_ID, Req_Comment, FeedbackCategory_ID));
}
catch
{
throw;
}
}
public static DataTable Get_CrewEvaluation_Details(int CrewID, int CrewDtl_Evaluation_ID)
{
try
{
return(DAL_Crew_Evaluation.Get_CrewEvaluation_Details_DL(CrewID, CrewDtl_Evaluation_ID));
}
catch
{
throw;
}
}
public static DataTable Get_FeedbackCompleted(int CrewEvaluation_ID, int Vessel_ID, int Office_ID)
{
try
{
return(DAL_Crew_Evaluation.Get_FeedbackCompleted_DL(CrewEvaluation_ID, Vessel_ID, Office_ID));
}
catch
{
throw;
}
}
public static int UPDATE_EvaluationRules(int Evaluation_ID, int RankID, int RuleID, int Active_Status, int Created_By)
{
try
{
return(DAL_Crew_Evaluation.UPDATE_EvaluationRules_DL(Evaluation_ID, RankID, RuleID, Active_Status, Created_By));
}
catch
{
throw;
}
}
public static int INSERT_Grading(string Grading_Name, int Grade_Type, int Min, int Max, int Divisions, int Created_By)
{
try
{
return(DAL_Crew_Evaluation.INSERT_Grading_DL(Grading_Name, Grade_Type, Min, Max, Divisions, Created_By));
}
catch
{
throw;
}
}
public static int DELETE_EvaluationRules(int Evaluation_ID, int RankID, int Deleted_By)
{
try
{
return(DAL_Crew_Evaluation.DELETE_EvaluationRules_DL(Evaluation_ID, RankID, Deleted_By));
}
catch
{
throw;
}
}
public static int Add_MandatoryGrades_ToEvaluation(int Criteria_ID, int Evaluation_ID, int Created_By, DataTable dtOptionValue)
{
try
{
return(DAL_Crew_Evaluation.Add_MandatoryGrades_ToEvaluation_DL(Criteria_ID, Evaluation_ID, Created_By, dtOptionValue));
}
catch
{
throw;
}
}
public static DataTable Get_GradingList()
{
try
{
return(DAL_Crew_Evaluation.Get_GradingList_DL());
}
catch
{
throw;
}
}
public static DataTable Get_MandatoryRemark(int ID, int Evaluation_ID, int Criteria_ID)
{
try
{
return(DAL_Crew_Evaluation.Get_MandatoryRemark_DL(ID, Evaluation_ID, Criteria_ID));
}
catch
{
throw;
}
}
public static DataTable Get_EvaluationRules(int Evaluation_ID, int RankID)
{
try
{
return(DAL_Crew_Evaluation.Get_EvaluationRules_DL(Evaluation_ID, RankID));
}
catch
{
throw;
}
}
public static int UPDATE_Grading(int ID, string Grading_Name, int Grading_Type, int Min, int Max, int Divisions, int Updated_By)
{
try
{
return(DAL_Crew_Evaluation.UPDATE_Grading_DL(ID, Grading_Name, Grading_Type, Min, Max, Divisions, Updated_By));
}
catch
{
throw;
}
}
public static DataTable Get_EvaluationUnSelectedRanks(int Evaluation_ID, int UserID)
{
try
{
return(DAL_Crew_Evaluation.Get_EvaluationUnSelectedRanks_DL(Evaluation_ID, UserID));
}
catch
{
throw;
}
}
public static int Get_CrewEvaluation_FeedbackCount(int?UserID, int Dtl_Evaluation_ID, int Office_ID, int Vessel_ID)
{
try
{
return(DAL_Crew_Evaluation.Get_CrewEvaluation_FeedbackCount_DL(UserID, Dtl_Evaluation_ID, Office_ID, Vessel_ID));
}
catch
{
throw;
}
}
public static DataTable Get_UnAssigned_CriteriaList(int Evaluation_ID, string SearchText, int CategoryID)
{
try
{
return(DAL_Crew_Evaluation.Get_UnAssigned_CriteriaList_DL(Evaluation_ID, SearchText, CategoryID));
}
catch
{
throw;
}
}
