Exemplo n.º 1
0
        internal static bool SaveFieldTripData(string uid, string datePaid, string allocationId, string fieldTripId)
        {
            bool statusOkay = false;

            // Pass "null" values if nothing entered. Not ideal, as loging in SP is required rather than automatic handling
            if (allocationId == "--PLEASE_SELECT--")
            {
                allocationId = "0";
            }
            if (datePaid == "")
            {
                datePaid = "2000/01/01";
            }

            BaseClasses.Data.StoredProcedureParameter firstParameter  = new BaseClasses.Data.StoredProcedureParameter("@validationUid", new Guid(uid), System.Data.SqlDbType.UniqueIdentifier, System.Data.ParameterDirection.Input);
            BaseClasses.Data.StoredProcedureParameter secondParameter = new BaseClasses.Data.StoredProcedureParameter("@datePaid", datePaid, System.Data.SqlDbType.Date, System.Data.ParameterDirection.Input);
            BaseClasses.Data.StoredProcedureParameter thirdParameter  = new BaseClasses.Data.StoredProcedureParameter("@allocationId", Int32.Parse(allocationId), System.Data.SqlDbType.Int, System.Data.ParameterDirection.Input);
            BaseClasses.Data.StoredProcedureParameter fourthParameter = new BaseClasses.Data.StoredProcedureParameter("@fieldTripId", Int32.Parse(fieldTripId), System.Data.SqlDbType.Int, System.Data.ParameterDirection.Input);

            // Step 2: Add the configured parameters to an array list.
            BaseClasses.Data.StoredProcedureParameter[] parameterList = new BaseClasses.Data.StoredProcedureParameter[4];
            parameterList[0] = firstParameter;
            parameterList[1] = secondParameter;
            parameterList[2] = thirdParameter;
            parameterList[3] = fourthParameter;
            //parameterList[1] = OutputPara1;
            BaseClasses.Data.StoredProcedure myStoredProcedure = null;


            // Step 3: Connect to the stored procedure.
            string spName = string.Format("sp_upd_{0}", "SaveFieldTripAllocations");

            myStoredProcedure = new BaseClasses.Data.StoredProcedure("DatabaseOLR_db", spName, parameterList);

            // Step 4: Run the stored procedure to insert a new record using the specified values.
            // RunNonQuery() will return true if stored procedure successfully executed. Otherwise, it will return false.
            // Use RunQuery or RunNonQuery.  RunQuery is used when a set of records is being returned.  RunNonQuery is used when one or more values are returned through output parameters.
            if (myStoredProcedure.RunNonQuery())
            {
                statusOkay = true;
            }
            else
            {
                ///IMPORTANT: If you raise an error that has a severity level of 10 or less, it is considered
                ///a warning, and no exception is raised. The severity of the error must be between 11 and 20
                ///for an exception to be thrown.

                var message = myStoredProcedure.ErrorMessage;
                statusOkay = false;
            }

            return(statusOkay);
        }
Exemplo n.º 2
0
        public static bool FlagRegistrationAsDeleted(string contactId)
        {
            bool statusOkay = false;

            //BaseClasses.Data.StoredProcedureParameter firstParameter = null;

            BaseClasses.Data.StoredProcedureParameter firstParameter = new BaseClasses.Data.StoredProcedureParameter("@contactId", Int32.Parse(contactId), System.Data.SqlDbType.Int, System.Data.ParameterDirection.Input);
            //BaseClasses.Data.StoredProcedureParameter OutputPara1 = new BaseClasses.Data.StoredProcedureParameter("@statusOkay", 0, System.Data.SqlDbType.Bit, System.Data.ParameterDirection.Output);

            // Step 2: Add the configured parameters to an array list.
            BaseClasses.Data.StoredProcedureParameter[] parameterList = new BaseClasses.Data.StoredProcedureParameter[1];
            parameterList[0] = firstParameter;
            //parameterList[1] = OutputPara1;
            BaseClasses.Data.StoredProcedure myStoredProcedure = null;


            // Step 3: Connect to the stored procedure.
            string spName = string.Format("sp_upd_{0}", "MarkRegistrationAsDeleted");

            myStoredProcedure = new BaseClasses.Data.StoredProcedure("DatabaseOLR_db", spName, parameterList);

            // Step 4: Run the stored procedure to insert a new record using the specified values.
            // RunNonQuery() will return true if stored procedure successfully executed. Otherwise, it will return false.
            // Use RunQuery or RunNonQuery.  RunQuery is used when a set of records is being returned.  RunNonQuery is used when one or more values are returned through output parameters.
            if (myStoredProcedure.RunNonQuery())
            {
                statusOkay = true;
            }
            else
            {
                ///IMPORTANT: If you raise an error that has a severity level of 10 or less, it is considered
                ///a warning, and no exception is raised. The severity of the error must be between 11 and 20
                ///for an exception to be thrown.

                var message = myStoredProcedure.ErrorMessage;
                statusOkay = false;
            }

            //results.Tables[0].Columns.Add("Sprite",typeof(object));

            return(statusOkay);
        }