ASP.NET

public void SaveContractHeader(
			string	refNumber
			,int suppID
			,int catID
			,string Buyer
			,int contVal
			,string contStDate
			,string contEndDate
			,string contRevDate
			,int insVal
			,string insStDate
			,string insEndDate
			,string insRevDate
			,int totalContVal
			,int annualVal
			,int locID
			,int  statusID
			,string conOwner
			,string remarks
			,string docname
			,string itemIdstack
			,string rateStack
			,string unitStack
			,string UOMStack
			,string currencyStack
			, ref int intErrCode
			, ref string strMsg
			)
		{
			/*OracleCommand oraCommand = null;
			OracleDataReader oraDataReader = null;
			
			try
			{	
				oraCommand = new OracleCommand();

				oraCommand.Connection = OraConn;

				oraCommand.CommandText = "XX_CR_PKG.SaveContractHeader";
			
				oraCommand.CommandType = CommandType.StoredProcedure;

				oraCommand.Parameters.Add("REFERENCENUMBER", OracleType.VarChar).Direction = ParameterDirection.Input;
				oraCommand.Parameters["REFERENCENUMBER"].Size=20;
				oraCommand.Parameters["REFERENCENUMBER"].Value=refNumber;

				oraCommand.Parameters.Add("SUPPLIERID", OracleType.Number).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["SUPPLIERID"].Value=suppID;
				
				oraCommand.Parameters.Add("BCID", OracleType.Number).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["BCID"].Value=catID;
				
				oraCommand.Parameters.Add("BUYER", OracleType.VarChar).Direction = ParameterDirection.Input;
				oraCommand.Parameters["BUYER"].Size=30;
				oraCommand.Parameters["BUYER"].Value=Buyer;

				oraCommand.Parameters.Add("CONTRACTVAL", OracleType.Number).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["CONTRACTVAL"].Value=contVal;
				
               			 //contStDate = Convert.ToDateTime(contStDate);
				DateTime conStDate=Convert.ToDateTime(String.Format("{0:MM-dd-yyyy}",contStDate));
				oraCommand.Parameters.Add("CONTRACTSTDATE", OracleType.DateTime).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["CONTRACTSTDATE"].Value=conStDate;

				
				DateTime conEndDate=Convert.ToDateTime(String.Format("{0:MM-dd-yyyy}",contEndDate));
				oraCommand.Parameters.Add("CONTRACTENDDATE", OracleType.DateTime).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["CONTRACTENDDATE"].Value=contStDate;

				//contRevDate = Convert.ToDateTime(contRevDate);
				DateTime conRevDate=Convert.ToDateTime(String.Format("{0:MM-dd-yyyy}",contRevDate));
				oraCommand.Parameters.Add("CONTRACTREVDATE", OracleType.DateTime).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["CONTRACTREVDATE"].Value=conRevDate;

				oraCommand.Parameters.Add("INSURANCEVAL", OracleType.Number).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["INSURANCEVAL"].Value=insVal;
				
				//insStDate = Convert.ToDateTime(insStDate);
				DateTime insrncStDate=Convert.ToDateTime(String.Format("{0:MM-dd-yyyy}",insStDate));
				oraCommand.Parameters.Add("INSURANCESTDATE", OracleType.DateTime).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["INSURANCESTDATE"].Value=insrncStDate;
				
				//insEndDate = Convert.ToDateTime(insEndDate);
				DateTime insrncEndDate=Convert.ToDateTime(String.Format("{0:MM-dd-yyyy}",insEndDate));
				oraCommand.Parameters.Add("INSURANCEENDDATE", OracleType.DateTime).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["INSURANCEENDDATE"].Value=insrncEndDate;

				//insRevDate = Convert.ToDateTime(insRevDate);
				DateTime insrncRevDate=Convert.ToDateTime(String.Format("{0:MM-dd-yyyy}",insRevDate));
				oraCommand.Parameters.Add("INSURANCEREVDATE", OracleType.DateTime).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["INSURANCEREVDATE"].Value=insrncRevDate;

				oraCommand.Parameters.Add("TOTALCONTRACTEXP", OracleType.Number).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["TOTALCONTRACTEXP"].Value=totalContVal;

				oraCommand.Parameters.Add("ANNUALEXP", OracleType.Number).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["ANNUALEXP"].Value=annualVal;

				oraCommand.Parameters.Add("LOCATIONID", OracleType.Number).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["LOCATIONID"].Value=locID;

				oraCommand.Parameters.Add("STATUSID", OracleType.Number).Direction = ParameterDirection.Input;				
				oraCommand.Parameters["STATUSID"].Value=statusID;
				
				oraCommand.Parameters.Add("CONTRACTOWNER", OracleType.VarChar).Direction = ParameterDirection.Input;
				oraCommand.Parameters["CONTRACTOWNER"].Size=30;
				oraCommand.Parameters["CONTRACTOWNER"].Value=conOwner;

				oraCommand.Parameters.Add("REMARKS", OracleType.VarChar).Direction = ParameterDirection.Input;
				oraCommand.Parameters["REMARKS"].Size=30;
				oraCommand.Parameters["REMARKS"].Value=remarks;
				
				oraCommand.Parameters.Add("DOCNAME", OracleType.VarChar).Direction = ParameterDirection.Input;
				oraCommand.Parameters["DOCNAME"].Size=30;
				oraCommand.Parameters["DOCNAME"].Value=docname;

				oraCommand.Parameters.Add("ITEMID", OracleType.VarChar).Direction = ParameterDirection.Input;
				oraCommand.Parameters["ITEMID"].Size=30;
				oraCommand.Parameters["ITEMID"].Value=itemIdstack;

				oraCommand.Parameters.Add("RATE", OracleType.VarChar).Direction = ParameterDirection.Input;
				oraCommand.Parameters["RATE"].Size=30;
				oraCommand.Parameters["RATE"].Value=rateStack;

				oraCommand.Parameters.Add("UOM", OracleType.VarChar).Direction = ParameterDirection.Input;
				oraCommand.Parameters["UOM"].Size=30;
				oraCommand.Parameters["UOM"].Value=UOMStack;

				oraCommand.Parameters.Add("UNIT", OracleType.VarChar).Direction = ParameterDirection.Input;
				oraCommand.Parameters["UNIT"].Size=30;
				oraCommand.Parameters["UNIT"].Value=unitStack;

				oraCommand.Parameters.Add("CURRENCY", OracleType.VarChar).Direction = ParameterDirection.Input;
				oraCommand.Parameters["CURRENCY"].Size=30;
				oraCommand.Parameters["CURRENCY"].Value=currencyStack;

				
				oraDataReader = oraCommand.ExecuteReader();
					
			}
			catch(OracleException exOra)
			{
				/*intErrCode = exOra.Code;
				strMsg = "Save receipt: "+exOra.Message;
				throw;*//*
				intErrCode = exOra.Code;
				intORA = exOra.Message.IndexOf("ORA-"); 
				
				
				intExc = exOra.Message.IndexOf("^EXCEPTION^"); 
				intCols = exOra.Message.IndexOf(": -");
				strSegment = exOra.Message.Substring(intORA + 4,intCols - 1);
				
				if ((intExc != 0) && (intExc != -1))
				{
					intDot = exOra.Message.IndexOf(".^^");
					intDot = intDot - 27;
					strSegment = exOra.Message.Substring(intORA + 4,intCols - 1);
					strSegment = strSegment + exOra.Message.Substring(intExc + 11, intDot);
				}
				else
				{
					
					strSegment = exOra.Message;
					
				}
				
				strMsg = strSegment ;
				throw;
			}
			catch(Exception ex)
			{
				strMsg = "Save Contract Header: "+ex.Message;
				throw;
			}
			finally
			{
				if(oraDataReader!=null)
				{
					oraDataReader.Dispose();
				}

				if(oraCommand!=null)
				{
					oraCommand.Dispose();
				}				
			}*/

			
		}