public static DateTime TranshipmentStatus(int ExpBLId, ref bool VoyageStatus, ref int CountID) { DateTime Result; string TempString; bool ClsVoyage = false; int Count = 0; string ProcName = "[exp].[prcTranshipmentStatus]"; DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName); dquery.AddIntegerParam("@ExpBLId", ExpBLId); dquery.AddDateTimeParam("@RESULT", null, QueryParameterDirection.Output); dquery.AddBooleanParam("@closeVoyage", ClsVoyage, QueryParameterDirection.Output); dquery.AddIntegerParam("@CountID", Count, QueryParameterDirection.Output); dquery.RunActionQuery(); TempString = Convert.ToString(dquery.GetParaValue("@Result")); if (TempString == null || TempString == "") { Result = default(DateTime); } else { Result = Convert.ToDateTime(dquery.GetParaValue("@Result")); } //Result = Convert.ToDateTime(dquery.GetParaValue("@SailDate")); VoyageStatus = Convert.ToBoolean(dquery.GetParaValue("@CloseVoyage")); CountID = Convert.ToInt32(dquery.GetParaValue("@CountID")); return(Result); }