// Program List/Scheduled
public static DataTable GetFleetList(int UserCompanyID, int VesselManager)
{
try
{
return(DAL_LMS_Training.GetFleetList(UserCompanyID, VesselManager));
}
catch
{
throw;
}
}
public static DataTable Get_VesselList(int Program_Id, int FleetID, int VesselID, int VesselManager, string SearchText, int UserCompanyID)
{
try
{
return(DAL_LMS_Training.Get_VesselList(Program_Id, FleetID, VesselID, VesselManager, SearchText, UserCompanyID, -1));
}
catch
{
throw;
}
}
public static DataTable GET_Program_List_Schedule()
{
try
{
return(DAL_LMS_Training.GET_Program_List_Schedule());
}
catch
{
throw;
}
}
public static string GET_VideoFileName(int?Id)
{
return(DAL_LMS_Training.GET_VideoFileName(Id));
}
public static DataSet GET_FileList_To_Sync(DataTable TBL_DATA)
{
return(DAL_LMS_Training.GET_FileList_To_Sync(TBL_DATA));
}
public static DataSet Get_Video_Program_List(string Search)
{
return(DAL_LMS_Training.Get_Video_Program_List(Search));
}
public static int Check_Duplicate_CHAPTER(string CHAPTER_DESCRIPTION, int Program_Id, int?ChapterID = null)
{
return(DAL_LMS_Training.Check_Duplicate_CHAPTER(CHAPTER_DESCRIPTION, Program_Id, ChapterID));
}
public static DataTable Ins_Chapter_Details(int?Program_Id, string Program_Description, ref int?Chapter_Id, string Chapter_Name, DataTable ChapterItemId, DataTable ChapterTrainerId, int?CREATED_BY, int?ACTIVE_STATUS)
{
return(DAL_LMS_Training.Ins_Chapter_Details(Program_Id, Program_Description, ref Chapter_Id, Chapter_Name, ChapterItemId, ChapterTrainerId, CREATED_BY, ACTIVE_STATUS));
}
public static DataTable Get_Program_Category()
{
return(DAL_LMS_Training.Get_Program_Category());
}
// Chapter Details
public static DataSet Get_ChapterDetails_List(int?Chapter_Id, string SearchItemName, string ITEM_TYPE, int?Page_Index, int?Page_Size, ref int is_Fetch_Count)
{
return(DAL_LMS_Training.Get_ChapterDetails_List(Chapter_Id, SearchItemName, ITEM_TYPE, Page_Index, Page_Size, ref is_Fetch_Count));
}
public static DataTable Get_Training_Calendar(string JobType, DateTime?StartDate, DateTime?EndDate, int UserID)
{
return(DAL_LMS_Training.Get_Training_Calendar(JobType, StartDate, EndDate, UserID));
}
public static DataTable GET_DRILL_SCHEDULE(int?Vessel_ID)
{
return(DAL_LMS_Training.GET_DRILL_SCHEDULE(Vessel_ID));
}
public static void Del_TrainingProgram_Chk(int PROGRAM_ID, ref int Row_Num)
{
DAL_LMS_Training.Del_TrainingProgram_Chk(PROGRAM_ID, ref Row_Num);
}
public static DataTable GET_Programs_To_Sync_Date_List()
{
return(DAL_LMS_Training.GET_Programs_To_Sync_Date_List());
}
public static DataTable Get_Training_Items_List(string SearchItemName, int?Page_Index, int?Page_Size, ref int is_Fetch_Count, int UserID)
{
return(DAL_LMS_Training.Get_Training_Items_List(SearchItemName, Page_Index, Page_Size, ref is_Fetch_Count, UserID));
}
public static int Del_Training_Items(Int32 ID, int Deleted_By)
{
return(DAL_LMS_Training.Del_Training_Items(ID, Deleted_By));
}
public static void Update_Traing_ITem(int?ID, string SearchUrl)
{
DAL_LMS_Training.Update_Traing_ITem(ID, SearchUrl);
}
public static string Validate_SeaStaff(int UserID)
{
return(DAL_LMS_Training.Validate_SeaStaff(UserID));
}
public static int Check_Duplicate_AttachmentFile(string AttachmentFile, string ITEM_NAME, ref string ITEM_PATH, ref int IsItemExist)
{
return(DAL_LMS_Training.Check_Duplicate_AttachmentFile(AttachmentFile, ITEM_NAME, ref ITEM_PATH, ref IsItemExist));
}
public static DataSet GET_YEARLY_DRILL_REPORT(int Month, int Year, int?Vessel_ID)
{
return(DAL_LMS_Training.GET_YEARLY_DRILL_REPORT(Month, Year, Vessel_ID));
}
public static DataSet GET_Chapter_Trainer(int?Chapter_Id)
{
return(DAL_LMS_Training.GET_Chapter_Trainer(Chapter_Id));
}
public static void Update_Program_Details(int?Program_Id, string Frequency_Type, DateTime?EffectiveStartDate, DateTime?EffectiveEndDate, int?UserId)
{
DAL_LMS_Training.Update_Program_Details(Program_Id, Frequency_Type, EffectiveStartDate, EffectiveEndDate, UserId);
}
public static int Check_Chapter_Item(int?Program_Id, int?Chapter_Id, DataTable ChapterItemId)
{
return(DAL_LMS_Training.Check_Chapter_Item(Program_Id, Chapter_Id, ChapterItemId));
}
public static DataTable GET_VESSEL_VIDEOS(int?Id)
{
return(DAL_LMS_Training.GET_VESSEL_VIDEOS(Id));
}
public static int Del_TRAINING_CHAPTER(Int32 ChapterId, int Deleted_By)
{
return(DAL_LMS_Training.Del_TRAINING_CHAPTER(ChapterId, Deleted_By));
}
public static DataTable INSUPD_VESSEL_VIDEOS(int ID, int Type, string Name, string OriginalFileName, string FileName, int ParentId, int UserId)
{
return(DAL_LMS_Training.INSUPD_VESSEL_VIDEOS(ID, Type, Name, OriginalFileName, FileName, ParentId, UserId));
}
public static int Check_Duplicate_CHAPTER_ITEM(int Item_Id, int Program_Id)
{
return(DAL_LMS_Training.Check_Duplicate_CHAPTER_ITEM(Item_Id, Program_Id));
}
public static DataTable Get_MIMEType()
{
return(DAL_LMS_Training.Get_MIMEType());
}
public static DataTable DEL_VESSEL_VIDEOS(int?ID, int UserId)
{
return(DAL_LMS_Training.DEL_VESSEL_VIDEOS(ID, UserId));
}
public static int Ins_Training_Items(string ITEM_NAME, string ITEM_Description, string ITEM_TYPE, string DURATION, string ITEM_PATH, string Attachment_Name, int CREATED_BY, int ACTIVE_STATUS, ref int ItemId, string Menu_Link)
{
return(DAL_LMS_Training.Ins_Training_Items(ITEM_NAME, ITEM_Description, ITEM_TYPE, DURATION, ITEM_PATH, Attachment_Name, CREATED_BY, ACTIVE_STATUS, ref ItemId, Menu_Link));
}
