private bool DeleteProperty(tInput oInput, ILambdaContext context, ref SqlConnection oSqlConnection)
        {
            SqlCommand sqlComm;
            string     strQuery;

            try
            {
                strQuery = " Update Property Set " +
                           " Deleted = 1 " +
                           " Where " +
                           " PropertyID = @PropertyID ";

                sqlComm = oSqlConnection.CreateCommand();

                sqlComm.CommandText = strQuery;

                SqlParameter sqlParamPropertyID = new SqlParameter("@PropertyID", SqlDbType.Int);
                sqlParamPropertyID.Value = oInput.PropertyID;
                sqlComm.Parameters.Add(sqlParamPropertyID);

                sqlComm.ExecuteNonQuery();
                sqlComm.Dispose();
            }

            catch (Exception ex)
            {
                context.Logger.LogLine("UpdateSite Ex " + ex.Message);
                return(false);
            }


            return(true);
        }
        private bool UpdateProperty(tInput oInput, ILambdaContext context, ref SqlConnection oSqlConnection)
        {
            SqlCommand sqlComm;
            string     strQuery;

            try
            {
                strQuery = " Update Property Set " +
                           " SiteID = @SiteID, " +
                           " PropertyNumber = @PropertyNumber, " +
                           " BlockName = @BlockName, " +
                           " BlockKey = @BlockKey, " +
                           " PropertyReference = @PropertyReference, " +
                           " BlockAddress = @BlockAddress, " +
                           " BlockPostCode = @BlockPostCode, " +
                           " ArchivedProperty = @ArchivedProperty, " +
                           " ArchivedReason = @ArchivedReason, " +
                           " ArchivedWho = @ArchivedWho, " +
                           " ArchivedWhen = @ArchivedWhen, " +
                           " Deleted = 0 " +
                           " Where " +
                           " PropertyID = @PropertyID ";

                sqlComm = oSqlConnection.CreateCommand();

                sqlComm.CommandText = strQuery;


                SqlParameter sqlParamPropertyID = new SqlParameter("@PropertyID", SqlDbType.Int);
                sqlParamPropertyID.Value = oInput.PropertyID;
                sqlComm.Parameters.Add(sqlParamPropertyID);

                SqlParameter sqlParamSiteID = new SqlParameter("@SiteID", SqlDbType.Int);
                sqlParamSiteID.Value = oInput.SiteID;
                sqlComm.Parameters.Add(sqlParamSiteID);

                SqlParameter sqlParamPropertyNumber = new SqlParameter("@PropertyNumber", SqlDbType.NVarChar);
                sqlParamPropertyNumber.Value = oInput.PropertyNumber;
                sqlComm.Parameters.Add(sqlParamPropertyNumber);

                SqlParameter sqlParamBlockName = new SqlParameter("@BlockName", SqlDbType.NVarChar);
                sqlParamBlockName.Value = oInput.BlockName;
                sqlComm.Parameters.Add(sqlParamBlockName);

                SqlParameter sqlParamBlockKey = new SqlParameter("@BlockKey", SqlDbType.NVarChar);
                sqlParamBlockKey.Value = oInput.BlockKey;
                sqlComm.Parameters.Add(sqlParamBlockKey);

                SqlParameter sqlParamPropertyReference = new SqlParameter("@PropertyReference", SqlDbType.NVarChar);
                sqlParamPropertyReference.Value = oInput.PropertyReference;
                sqlComm.Parameters.Add(sqlParamPropertyReference);


                SqlParameter sqlParamBlockAddress = new SqlParameter("@BlockAddress", SqlDbType.NVarChar);
                sqlParamBlockAddress.Value = oInput.BlockAddress;
                sqlComm.Parameters.Add(sqlParamBlockAddress);

                SqlParameter sqlParamBlockPostCode = new SqlParameter("@BlockPostCode", SqlDbType.NVarChar);
                sqlParamBlockPostCode.Value = oInput.BlockPostCode;
                sqlComm.Parameters.Add(sqlParamBlockPostCode);

                SqlParameter sqlParamArchivedProperty = new SqlParameter("@ArchivedProperty", SqlDbType.Bit);
                sqlParamArchivedProperty.Value = oInput.ArchivedProperty;
                sqlComm.Parameters.Add(sqlParamArchivedProperty);

                SqlParameter sqlParamArchivedReason = new SqlParameter("@ArchivedReason", SqlDbType.NVarChar);
                sqlParamArchivedReason.Value = oInput.ArchivedReason;
                sqlComm.Parameters.Add(sqlParamArchivedReason);

                SqlParameter sqlParamArchivedWho = new SqlParameter("@ArchivedWho", SqlDbType.NVarChar);
                sqlParamArchivedWho.Value = oInput.ArchivedWho;
                sqlComm.Parameters.Add(sqlParamArchivedWho);


                SqlParameter sqlParamArchivedWhen = new SqlParameter("@ArchivedWhen", SqlDbType.DateTime);
                if (oInput.ArchivedWhen == "")
                {
                    sqlParamArchivedWhen.Value = DBNull.Value;
                }
                else
                {
                    sqlParamArchivedWhen.Value = ecoCommon.DateJson(oInput.ArchivedWhen);
                }
                sqlComm.Parameters.Add(sqlParamArchivedWhen);


                sqlComm.ExecuteNonQuery();
                sqlComm.Dispose();
            }

            catch (Exception ex)
            {
                context.Logger.LogLine("UpdateSite Ex " + ex.Message);
                return(false);
            }


            return(true);
        }