All pastes #605327 Raw Edit

Someone

public text v1 · immutable
·published 2007-07-06 02:58 UTC
rendered paste body
   		try
			{
				cmdUpdateComm = new SqlCommand();

				cmdUpdateComm.Connection = conn;
				cmdUpdateComm.CommandText = "web_UpdateHistCommSp";
				cmdUpdateComm.CommandType = CommandType.StoredProcedure;
				cmdUpdateComm.CommandTimeout = 30;

				aParam = new SqlParameter();
				aParam.ParameterName = "@ManID";
				aParam.SqlDbType = SqlDbType.VarChar;
				aParam.Size = 17;
				aParam.Direction = ParameterDirection.Input;
				cmdUpdateComm.Parameters.Add(aParam);

				cmdUpdateComm.Parameters["@ManID"].Value = macAddr;
				cmdUpdateComm.ExecuteNonQuery();
				cmdUpdateComm = null;
			}
			catch (Exception ex)
			{
				writeError("SP: " + ex.Message);
			}
			finally
			{
				cmdUpdateComm = null;
			}		
						
			
			int tzOffset = 0;

			if (!(int.TryParse(root.Attributes.GetNamedItem("TZOffset").Value, out tzOffset)))
			{
				writeError("Invalid TZOffset: " + root.Attributes.GetNamedItem("TZOffset").Value);
				return;
			}

			bool bDST = root.Attributes.GetNamedItem("DST").Value.Equals("1");
			bool bCalcDelta = WebConfigurationManager.AppSettings["CalcDelta"].Equals("Y");

			DateTime TimeStamp = DateTime.MinValue;
			string sensorId = "";
			int sensorType = 0;
			int pIndex = 0;

			string nodeVal = "";
			decimal dValueA = 0;
			decimal dValueB = 0;
			string sState = "";
			decimal dHumidity = 0;
			decimal dTemp = 0;
			decimal dAnalog = 0;
			string sSourceIp = Request.ServerVariables.Get("REMOTE_HOST");

			for (int i1 = 0; i1 < root.ChildNodes.Count; ++i1)
			{
				XmlNode xmlPNode = root.ChildNodes.Item(i1);
				for (int i2 = 0; i2 < xmlPNode.ChildNodes.Count; ++i2)
				{
					bool EmptyRecord = false;
					XmlNode xmlNode = xmlPNode.ChildNodes.Item(i2);
					string nodeName = xmlNode.Name;
					string nodeText = xmlNode.InnerText;
					switch (nodeName)