public static DataTable Get_AllCrewFeeStatus(int FleetCode, int VesselID, int ManningOfficeID, int Rank_Category, int UserID, int Crew_Status, int Fee_Type, int Approved_YesNo, string Sign_On_From, string Sign_On_To, string Approved_From, string Approved_To, int?PAGE_SIZE, int?PAGE_INDEX, ref int SelectRecordCount, ref decimal GrandTotal, int Month, int Year, string SearchText)
{
try
{
DateTime dtSign_On_From = DateTime.Parse("1900/01/01");
if (Sign_On_From != "")
{
dtSign_On_From = DateTime.Parse(Sign_On_From, iFormatProvider);
}
DateTime dtSign_On_To = DateTime.Parse("2900/01/01");
if (Sign_On_To != "")
{
dtSign_On_To = DateTime.Parse(Sign_On_To, iFormatProvider);
}
DateTime dtApproved_From = DateTime.Parse("1900/01/01");
if (Approved_From != "")
{
dtApproved_From = DateTime.Parse(Approved_From, iFormatProvider);
}
DateTime dtApproved_To = DateTime.Parse("2900/01/01");
if (Approved_To != "")
{
dtApproved_To = DateTime.Parse(Approved_To, iFormatProvider);
}
return(DAL_Crew_Disbursement.Get_AllCrewFeeStatus_DL(FleetCode, VesselID, ManningOfficeID, Rank_Category, UserID, Crew_Status, Fee_Type, Approved_YesNo, dtSign_On_From, dtSign_On_To, dtApproved_From, dtApproved_To, PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, ref GrandTotal, Month, Year, SearchText));
}
catch
{
throw;
}
}
public static DataTable Get_MODisbursementFeeDetails(int ID, int UserID)
{
try
{
return(DAL_Crew_Disbursement.Get_MODisbursementFeeDetails_DL(ID, UserID));
}
catch
{
throw;
}
}
public static DataSet Get_MOProcessingFee(int UserID)
{
try
{
return(DAL_Crew_Disbursement.Get_MOProcessingFee_DL(UserID));
}
catch
{
throw;
}
}
public static DataTable Get_MODisbursementFeeTypes()
{
try
{
return(DAL_Crew_Disbursement.Get_MODisbursementFeeTypes_DL());
}
catch
{
throw;
}
}
public static DataTable Get_MODisbursementFee(int ManningOfficeID, int FeeType)
{
try
{
return(DAL_Crew_Disbursement.Get_MODisbursementFee_DL(ManningOfficeID, FeeType));
}
catch
{
throw;
}
}
public static DataTable Get_VesselList_CrewFee(int UserID, int FleetCode)
{
try
{
return(DAL_Crew_Disbursement.Get_VesselList_CrewFee_DL(UserID, FleetCode));
}
catch
{
throw;
}
}
public static int UPDATE_ApprovedStatus(int ID, int CrewID, int Approved_YesNo, string Approved_Date, int Approved_By, string Remarks)
{
try
{
DateTime dtApproved_Date = DateTime.Now;
if (Approved_Date != "")
{
dtApproved_Date = DateTime.Parse(Approved_Date, iFormatProvider);
}
return(DAL_Crew_Disbursement.UPDATE_ApprovedStatus_DL(ID, CrewID, Approved_YesNo, dtApproved_Date, Approved_By, Remarks));
}
catch
{
throw;
}
}
public static int AddNew_ProcessingFee(int CrewID, int Vessel_ID, int VoyageID, int ManningOfficeID, int FeeType, decimal Amount, string Due_Date, int Created_By, string Remarks)
{
try
{
DateTime Dt_Due_Date = DateTime.Parse("1900/01/01");
if (Due_Date != "")
{
Dt_Due_Date = DateTime.Parse(Due_Date, iFormatProvider);
}
return(DAL_Crew_Disbursement.AddNew_ProcessingFee_DL(CrewID, Vessel_ID, VoyageID, ManningOfficeID, FeeType, Amount, Dt_Due_Date, Created_By, Remarks));
}
catch
{
throw;
}
}
public static int UPDATE_MODisbursementFee_DL(DataTable dt, int FeeType, int Created_By)
{
int sts = 0;
try
{
DateTime Dt_EffectiveDate = DateTime.Parse("1900/01/01");
//if (DateTime.TryParse(EffectiveDate, out Dt_EffectiveDate) && Dt_EffectiveDate != DateTime.Parse("1900/01/01"))
//{
sts = DAL_Crew_Disbursement.UPDATE_MODisbursementFee_DL(dt, FeeType, Created_By);
// }
return(sts);
}
catch
{
throw;
}
}
public static int UPDATE_MODisbursementFee_DL(int ManningOfficeID, int FeeType, decimal Amount, int ID, string EffectiveDate, int Created_By, int Rank_Category)
{
int sts = 0;
try
{
DateTime Dt_EffectiveDate = DateTime.Parse("1900/01/01");
if (DateTime.TryParse(EffectiveDate, out Dt_EffectiveDate) && Dt_EffectiveDate != DateTime.Parse("1900/01/01"))
{
sts = DAL_Crew_Disbursement.UPDATE_MODisbursementFee_DL(ManningOfficeID, FeeType, Amount, ID, Dt_EffectiveDate, Created_By, Rank_Category);
}
return(sts);
}
catch
{
throw;
}
}