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, "")); }