Example #1
0
        public static int Insert(bMemberTypes objMemberTypes, SqlConnection sqlConn, SqlTransaction sqlTran)
        {
            //	construct new connection and command objects
            SqlConnection conn = sqlConn;
            SqlCommand    cmd  = DBHelper.getSprocCmd("sprocMemberTypesInsert", conn);

            cmd.Transaction = sqlTran;

            SqlParameter param;

            //	Add return value param
            param           = new SqlParameter("@RETURN_VALUE", SqlDbType.Int);
            param.Direction = ParameterDirection.ReturnValue;
            cmd.Parameters.Add(param);

            //	Add params
            param           = new SqlParameter("@MemberTypeID", SqlDbType.Int);
            param.Direction = ParameterDirection.Input;
            param.Value     = objMemberTypes.MemberTypeID;
            cmd.Parameters.Add(param);

            param           = new SqlParameter("@Description", SqlDbType.NVarChar);
            param.Direction = ParameterDirection.Input;
            param.Value     = objMemberTypes.Description;
            cmd.Parameters.Add(param);

            param           = new SqlParameter("@Code", SqlDbType.VarChar);
            param.Direction = ParameterDirection.Input;
            param.Value     = objMemberTypes.Code;
            cmd.Parameters.Add(param);


            //	open connection
            conn.Open();
            //	Execute command
            cmd.ExecuteNonQuery();
            //	get return value
            int retValue = 0;

            try {
                //	get return value of the sproc
                retValue = (int)cmd.Parameters["@RETURN_VALUE"].Value;
            } catch (System.Exception) {        //	catch all possible exceptions
                retValue = 0;                   //	set retValue To 0 (all ok)
            }
            //	close connection
            conn.Close();

            //	set dirty flag To false
            if (retValue != 0)
            {
                objMemberTypes.MemberTypeID = retValue;
            }
            return(retValue);
        }
Example #2
0
        public static int Delete(bMemberTypes objMemberTypes)
        {
            //	construct new connection and command objects
            SqlConnection conn = DBHelper.getConnection();
            SqlCommand    cmd  = DBHelper.getSprocCmd("sprocMemberTypesDelete", conn);

            SqlParameter param;

            //	add return value param
            param           = new SqlParameter("@RETURN_VALUE", SqlDbType.Int);
            param.Direction = ParameterDirection.ReturnValue;
            cmd.Parameters.Add(param);

            //	Add params
            param           = new SqlParameter("@MemberTypeID", SqlDbType.Int);
            param.Direction = ParameterDirection.Input;
            param.Value     = objMemberTypes.MemberTypeID;
            cmd.Parameters.Add(param);

            //	open connection
            conn.Open();
            //	Execute command
            cmd.ExecuteNonQuery();
            //	get return value
            int retValue = 0;

            try {
                //	get return value of the sproc
                retValue = (int)cmd.Parameters["@RETURN_VALUE"].Value;
            } catch (System.Exception) {        //	catch all possible exceptions
                retValue = 0;                   //	set retValue To 0 (all ok)
            }
            //	close connection
            conn.Close();

            return(retValue);
        }