public DataSet SaveVesselDetails(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parametes = new Object[48] {
objVesselDetails.RefNo, objVesselDetails.PolicyId, objVesselDetails.PolVersionId, objVesselDetails.VesselMultipleBilling,
objVesselDetails.VesselName, objVesselDetails.Built, objVesselDetails.VesselType, objVesselDetails.GRT,
objVesselDetails.NRT, objVesselDetails.BHP, objVesselDetails.Class,
objVesselDetails.Flag, objVesselDetails.Dimension, objVesselDetails.Owner, objVesselDetails.Managers,
objVesselDetails.Mortgagees, objVesselDetails.InceptionDate, objVesselDetails.ExpiryDate, objVesselDetails.UserID, objVesselDetails.GT, objVesselDetails.RegisteredLength, objVesselDetails.RegisteredBreadth, objVesselDetails.RegisteredDepth, objVesselDetails.NoOfCarry, objVesselDetails.RegisteredPlate, objVesselDetails.HMValue, objVesselDetails.IV,
objVesselDetails.DWT, objVesselDetails.IMONo, objVesselDetails.IVInsuredValue, objVesselDetails.AOIInsuredValue, objVesselDetails.AdditionalAssureds, objVesselDetails.GeneralAverage,
/*Below parameter Added for redmine 23517*/
objVesselDetails.Classification,
objVesselDetails.LengthOverall,
objVesselDetails.DesignDraft,
objVesselDetails.HullNo,
objVesselDetails.RegisteredOwner,
objVesselDetails.OtherInsuredParties,
objVesselDetails.Shipyard,
objVesselDetails.CallsignDistincitiveNo,
objVesselDetails.BollardPull,
objVesselDetails.CraneLiftingCapacity,
objVesselDetails.Clause12,
objVesselDetails.TradingPlyingLimit,
objVesselDetails.AMD,
objVesselDetails.ValueofVessels,
objVesselDetails.VesselStatus,
};
return(dataAccess.LoadDataSet(parametes, "P_Pol_Policy_VesselDetailsInsertUpdate", "PolicyVesselDetailsInsertUpdate"));
}
public DataSet GetVesselSectionDetails(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parametes = new Object[3] {
objVesselDetails.PolicyId, objVesselDetails.PolVersionId, objVesselDetails.RefNo
};
return(dataAccess.LoadDataSet(parametes, "P_Pol_LoadPolicyVessel_SectionDetails", "PolicyVesselSectionDetails"));
}
public DataSet GetBindRIVesselDetails(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parametes = new Object[3] {
objVesselDetails.TranRefNo, objVesselDetails.CoverNoteNo, objVesselDetails.VesselName
};
return(dataAccess.LoadDataSet(parametes, "RI_CN_Policy_VesselDetailsBind", "RIVesselDetailsBind"));
}
public DataSet DeleteRIVesselDetails(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parametes = new Object[3] {
objVesselDetails.TranRefNo, objVesselDetails.CoverNoteNo, objVesselDetails.RefNo
};
return(dataAccess.LoadDataSet(parametes, "RI_CN_Policy_VesselDetails_Delete", "RIVesselDetails"));
}
public DataSet GetBindVesselDetails(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parametes = new Object[3] {
objVesselDetails.PolicyId, objVesselDetails.PolVersionId, objVesselDetails.VesselName
};
return(dataAccess.LoadDataSet(parametes, "P_Pol_Policy_VesselDetailsBind", "PolicyVesselDetailsBind"));
}
public DataSet ResetVesselDetails(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parametes = new Object[3] {
objVesselDetails.PolicyId, objVesselDetails.PolVersionId, objVesselDetails.RefNo
};
return(dataAccess.LoadDataSet(parametes, "P_Pol_PolicyVessel_VesselDetails_Reset", "PolicyVesselUWDetailsDelete"));
}
public DataSet GetVesselData(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objVesselDetails.RefNo, objVesselDetails.PolicyId, objVesselDetails.PolVersionId
};
return(dataAccess.LoadDataSet(parameters, "Get_VesselData", "Vessel_UploadDownload"));
}
public DataSet GetRIVesselSectionDetails(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parametes = new Object[3] {
objVesselDetails.TranRefNo, objVesselDetails.CoverNoteNo, objVesselDetails.RefNo
};
return(dataAccess.LoadDataSet(parametes, "RI_CN_LoadPolicyVessel_SectionDetails", "RIVesselSectionDetails"));
}
public DataSet InsertBatchUploadVessel(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[7] {
objVesselDetails.RefNo, objVesselDetails.FileName, objVesselDetails.FileType, objVesselDetails.UploadedBy, objVesselDetails.PolicyId, objVesselDetails.PolVersionId, objVesselDetails.frmFor
};
return(dataAccess.LoadDataSet(parameters, "P_Vessel_BatchUploadInsert", "Vessel_BatchUploadInsert"));
}
public DataSet GetUWSharePercentTotal(clsVesselDetails objvessel)
{
dataAccess = new DataAccess();
object[] parametes = new object[4] {
objvessel.PolicyId, objvessel.PolVersionId, objvessel.COI, objvessel.frmFor
};
return(dataAccess.LoadDataSet(parametes, "P_Validate_SharePercent_UNW", "Pol_PolicyVessel_SectionDetails"));
}
/* Added for redmine 23*/
public DataSet SaveRIVesselDetails(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parametes = new Object[27] {
objVesselDetails.RefNo, objVesselDetails.TranRefNo, objVesselDetails.CoverNoteNo, objVesselDetails.VesselMultipleBilling,
objVesselDetails.VesselName, objVesselDetails.Built, objVesselDetails.VesselType, objVesselDetails.GRT,
objVesselDetails.NRT, objVesselDetails.BHP, objVesselDetails.Class,
objVesselDetails.Flag, objVesselDetails.Dimension, objVesselDetails.Owner, objVesselDetails.Managers,
objVesselDetails.Mortgagees, objVesselDetails.InceptionDate, objVesselDetails.ExpiryDate, objVesselDetails.UserID, objVesselDetails.GT, objVesselDetails.RegisteredLength, objVesselDetails.RegisteredBreadth, objVesselDetails.RegisteredDepth, objVesselDetails.NoOfCarry, objVesselDetails.RegisteredPlate, objVesselDetails.HMValue, objVesselDetails.IV
};
return(dataAccess.LoadDataSet(parametes, "RI_CN_VesselDetailsInsertUpdate", "RIVesselDetailsInsertUpdate"));
}
public DataSet GetVesselBatchFileUploadList(clsVesselDetails objVesselDetails, string strConString)
{
if (strConString.Trim() != "")
{
dataAccess = new DataAccess(strConString, "");
}
else
{
dataAccess = new DataAccess();
}
Object[] parameters = new Object[7] {
objVesselDetails.FileName, objVesselDetails.RefNo, objVesselDetails.UploadFromDate, objVesselDetails.UploadToDate, objVesselDetails.frmFor, objVesselDetails.PolicyId, objVesselDetails.PolVersionId
};
return(dataAccess.LoadDataSet(parameters, "P_Vessel_BatchUploadList", "Vessel_BatchUploadList"));
}
public DataSet UpdateBatchUploadVessel(clsVesselDetails objVesselDetails, string strConString)
{
if (strConString.Trim() != "")
{
dataAccess = new DataAccess(strConString, "");
}
else
{
dataAccess = new DataAccess();
}
Object[] parameters = new Object[6] {
objVesselDetails.RefNo, objVesselDetails.FilePath, objVesselDetails.Source, objVesselDetails.TotalRecord, objVesselDetails.SuccessRecord, objVesselDetails.FailRecord
};
return(dataAccess.LoadDataSet(parameters, "P_Vessel_BatchUploadUpdate", "Vessel_BatchUploadUpdate"));
}
public DataSet getVesselHistory(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parametes = new Object[] { objVesselDetails.PolicyId, objVesselDetails.PolVersionId };
return(dataAccess.LoadDataSet(parametes, "get_Vessel_History", "get_Vessel_History"));
}
public DataSet getUWCodeForVesselId(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parametes = new Object[] { objVesselDetails.PolicyId, objVesselDetails.PolVersionId };
return(dataAccess.LoadDataSet(parametes, "P_Get_UW_For_Vessel", "P_Get_UW_For_Vessel"));
}
public DataSet bulkUploadVesselDetails(clsVesselDetails objVesselDetails)
{
dataAccess = new DataAccess();
Object[] parametes = new Object[] { objVesselDetails.dt, objVesselDetails.PolicyId, objVesselDetails.PolVersionId, objVesselDetails.VesselMultipleBilling, objVesselDetails.UserID };
return(dataAccess.LoadDataSet(parametes, "P_Pol_Policy_VesselDetails_BulkInsert", "P_Pol_Policy_VesselDetails_BulkInsert"));
}
public DataSet GetVesselBatchFileUploadList(clsVesselDetails objVesselDetails)
{
return(GetVesselBatchFileUploadList(objVesselDetails, ""));
}
public DataSet UpdateBatchUploadVessel(clsVesselDetails objVesselDetails)
{
return(UpdateBatchUploadVessel(objVesselDetails, ""));
}
