public static DataTable Get_Wages_EntryType_Deduction()
{
try
{
return(DAL_PortageBill.Get_Wages_EntryType_Deduction_DL());
}
catch
{
throw;
}
}
public static DataTable Get_VesselType()
{
try
{
return(DAL_PortageBill.Get_VesselType_DL());
}
catch
{
throw;
}
}
public static DataTable Get_VesselSpecificWage(int VesselTypeID, int WageContractId, int SalaryCode)
{
try
{
return(DAL_PortageBill.Get_VesselSpecificWage_DL(VesselTypeID, WageContractId, SalaryCode));
}
catch
{
throw;
}
}
public static int Insert_NationalityGroup(int RankID, int NationalityGroupId, String NationalityGroupName, DataTable dt, int UserId)
{
try
{
return(DAL_PortageBill.Insert_NationalityGroup_DL(RankID, NationalityGroupId, NationalityGroupName, dt, UserId));
}
catch
{
throw;
}
}
public static int DeleteNationalityGroup(int NationalityGroupId, int UserId)
{
try
{
return(DAL_PortageBill.DeleteNationalityGroup_DL(NationalityGroupId, UserId));
}
catch
{
throw;
}
}
public static DataTable Get_RJBDetails(int ID)
{
try
{
return(DAL_PortageBill.Get_RJBDetails(ID));
}
catch
{
throw;
}
}
public static DataTable Get_NationalityGroupForWege_Contract(int RankID)
{
try
{
return(DAL_PortageBill.Get_NationalityGroupForWege_Contract_DL(RankID));
}
catch
{
throw;
}
}
public static DataSet Ins_CrewWages(DataTable dtWages, int WageContractId)
{
try
{
return(DAL_PortageBill.Ins_CrewWages(dtWages, WageContractId));
}
catch
{
throw;
}
}
public static DataTable Get_CompanySeniority_Rates(int RankID)
{
try
{
return(DAL_PortageBill.Get_CompanySeniority_Rates_DL(RankID));
}
catch
{
throw;
}
}
public static int Update_CrewSeniorityYear(int VoyID, int SeniorityYear, int UserID)
{
try
{
return(DAL_PortageBill.Update_CrewSeniorityYear_DL(VoyID, SeniorityYear, UserID));
}
catch
{
throw;
}
}
public static DataSet Get_Rank_WageContract(int RankID, int Contract_Type, int NationalityConsidered, int CountryId, int RankScaleId)
{
try
{
return(DAL_PortageBill.Get_Rank_WageContract_DL(RankID, Contract_Type, NationalityConsidered, CountryId, RankScaleId));
}
catch
{
throw;
}
}
public static DataTable Get_SeniorityRecords(int FleetID, int Vessel_ID, int Rank, string Month, string Year, string SearchText, int?CrewID, int PAGE_SIZE, int PAGE_INDEX, ref int SelectRecordCount, string sortbycoloumn, int?sortdirection)
{
try
{
return(DAL_PortageBill.Get_SeniorityRecords_DL(FleetID, Vessel_ID, Rank, Month, Year, SearchText, CrewID, PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, sortbycoloumn, sortdirection));
}
catch
{
throw;
}
}
public static int AutoPopulate_CrewWages(int VoyID, int UserID)
{
try
{
return(DAL_PortageBill.AutoPopulate_CrewWages_DL(VoyID, UserID));
}
catch
{
throw;
}
}
public static DataSet Ins_Rank_Wage_Contract(DataTable dtWages)
{
try
{
return(DAL_PortageBill.Ins_Rank_Wage_Contract_DL(dtWages));
}
catch
{
throw;
}
}
public static int Update_CrewRankSeniority(int CrewID, int RankId, int SeniorityYear, int SeniorityDays, int VoyageId, string Remarks, DateTime RankEffectiveDate, int UserID)
{
try
{
return(DAL_PortageBill.Update_CrewRankSeniority_DL(CrewID, RankId, SeniorityYear, SeniorityDays, VoyageId, Remarks, RankEffectiveDate, UserID));
}
catch
{
throw;
}
}
public static int Save_Company_Seniority_Rates(int RankID, int CompanySeniorityYear, decimal CompanySeniorityAmount, int UserID)
{
try
{
return(DAL_PortageBill.Save_Company_Seniority_Rates_DL(RankID, CompanySeniorityYear, CompanySeniorityAmount, UserID));
}
catch
{
throw;
}
}
public static DataTable GetRejoiningBonus(int CrewID)
{
try
{
return(DAL_PortageBill.GetRejoiningBonus(CrewID));
}
catch
{
throw;
}
}
public static int Update_Company_Seniority_Rates(DataTable dtRates, int RankID, int UserID)
{
try
{
return(DAL_PortageBill.Update_Company_Seniority_Rates_DL(dtRates, RankID, UserID));
}
catch
{
throw;
}
}
public static int CopyRankWageFromExistingCountry(int VesselFlag, int RankId, int CountryFromId, DateTime EffectiveDate, int Currency, int CompanyId, DataTable dtCountryToList, int CreatedBy)
{
try
{
return(DAL_PortageBill.CopyRankWageFromExistingCountry_DL(VesselFlag, RankId, CountryFromId, EffectiveDate, Currency, CompanyId, dtCountryToList, CreatedBy));
}
catch
{
throw;
}
}
public static DataTable Get_NationalityForWages(int RankID, int Contract_Type)
{
try
{
return(DAL_PortageBill.Get_NationalityForWages_DL(RankID, Contract_Type));
}
catch
{
throw;
}
}
public static DataTable Check_NationalityGroup(int RankID, int NationalityGroupId, String NationalityGroupName, DataTable dt)
{
try
{
return(DAL_PortageBill.Check_NationalityGroup_DL(RankID, NationalityGroupId, NationalityGroupName, dt));
}
catch
{
throw;
}
}
public static DataTable Get_CrewSeniorityRecords(int Rank, string Status, int CompanySeniorityYear, string searchText, int PAGE_SIZE, int PAGE_INDEX, ref int SelectRecordCount, string sortbycoloumn, int?sortdirection)
{
try
{
return(DAL_PortageBill.Get_CrewSeniorityRecords_DL(Rank, Status, CompanySeniorityYear, searchText, PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, sortbycoloumn, sortdirection));
}
catch
{
throw;
}
}
public static DataSet Get_RankWise_GroupDetails(int NationalityGroupId)
{
try
{
return(DAL_PortageBill.Get_RankWise_GroupDetails_DL(NationalityGroupId));
}
catch
{
throw;
}
}
public static int Update_CrewCompanySeniority(int CrewID, int SeniorityYear, int SeniorityDays, string Remarks, DateTime CompanyEffectiveDate, int UserID)
{
try
{
return(DAL_PortageBill.Update_CrewCompanySeniority_DL(CrewID, SeniorityYear, SeniorityDays, Remarks, CompanyEffectiveDate, UserID));
}
catch
{
throw;
}
}
public static DataTable Get_NationalityGroupbyGroupID(int NationalityGroupId)
{
try
{
return(DAL_PortageBill.Get_NationalityGroupbyGroupID_DL(NationalityGroupId));
}
catch
{
throw;
}
}
public static int GET_Crew_CompanySeniorityAmount(int CrewID, int RankId)
{
try
{
return(DAL_PortageBill.GET_Crew_CompanySeniorityAmount_DL(CrewID, RankId));
}
catch
{
throw;
}
}
public static DataTable Get_VesselList(int vesselTypeID)
{
try
{
return(DAL_PortageBill.Get_VesselList_DL(vesselTypeID));
}
catch
{
throw;
}
}
public static DataTable GET_Crew_RankSeniorityAmount(int CrewID, int RankId, int VoyID)
{
try
{
return(DAL_PortageBill.GET_Crew_RankSeniorityAmount_DL(CrewID, RankId, VoyID));
}
catch
{
throw;
}
}
public static int Ins_CrewChangeWageLog(int RankId, int RankScaleId, int CrewId, int UserID)
{
try
{
return(DAL_PortageBill.Ins_CrewChangeWageLog_DL(RankId, RankScaleId, CrewId, UserID));
}
catch
{
throw;
}
}
public static DataTable Get_Salary_Types()
{
try
{
return(DAL_PortageBill.Get_Salary_Types_DL());
}
catch
{
throw;
}
}
