public DataSet GetMLVoyage(int VoyageId, string voyageType, string VesselName, string voyageNo)
{
string ProcName = "prcGetMLVoyage";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@pk_VoyageID", VoyageId);
dquery.AddCharParam("@VoyageType", 1, voyageType.ToCharArray()[0]);
dquery.AddVarcharParam("@vesselName", 70, VesselName);
dquery.AddVarcharParam("@VoyageNo", 10, voyageNo);
return dquery.GetTables();
}
public int AddEditLine(int userID, int pk_NVOCCId, string NVOCCName, int DefaultFreeDays, string ContAgentCode, decimal ImpCommsn, decimal ExpCommsn, char ExpBook, decimal rBuffer, string logoPath, bool isEdit)
{
string ProcName = "admin.prcAddEditLine";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@userID", userID);
dquery.AddIntegerParam("@pk_NVOCCId", pk_NVOCCId);
dquery.AddVarcharParam("@NVOCCName", 50, NVOCCName);
dquery.AddIntegerParam("@DefaultFreeDays", DefaultFreeDays);
dquery.AddVarcharParam("@ContAgentCode", 10, ContAgentCode);
dquery.AddDecimalParam("@ImportCommission", 6, 2, ImpCommsn);
dquery.AddDecimalParam("@ExportCommission", 6, 2, ExpCommsn);
dquery.AddDecimalParam("@RBuffer", 6, 2, rBuffer);
dquery.AddCharParam("@ExportBooking", 1, ExpBook);
dquery.AddVarcharParam("@logoPath", 150, logoPath);
dquery.AddBooleanParam("@isEdit", isEdit);
return(dquery.RunActionQuery());
}
